Content Pillars: Views per Video and Profile Visits per 1,000 Views by Pillar, a Rank with RANK.EQ and a Lookup with XLOOKUP
Lessons in this course
- Watch-Through Rate & Average Watch Time: Reading the Two Numbers That Show How Well a Short Video Holds Its ViewersFree
- Retention Curves: Viewers Still Watching per Second, the Hook Rate and Where a Video Loses People Locked
- For You vs Follower Views: Traffic Sources per Video, Source Shares and the Account Mix Locked
- Engagement by Views: Engagement Rate, Shares per 1,000 Views and a Weighted Interaction Score Locked
- Posting Cadence: Days Between Posts, Posts per Week with COUNTIFS and Views per Post with SUMIFS Locked
- Posting Time Slots: Average Views per Slot with AVERAGEIFS, an Index Against the Account Average and a Highlight Rule Locked
- Sound & Trend Tests: Average Views by Audio Type, Pooled Watch-Through Rate and the Lift Against Original Audio Locked
- From Views to Link Clicks: Profile Visit Rate, Link Click Rate and Clicks per 1,000 Views Locked
- Hook Rate and Hold Rate: Splitting Watch-Through into Two Steps and Diagnosing Each Video with IFS Locked
- Video Length Buckets: Watch-Through and Watch Time by Length with Two-Condition COUNTIFS and SUMIFS Locked
- Follower Growth: Net New Followers, Weekly Growth Rate, Followers per 1,000 Views and a Rule for Shrinking Weeks Locked
- Typical Performance: Mean vs Median Views, the Share of the Top Three Videos and an Index Against the Median Locked
- The Lifetime of a Video: Cumulative Views, the Share Reached per Day and When to Judge a Post Locked
- Content Pillars: Views per Video and Profile Visits per 1,000 Views by Pillar, a Rank with RANK.EQ and a Lookup with XLOOKUP Locked
- A Posting Frequency Test: Views per Post, the Slope of Weekly Views on Posts and a Forecast for a New Cadence Locked
- Follower Forecast: Weekly Gains, the Trend with SLOPE, a Forecast with FORECAST.LINEAR and Weeks Until a Goal Locked
- Quality Checks on an Analytics Export: Duplicate Rows, Impossible Numbers, Replay Loops and a Clean Total Locked
- Paired Video Tests: Difference in Percentage Points, Relative Lift and a Verdict with Minimum Views Locked
- 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 Target Locked
- Final Project: Monthly Organic Video Scorecard with Watch-Through Rate, For You Share, Link Clicks per 1,000 Views, a Flag and a Combo Chart Locked