Skip to content
Faisal Mahmud TusherDigital marketing, SEO & analytics
with Faisal Tusher

Marketing 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
  1. 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.

    1. 1.1ReadSQL for MarketersGuide
    2. 1.2ReadMetrics Layer and Metric DefinitionsGuide
    3. 1.3ReadDashboard GovernanceGuide
    4. 1.4DoWriting a Channel Summary Query for a Broadband ProviderLesson
    5. 1.5CheckCheckpoint: SQL, Metric Definitions and Dashboard GovernanceLesson
  2. 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.

    1. 2.1ReadChoosing an Attribution ApproachGuide
    2. 2.2ReadMarketing Mix Modelling vs Multi-Touch AttributionComparison
    3. 2.3ReadMarketing Mix Modelling BasicsGuide
    4. 2.4DoChoosing a Measurement Approach for an Insurance BrokerLesson
    5. 2.5CheckCheckpoint: Attribution, MMM and ExperimentsLesson
  3. 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.

    1. 3.1ReadThe Marketing P&L ExplainedGuide
    2. 3.2ReadROI vs ROAS for Finance ReportingComparison
    3. 3.3ReadTracking Marketing Spend Against BudgetGuide
    4. 3.4DoReconciling Marketing Spend for a Garden Furniture BrandLesson
    5. 3.5DoCapstone: A Quarterly Marketing Performance Review for a Gym ChainLesson