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.
- 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
- Auction Mechanics: Who Wins a Display Auction and What the Winner Pays at First Price and at Second PriceFree
- From Bid Requests to Impressions: Win Rate, Clearing CPM and the Gap Between Bid and Price per Line Item Locked
- Viewability and vCPM: Measured Rate, Viewability Rate and the Cost per 1,000 Viewable Impressions by Placement Locked
- Tech Fees and Working Media: Agency and DSP Percentages, Data and Verification CPMs, SSP Take Rate and What the Publisher Receives Locked
- All-In CPM and qCPM: Adding Fees, Removing Unviewable, Invalid and Unsuitable Impressions and Ranking Supply Sources Locked
- Deals vs Open Auction: Comparing Open Exchange, Private Marketplace, Preferred Deals and Programmatic Guaranteed on CPM and vCPM Locked
- Bid Shading at First Price: The Win Curve, Expected Surplus per Bid Level and the Best Bid with INDEX and MATCH Locked
- Brand Safety and Invalid Traffic: Unsuitable and IVT Rates, Wasted Spend and Block, Review or Keep Rules per Domain Locked
- Supply-Path Optimisation: Take Rates per Path, the Best Route to Each Publisher with MINIFS and the Money Recovered by Cutting Resellers Locked
- Authorised Sellers Audit: Matching Bid-Stream Sellers to Publisher Lists with Keys, COUNTIFS and XLOOKUP, and the Direct Share of Spend Locked
- Reach, Frequency and Capping: Impressions per Frequency Group, Average Frequency and the Budget Freed by a Frequency Cap Locked
- Budget Pacing: Ideal Cumulative Spend, Pacing Index, a FORECAST.LINEAR Projection to the End of the Flight and the Required Daily Spend Locked
- Modelling the Win Curve: SLOPE, INTERCEPT and R Squared of Win Rate on Bid and the Bid That Reaches a Target Win Rate Locked
- Is the Deal Really More Viewable? A Two-Proportion z-Test with Pooled Rate, z Value, p-Value and a Verdict for Eight Size Tests Locked
- View-Through vs Incremental: Holdout Rates, Incremental Conversions and the True Cost per Conversion by Audience Locked
- Is the Data Segment Worth Its Fee? Data CPM, Cost per Conversion, Lift and Break-Even Lift for Ten Audience Segments Locked
- Size by Device: Two-Way SUMIFS Grids with Mixed References for Spend and vCPM, the Cheapest Combination and the In-App Share Locked
- What-If Grid: All-In vCPM by Media CPM and Viewability, the Green Zone Below a Target and the Highest CPM You Can Afford Locked
- Negotiating Guaranteed Deals: Deal qCPM, the Walk-Away CPM Against the Open-Auction Benchmark, Headroom and an Accept, Negotiate or Decline Verdict Locked
- Final Project: Quarterly Programmatic Scorecard by Exchange Partner with Quality Impressions, qCPM, Working Media Share, a Combo Chart and a Flag Locked
Learner reviews
Be the first to review this course.