Quality Checks Before Reporting: Naming Codes with LEFT, Impossible Rows, Duplicate Ads and Reconciling Spend
Lessons in this course
- Campaign, Ad Set, Ad: Reading the Account Structure and Rolling Ad Results Up with SUMIFSFree
- The Delivery Chain: CPM, Link CTR and Conversion Rate and How They Multiply into the Cost per Purchase Locked
- Diagnosing a Weak Ad Set: Account Rates from Totals, CPM, CTR and CVR Indexes and an IFS Diagnosis Locked
- Audiences: Reach, Frequency, Reach % of the Audience and the Cost per 1,000 People Reached Locked
- Frequency and Creative Fatigue: Weekly Frequency, CTR Change Against Week 1 and a Refresh Rule Locked
- Audience Overlap: Shared People, Overlap % of the Smaller Audience, Unique Reach and When to Merge Locked
- The Learning Phase: Weekly Optimisation Events, Days Since the Last Edit and the Budget an Ad Set Needs Locked
- Budgets: Campaign Budget (CBO) vs Ad Set Budgets, Budget Shares and the Blended Cost per Purchase Locked
- Placement Breakdowns: Facebook vs Instagram, Feed vs Stories vs Reels, Shares of Spend and Cost per Purchase Locked
- Creative Testing: Hook Rate, Hold Rate, Cost per Purchase and Ranking Video Ads with RANK.EQ Locked
- Reporting and Attribution: 7-Day Click vs 1-Day View, View-Through Share, ROAS and the Gap to Shop Analytics Locked
- ROAS in Context: Margin Lookup with XLOOKUP, Break-Even ROAS and Profit After Ad Spend Locked
- Scaling a Budget: Rising Cost per Purchase, Profit per Day and the Cost of Each Extra Purchase Locked
- Seasonal CPM: Trend with SLOPE, a FORECAST.LINEAR Plan and What the Same Budget Buys in Peak Weeks Locked
- Split Tests: Conversion Rates, Relative Lift, the z-Score and an Honest Verdict Locked
- Quality Checks Before Reporting: Naming Codes with LEFT, Impossible Rows, Duplicate Ads and Reconciling Spend Locked
- Funnel Stages: Prospecting, Retargeting and Retention by Share of Spend, Cost per Purchase and New Customers Locked
- Budget Pacing: Cumulative Spend, the Plan to Date with DAY and EOMONTH, Month-End Projection and the Corrected Daily Budget Locked
- Scenario Grid: Cost per Purchase for Every CPM and Conversion Rate with Mixed References and a Heat Map Locked
- Final Project: The Monthly Meta Ads Report by Funnel Stage with Spend, CPM, Cost per Purchase, ROAS, a Verdict and a Chart Locked