Tabellab

Paid advertising courses: PPC, social ads and media planning math

Paid media rewards people who can do the arithmetic quickly: cost per click, cost per acquisition, reach and frequency, budget pacing and break-even bids.

Paid Ads: PPC & Media Planning courses (13)

$9.90Beginner

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

$9.90Intermediate

Podcast Advertising Math: Downloads, CPM, Promo Codes & ROAS

Model episode download curves, price pre-, mid- and post-roll ads by CPM, compare flat-rate and CPM deals, attribute orders with promo codes, vanity URLs and survey lift, then go further: filter raw downloads, pace impression commitments and make-goods, price the back catalog, cost code leakage, spot ad wear-out, judge profit ROAS, net rate cards, run a show's P&L, decide test flights and reconcile invoices, in 20 hands-on labs, every cell checked. Fictional shows, illustrative CPMs.

20 lessons · 20 labs

$9.90Intermediate

Digital Advertising Math: Search & Social Ads

Calculate CTR, CPA and ROAS, roll keyword reports up with SUMIFS, set break-even CPAs, pace budgets, model ad auctions, compare attribution models, test ad creatives and scale audiences, then clean search terms, set bid adjustments and product bids, pay for new customers, measure incrementality, cap frequency, correct conversion lag, size budget headroom, plan a seasonal budget, reconcile platform claims and build a monthly report, in 20 hands-on labs with every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Streaming Audio Ads: Listen-Through Rate, Companion Banners, Frequency, Dayparts, Cost per Listen & Promo-Code Response

Measure ads on music-streaming and radio apps with nothing but a spreadsheet. You will turn delivery reports into listen-through rates, eCPM and cost per completed listen, read quartile drop-off, size companion banners by device, split reach from frequency and find where response flattens. Then you compare dayparts and a daypart-by-weekday grid, price promo codes after the discount, climb the cost ladder to cost per redemption, read an order survey and test a brand-lift survey for significance. Later labs run a frequency-cap what-if, track creative wear-out with SLOPE and FORECAST.LINEAR, apply an attribution window to redemption lags, check pacing against the calendar, screen reports for bad lines, test a budget shift with diminishing returns, forecast the next flight, plan an A/B test and finish with a campaign dashboard. 20 hands-on labs, fictional Dunlin Trail Co. data, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Connected TV & Streaming Ads: Household Reach & Frequency, Cost per Completed View, Co-Viewing, Incremental Reach, QR Response & Attribution Windows

Plan and judge streaming TV campaigns with real arithmetic. You start with household reach and frequency, compare CPM with cost per completed view, convert household impressions into viewer impressions, read a frequency distribution and separate the households that only streaming reached from linear TV. Then you measure publisher overlap and effective reach, check flight pacing and verified impressions, follow QR codes and second-screen response, choose attribution windows, run holdout and matched-market tests, test whether a lift is real, read a brand lift survey, forecast reach with diminishing returns, compare budget scenarios and finish with a campaign dashboard in 20 hands-on labs, fictional data, every cell checked as you go.

20 lessons · 20 labs

$9.90Beginner

Google Search Ads Campaigns: Keywords & Match Types, Quality Score & Ad Rank, Search Terms, Negatives, Impression Share & Account Structure

Learn how a Google Search campaign works by rebuilding its numbers in a spreadsheet. You will read a keyword report with CTR, average CPC, conversion rate and cost per conversion, compare broad, phrase and exact match, rebuild a Quality Score from its three components, calculate Ad Rank and the actual CPC of a simplified auction, sort a search terms report, test negative keywords with wildcards and turn impression share into lost impressions. Then you measure ad assets, roll keywords up to ad groups and campaigns, derive bids from a target CPA, pace a monthly budget, price a better Quality Score in a what-if grid, segment by device and time of day, compare responsive search ads, forecast what more budget would buy, check landing pages, project a click trend, separate brand from non-brand, audit the account and finish with a quarterly scorecard. 20 hands-on labs, fictional bike shop Tarnwick Cycles, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Native Advertising & Sponsored Content: Widget CPC, Engaged Visits, Scroll Depth, Publisher Packages & Disclosure Rules

Judge sponsored traffic by what readers do, not by what a click costs. You will turn views, clicks and spend of recommendation-widget headlines into CTR, CPC and cost per 1,000 views, measure the gap between clicks and landing sessions, define an engaged visit and compare CPC with cost per engaged visit, follow readers down the page with scroll-depth curves, roll placements up by publisher, device and position, price flat-fee sponsored articles with guarantees and make-good credits, compare publisher rate cards, connect engaged visits to orders and ROAS, read conversion lag and attribution windows, spot headlines that win clicks they cannot keep, plan bids, budgets and delivery, claim credits for invalid traffic, test headlines for significance, track creative fatigue, audit disclosure labels, compare sponsored reading with an editorial benchmark, build a what-if grid and finish with a six-month dashboard, all in 20 hands-on labs with fictional Wickerby Kitchen Supply data, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

PPC Bidding & Budget Pacing: Break-Even Bids, Manual CPC vs Target CPA vs Target ROAS, Bid Modifiers, Monthly Pacing & Spend Forecasts

Set bids and budgets you can defend. You will calculate break-even CPC, CPA and ROAS, turn a target CPA into capped manual bids, compare manual CPC, target CPA and target ROAS campaigns, derive the max CPC a ROAS target implies, build day-parting, device and geo modifiers and see how they stack, then pace a monthly budget day by day, forecast month-end spend, weight the plan by weekday, read impression share lost to budget and rank, move money by marginal CPA, find the most profitable bid on a bid landscape, check whether campaigns have enough data for automated bidding, build a target ROAS what-if grid, plan a seasonal annual budget, test a bid strategy change and finish with a bidding and pacing dashboard. 20 hands-on labs, fictional bike-parts shop Fernwick Cycle Supply, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

