# ------------------------------------------------------------------------------
# poc-bot environment configuration (example)
#
# 1. Copy this file to .env:   cp .env.example .env
# 2. Fill in the values below (leave optional ones blank to use their defaults).
# 3. Load it into your shell before running any script. The scripts read from the
#    process environment; there is NO dotenv auto-loader, so export the vars:
#
#        set -a && source .env && set +a
#
# Never commit your real .env — only this .env.example belongs in version control.
#
# Quote any value containing spaces (e.g. LABEL="two words") — unquoted spaces
# break the `source .env` load step.
#
# Legend:  [required]  must be set    [optional]  has a default / can be left blank
#          Skills:  [poc-analysis]  [poc-not-customer-usage]  [both]
# ------------------------------------------------------------------------------

# ==============================================================================
# HubSpot
# ==============================================================================
# [required][poc-analysis] Private app token with "deals" read scope.
# Also used by poc-not-customer-usage for owner enrichment if the token below is unset.
HUBSPOT_ACCESS_TOKEN=

# [required][poc-analysis] Pipeline + "Pilot Kicked Off" stage to pull deals from.
# Find under Settings > CRM > Deals > Pipelines, or GET /crm/v3/pipelines/deals
HUBSPOT_POC_PIPELINE_ID=
HUBSPOT_POC_STAGE_ID=

# [optional][poc-analysis] Deal properties that drive the Metabase queries (defaults shown).
HUBSPOT_TEAM_ID_PROPERTY=team_id
HUBSPOT_DEMO_DATE_PROPERTY=demo_held_date

# [optional][poc-not-customer-usage] Token for company/owner enrichment.
# Preferred over HUBSPOT_ACCESS_TOKEN when set; enrichment is skipped if neither is set.
GENERAL_HUBSPOT_APP_TOKEN=
# [optional] Comma-separated custom company property names used to prefer better-enriched matches.
HUBSPOT_ENGINEER_COUNT_PROPERTIES=

# ==============================================================================
# Metabase
# ==============================================================================
# [required][both] Base URL of your Metabase instance and an API key.
METABASE_BASE_URL=https://metabase.example.com
METABASE_API_KEY=
# [required][both] Numeric dashboard ID (visible in the dashboard URL).
METABASE_DASHBOARD_ID=
# [required][both] Dashboard parameter IDs — GET /api/dashboard/{id} -> "parameters" array.
METABASE_PARAM_DATE_RANGE_ID=
METABASE_PARAM_TEAM_ID_ID=

# [required][poc-not-customer-usage] Database ID for native SQL queries.
# Find under Settings > Admin > Databases, or GET /api/database
METABASE_DB_ID=
# [required][poc-not-customer-usage] Primary-metric tile — GET /api/dashboard/{id} -> "dashcards" array.
METABASE_PRIMARY_METRIC_DASHCARD_ID=
METABASE_PRIMARY_METRIC_CARD_ID=

# [optional][both] Override the default JSON config file paths (defaults live in each skill's config/ dir).
METABASE_CARDS_CONFIG=
DATA_SOURCES_CONFIG=

# ==============================================================================
# Primary metric display  [poc-not-customer-usage]
# ==============================================================================
# Display label + emoji for your primary value metric (e.g. "API calls", "pipeline runs", "MAU").
PRIMARY_METRIC_LABEL="primary metric"
PRIMARY_METRIC_EMOJI=:bar_chart:

# ==============================================================================
# Cohort / filters  [poc-not-customer-usage]
# ==============================================================================
# pipeline_label value that marks PoC deals in the deals table.
POC_PIPELINE_LABEL="poc pipeline"
# Comma-separated internal demo/test team names to exclude (empty by default).
INTERNAL_TEAM_NAMES=
# Comma-separated internal domains whose admin emails are flagged as internal/test (empty by default).
INTERNAL_EMAIL_DOMAINS=
# Comma-separated personal email domains flagged for review (default shown).
PERSONAL_EMAIL_DOMAINS=gmail.com,outlook.com,hotmail.com,yahoo.com

# ==============================================================================
# Warehouse overrides  [poc-not-customer-usage] (optional)
# ==============================================================================
# Override table/column names from config/data_sources.json when set.
DB_TEAMS_FACTS_TABLE=
DB_SERVICE_AGREEMENTS_TABLE=
DB_ENTERPRISE_DEALS_TABLE=
DB_DEALS_TEAM_ID_COLUMN=

# ==============================================================================
# Slack
# ==============================================================================
# [required][both] Bot OAuth token (xoxb-...) with chat:write scope.
POC_BOT_SLACK_TOKEN=
# [optional][both] Target channel (default shown).
SLACK_CHANNEL=#poc-bot