D-04 · Аналитик/CMO

Атрибуция и окна

Сравнение моделей и окон атрибуции, post-view и валюта/НДС.

maturity offinflation toggleno markers

1 ready3 todo

Сравнение моделей атрибуции

D-04.models_compare

credit_share / revenue / profit по model × window.

core.fct_attribution

{{day_from}} · date{{day_to}} · date

SELECT
    model,
    window_days,
    sum(credit_share) AS credit_share,
    sum(credit_revenue) AS credit_revenue,
    sum(credit_profit) AS credit_profit
FROM core.fct_attribution
WHERE date BETWEEN toDate({{day_from}}) AND toDate({{day_to}})
GROUP BY model, window_days
ORDER BY model, window_days