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

Marketing Analytics and Reporting › Level

Marketing Analytics and Reporting: Beginner

Organise metrics in a KPI tree with one agreed definition each
3 modulesAbout 10 hours
Beginner progress
0/6

Saved in this browser only.

By the end of this level

  • 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
  1. Module 1

    From data to decisions

    What marketing analysis is for, how a KPI tree links metrics to outcomes and how to use benchmarks without being misled.

    1. 1.1ReadMarketing Data and Analytics LibraryHub
    2. 1.2ReadKPI TreesGuide
    3. 1.3ReadHow to Use Industry BenchmarksGuide
    4. 1.4DoDefining Metrics for a Car Wash ChainLesson
    5. 1.5CheckCheckpoint: Metrics, KPI Trees and BenchmarksLesson
  2. Module 2

    Reports people read

    Reporting versus business intelligence, a monthly report template and the routine that produces the pack on time.

    1. 2.1ReadReporting vs Business IntelligenceComparison
    2. 2.2ReadMonthly Marketing Report TemplateTemplate
    3. 2.3ReadMonthly Reporting Pack SOPSOP
    4. 2.4DoRestructuring a Monthly Report for a Dental GroupLesson
    5. 2.5CheckCheckpoint: Monthly Marketing ReportingLesson
  3. Module 3

    Working with data in Looker Studio

    Connect data sources, create calculated fields and practise on a sample campaign dataset before building for real.

    1. 3.1ReadData Sources and ConnectorsGuide
    2. 3.2ReadCalculated Fields in Looker StudioTutorial
    3. 3.3ReadSample Campaign DatasetData resource
    4. 3.4DoBuilding Calculated Fields for an Outdoor Gear RetailerLesson
    5. 3.5DoCapstone: A First Marketing Report for a Pet Supplies StoreLesson