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.
- 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
- Concurrent Viewers and Watch Time: Average Concurrent, Watch Time per Viewer and the Peak-to-Average RatioFree
- The Retention Curve: Viewers per Minute, Share of Peak, Drop-Off Steps and Watch Minutes by the Trapezoid Rule Locked
- Chat Rate and Participation: Human Messages, Messages per 100 Viewers per Minute and the Chatter Share Locked
- Schedule Consistency: Gaps Between Streams, Late Starts and Whether Regularity Pays Off Locked
- Follower Conversion per Stream: New and Net Followers, Followers per 1,000 Viewers and Pooled Conversion Locked
- Live versus Replay Views: Total Views, Live Share of Views and Watch Minutes, and Replay per Live Viewer by Format Locked
- Time Slot Performance: Average Concurrent by Weekday and Slot with AVERAGEIFS, Stream Counts and Evening Uplift Locked
- Raids and Hosts: Raid Retention, Share of the Room at Arrival, Followers per 100 Raid Viewers and Large versus Small Raids Locked
- Collab versus Solo Streams: Lift in Average Concurrent, Follower Conversion Gain and New Viewers from a Guest Locked
- Baseline and Lift: Rolling Four-Stream Baseline, Lift vs Baseline, Spike and Dip Signals with IFS Locked
- Audience Growth Trend: Weekly Change, SLOPE, FORECAST.LINEAR and the Compound Weekly Growth Rate Locked
- Content Format Scorecard: AVERAGEIFS by Format, Weighted Index Score with SUMPRODUCT, RANK.EQ and the Best Format Locked
- Viewer Cohorts: One-Time, Returning and Loyal Viewers, Segment Limits with COUNTIFS and SUMIFS and the Share of Watch Time Locked
- Stream Quality and Early Drop-Off: Buffering Share, CORREL, SLOPE, FORECAST.LINEAR and a Fix-First Rule Locked
- Pre-Stream Promotion: Join Rate, Cost per Live Join, Share of Joins by Channel and the Blended Cost Locked
- Live Shopping: Order Conversion, Average Order Value, Net Revenue After Returns and the Share of Discount-Code Orders Locked
- View Quality Checks: Chatters per 100 Peak Viewers, Review Flags with AND, Plausible Peak and a Conditional Format Locked
- Is It Real? Z-Scores and Outliers, CONFIDENCE.T Margin of Error and T.TEST for a Schedule Change Locked
- Quarter Planning: Scenario Grid with Mixed References, Audience Fatigue, Cost per Net Follower and a Worth-It Verdict Locked
- Final Project: A Quarterly Live Streaming Scorecard with Pooled Conversion, Weighted Audience, Chat Rate, Replay Share and a Verdict Locked
Learner reviews
Be the first to review this course.