TikTok Ads & Short-Video Advertising: Hook Rate, Hold Rate, CPV, CPA, Creative Rotation, Bidding & Attribution Windows

The arithmetic behind TikTok ads and boosted creator posts, one spreadsheet at a time. You measure hook rate and hold rate, read quartile views and completion, price attention with CPM, CPV and cost per 6-second view, follow the funnel from view to purchase and set break-even and target CPAs. After that you score creatives against format benchmarks, catch creative fatigue with a trend line, cost boosted creator posts all-in, check bid strategies and delivery, size budgets for the learning phase, pace a monthly budget, compare attribution windows, correct recent days for conversion lag, judge split tests with a z-score, run a test lane with kill rules, plan creative rotation with dates, summarise audiences with SUMIFS, link frequency to CTR, build a CPA what-if grid and finish with an account dashboard: 20 hands-on labs, fictional tea brand Tindlewick Tea Co., every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

YouTube & Video Ads: View Rate, CPV, Cost per Completed View, Reach & Frequency, Video Sequencing & Brand Lift

Measure video advertising the way an analyst does. You will calculate view rate and cost per view for skippable in-stream ads, read quartile reports, price a completed view, work out reach, average frequency and the cost per 1,000 people reached, plan budgets from a view target and translate CPV into CPM. Then you go deeper: watch time and earned actions, audiences and devices with SUMIFS, the first five seconds and benchmarks by length, five ad formats on one scale, frequency distributions and caps, reach curves with marginal cost, video sequences step by step, brand-lift surveys with absolute and relative lift, a significance test, confidence intervals and survey sizes, creative wear-out, a placement audit, a what-if grid and a budget ranked by cost per lifted user, finishing with a quarterly dashboard. 20 hands-on labs, fictional e-bike brand Tarnwick Cycles, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Media Planning: Reach, Frequency, GRP & CPM

Calculate GRPs and TRPs, compare buys by CPM and CPP, build a channel plan, combine reach, measure effective frequency, schedule flights, pick the best mix and check delivery, then model reach curves, budget for reach goals, use measured duplication, select programmes by index, cost rate cards, weight regional markets, plan share of voice, model adstock, compare burst and continuity, weight exposures, test cost scenarios and build a launch dashboard, in 20 hands-on labs with every cell checked.

20 lessons · 20 labs

$9.90Intermediate

LinkedIn Ads for B2B Lead Generation: Audience Sizing, CPM & CPL, Lead Gen Forms vs Landing Pages, Lead Quality, Pipeline & Account Lists

Plan and judge LinkedIn campaigns for B2B in Excel. You will size audiences from job titles, company size and industry, calculate CPM, CTR, CPC and cost per lead, compare Lead Gen Forms with landing pages, follow leads to MQL, SQL and pipeline, check account lists and match rates, forecast leads from a budget, break results down by seniority, test leads against the target profile, measure creative fatigue, test forms for significance, find the marginal cost of scaling, time the sales cycle, report account penetration, allocate a budget with caps, build a what-if grid, score leads, pace a monthly budget and finish with a programme dashboard: 20 hands-on labs, fictional B2B software company, every cell checked as you go.

20 lessons · 20 labs

$9.90Advanced

Programmatic Display Advertising: Auction Mechanics, vCPM & Viewability, Tech Fees & Working Media, Deals vs Open Auction, Brand Safety & Supply Paths

Understand where a programmatic display budget goes. You will decide who wins first-price and second-price auctions, read win rates and clearing CPMs, turn CPM into vCPM, take budgets through the fee stack to working media and price quality impressions as qCPM. Then you compare open auction with private marketplaces and guaranteed deals, shade bids along a win curve, block invalid traffic and unsuitable sites, cut expensive supply paths, audit authorised sellers, cap frequency, pace a flight, fit a win-rate regression, test viewability differences for significance, measure incrementality with holdouts, judge data fees, build size-by-device and what-if grids, set walk-away prices for deals and finish with a partner scorecard. 20 hands-on labs, fictional retailer Fernhollow Cycles, every cell checked as you go.

20 lessons · 20 labs

Paid media rewards people who can do the arithmetic quickly: cost per click, cost per acquisition, reach and frequency, budget pacing and break-even bids. These courses go platform by platform, from search and social to video, streaming audio, connected TV and podcasts, and add a general media-planning course for splitting a budget across channels. Every lab is a spreadsheet exercise built around a realistic campaign, so the formulas carry over to your own accounts.

This topic hub gathers 13 Paid Ads: PPC & Media Planning courses from Marketing: 2 beginner, 10 intermediate, 1 advanced. Most courses have about 20 hands-on labs, a final exam and a certificate, and the first lesson of every course is free. Searches this hub is built for: ppc bidding strategy excel; cpc cpm cpa formulas; media planning excel; meta ads metrics.

Frequently asked questions

Which Paid Ads: PPC & Media Planning course should I start with?

Start with “Digital Advertising Math”. It is the most central course in this topic at intermediate level. Then move on to the more specialised courses in the list above.

How much do the Paid Ads: PPC & Media Planning courses cost?

Every course costs a one-time $9.90, with no subscription, and the first lesson of each course is free so you can try it before buying. Each course ends with a final exam and a certificate.

How are the Paid Ads: PPC & Media Planning courses taught?

Each course is a series of hands-on labs in a built-in spreadsheet that checks your formulas as you type, with short explanations alongside. You need only a web browser; nothing to install. Examples use fictional data and are for learning, not professional advice.

Open your first lab in under a minute

Pick a course, pay once and start right away. Your progress is saved in your account.

Browse the courses