Problem
Comparing geography charts across periods with different total audience sizes and ignoring absolute changes.
Solution
Root Cause / Diagnostic:
When total channel viewership expands or contracts significantly between two periods, geographic percentage distributions change purely due to denominator shifts. For instance, if total views double due to a domestic viral hit, international market shares will appear to shrink in percentage terms even if their absolute viewer counts expanded substantially.
Actionable Fix:
1. In Advanced Analytics, select "Compare to..." and set the primary metric to absolute "Views by Country" rather than percentage distribution.
2. Calculate raw period-over-period growth rates for each target country individually to evaluate regional expansion accurately.
3. Maintain an external tracking sheet tracking absolute monthly views across your top 5 target international territories.
Pro Tip:
If your domestic views explode by 500%, your international percentage will plummet even if your international audience grew; always evaluate geographic expansion using absolute view counts.
When total channel viewership expands or contracts significantly between two periods, geographic percentage distributions change purely due to denominator shifts. For instance, if total views double due to a domestic viral hit, international market shares will appear to shrink in percentage terms even if their absolute viewer counts expanded substantially.
Actionable Fix:
1. In Advanced Analytics, select "Compare to..." and set the primary metric to absolute "Views by Country" rather than percentage distribution.
2. Calculate raw period-over-period growth rates for each target country individually to evaluate regional expansion accurately.
3. Maintain an external tracking sheet tracking absolute monthly views across your top 5 target international territories.
Pro Tip:
If your domestic views explode by 500%, your international percentage will plummet even if your international audience grew; always evaluate geographic expansion using absolute view counts.