dbt_project.yml

name: 'ra_data_warehouse_production'
version: '1.0.0'

require-dbt-version: [">=1.0.0", "<2.0.0"]
config-version: 2
profile: 'ra_data_warehouse'

target-path: "target"
clean-targets: ["target", "dbt_modules", "dbt_packages"]
macro-paths: ["macros"]
log-path: "logs"

model-paths: ["models"]
analysis-paths: ["analysis"]
test-paths: ["tests"]
seed-paths: ["data"]




models:
  ra_data_warehouse_production:
      sources:
          materialized: view
          schema: staging
          +tags: staging
      integration:
          materialized: view
          schema: staging
          +tags: integration
      warehouse:
          materialized: table
          +tags: warehouse
seeds:
  ra_data_warehouse_production:
    schema: seed

vars:
  crm_warehouse_company_sources: ['hubspot_crm','harvest_projects','xero_accounting','stripe_payments','asana_projects','jira_projects','gcp_billing','bigquery_usage']
  crm_warehouse_contact_sources: ['hubspot_crm','harvest_projects','xero_accounting','mailchimp_email','calendly_discovery','twitter_followers','twitter_likers','linkedin_followers','github_starrers','harvest_forecast','linkedin_commenters','linkedin_likers','asana_projects','jira_projects','docusign_contracts','hubspot_nps','humaans_hr']
  crm_warehouse_conversations_sources: ['hubspot_crm','intercom_messaging']
  hr_warehouse_timeoff_sources: ['humaans_hr']
  marketing_warehouse_ad_campaign_sources: ['google_ads','facebook_ads','mailchimp_email','hubspot_email']
  marketing_warehouse_ad_campaign_performance_sources: ['google_ads','mailchimp_email','hubspot_email']
  marketing_warehouse_ad_performance_sources: ['facebook_ads']
  marketing_warehouse_ad_group_sources: []
  marketing_warehouse_ad_sources: []
  marketing_warehouse_email_event_sources: ['hubspot_email','mailchimp_email']
  marketing_warehouse_email_list_sources: ['mailchimp_email']
  marketing_warehouse_content_interaction_sources: ['linkedin_likers','linkedin_followers','linkedin_commenters','twitter_likes']
  marketing_warehouse_interaction_content_sources: ['linkedin_posts','twitter_tweets']
  marketing_warehouse_deal_sources: ['hubspot_crm']
  marketing_warehouse_meetings_sources: ['calendly_discovery']
  projects_warehouse_delivery_sources: ['asana_projects','jira_projects']
  projects_warehouse_timesheet_sources: ['harvest_projects']
  projects_warehouse_contract_sources: ['docusign_contracts']
  projects_warehouse_forecast_sources: ['harvest_forecast']
  finance_warehouse_invoice_sources: ['xero_accounting','harvest_projects']
  finance_warehouse_currencies_sources: ['xero_accounting']
  finance_warehouse_transaction_sources: ['stripe_payments']
  finance_warehouse_bank_transaction_sources: ['xero_accounting']
  finance_warehouse_journal_sources: ['xero_accounting']
  finance_warehouse_journal_line_sources: ['xero_accounting']
  finance_warehouse_payment_sources: ['xero_accounting']
  product_warehouse_event_sources: ['segment_events_track','segment_events_page','rudderstack_events_track','rudderstack_events_page','mixpanel_events']
  subscriptions_warehouse_sources: []
  dev_warehouse_git_sources: ['github_repos']
  product_warehouse_usage_sources: ['gcp_billing','bigquery_usage']
  crm_warehouse_nps_sources: ['hubspot_nps']
  hr_warehouse_survey_sources: ['officevibe_surveys']

  stg_git_repos_id-prefix: github-
  stg_git_repos_etl: fivetran
  stg_git_repos_fivetran_database: ra-development
  stg_git_repos_fivetran_schema: fivetran_github


  stg_asana_projects_id-prefix: asana-
  stg_asana_projects_etl: stitch
  stg_asana_projects_stitch_database: ra-development
  stg_asana_projects_stitch_schema: stitch_asana
  stg_asana_projects_staff_email_domain: rittmananalytics.com
  stg_asana_projects_stitch_workspaces_table: "{{ source('stitch_asana_projects', 'workspaces') }}"
  stg_asana_projects_stitch_projects_table: "{{ source('stitch_asana_projects', 'projects') }}"
  stg_asana_projects_stitch_tasks_table: "{{ source('stitch_asana_projects', 'tasks') }}"
  stg_asana_projects_stitch_users_table: "{{ source('stitch_asana_projects', 'users') }}"

  stg_looker_usage_stats_id-prefix: looker-
  stg_looker_usage_database: ra-development
  stg_looker_usage_schema: fivetran_email
  stg_looker_usage_stats_table: usage_stats

  stg_gcp_billing_product_usage_id-prefix: gcp-billing-
  stg_gcp_billing_product_usage_database: ra-development
  stg_gcp_billing_product_usage_schema: gcp_billing_export
  stg_gcp_billing_product_usage_table: "{{ source('gcp_billing_product_usage', 'gcp_billing_export_v1_01002B_781DA7_8295B1') }}"
  stg_gcp_billing_products_table: "{{ source('gcp_billing_product_usage', 'gcp_billing_export_v1_01002B_781DA7_8295B1') }}"
  stg_gcp_billing_companies_table: "{{ source('gcp_billing_product_usage', 'gcp_billing_export_v1_01002B_781DA7_8295B1') }}"

  stg_bigquery_usage_id-prefix: bigquery-log-
  stg_bigquery_usage_database: ra-development
  stg_bigquery_usage_schema: bigquery_log_export
  stg_bigquery_usage_table: "{{ source('bigquery_usage_product_usage', 'cloudaudit_data_access') }}"
  stg_bigquery_products_table: "{{ source('bigquery_usage_product_usage', 'cloudaudit_data_access') }}"
  stg_bigquery_companies_table: "{{ source('bigquery_usage_product_usage', 'cloudaudit_data_access') }}"


  stg_facebook_ads_id-prefix: fbads-
  stg_facebook_ads_etl: segment
  stg_facebook_ads_stitch_database: ra-development
  stg_facebook_ads_stitch_schema: stitch_facebook_ads
  stg_facebook_ads_stitch_ad_performance_table: "{{ source('stitch_facebook_ads', 'insights') }}"
  stg_facebook_ads_stitch_ad_performance_table_snowflake: "{{ source('stitch_facebook_ads', 'ads_insights') }}"
  stg_facebook_ads_stitch_ad_groups_table: "{{ source('stitch_facebook_ads', 'ad_sets') }}"
  stg_facebook_ads_stitch_ad_groups_table_snowflake: "{{ source('stitch_facebook_ads', 'adsets') }}"
  stg_facebook_ads_stitch_ads_table: "{{ source('stitch_facebook_ads', 'ads') }}"
  stg_facebook_ads_stitch_campaigns_table: "{{ source('stitch_facebook_ads', 'campaigns') }}"
  stg_facebook_ads_segment_database: ra-development
  stg_facebook_ads_segment_schema: facebook_ads
  stg_facebook_ads_segment_ad_performance_table: "{{ source('segment_facebook_ads', 'insights') }}"
  stg_facebook_ads_segment_ad_groups_table: "{{ source('stitch_facebook_ads', 'ad_adsets') }}"
  stg_facebook_ads_segment_ads_table: "{{ source('segment_facebook_ads', 'ads') }}"
  stg_facebook_ads_segment_campaigns_table: "{{ source('segment_facebook_ads', 'campaigns') }}"

  stg_google_ads_id-prefix: gads-
  stg_google_ads_etl: stitch
  stg_google_ads_stitch_database: ra-development
  stg_google_ads_stitch_schema: stitch_google_ads
  stg_google_ads_stitch_campaign_performance_table: "{{ source('stitch_google_ads', 'CAMPAIGN_PERFORMANCE_REPORT') }}"
  stg_google_ads_stitch_campaigns_table: "{{ source('stitch_google_ads', 'campaigns') }}"
  stg_google_ads_segment_database: ra-development
  stg_google_ads_segment_schema: google_ads
  stg_google_ads_segment_campaign_performance_table: "{{ source('segment_google_ads', 'campaign_performance_reports') }}"
  stg_google_ads_segment_ad_performance_table: "{{ source('segment_google_ads', 'ad_performance_reports') }}"
  stg_google_ads_segment_ad_groups_table: "{{ source('segment_google_ads', 'ad_groups') }}"
  stg_google_ads_segment_ads_table: "{{ source('segment_google_ads', 'ads') }}"
  stg_google_ads_segment_campaigns_table: "{{ source('segment_google_ads', 'campaigns') }}"
  ads_campaigns_only: true

  stg_docusign_contracts_id-prefix: docusign-
  stg_docusign_contracts_etl: fivetran
  stg_docusign_contracts_fivetran_database: ra-development
  stg_docusign_contracts_fivetran_schema: fivetran_docusign
  stg_docusign_contracts_contracts_table: "{{ source('fivetran_docusign', 'docusign_envelopes') }}"

  stg_segment_events_id-prefix: segment-
  stg_segment_events_etl: segment
  stg_segment_events_segment_database: ra-development
  stg_segment_events_segment_schema: company_website
  stg_segment_events_segment_tracks_table: "{{ source('segment', 'tracks') }}"
  stg_segment_events_segment_pages_table: "{{ source('segment', 'pages') }}"
  stg_segment_events_segment_users_table: "{{ source('segment', 'users') }}"
  stg_segment_events_site: rittmananalytics.com
  enable_event_type_mapping: true

  stg_rudderstack_events_id-prefix: rudderstack-
  stg_rudderstack_events_etl: rudderstack
  stg_rudderstack_events_rudderstack_database: ra-development
  stg_rudderstack_events_rudderstack_schema: rudderstack_ra_website
  stg_rudderstack_events_rudderstack_tracks_table: "{{ source('rudderstack', 'tracks') }}"
  stg_rudderstack_events_rudderstack_pages_table: "{{ source('rudderstack', 'pages') }}"
  stg_rudderstack_events_rudderstack_users_table: "{{ source('rudderstack', 'users') }}"
  stg_rudderstack_events_site: rittmananalytics.com

  stg_baremetrics_analytics_id-prefix: baremetrics-
  stg_baremetrics_analytics_etl: segment
  stg_baremetrics_analytics_segment_schema: baremetrics
  stg_baremetrics_analytics_segment_plan_breakdown_table: plan_breakdown

  stg_harvest_projects_id-prefix: harvest-
  stg_harvest_projects_etl: stitch
  stg_harvest_projects_stitch_database: ra-development
  stg_harvest_projects_stitch_schema: stitch_harvest
  stg_harvest_projects_staff_email_domain: rittmananalytics.com
  stg_harvest_projects_stitch_companies_table: "{{ source('stitch_harvest_projects', 'companies') }}"
  stg_harvest_projects_stitch_contacts_table: "{{ source('stitch_harvest_projects', 'contacts') }}"
  stg_harvest_projects_stitch_invoices_table: "{{ source('stitch_harvest_projects', 'invoices') }}"
  stg_harvest_projects_stitch_invoice_line_items_table: "{{ source('stitch_harvest_projects', 'invoice_line_items') }}"
  stg_harvest_projects_stitch_projects_table: "{{ source('stitch_harvest_projects', 'projects') }}"
  stg_harvest_projects_stitch_tasks_table: "{{ source('stitch_harvest_projects', 'tasks') }}"
  stg_harvest_projects_stitch_project_tasks_table: "{{ source('stitch_harvest_projects', 'project_tasks') }}"
  stg_harvest_projects_stitch_timesheets_table: "{{ source('stitch_harvest_projects', 'timesheets') }}"
  stg_harvest_projects_stitch_users_table: "{{ source('stitch_harvest_projects', 'users') }}"
  stg_harvest_projects_stitch_user_projects_table: "{{ source('stitch_harvest_projects', 'user_projects') }}"
  stg_harvest_projects_stitch_user_project_tasks_table: "{{ source('stitch_harvest_projects', 'user_project_tasks') }}"
  stg_harvest_projects_stitch_expenses_table: "{{ source('stitch_harvest_projects', 'expenses') }}"
  stg_harvest_projects_stitch_expense_categories_table: "{{ source('stitch_harvest_projects', 'expense_categories') }}"


  stg_hubspot_crm_id-prefix: hubspot-
  stg_hubspot_crm_stitch_database: ra-development
  stg_hubspot_crm_stitch_schema: stitch_hubspot
  stg_hubspot_crm_fivetran_database: ra-development
  stg_hubspot_crm_fivetran_schema: fivetran_hubspot_euwest2
  stg_hubspot_crm_etl: stitch
  stg_hubspot_crm_stitch_companies_table: "{{ source('stitch_hubspot_crm', 'companies') }}"
  stg_hubspot_crm_stitch_contacts_table: "{{ source('stitch_hubspot_crm', 'contacts') }}"
  stg_hubspot_crm_stitch_deals_table: "{{ source('stitch_hubspot_crm', 'deals') }}"
  stg_hubspot_crm_stitch_owners_table: "{{ source('stitch_hubspot_crm', 'owners') }}"
  stg_hubspot_crm_stitch_pipeline_stages_table: "{{ source('stitch_hubspot_crm', 'pipeline_stages') }}"
  stg_hubspot_crm_stitch_deal_pipelines_table: "{{ source('stitch_hubspot_crm', 'deal_pipelines') }}"
  stg_hubspot_crm_stitch_engagements_table: "{{ source('stitch_hubspot_crm', 'engagements') }}"

  stg_hubspot_crm_fivetran_company_table: "{{ source('fivetran_hubspot_crm', 'engagements') }}"
  stg_hubspot_crm_fivetran_contact_table: "{{ source('fivetran_hubspot_crm', 'contacts') }}"
  stg_hubspot_crm_fivetran_deal_table: "{{ source('fivetran_hubspot_crm', 'deals') }}"
  stg_hubspot_crm_fivetran_owner_table: "{{ source('fivetran_hubspot_crm', 'owners') }}"
  stg_hubspot_crm_fivetran_pipeline_stage_table: "{{ source('fivetran_hubspot_crm', 'pipeline_stages') }}"
  stg_hubspot_crm_fivetran_pipeline_table: "{{ source('fivetran_hubspot_crm', 'deal_pipelines') }}"
  stg_hubspot_crm_fivetran_property_history_table: "{{ source('fivetran_hubspot_crm', 'property_history') }}"
  stg_hubspot_crm_fivetran_deal_company_table: "{{ source('fivetran_hubspot_crm', 'deal_company') }}"
  stg_hubspot_crm_fivetran_engagements_table: "{{ source('fivetran_hubspot_crm', 'engagements') }}"

  stg_hubspot_nps_id-prefix: hubspot_nps-

  stg_twitter_social_database: ra-development
  stg_twitter_social_schema: coupler_socialmedia
  stg_twitter_social_id-prefix: twitter-

  stg_linkedin_social_database: ra-development
  stg_linkedin_social_schema: coupler_socialmedia
  stg_linkedin_social_id-prefix: linkedin-

  stg_calendly_meetings_database: ra-development
  stg_calendly_meetings_schema: coupler_socialmedia
  stg_calendly_meetings_id-prefix: calendly-

  stg_github_starrers_database: ra-development
  stg_github_starrers_schema: coupler_socialmedia
  stg_github_starrers_id-prefix: github-

  stg_hubspot_email_id-prefix: hubspot-
  stg_hubspot_email_stitch_database: ra-development
  stg_hubspot_email_stitch_schema: stitch_hubspot
  stg_hubspot_email_etl: stitch
  stg_hubspot_email_stitch_email_events_table: "{{ source('stitch_hubspot_email', 'email_events') }}"
  stg_hubspot_email_stitch_campaigns_table: "{{ source('stitch_hubspot_email', 'campaigns') }}"

  stg_intercom_messaging_id-prefix: intercom-
  stg_intercom_messaging_etl: stitch
  stg_intercom_messaging_stitch_database: ra-development
  stg_intercom_messaging_stitch_schema: stitch_intercom
  stg_intercom_messaging_stitch_contacts_table: contacts
  stg_intercom_messaging_stitch_conversations_table: conversations
  stg_intercom_messaging_tags: ["intercom", "messaging"]

  stg_jira_projects_id-prefix: jira-
  stg_jira_projects_etl: stitch
  stg_jira_projects_stitch_database: ra-development
  stg_jira_projects_stitch_schema: stitch_jira
  stg_jira_projects_staff_email_domain: rittmananalytics.com
  stg_jira_projects_stitch_projects_table: "{{ source('stitch_jira_projects', 'projects') }}"
  stg_jira_projects_stitch_project_types_table: "{{ source('stitch_jira_projects', 'project_types') }}"
  stg_jira_projects_stitch_project_categories_table: "{{ source('stitch_jira_projects', 'project_categories') }}"
  stg_jira_projects_stitch_issues_table: "{{ source('stitch_jira_projects', 'issues') }}"
  stg_jira_projects_stitch_users_table: "{{ source('stitch_jira_projects', 'users') }}"
  stg_jira_projects_jira_url: rittmananalytics.atlassian.net/jira

  stg_mailchimp_email_id-prefix: mailchimp-
  stg_mailchimp_email_etl: stitch
  stg_mailchimp_email_stitch_database: ra-development
  stg_mailchimp_email_stitch_schema: stitch_mailchimp
  stg_mailchimp_email_stitch_list_members_table: "{{ source('stitch_mailchimp_email', 'list_members') }}"
  stg_mailchimp_email_stitch_reports_email_activity_table: "{{ source('stitch_mailchimp_email', 'reports_email_activity') }}"
  stg_mailchimp_email_stitch_lists_table: "{{ source('stitch_mailchimp_email', 'lists') }}"
  stg_mailchimp_email_stitch_campaigns_table: "{{ source('stitch_mailchimp_email', 'campaigns') }}"

  stg_mixpanel_events_id-prefix: mixpanel-
  stg_mixpanel_events_stitch_database: ra-development
  stg_mixpanel_events_fivetran_database: ra-development
  stg_mixpanel_events_stitch_schema: mixpanel_stitch
  stg_mixpanel_events_fivetran_schema: fivetran_mixpanel
  stg_mixpanel_events_etl: fivetran
  stg_mixpanel_events_fivetran_event_table: "{{ source('fivetran_mixpanel_events', 'event') }}"
  stg_mixpanel_events_stitch_event_table: "{{ source('stitch_mixpanel_events', 'event') }}"
  stg_mixpanel_events_site: rittmananalytics.com





  stg_xero_accounting_id-prefix: xero-
  stg_xero_accounting_etl: fivetran
  stg_xero_accounting_stitch_database: ra-development
  stg_xero_accounting_stitch_schema: xero
  stg_xero_accounting_stitch_accounts_table: "{{ source('stitch_xero_accounting', 'accounts') }}"
  stg_xero_accounting_stitch_payments_table: "{{ source('stitch_xero_accounting', 'payments') }}"
  stg_xero_accounting_stitch_categories_table: "{{ source('stitch_xero_accounting', 'tracking_categories') }}"
  stg_xero_accounting_stitch_bank_transactions_table: "{{ source('stitch_xero_accounting', 'bank_transactions') }}"
  stg_xero_accounting_stitch_contacts_table: "{{ source('stitch_xero_accounting', 'contacts') }}"
  stg_xero_accounting_stitch_currencies_table: "{{ source('stitch_xero_accounting', 'currencies') }}"
  stg_xero_accounting_stitch_expense_claims_table: "{{ source('stitch_xero_accounting', 'expense_claims') }}"
  stg_xero_accounting_stitch_invoices_table: "{{ source('stitch_xero_accounting', 'invoices') }}"
  stg_xero_accounting_fivetran_database: ra-development
  stg_xero_accounting_fivetran_schema: fivetran_xero
  stg_xero_accounting_fivetran_accounts_table: "{{ source('fivetran_xero_accounting', 'account') }}"
  stg_xero_accounting_fivetran_payments_table: "{{ source('fivetran_xero_accounting', 'payment') }}"
  stg_xero_accounting_fivetran_categories_table: "{{ source('fivetran_xero_accounting', 'tracking_category') }}"
  stg_xero_accounting_fivetran_bank_transactions_table: "{{ source('fivetran_xero_accounting', 'bank_transaction') }}"
  stg_xero_accounting_fivetran_bank_transaction_line_items_table: "{{ source('fivetran_xero_accounting', 'bank_transaction_line_items') }}"
  stg_xero_accounting_fivetran_journal_table: "{{ source('fivetran_xero_accounting', 'journal') }}"
  stg_xero_accounting_fivetran_journal_line_table: "{{ source('fivetran_xero_accounting', 'journal_line') }}"
  stg_xero_accounting_fivetran_contacts_table: "{{ source('fivetran_xero_accounting', 'contact') }}"
  stg_xero_accounting_fivetran_contact_address_table: "{{ source('fivetran_xero_accounting', 'contact_address') }}"
  stg_xero_accounting_fivetran_currency_table: "{{ source('fivetran_xero_accounting', 'currency') }}"
  stg_xero_accounting_fivetran_expense_claims_table: "{{ source('fivetran_xero_accounting', 'expense_claim') }}"
  stg_xero_accounting_fivetran_invoices_table: "{{ source('fivetran_xero_accounting', 'invoice') }}"

  stg_officevibe_surveys_schema: analytics_seed
  stg_officevibe_surveys_results_table: "{{ source('officevibe', 'survey_results') }}"
  stg_officevibe_surveys_database: ra-development

  stg_enrichment_id-prefix: clearbit-
  stg_enrichment_clearbit_schema: enrichment
  stg_enrichment_clearbit_contacts_table: contacts_companies
  stg_enrichment_clearbit_companies_table: contacts_companies
  stg_enrichment_geolite_city_table: company_website.geolite_city_bq_b2b

  stg_stripe_payments_id-prefix: stripe-
  stg_stripe_payments_etl: stitch
  stg_stripe_payments_stitch_database: ra-development
  stg_stripe_payments_stitch_schema: stitch_stripe
  stg_stripe_payments_stitch_balance_transactions_table: "{{ source('stitch_stripe_payments', 'balance_transactions') }}"
  stg_stripe_payments_stitch_charges_table: "{{ source('stitch_stripe_payments', 'charges') }}"
  stg_stripe_payments_stitch_events_table: "{{ source('stitch_stripe_payments', 'events') }}"
  stg_stripe_payments_stitch_payout_transactions_table: "{{ source('stitch_stripe_payments', 'payout_transactions') }}"
  stg_stripe_payments_stitch_payouts_table: "{{ source('stitch_stripe_payments', 'payouts') }}"

  stg_stripe_subscriptions_id-prefix: stripe-
  stg_stripe_subscriptions_etl: segment
  stg_stripe_subscriptions_segment_database: ra-development
  stg_stripe_subscriptions_segment_schema: stripe
  stg_stripe_subscriptions_segment_customers_table: "{{ source('segment_stripe_subscriptions', 'customers') }}"
  stg_stripe_subscriptions_segment_accounts_table: "{{ source('segment_stripe_subscriptions', 'accounts') }}"
  stg_stripe_subscriptions_segment_cards_table: "{{ source('segment_stripe_subscriptions', 'cards') }}"
  stg_stripe_subscriptions_segment_coupons_table: "{{ source('segment_stripe_subscriptions', 'coupons') }}"
  stg_stripe_subscriptions_segment_discounts_table: "{{ source('segment_stripe_subscriptions', 'discounts') }}"
  stg_stripe_subscriptions_segment_invoices_table: "{{ source('segment_stripe_subscriptions', 'invoices') }}"
  stg_stripe_subscriptions_segment_plans_table: "{{ source('segment_stripe_subscriptions', 'plans') }}"
  stg_stripe_subscriptions_segment_products_table: "{{ source('segment_stripe_subscriptions', 'products') }}"
  stg_stripe_subscriptions_segment_subscriptions_table: "{{ source('segment_stripe_subscriptions', 'subscriptions') }}"
  stg_stripe_subscriptions_segment_balance_transactions_table: "{{ source('segment_stripe_subscriptions', 'balance_transactions') }}"
  stg_stripe_subscriptions_segment_charges_table: "{{ source('segment_stripe_subscriptions', 'charges') }}"
  stg_stripe_subscriptions_segment_events_table: "{{ source('segment_stripe_subscriptions', 'eventsplans') }}"
  stg_stripe_subscriptions_segment_payout_transactions_table: "{{ source('segment_stripe_subscriptions', 'payout_transactions') }}"
  stg_stripe_subscriptions_segment_payouts_table: "{{ source('segment_stripe_subscriptions', 'payouts') }}"

  stg_humaans_hr_database: ra-development
  stg_humaans_hr_schema: coupler_humaans
  stg_humaans_hr_id-prefix: humaans-

  stg_harvest_forecast_stitch_database : ra-development
  stg_harvest_forecast_stitch_schema : stitch_harvest_forecast_2
  stg_harvest_forecast_contacts_table : "{{ source('stitch_harvest_forecast', 'contacts') }}"
  stg_harvest_forecast_projects_table : "{{ source('stitch_harvest_forecast', 'projects') }}"
  stg_harvest_forecast_timesheets_forecast_table: "{{ source('stitch_harvest_forecast', 'assignments') }}"
  stg_harvest_forecast_id-prefix: harvest_forecast-

  web_sessionization_trailing_window: 3
  web_inactivity_cutoff: 30 * 60
  attribution_create_account_event_type: account_opened
  attribution_conversion_event_type: subscribed
  attribution_topup_event_type: account_credited
  attribution_converter_ltv: 200

  attribution_create_account_event_type: user_registration  # event name for registration events
  attribution_conversion_event_type: confirmed_order # event name for order events
  attribution_global_currency: 'USD' # currency code for global amounts
  attribution_lookback_days_window : 30  # how far back sessions can go to be eligable for attribution
  attribution_time_decay_days_window : 7 # over how many days do we decay the value of conversions for time-decay model
  attribution_include_conversion_session: true # whether the session containing the conversion event is within scope for attribution
  attribution_match_offline_conversions_to_sessions: true # whether orders and registrations are matched to Snowplow sessions or not
  attribution_max_session_hours: 24 # maximum length of a session in hours to be considered for matching purposes
  attribution_demo_mode: true # set to 'true' to source events, orders and other custom app data from seed files, 'false' to source from database

  attribution_models: ['first_click_attrib','first_non_direct_click_attrib','first_paid_click_attrib','last_click_attrib',
                      'last_non_direct_click_attrib','last_paid_click_attrib','even_click_attrib','time_decay_attrib'] # list of model names to be appended to measures

  attribution_input_measures: ['total_revenue_local_currency','total_revenue_global_currency','ltv_30d_local_currency','ltv_30d_global_currency',
                              'ltv_60d_local_currency','ltv_60d_global_currency','ltv_90d_local_currency','ltv_90d_global_currency',
                              'ltv_180d_local_currency','ltv_180d_global_currency','ltv_365d_local_currency','ltv_365d_global_currency'] # list of attribution input measures

  attribution_output_conversion_measures: {
                                          "count_registration_conversions" : "user_registration",
                                          "count_first_order_conversions" : "first_order",
                                          "count_repeat_order_conversions" : "repeat_order"
                                          } # list of attribution output conversion measures

  attribution_output_revenue_measures: {
                                        "first_order_total_revenue_local_currency" : "first_order_total_revenue_local_currency",
                                        "first_order_total_revenue_global_currency" : "first_order_total_revenue_global_currency",
                                        "first_order_ltv_30d_local_currency" : "first_order_ltv_30d_local_currency",
                                        "first_order_ltv_30d_global_currency" : "first_order_ltv_30d_global_currency",
                                        "first_order_ltv_60d_local_currency" : "first_order_ltv_60d_local_currency",
                                        "first_order_ltv_60d_global_currency" : "first_order_ltv_60d_global_currency",
                                        "first_order_ltv_90d_local_currency" : "first_order_ltv_90d_local_currency",
                                        "first_order_ltv_90d_local_currency" : "first_order_ltv_90d_global_currency",
                                        "first_order_ltv_180d_local_currency" : "first_order_ltv_180d_local_currency",
                                        "first_order_ltv_180d_global_currency" : "first_order_ltv_180d_global_currency",
                                        "first_order_ltv_365d_local_currency" : "first_order_ltv_365d_local_currency",
                                        "first_order_ltv_365d_global_currency" : "first_order_ltv_365d_global_currency",
                                        "repeat_order_total_revenue_local_currency" : "repeat_order_total_revenue_global_currency"
                                        } # list of attribution output revenue measures




  enable_companies_merge_file: true
  enable_ip_geo_enrichment: false