Stub ClickHouse

raw

• events

  event_id, event_time, event_name, payload

core

• fct_stats_daily

  date, campaign_id, adgroup_id, geo_id, cost_rub, budget_plan_rub, impressions, clicks, cpc, cpa, learning_status

• fct_attribution

  date, model, window_days, credit_share, credit_revenue, credit_profit, campaign_id

• fct_orders

• fct_visits

• dim_campaign

• dim_adgroup

• dim_ad

• dim_geo

  region_id, name, region_type

• dim_goal

• dim_product_category

marts

• unit_econ_daily

  date, cost_rub, revenue_rub, gross_profit_rub, maturity_share, new_customers, returning_customers, target_revenue_rub

• cohort_conversion_lag

  cohort_date, campaign_id, horizon_days, sales_cum, cpa_cum, drr_cum, maturity_share, entity_type

• change_cohort

  change_id, created_at, actor_type, actor_id, entity_type, entity_id, change_type, hypothesis, tier, status, verdict_30d

• signal_health_daily

• recon_daily

• ltv_cohorts

• geo_city_daily

  date, region_id, clicks, cost_rub, leads, sales

default

нет таблиц в фикстуре