with Faisal TusherLearning path
Marketing Analytics and Reporting
Learn marketing analysis and reporting in order: metric definitions, reports and Looker Studio, then SQL, BI governance, attribution and finance reporting.
4 levelsAbout 66 hoursUpdated
Path progress
0/24
Saved in this browser only.
What you will be able to do
- Define metrics once and use benchmarks with care when judging performance
- Build reports and Looker Studio dashboards that answer the questions people ask
- Query marketing data with SQL and govern metrics and dashboards as shared assets
- Choose a measurement approach and report marketing in terms finance accepts
Before you start
Levels
- Beginner3 modules · 15 lessons · about 10 hours
- – Organise metrics in a KPI tree with one agreed definition each
- – Use industry benchmarks without drawing the wrong conclusions
- – Turn a data dump into a monthly report with commentary and actions
- – Build a first Looker Studio report from a campaign dataset
Open the beginner levelBeginner progress0/6Saved in this browser only.
- Intermediate3 modules · 15 lessons · about 16 hours
- – 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
Open the intermediate levelIntermediate progress0/6Saved in this browser only.
- Advanced3 modules · 15 lessons · about 20 hours
- – Report from warehouse event data and reconcile it with the analytics interface
- – Build spend forecasts and incrementality readouts that finance can use for budget decisions
- – Run data quality and taxonomy governance across teams, platforms and markets
- – Write a reporting and analysis plan that ties every measure to a decision
Open the advanced levelAdvanced progress0/6Saved in this browser only.
- Expert3 modules · 15 lessons · about 20 hours
- – Design the warehouse tables behind marketing reporting, land ad platform data in them and test them before dashboards do
- – Assemble the dataset for a marketing mix model, review a delivered model and calibrate it with experiments
- – Value leads by pipeline stage, allocate shared costs for reporting and build rule-based attribution in SQL
- – Show finance which figures report, which decide spend and how sure each one is
Open the expert levelExpert progress0/6Saved in this browser only.