What-If Grid: Watch Hours for Every Combination of CTR and View Duration with Mixed References
Lessons in this course
- Impressions and Thumbnail CTR: Click-Through Rate per Video, Channel Totals and the Weighted Channel CTRFree
- Average View Duration: Watch Time per View, Average Percentage Viewed and the Channel Average Locked
- Audience Retention Curves: Retention per Time Mark, Drop-Off Steps, Average Retention and a Line Chart Locked
- From Impressions to Watch Time: Views, Watch Hours and Watch Minutes per 1,000 Impressions Locked
- Traffic Sources: Share of Views, Share of Watch Time and View Duration by Source Locked
- YouTube Search Terms: Search CTR per Term and Topic Totals with COUNTIFS and SUMIFS Locked
- Subscriber Conversion: Net Subscribers per Video, Subscribers per 1,000 Views and Magnet Videos Locked
- Upload Cadence: Days Between Uploads, Uploads per Month and Views per Upload with COUNTIFS and AVERAGEIFS Locked
- Thumbnail Tests: CTR of Two Thumbnails, Relative Lift and a Three-Way Decision Rule with IFS Locked
- Video Length Groups: Watch Hours per Video, Percentage Viewed and View Duration by Length Locked
- The First 48 Hours: Typical Start per Format with XLOOKUP, Ratio to Typical and Breakout Labels Locked
- New and Returning Viewers: Returning Share, Views per Viewer and a Stacked Column Chart Locked
- Series Planning I: Episodes, Views per Episode and Subscribers per 1,000 Views by Series Locked
- Series Planning II: Episode Carry-Over Rate, Index Against Episode 1 and Ranking with RANK.EQ Locked
- End Screens and the Next Video: End-Screen Impressions, Click Rate and Extra Clicks with SUMPRODUCT Locked
- Subscriber Growth Forecast: Net New Subscribers, Trend with SLOPE, FORECAST.LINEAR and Months to a Target Locked
- Upload Day Comparison: Average Early Views per Weekday, an Index and a Sample-Size Check Locked
- What-If Grid: Watch Hours for Every Combination of CTR and View Duration with Mixed References Locked
- Video Health Check: Diagnosing Thumbnail and Opening Problems with IFS, Multi-Condition COUNTIFS and a Formula Rule Locked
- Final Project: Quarterly Channel Growth Scorecard with Watch Hours, Subscribers, CTR, View Duration, a Flag Rule and a Combo Chart Locked