Problem
Changing date ranges while comparing metrics and forgetting that some derived percentages are recalculated for each period.
Solution
Root Cause / Diagnostic:
Derived metrics such as Click-Through Rate (CTR), Average Percentage Viewed (APV), and Traffic Source Distribution percentages are non-linear ratios recalculated across the specific impressions and views within the selected timeframe. Expanding a date range from 7 days to 90 days does not merely aggregate volume; it incorporates shifting audience segments that re-weight the denominator, radically altering the computed percentages. Misinterpreting this mathematical re-weighting causes creators to draw erroneous conclusions about creative decay.
Actionable Fix:
1. Lock date ranges during comparative creative audits and only analyze absolute metrics (impressions, views, watch hours) alongside derived percentages.
2. In Advanced Analytics, inspect the raw components of derived metrics (Impressions and Clicks separately for CTR; Watch Time and Views separately for AVD).
3. Document the exact denominator shifts when transitioning between analytical time horizons to contextualize percentage variances.
Pro Tip:
When auditing CTR changes across expanded date windows, always plot Impressions alongside CTR; an apparent CTR drop across 60 days usually reflects healthy impression expansion into colder audiences rather than creative fatigue.
Derived metrics such as Click-Through Rate (CTR), Average Percentage Viewed (APV), and Traffic Source Distribution percentages are non-linear ratios recalculated across the specific impressions and views within the selected timeframe. Expanding a date range from 7 days to 90 days does not merely aggregate volume; it incorporates shifting audience segments that re-weight the denominator, radically altering the computed percentages. Misinterpreting this mathematical re-weighting causes creators to draw erroneous conclusions about creative decay.
Actionable Fix:
1. Lock date ranges during comparative creative audits and only analyze absolute metrics (impressions, views, watch hours) alongside derived percentages.
2. In Advanced Analytics, inspect the raw components of derived metrics (Impressions and Clicks separately for CTR; Watch Time and Views separately for AVD).
3. Document the exact denominator shifts when transitioning between analytical time horizons to contextualize percentage variances.
Pro Tip:
When auditing CTR changes across expanded date windows, always plot Impressions alongside CTR; an apparent CTR drop across 60 days usually reflects healthy impression expansion into colder audiences rather than creative fatigue.