Tabellab
Marketing Analytics Intermediate

Marketing Dashboards & KPI Reporting: Blended CAC and MER, Channel Roll-Ups, Targets and Pacing, Sparklines & the Weekly Report Narrative

Build marketing dashboards that people trust and reports that get read, in 20 hands-on labs. You will calculate MER, blended CAC and acquisition MER from business totals, roll raw campaign exports up into a channel table with SUMIFS, clean and map messy source names, compare KPIs with targets in the right direction, pace a month against its target and separate real change from weekly noise. Then you add sparklines, heat maps and highlight rules, drive a scorecard from one selector cell, calibrate over-claiming platform numbers, read MER against the break-even level, fix total lines that average averages, forecast a quarter, flag unusual days, find the top movers, remove duplicates and reconcile with finance, check CAC payback by cohort, test budget scenarios and reallocations, let the sheet write the weekly narrative and finish with a complete four-week dashboard. 20 hands-on labs, fictional outdoor-gear shop, every cell checked as you go.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This course teaches the complete workflow behind a marketing dashboard, from the raw export to the sentence in the weekly report. In 20 interactive spreadsheet labs you work with the data of Fernhollow Outfitters, a fictional online shop for outdoor gear. You calculate the marketing efficiency ratio (MER), blended CAC and acquisition MER, roll campaign rows up into a channel table with SUMIFS and XLOOKUP, compare KPIs with targets, pace a month and a quarter, and add sparklines, colour scales and highlight rules so that problems are visible at a glance. Later labs deal with the quality of the numbers: over-attribution by ad platforms, weighted total lines, duplicates and reconciliation with finance, anomaly flags, cohort payback and budget what-if grids. You finish by letting formulas write the routine report sentences and by building a full four-week dashboard. Every formula is checked instantly. All companies, campaigns and numbers are fictional and all benchmarks are illustrative.

Why learn with Tabellab

  • Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
  • Verifiable certificatePass the final exam and get a certificate with a public verification code.
  • Try before you buyLesson 1 is free, with no sign-up or card needed.
  • Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint

Lessons

  1. Blended CAC and MER: Marketing Efficiency Ratio, Blended Customer Acquisition Cost and Acquisition MER from Monthly TotalsLabFree
  2. Channel Roll-Ups from Raw Exports: SUMIFS for Spend and Revenue, ROAS per Channel and Share of SpendLab Locked
  3. Cleaning Raw Exports: Clean Keys with LOWER and TRIM, a Channel Mapping Table with XLOOKUP and the Unmapped ShareLab Locked
  4. Targets on a Dashboard: Variance, Attainment for Higher- and Lower-Is-Better KPIs, Status Bands and a Highlight RuleLab Locked
  5. Pacing Against a Monthly Target: Days in Month with EOMONTH, Expected to Date, Pace, Run-Rate Projection and Required Daily RevenueLab Locked
  6. Week-over-Week Reporting: Conversion Rate, WoW Change, a Trailing 4-Week Average and the Deviation from Recent NormalLab Locked
  7. Sparklines and Conditional Formats: Trend per Channel, a Heat Map of Weekly ROAS and a Rule That Flags Falling ChannelsLab Locked
  8. A Scorecard Driven by One Selector Cell: XLOOKUP by Month, Previous Month with EDATE, MoM Change and Year-to-Date FiguresLab Locked
  9. Platform Numbers vs Reality: Over-Attribution Factor, Proportional Calibration and a Calibrated CAC per ChannelLab Locked
  10. Reading MER Honestly: New vs Returning Revenue, Break-Even MER and Contribution After MarketingLab Locked
  11. The Total Line Done Right: Weighted Conversion Rate and Order Value with SUMPRODUCT Instead of an Average of AveragesLab Locked
  12. Trend Forecasts for a Dashboard: SLOPE, FORECAST.LINEAR, R² and the Projected Attainment of a Quarter TargetLab Locked
  13. Is Today Unusual? Mean, Standard Deviation, z-Scores and a Row-Highlight Rule for Daily CPALab Locked
  14. Explaining the Change: Top Movers with RANK.EQ, LARGE and XLOOKUP and the Net Change of All CampaignsLab Locked
  15. Data Quality Checks: Row Keys with TEXT, Duplicate Highlighting, De-Duplicated Totals and Reconciliation with FinanceLab Locked
  16. Is the CAC Worth It? Cohort Payback Month, Six-Month Margin to CAC and a Payback Staircase with a Formula RuleLab Locked
  17. What-If Grid for a Bigger Budget: New MER by Extra Spend and Marginal ROAS, Mixed References and the Break-Even Marginal ROASLab Locked
  18. Budget Reallocation: Average vs Marginal ROAS, Giving and Receiving Channels with MIN, MAX and XLOOKUP and the New Blended MERLab Locked
  19. The Weekly Report Narrative: Sentences from Numbers with TEXT, a Direction Word with a Flat Band and a Headline CountLab Locked
  20. Final Project: A Four-Week Marketing Dashboard with Channel Roll-Up, Blended MER and CAC, Target Status and a Combo ChartLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy