Tabellab

Meta Ads (Facebook & Instagram): Campaign Structure, Audiences & Overlap, the CPM-CTR-CVR Chain, Frequency, Learning Phase, Budgets & Reporting

Learn to read and steer Facebook and Instagram ads with a spreadsheet. You will roll ads up to ad sets and campaigns, split the cost per purchase into CPM, link CTR and conversion rate, diagnose weak ad sets against the account, measure reach, frequency and creative fatigue, check audience overlap, see what the learning phase demands of a budget and compare a campaign budget (CBO) with ad set budgets. Then you go deeper: placement breakdowns, hook and hold rates of video ads, attribution windows, break-even ROAS, the marginal cost of scaling, a seasonal CPM forecast, split-test significance, export quality checks, funnel stages, budget pacing and a scenario grid, and you finish with a monthly report by funnel stage. 20 hands-on labs, fictional candle shop Saltmarsh Candle Co., every cell checked as you go.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This course teaches you to read and steer Facebook and Instagram advertising with nothing more than a spreadsheet. In 20 interactive labs you work on the fictional account of Saltmarsh Candle Co., an online shop for candles and home fragrance. You roll ad results up to ad sets and campaigns, split the cost per purchase into CPM, link CTR and conversion rate, and index each ad set against the account to find the weak link. You measure reach, frequency, creative fatigue and audience overlap, work out what the learning phase demands of a budget and compare a campaign budget (CBO) with ad set budgets. Later labs cover placement breakdowns, hook and hold rates, attribution windows, break-even ROAS, the marginal cost of scaling, a seasonal CPM forecast, split-test significance, export checks, funnel stages and budget pacing. You finish with a monthly report by funnel stage, a 20-question exam and a certificate. Every formula is checked as you type. All companies, campaigns and figures are fictional, and 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

  1. Campaign, Ad Set, Ad: Reading the Account Structure and Rolling Ad Results Up with SUMIFSLabFree
  2. The Delivery Chain: CPM, Link CTR and Conversion Rate and How They Multiply into the Cost per PurchaseLab Locked
  3. Diagnosing a Weak Ad Set: Account Rates from Totals, CPM, CTR and CVR Indexes and an IFS DiagnosisLab Locked
  4. Audiences: Reach, Frequency, Reach % of the Audience and the Cost per 1,000 People ReachedLab Locked
  5. Frequency and Creative Fatigue: Weekly Frequency, CTR Change Against Week 1 and a Refresh RuleLab Locked
  6. Audience Overlap: Shared People, Overlap % of the Smaller Audience, Unique Reach and When to MergeLab Locked
  7. The Learning Phase: Weekly Optimisation Events, Days Since the Last Edit and the Budget an Ad Set NeedsLab Locked
  8. Budgets: Campaign Budget (CBO) vs Ad Set Budgets, Budget Shares and the Blended Cost per PurchaseLab Locked
  9. Placement Breakdowns: Facebook vs Instagram, Feed vs Stories vs Reels, Shares of Spend and Cost per PurchaseLab Locked
  10. Creative Testing: Hook Rate, Hold Rate, Cost per Purchase and Ranking Video Ads with RANK.EQLab Locked
  11. Reporting and Attribution: 7-Day Click vs 1-Day View, View-Through Share, ROAS and the Gap to Shop AnalyticsLab Locked
  12. ROAS in Context: Margin Lookup with XLOOKUP, Break-Even ROAS and Profit After Ad SpendLab Locked
  13. Scaling a Budget: Rising Cost per Purchase, Profit per Day and the Cost of Each Extra PurchaseLab Locked
  14. Seasonal CPM: Trend with SLOPE, a FORECAST.LINEAR Plan and What the Same Budget Buys in Peak WeeksLab Locked
  15. Split Tests: Conversion Rates, Relative Lift, the z-Score and an Honest VerdictLab Locked
  16. Quality Checks Before Reporting: Naming Codes with LEFT, Impossible Rows, Duplicate Ads and Reconciling SpendLab Locked
  17. Funnel Stages: Prospecting, Retargeting and Retention by Share of Spend, Cost per Purchase and New CustomersLab Locked
  18. Budget Pacing: Cumulative Spend, the Plan to Date with DAY and EOMONTH, Month-End Projection and the Corrected Daily BudgetLab Locked
  19. Scenario Grid: Cost per Purchase for Every CPM and Conversion Rate with Mixed References and a Heat MapLab Locked
  20. Final Project: The Monthly Meta Ads Report by Funnel Stage with Spend, CPM, Cost per Purchase, ROAS, a Verdict and a ChartLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy