Sample Template
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
MAKE A COPY (File --> Make a copy")
2
Instructions
1. Click on the links in column A to view channel metric in analytics
2. Set date range to "last 90 days"
2. Keep date range at "last 90 days" and adjust the years to reflect one year ago
3. Review calculated %change
4. Develop insight
3
4
5
EXAMPLE
6
MetricLast 90 days
90 day data from 1 year ago
% change*Insight
7
Revenue20,00010,000100%Revenue is up significantly from last year.
8
Views15,000,00010,000,00050%Strong viewership growth is a driver in revenue growth.
9
EMPs5,000,0002,000,000150%EMP growth strongly outpaced viewership growth.
10
Playback-based CPM$4.00$4.50-11%CPMs dropped from last year, but are still healthy. This caused a slight drag on revenue growth, but not enough to reverse positive trends in viewership or EMPs.
11
12
13
14
YOUR CHANNEL
15
MetricLast 90 days
90 day data from 1 year ago
% change*Insight
16
Revenue#DIV/0!
17
Views#DIV/0!
18
EMPs#DIV/0!
19
Playback-based CPM#DIV/0!
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1