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.
- 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
- 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
Learner reviews
Be the first to review this course.