D-01 · CMO/CEO

Пульс юнит-экономики

Ежедневный снимок ROMI/POAS, выручки и прибыли без сырых API платформ.

maturity oninflation togglechange markers

2 ready3 todo

ROMI / POAS

D-01.romi_poas

Периодный ROMI и POAS по витрине unit_econ_daily.

marts.unit_econ_daily

{{day_from}} · date{{day_to}} · date{{min_maturity}} · number

SELECT
    round(if(sum(cost_rub) = 0, NULL, sum(revenue_rub) / sum(cost_rub)), 2) AS romi,
    round(if(sum(cost_rub) = 0, NULL, sum(gross_profit_rub) / sum(cost_rub)), 2) AS poas
FROM marts.unit_econ_daily
WHERE date BETWEEN toDate({{day_from}}) AND toDate({{day_to}})
  AND maturity_share >= {{min_maturity}}