with Faisal TusherMarketing Analytics and Reporting › Level
Marketing Analytics and Reporting: Intermediate
Query marketing data with SQL and keep metric definitions in one shared layer
3 modulesAbout 16 hours
Intermediate progress
0/6
Saved in this browser only.
By the end of this level
- Query marketing data with SQL and keep metric definitions in one shared layer
- Govern dashboards so they stay accurate, owned and used
- Choose between attribution, marketing mix modelling and experiments for a question
- Report marketing in a P&L, ROI and budget view that finance accepts
Module 1
SQL, metric layers and dashboard governance
Query marketing data with SQL, define metrics once in a shared layer and keep dashboards accurate, owned and used.
Module 2
Choosing a measurement approach
When to rely on attribution, when marketing mix modelling answers the question better and how the two fit with experiments.
Module 3
Finance-facing reporting
Present marketing in a P&L, report ROI and ROAS in the way finance expects and track spend against budget.