Is Today Unusual? Mean, Standard Deviation, z-Scores and a Row-Highlight Rule for Daily CPA
Lessons in this course
- 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