Quality Checks Before the Report: Impossible Numbers, a Check Flag with IF and OR, and a Highlighted Export
Lessons in this course
- The Channel Landscape: Sessions, Orders and Revenue by Channel, Share of Traffic, Conversion Rate and Revenue per SessionFree
- Owned, Earned and Paid Media: Sorting Touchpoints and Summing Sessions and Revenue by Type with COUNTIF and SUMIF Locked
- The Marketing Funnel: Stages from Awareness to Loyalty, Step Conversion, Share of Visits and Where People Drop Out Locked
- Paying for Attention: Impressions, Reach, Frequency, CPM and CTR Across Ten Ad Sets Locked
- From Click to Customer: CPC, Conversion Rate and CPA, How They Multiply and a Target CPA Check Locked
- The Revenue Side: Average Order Value, ROAS, Break-Even ROAS from the Gross Margin and Profit After Ad Spend Locked
- Customer Acquisition Cost: New Customers, Paid CAC, Blended CAC and a Year of Monthly Figures Locked
- Lifetime Value: Margin per Year, a Simple LTV, the LTV:CAC Ratio, Payback Months and a Verdict with IFS Locked
- Segments: Sessions and Orders by Channel and Device with SUMIFS, Mixed References and COUNTIFS Locked
- Campaign Tags: Source and Medium, Channel Grouping with XLOOKUP and the Unassigned Share Locked
- A First Budget Plan: Splitting a Monthly Budget by Channel into Expected Visits, Orders and Revenue Locked
- Working Backwards from a Revenue Target: Orders, Visits, Paid Visits and the Budget It Takes Locked
- Reading a Trend: Week-over-Week Change, a 4-Week Moving Average, SLOPE and FORECAST.LINEAR Locked
- A First Test: Two Page Versions, Conversion Rates, Lift and Simple Rules for a Decision Locked
- A What-If Grid: CPA for Every Combination of CPC and Conversion Rate, Break-Even CPC and a Coloured Target Zone Locked
- Quality Checks Before the Report: Impossible Numbers, a Check Flag with IF and OR, and a Highlighted Export Locked
- A Campaign Calendar: Durations from Dates, Budget per Day, Status on a Check Date and What Is Live Locked
- A Channel Scorecard: ROAS and CPA per Channel, Ranking with RANK.EQ, the Winner with INDEX and MATCH, and LARGE Locked
- Three Scenarios: Cautious, Expected and Optimistic Orders, Revenue with SUMPRODUCT, ROAS and Blended CPA Locked
- Final Project: A One-Page First Marketing Plan with Expected Orders and Revenue, Media-Type Summary, Blended CAC, LTV:CAC and a Chart Locked