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.
- 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
- 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
Learner reviews
Be the first to review this course.