Connected TV & Streaming Ads: Household Reach & Frequency, Cost per Completed View, Co-Viewing, Incremental Reach, QR Response & Attribution Windows
Plan and judge streaming TV campaigns with real arithmetic. You start with household reach and frequency, compare CPM with cost per completed view, convert household impressions into viewer impressions, read a frequency distribution and separate the households that only streaming reached from linear TV. Then you measure publisher overlap and effective reach, check flight pacing and verified impressions, follow QR codes and second-screen response, choose attribution windows, run holdout and matched-market tests, test whether a lift is real, read a brand lift survey, forecast reach with diminishing returns, compare budget scenarios and finish with a campaign dashboard in 20 hands-on labs, fictional data, every cell checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This course teaches the arithmetic behind connected TV and streaming video advertising in 20 interactive spreadsheet labs. You work for Osterbrook Kitchen, a fictional restaurant and meal-delivery brand, and build every table yourself: household reach and frequency by market, CPM against cost per completed view, co-viewing and viewer impressions, frequency distributions and caps, and the incremental reach of streaming over linear TV. Then you go deeper: publisher overlap, effective reach, flight pacing, verified impressions, QR and second-screen response, attribution windows, click and view-through orders, holdout and matched-market tests, significance and brand lift, reach forecasts with diminishing returns, budget scenarios and a final campaign dashboard. Each task is checked the moment you type the formula. All companies, people, campaigns and numbers are fictional and benchmarks are illustrative.
Lessons
- 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
Learner reviews
Be the first to review this course.