Frequency Distribution: Households by Exposures, Weighted Average Frequency and the Impressions Above the Cap
Lessons in this course
- Household Reach and Frequency on Connected TV: Impressions per Household, Reach of the CTV Universe and a Frequency Cap CheckFree
- CPM vs Cost per Completed View: Completion Rate by Publisher, CPCV and the Cheapest Publisher with INDEX and MATCH Locked
- Co-Viewing: Viewers per Impression by Genre, Viewer Impressions and the Cost per 1,000 Viewers Locked
- Frequency Distribution: Households by Exposures, Weighted Average Frequency and the Impressions Above the Cap Locked
- Incremental Reach over Linear TV: Overlap, CTV-Only Households, Combined Reach and the Cost per Incremental Reach Point Locked
- Publisher Overlap: Combined Reach, Overlap if Independent and the Overlap Ratio of Streaming Pairs Locked
- Effective Reach: Reach N+ from a Frequency Distribution and the Cost per Effective Household Locked
- Flight Pacing: Delivery % by Week, Running Totals, Pacing Status and the Required Daily Delivery Locked
- Verified Impressions: Ad-Server vs Publisher Discrepancy, Invalid Traffic and the Effective CPM on Valid Impressions Locked
- QR and Second-Screen Response: Scans per 1,000 Impressions, Scan-to-Order Rate and Cost per Scan and Order Locked
- QR Display Time: Scans per 1,000 by Daypart, SLOPE, FORECAST.LINEAR and a Scatter Chart Locked
- Attribution Windows: Lag Table, Cumulative Share of Orders, Cost per Attributed Order and the Shortest Window Locked
- Click vs View-Through Orders: Cumulative Windows, INDEX and MATCH, Cost per Attributed Order and a Heat Map Locked
- Holdout Test: Exposed vs Holdout Rate, Lift, Incremental Buyers and the Cost per Incremental Buyer Locked
- Is the Lift Real? Two-Proportion z-Test: Pooled Rate, Standard Error, z, p-Value and Verdict Locked
- Brand Lift Survey: Aware Rates, Lift in Points, Margin of Error, Lower Bound and the Cost per Lifted Household Locked
- Matched-Market Geo Test: Test vs Control Change, Lift in Points, Expected Sales and Incremental Sales per Dollar Locked
- Reach Forecast: Diminishing Returns, LN of Spend, SLOPE, FORECAST.LINEAR and the Cost of an Extra Reach Point Locked
- Budget Scenario Grid: SUMPRODUCT Yields, Cost per Incremental Household, a Share Cap and RANK.EQ Locked
- Final Project: Connected-TV Campaign Dashboard from Delivery to Cost per Incremental Order Locked