Raids and Hosts: Raid Retention, Share of the Room at Arrival, Followers per 100 Raid Viewers and Large versus Small Raids
Lessons in this course
- 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