Tabellab

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 Certificate

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

About this course

This course follows a programmatic display budget from the auction to the result, one spreadsheet lab at a time. In 20 labs you decide who wins first-price and second-price auctions, read win rates and clearing CPMs, convert CPM into vCPM with viewability data, take budgets through agency, DSP, data and SSP fees to working media, and price quality impressions as qCPM. You compare open auction, private marketplaces and guaranteed deals, shade bids along a win curve, block invalid traffic, cut costly supply paths, audit authorised sellers, cap frequency, pace a flight, test viewability differences for significance and measure incrementality with holdouts, before finishing with a partner scorecard. Every lab uses a fresh data set of the fictional e-bike retailer Fernhollow Cycles, and every formula is checked as you type. All companies, data and benchmarks in the course are fictional and 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. Auction Mechanics: Who Wins a Display Auction and What the Winner Pays at First Price and at Second PriceLabFree
  2. From Bid Requests to Impressions: Win Rate, Clearing CPM and the Gap Between Bid and Price per Line ItemLab Locked
  3. Viewability and vCPM: Measured Rate, Viewability Rate and the Cost per 1,000 Viewable Impressions by PlacementLab Locked
  4. Tech Fees and Working Media: Agency and DSP Percentages, Data and Verification CPMs, SSP Take Rate and What the Publisher ReceivesLab Locked
  5. All-In CPM and qCPM: Adding Fees, Removing Unviewable, Invalid and Unsuitable Impressions and Ranking Supply SourcesLab Locked
  6. Deals vs Open Auction: Comparing Open Exchange, Private Marketplace, Preferred Deals and Programmatic Guaranteed on CPM and vCPMLab Locked
  7. Bid Shading at First Price: The Win Curve, Expected Surplus per Bid Level and the Best Bid with INDEX and MATCHLab Locked
  8. Brand Safety and Invalid Traffic: Unsuitable and IVT Rates, Wasted Spend and Block, Review or Keep Rules per DomainLab Locked
  9. Supply-Path Optimisation: Take Rates per Path, the Best Route to Each Publisher with MINIFS and the Money Recovered by Cutting ResellersLab Locked
  10. Authorised Sellers Audit: Matching Bid-Stream Sellers to Publisher Lists with Keys, COUNTIFS and XLOOKUP, and the Direct Share of SpendLab Locked
  11. Reach, Frequency and Capping: Impressions per Frequency Group, Average Frequency and the Budget Freed by a Frequency CapLab Locked
  12. Budget Pacing: Ideal Cumulative Spend, Pacing Index, a FORECAST.LINEAR Projection to the End of the Flight and the Required Daily SpendLab Locked
  13. Modelling the Win Curve: SLOPE, INTERCEPT and R Squared of Win Rate on Bid and the Bid That Reaches a Target Win RateLab Locked
  14. Is the Deal Really More Viewable? A Two-Proportion z-Test with Pooled Rate, z Value, p-Value and a Verdict for Eight Size TestsLab Locked
  15. View-Through vs Incremental: Holdout Rates, Incremental Conversions and the True Cost per Conversion by AudienceLab Locked
  16. Is the Data Segment Worth Its Fee? Data CPM, Cost per Conversion, Lift and Break-Even Lift for Ten Audience SegmentsLab Locked
  17. Size by Device: Two-Way SUMIFS Grids with Mixed References for Spend and vCPM, the Cheapest Combination and the In-App ShareLab Locked
  18. What-If Grid: All-In vCPM by Media CPM and Viewability, the Green Zone Below a Target and the Highest CPM You Can AffordLab Locked
  19. Negotiating Guaranteed Deals: Deal qCPM, the Walk-Away CPM Against the Open-Auction Benchmark, Headroom and an Accept, Negotiate or Decline VerdictLab Locked
  20. Final Project: Quarterly Programmatic Scorecard by Exchange Partner with Quality Impressions, qCPM, Working Media Share, a Combo Chart and a FlagLab 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