Tabellab
Marketing Analytics Intermediate

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.

20 lessons 20 labs Certificate

  • 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

  1. Household Reach and Frequency on Connected TV: Impressions per Household, Reach of the CTV Universe and a Frequency Cap CheckLabFree
  2. CPM vs Cost per Completed View: Completion Rate by Publisher, CPCV and the Cheapest Publisher with INDEX and MATCHLab Locked
  3. Co-Viewing: Viewers per Impression by Genre, Viewer Impressions and the Cost per 1,000 ViewersLab Locked
  4. Frequency Distribution: Households by Exposures, Weighted Average Frequency and the Impressions Above the CapLab Locked
  5. Incremental Reach over Linear TV: Overlap, CTV-Only Households, Combined Reach and the Cost per Incremental Reach PointLab Locked
  6. Publisher Overlap: Combined Reach, Overlap if Independent and the Overlap Ratio of Streaming PairsLab Locked
  7. Effective Reach: Reach N+ from a Frequency Distribution and the Cost per Effective HouseholdLab Locked
  8. Flight Pacing: Delivery % by Week, Running Totals, Pacing Status and the Required Daily DeliveryLab Locked
  9. Verified Impressions: Ad-Server vs Publisher Discrepancy, Invalid Traffic and the Effective CPM on Valid ImpressionsLab Locked
  10. QR and Second-Screen Response: Scans per 1,000 Impressions, Scan-to-Order Rate and Cost per Scan and OrderLab Locked
  11. QR Display Time: Scans per 1,000 by Daypart, SLOPE, FORECAST.LINEAR and a Scatter ChartLab Locked
  12. Attribution Windows: Lag Table, Cumulative Share of Orders, Cost per Attributed Order and the Shortest WindowLab Locked
  13. Click vs View-Through Orders: Cumulative Windows, INDEX and MATCH, Cost per Attributed Order and a Heat MapLab Locked
  14. Holdout Test: Exposed vs Holdout Rate, Lift, Incremental Buyers and the Cost per Incremental BuyerLab Locked
  15. Is the Lift Real? Two-Proportion z-Test: Pooled Rate, Standard Error, z, p-Value and VerdictLab Locked
  16. Brand Lift Survey: Aware Rates, Lift in Points, Margin of Error, Lower Bound and the Cost per Lifted HouseholdLab Locked
  17. Matched-Market Geo Test: Test vs Control Change, Lift in Points, Expected Sales and Incremental Sales per DollarLab Locked
  18. Reach Forecast: Diminishing Returns, LN of Spend, SLOPE, FORECAST.LINEAR and the Cost of an Extra Reach PointLab Locked
  19. Budget Scenario Grid: SUMPRODUCT Yields, Cost per Incremental Household, a Share Cap and RANK.EQLab Locked
  20. Final Project: Connected-TV Campaign Dashboard from Delivery to Cost per Incremental OrderLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy