11. 4.She shops at:
4. Target
5. Macys
6. Walmart
7. Kohls
8. Just Fab
9. Victorias Secret
10. Dress Lily
The Two Basic Spreadsheets
1. Video Level
2. Channel Level
12. 4.She shops at:
4. Target
5. Macys
6. Walmart
7. Kohls
8. Just Fab
9. Victorias Secret
10. Dress Lily
The First Rule
1.To compare data, all data must must
be pulled with the same length of time.
41. Graph which shows whether the % of
audience still watching at any given
second in a video is above or below
platform average for videos of a similar
length.
Relative Retention
46. 1.Where did they find the video?
A.Traffic Sources Tab
2. Did they click?
A.Watchtime/Traffic Sources Tab
3. Did they view the video?
A.Watchtime/Traffic Sources Tab
4. When did they leave?
A.Retention Tab
5. Did they engage?
A.Likes/Dislikes, Comments, Sharing Tabs
Viewing Life Cycle Cheat Sheet
47. What am I comparing to?
Channel Average
Month
Subscribed
Views Vs Avg
Unsubscribed
Views Vs Avg Engagements Vs Avg
Video #1 55,000 15% 102,000 5% 6,600 -15%
Video #2 75,000 -15% 93,000 -5% 9,000 15%
AVERAGE 65,000 97,500 7,800
55. 1. Followers Growth Rate
2. Monthly Views Growth Rate
A. Subscribed vs Unsubscribed
B. Library Views vs. New Video Views
3. Monthly Engagements Growth Rate
Growth Rate
56. Month Total Followers Growth Subscribed Views Growth Unsubscribed Views Growth
Jan 88,000 102,000 250,000
Feb 94,000 7% 93,000 -9% 275,000 10%
Super Simple Spreadsheets
Channel Level
57. Total subscribers from end of this month, compared to the
total subscribers at the end of last month.
Subscriber Growth Rate
(Current Subs Past Subs)
Past Subs
58. Total views from this month compared to the total views
from last month.
Views Growth Rate
(Current Views Past Views)
Past Views
59. Total Engagement from this month compared to the total
Engagement from last month.
Engagement Growth Rate
(Current Engagement Past Engagement)
Past Engagement
60. Month Total Followers Growth Subscribed Views Growth Unsubscribed Views Growth
Jan 88,000 102,000 250,000
Feb 94,000 7% 93,000 -9% 275,000 10%
Super Simple Spreadsheets
Channel Level
61. How good a channel is at converting unsubscribed views
into subscribers.
Conversion Rate
Subscribers Gained
Unsubscribed Views
67. 1.Followers
A. Channel Page
2. Views
A. Unsubscribed vs Subscribed
1. Watchtime Tab
B. Library vs. New Upload
Views
1. Create video group
3. Engagements
A. Interaction Reports
4. Conversion Rate
A. Subscribers Tab
B. Watchtime Tab
Channel Level Cheat Sheet