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.
- 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
- Blended CAC and MER: Marketing Efficiency Ratio, Blended Customer Acquisition Cost and Acquisition MER from Monthly TotalsFree
- Channel Roll-Ups from Raw Exports: SUMIFS for Spend and Revenue, ROAS per Channel and Share of Spend Locked
- Cleaning Raw Exports: Clean Keys with LOWER and TRIM, a Channel Mapping Table with XLOOKUP and the Unmapped Share Locked
- Targets on a Dashboard: Variance, Attainment for Higher- and Lower-Is-Better KPIs, Status Bands and a Highlight Rule Locked
- Pacing Against a Monthly Target: Days in Month with EOMONTH, Expected to Date, Pace, Run-Rate Projection and Required Daily Revenue Locked
- Week-over-Week Reporting: Conversion Rate, WoW Change, a Trailing 4-Week Average and the Deviation from Recent Normal Locked
- Sparklines and Conditional Formats: Trend per Channel, a Heat Map of Weekly ROAS and a Rule That Flags Falling Channels Locked
- A Scorecard Driven by One Selector Cell: XLOOKUP by Month, Previous Month with EDATE, MoM Change and Year-to-Date Figures Locked
- Platform Numbers vs Reality: Over-Attribution Factor, Proportional Calibration and a Calibrated CAC per Channel Locked
- Reading MER Honestly: New vs Returning Revenue, Break-Even MER and Contribution After Marketing Locked
- The Total Line Done Right: Weighted Conversion Rate and Order Value with SUMPRODUCT Instead of an Average of Averages Locked
- Trend Forecasts for a Dashboard: SLOPE, FORECAST.LINEAR, R² and the Projected Attainment of a Quarter Target Locked
- Is Today Unusual? Mean, Standard Deviation, z-Scores and a Row-Highlight Rule for Daily CPA Locked
- Explaining the Change: Top Movers with RANK.EQ, LARGE and XLOOKUP and the Net Change of All Campaigns Locked
- Data Quality Checks: Row Keys with TEXT, Duplicate Highlighting, De-Duplicated Totals and Reconciliation with Finance Locked
- Is the CAC Worth It? Cohort Payback Month, Six-Month Margin to CAC and a Payback Staircase with a Formula Rule Locked
- What-If Grid for a Bigger Budget: New MER by Extra Spend and Marginal ROAS, Mixed References and the Break-Even Marginal ROAS Locked
- Budget Reallocation: Average vs Marginal ROAS, Giving and Receiving Channels with MIN, MAX and XLOOKUP and the New Blended MER Locked
- The Weekly Report Narrative: Sentences from Numbers with TEXT, a Direction Word with a Flat Band and a Headline Count Locked
- Final Project: A Four-Week Marketing Dashboard with Channel Roll-Up, Blended MER and CAC, Target Status and a Combo Chart Locked
Learner reviews
Be the first to review this course.