Tabellab

YouTube Channel Growth Analytics: Thumbnail CTR, View Duration & Retention, Traffic Sources, Upload Cadence, Subscriber Conversion & Series Planning

Understand what makes a YouTube channel grow by working through its numbers. You will calculate thumbnail CTR and the weighted channel CTR, turn watch hours into average view duration, rebuild a retention curve, chain impressions into watch time, split views by traffic source and group search terms into topics. You then measure subscriber conversion per 1,000 views and upload cadence, judge thumbnail tests with a written rule, compare video lengths, benchmark the first 48 hours, follow new and returning viewers, plan series by views per episode and carry-over, value end screens, forecast subscribers, compare upload days, build a what-if grid of CTR against view duration, run a video health check and finish with a quarterly channel scorecard. 20 hands-on labs, fictional gardening channel Pebblewick Garden, every cell checked as you go.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This beginner course teaches YouTube channel growth through the numbers behind it. In 20 interactive spreadsheet labs you work on the analytics of Pebblewick Garden, a fictional gardening channel: you calculate thumbnail CTR per video and the weighted channel CTR, turn watch hours into average view duration and percentage viewed, rebuild an audience retention curve and chain impressions into watch time. You split views by traffic source, group YouTube search terms into topics, measure net subscribers per 1,000 views and check the upload cadence. Later labs evaluate thumbnail tests, compare video lengths and upload days, benchmark the first 48 hours, plan series by views per episode and carry-over, value end screens, forecast subscribers and build a what-if grid, a video health check and a quarterly scorecard. Each function is explained when it first appears and every formula is checked instantly. All channels, videos and figures are fictional, and platform numbers are illustrative.

Lessons

  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

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy