Tabellab
Marketing Analytics Intermediate

Live Streaming & Audience Growth: Concurrent Viewers, Watch Time, Chat Rate, Schedule Consistency, Raids & Collabs, Follower Conversion and Live vs Replay

Turn live stream analytics into decisions with a spreadsheet. You will convert watch minutes into average concurrent viewers and watch time per viewer, read the retention curve minute by minute, normalise chat to a rate per 100 viewers, measure schedule consistency, calculate follower conversion per stream, split live from replay views, build a weekday-and-slot grid, measure raids and collabs against a rolling baseline, forecast growth with SLOPE, score content formats, segment loyal viewers, relate buffering to early drop-off, compare promotion channels, price live shopping, flag implausible views, test whether a change is real, plan a quarter with a scenario grid and finish with a quarterly scorecard, in 20 hands-on labs, fictional data, 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 shows how brands and creators can measure a live audience with a spreadsheet, using the numbers of Wavelark Studio, a fictional baking-kit brand with a weekly live show. In 20 interactive labs you turn watch minutes into average concurrent viewers and watch time per viewer, read the retention curve minute by minute, normalise chat to a rate per 100 viewers and measure how consistent the schedule is. You calculate follower conversion per stream, separate live from replay views, compare weekday and time-slot performance, and measure how many raid viewers stay and how much a collab adds. Later labs cover baselines and lift, growth forecasts with SLOPE, content-format scorecards, viewer cohorts, stream quality, promotion channels, live shopping, view-quality checks, significance tests and a quarter planning grid, ending with a scorecard. All companies, streams and numbers are fictional and for learning only.

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. Concurrent Viewers and Watch Time: Average Concurrent, Watch Time per Viewer and the Peak-to-Average RatioLabFree
  2. The Retention Curve: Viewers per Minute, Share of Peak, Drop-Off Steps and Watch Minutes by the Trapezoid RuleLab Locked
  3. Chat Rate and Participation: Human Messages, Messages per 100 Viewers per Minute and the Chatter ShareLab Locked
  4. Schedule Consistency: Gaps Between Streams, Late Starts and Whether Regularity Pays OffLab Locked
  5. Follower Conversion per Stream: New and Net Followers, Followers per 1,000 Viewers and Pooled ConversionLab Locked
  6. Live versus Replay Views: Total Views, Live Share of Views and Watch Minutes, and Replay per Live Viewer by FormatLab Locked
  7. Time Slot Performance: Average Concurrent by Weekday and Slot with AVERAGEIFS, Stream Counts and Evening UpliftLab Locked
  8. Raids and Hosts: Raid Retention, Share of the Room at Arrival, Followers per 100 Raid Viewers and Large versus Small RaidsLab Locked
  9. Collab versus Solo Streams: Lift in Average Concurrent, Follower Conversion Gain and New Viewers from a GuestLab Locked
  10. Baseline and Lift: Rolling Four-Stream Baseline, Lift vs Baseline, Spike and Dip Signals with IFSLab Locked
  11. Audience Growth Trend: Weekly Change, SLOPE, FORECAST.LINEAR and the Compound Weekly Growth RateLab Locked
  12. Content Format Scorecard: AVERAGEIFS by Format, Weighted Index Score with SUMPRODUCT, RANK.EQ and the Best FormatLab Locked
  13. Viewer Cohorts: One-Time, Returning and Loyal Viewers, Segment Limits with COUNTIFS and SUMIFS and the Share of Watch TimeLab Locked
  14. Stream Quality and Early Drop-Off: Buffering Share, CORREL, SLOPE, FORECAST.LINEAR and a Fix-First RuleLab Locked
  15. Pre-Stream Promotion: Join Rate, Cost per Live Join, Share of Joins by Channel and the Blended CostLab Locked
  16. Live Shopping: Order Conversion, Average Order Value, Net Revenue After Returns and the Share of Discount-Code OrdersLab Locked
  17. View Quality Checks: Chatters per 100 Peak Viewers, Review Flags with AND, Plausible Peak and a Conditional FormatLab Locked
  18. Is It Real? Z-Scores and Outliers, CONFIDENCE.T Margin of Error and T.TEST for a Schedule ChangeLab Locked
  19. Quarter Planning: Scenario Grid with Mixed References, Audience Fatigue, Cost per Net Follower and a Worth-It VerdictLab Locked
  20. Final Project: A Quarterly Live Streaming Scorecard with Pooled Conversion, Weighted Audience, Chat Rate, Replay Share and a VerdictLab 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