Tabellab

What-If Grid: Watch Hours for Every Combination of CTR and View Duration with Mixed References

Lesson 18 of 20 Lab 🔒 Locked

Lessons in this course

  1. Impressions and Thumbnail CTR: Click-Through Rate per Video, Channel Totals and the Weighted Channel CTRLabFree
  2. Average View Duration: Watch Time per View, Average Percentage Viewed and the Channel AverageLab Locked
  3. Audience Retention Curves: Retention per Time Mark, Drop-Off Steps, Average Retention and a Line ChartLab Locked
  4. From Impressions to Watch Time: Views, Watch Hours and Watch Minutes per 1,000 ImpressionsLab Locked
  5. Traffic Sources: Share of Views, Share of Watch Time and View Duration by SourceLab Locked
  6. YouTube Search Terms: Search CTR per Term and Topic Totals with COUNTIFS and SUMIFSLab Locked
  7. Subscriber Conversion: Net Subscribers per Video, Subscribers per 1,000 Views and Magnet VideosLab Locked
  8. Upload Cadence: Days Between Uploads, Uploads per Month and Views per Upload with COUNTIFS and AVERAGEIFSLab Locked
  9. Thumbnail Tests: CTR of Two Thumbnails, Relative Lift and a Three-Way Decision Rule with IFSLab Locked
  10. Video Length Groups: Watch Hours per Video, Percentage Viewed and View Duration by LengthLab Locked
  11. The First 48 Hours: Typical Start per Format with XLOOKUP, Ratio to Typical and Breakout LabelsLab Locked
  12. New and Returning Viewers: Returning Share, Views per Viewer and a Stacked Column ChartLab Locked
  13. Series Planning I: Episodes, Views per Episode and Subscribers per 1,000 Views by SeriesLab Locked
  14. Series Planning II: Episode Carry-Over Rate, Index Against Episode 1 and Ranking with RANK.EQLab Locked
  15. End Screens and the Next Video: End-Screen Impressions, Click Rate and Extra Clicks with SUMPRODUCTLab Locked
  16. Subscriber Growth Forecast: Net New Subscribers, Trend with SLOPE, FORECAST.LINEAR and Months to a TargetLab Locked
  17. Upload Day Comparison: Average Early Views per Weekday, an Index and a Sample-Size CheckLab Locked
  18. What-If Grid: Watch Hours for Every Combination of CTR and View Duration with Mixed ReferencesLab Locked
  19. Video Health Check: Diagnosing Thumbnail and Opening Problems with IFS, Multi-Condition COUNTIFS and a Formula RuleLab Locked
  20. Final Project: Quarterly Channel Growth Scorecard with Watch Hours, Subscribers, CTR, View Duration, a Flag Rule and a Combo ChartLab Locked