Tabellab

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.

20 lessons 20 labs Certificate

  • 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

  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

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