TikTok Organic Content Analytics: Watch-Through Rate, Average Watch Time, For You vs Follower Views, Posting Cadence, Sound Tests & Profile-to-Link Clicks
Read organic short-video numbers the way an analyst does. You will calculate average watch time and watch-through rate, draw a retention curve and find the hook rate, split views into For You and follower traffic, measure engagement on views, log posting cadence and compare time slots, test trending sounds against original audio and follow the path from video views to profile visits and link clicks. Then you diagnose hooks and holds, compare video lengths, track net follower growth, separate typical videos from viral outliers, time the lifetime of a post, rank content pillars, read a posting-frequency test, forecast followers, audit an export, judge paired video tests, build a what-if grid for link clicks and finish with a monthly scorecard and chart. 20 hands-on labs, fictional stationery brand Quillfeather Paper Co., every cell checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This course teaches the analytics of organic short video with nothing but a spreadsheet. In 20 interactive labs you work through the numbers of Quillfeather Paper Co., a fictional stationery brand that posts on TikTok: you calculate average watch time and watch-through rate, build retention curves, split views into For You and follower traffic, measure engagement per view, log posting cadence, compare time slots and sound tests, and follow viewers from the video to the profile and on to the link. Later labs cover hook and hold rates, video length, follower growth, medians and outliers, content pillars, a frequency test with SLOPE and FORECAST.LINEAR, data quality checks, paired tests and a what-if grid, and the final project is a monthly scorecard with a chart. Each function is explained when it first appears, and a grader checks every formula at once. Platform features change, so the course teaches the durable arithmetic and makes no promises about reach. All companies, videos and numbers are fictional.
Why learn with Tabellab
- Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
- Verifiable certificatePass the final exam and get a certificate with a public verification code.
- Try before you buyLesson 1 is free, with no sign-up or card needed.
- Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint
Lessons
- 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
Learner reviews
Be the first to review this course.