Tabellab

Budget Pacing: Ideal Cumulative Spend, Pacing Index, a FORECAST.LINEAR Projection to the End of the Flight and the Required Daily Spend

Lesson 12 of 20 Lab 🔒 Locked

Lessons in this course

  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