Tabellab

Paying for Attention: Impressions, Reach, Frequency, CPM and CTR Across Ten Ad Sets

Lesson 4 of 20 Lab 🔒 Locked

Lessons in this course

  1. The Channel Landscape: Sessions, Orders and Revenue by Channel, Share of Traffic, Conversion Rate and Revenue per SessionLabFree
  2. Owned, Earned and Paid Media: Sorting Touchpoints and Summing Sessions and Revenue by Type with COUNTIF and SUMIFLab Locked
  3. The Marketing Funnel: Stages from Awareness to Loyalty, Step Conversion, Share of Visits and Where People Drop OutLab Locked
  4. Paying for Attention: Impressions, Reach, Frequency, CPM and CTR Across Ten Ad SetsLab Locked
  5. From Click to Customer: CPC, Conversion Rate and CPA, How They Multiply and a Target CPA CheckLab Locked
  6. The Revenue Side: Average Order Value, ROAS, Break-Even ROAS from the Gross Margin and Profit After Ad SpendLab Locked
  7. Customer Acquisition Cost: New Customers, Paid CAC, Blended CAC and a Year of Monthly FiguresLab Locked
  8. Lifetime Value: Margin per Year, a Simple LTV, the LTV:CAC Ratio, Payback Months and a Verdict with IFSLab Locked
  9. Segments: Sessions and Orders by Channel and Device with SUMIFS, Mixed References and COUNTIFSLab Locked
  10. Campaign Tags: Source and Medium, Channel Grouping with XLOOKUP and the Unassigned ShareLab Locked
  11. A First Budget Plan: Splitting a Monthly Budget by Channel into Expected Visits, Orders and RevenueLab Locked
  12. Working Backwards from a Revenue Target: Orders, Visits, Paid Visits and the Budget It TakesLab Locked
  13. Reading a Trend: Week-over-Week Change, a 4-Week Moving Average, SLOPE and FORECAST.LINEARLab Locked
  14. A First Test: Two Page Versions, Conversion Rates, Lift and Simple Rules for a DecisionLab Locked
  15. A What-If Grid: CPA for Every Combination of CPC and Conversion Rate, Break-Even CPC and a Coloured Target ZoneLab Locked
  16. Quality Checks Before the Report: Impossible Numbers, a Check Flag with IF and OR, and a Highlighted ExportLab Locked
  17. A Campaign Calendar: Durations from Dates, Budget per Day, Status on a Check Date and What Is LiveLab Locked
  18. A Channel Scorecard: ROAS and CPA per Channel, Ranking with RANK.EQ, the Winner with INDEX and MATCH, and LARGELab Locked
  19. Three Scenarios: Cautious, Expected and Optimistic Orders, Revenue with SUMPRODUCT, ROAS and Blended CPALab Locked
  20. Final Project: A One-Page First Marketing Plan with Expected Orders and Revenue, Media-Type Summary, Blended CAC, LTV:CAC and a ChartLab Locked