Tabellab

From Views to Link Clicks: Profile Visit Rate, Link Click Rate and Clicks per 1,000 Views

Lesson 8 of 20 Lab 🔒 Locked

Lessons in this course

  1. Watch-Through Rate & Average Watch Time: Reading the Two Numbers That Show How Well a Short Video Holds Its ViewersLabFree
  2. Retention Curves: Viewers Still Watching per Second, the Hook Rate and Where a Video Loses PeopleLab Locked
  3. For You vs Follower Views: Traffic Sources per Video, Source Shares and the Account MixLab Locked
  4. Engagement by Views: Engagement Rate, Shares per 1,000 Views and a Weighted Interaction ScoreLab Locked
  5. Posting Cadence: Days Between Posts, Posts per Week with COUNTIFS and Views per Post with SUMIFSLab Locked
  6. Posting Time Slots: Average Views per Slot with AVERAGEIFS, an Index Against the Account Average and a Highlight RuleLab Locked
  7. Sound & Trend Tests: Average Views by Audio Type, Pooled Watch-Through Rate and the Lift Against Original AudioLab Locked
  8. From Views to Link Clicks: Profile Visit Rate, Link Click Rate and Clicks per 1,000 ViewsLab Locked
  9. Hook Rate and Hold Rate: Splitting Watch-Through into Two Steps and Diagnosing Each Video with IFSLab Locked
  10. Video Length Buckets: Watch-Through and Watch Time by Length with Two-Condition COUNTIFS and SUMIFSLab Locked
  11. Follower Growth: Net New Followers, Weekly Growth Rate, Followers per 1,000 Views and a Rule for Shrinking WeeksLab Locked
  12. Typical Performance: Mean vs Median Views, the Share of the Top Three Videos and an Index Against the MedianLab Locked
  13. The Lifetime of a Video: Cumulative Views, the Share Reached per Day and When to Judge a PostLab Locked
  14. Content Pillars: Views per Video and Profile Visits per 1,000 Views by Pillar, a Rank with RANK.EQ and a Lookup with XLOOKUPLab Locked
  15. A Posting Frequency Test: Views per Post, the Slope of Weekly Views on Posts and a Forecast for a New CadenceLab Locked
  16. Follower Forecast: Weekly Gains, the Trend with SLOPE, a Forecast with FORECAST.LINEAR and Weeks Until a GoalLab Locked
  17. Quality Checks on an Analytics Export: Duplicate Rows, Impossible Numbers, Replay Loops and a Clean TotalLab Locked
  18. Paired Video Tests: Difference in Percentage Points, Relative Lift and a Verdict with Minimum ViewsLab Locked
  19. What-If Grid: Monthly Link Clicks for Every Mix of Views per Post and Profile Visit Rate, a Heat Map and the Numbers Needed for a TargetLab Locked
  20. Final Project: Monthly Organic Video Scorecard with Watch-Through Rate, For You Share, Link Clicks per 1,000 Views, a Flag and a Combo ChartLab Locked