Problem
Comparing unique viewers across periods without considering differences in the length of the reporting window.
Solution
Root Cause / Diagnostic:
Unique viewers cannot be linearly aggregated or compared across different timeframes because individual viewers who watch across multiple days or weeks are deduplicated. Comparing a 7-day unique viewer count against a 28-day or 90-day count without normalizing window length leads to absurdly skewed growth assessments.
Actionable Fix:
1. Standardize Reporting Windows Strictly: Compare performance exclusively across identical rolling time horizons (e.g., 28 days vs. previous 28 days, or 90 days vs. previous 90 days).
2. Avoid Summing Unique Viewers Across Consecutive Weeks: Never add Week 1 unique viewers to Week 2 unique viewers; instead, pull the unified two-week deduplicated total directly from Studio.
3. Calculate Average Daily Unique Viewers for Custom Ranges: When comparing periods of uneven length, normalize the comparison by calculating average daily unique viewer reach.
Pro Tip:
Unique viewers cannot be added together like standard views: deduplication means 10,000 unique viewers in Week 1 plus 10,000 in Week 2 might only equal 12,000 total unique people across the month.
Unique viewers cannot be linearly aggregated or compared across different timeframes because individual viewers who watch across multiple days or weeks are deduplicated. Comparing a 7-day unique viewer count against a 28-day or 90-day count without normalizing window length leads to absurdly skewed growth assessments.
Actionable Fix:
1. Standardize Reporting Windows Strictly: Compare performance exclusively across identical rolling time horizons (e.g., 28 days vs. previous 28 days, or 90 days vs. previous 90 days).
2. Avoid Summing Unique Viewers Across Consecutive Weeks: Never add Week 1 unique viewers to Week 2 unique viewers; instead, pull the unified two-week deduplicated total directly from Studio.
3. Calculate Average Daily Unique Viewers for Custom Ranges: When comparing periods of uneven length, normalize the comparison by calculating average daily unique viewer reach.
Pro Tip:
Unique viewers cannot be added together like standard views: deduplication means 10,000 unique viewers in Week 1 plus 10,000 in Week 2 might only equal 12,000 total unique people across the month.