Tabellab

Frequency Distribution: Households by Exposures, Weighted Average Frequency and the Impressions Above the Cap

Lesson 4 of 20 Lab 🔒 Locked

Lessons in this course

  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