D-02 · Маркетолог-оператор

Операционный контроль кампаний

Pacing, обучение, гео-CPA и очередь согласований на уровне кампаний.

maturity offno inflationchange markers

1 ready5 todo

Pacing бюджета

D-02.pacing

Дневной spend vs план из core.fct_stats_daily.

core.fct_stats_daily

{{grain}} · text{{day_from}} · date{{day_to}} · date

SELECT
    multiIf(
      {{grain}} = 'week',  toStartOfWeek(date, 1),
      {{grain}} = 'month', toStartOfMonth(date),
      date
    ) AS period,
    sum(cost_rub) AS spend_rub,
    sum(budget_plan_rub) AS budget_plan_rub,
    if(sum(budget_plan_rub) = 0, NULL, sum(cost_rub) / sum(budget_plan_rub)) AS pacing
FROM core.fct_stats_daily
WHERE date BETWEEN toDate({{day_from}}) AND toDate({{day_to}})
GROUP BY period
ORDER BY period