Is the Data Segment Worth Its Fee? Data CPM, Cost per Conversion, Lift and Break-Even Lift for Ten Audience Segments
Lessons in this course
- 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