Tabellab

Testing a Show Format: Pooled Conversion, z Score, p-Value and a Careful Verdict

Lesson 17 of 20 Lab 🔒 Locked

Lessons in this course

  1. The Shop-Tab Funnel: Impressions, Product Views, Adds to Cart and Orders per 1,000 ImpressionsLabFree
  2. Funnel Leaks: Step Rates, Change in Percentage Points and the Orders Lost at the Weakest StepLab Locked
  3. Live Viewers to Buyers: Viewer-to-Buyer Rate, Revenue per Viewer, Ranking Shows and the Pooled RateLab Locked
  4. Peak Concurrent Viewers: Peak, Minute of the Peak, Average Audience and Minutes Near the PeakLab Locked
  5. Items per Live Order: Units per Order, Average Order Value, Bundle vs Single-Item Shows and the Value of One More ItemLab Locked
  6. Host Commission: Flat Rate vs Tiers, Approximate Lookups and the Extra Cost of a Tier ModelLab Locked
  7. Returns After Live Sales: Unit Return Rate, Net Revenue, a Review Limit and the Pooled Return RateLab Locked
  8. Live Show Contribution: Net Revenue, Variable Costs, Margin and Contribution per Live HourLab Locked
  9. Return Reasons: Totals by Reason, Shares, Return Rate per Category and the Preventable ShareLab Locked
  10. Discount Depth in Flash Deals: Sale Price, Total Margin, Conversion and a Forecast at a New DiscountLab Locked
  11. Audience Retention: Retention Curve, Viewers Lost per Interval, the 50 % Minute and Average Minutes WatchedLab Locked
  12. Engagement Levels: Conversion by Level, Lift vs. Silent Viewers and Where the Buyers Come FromLab Locked
  13. Order-Log Cleaning and Attribution: Duplicates, Test and Cancelled Orders and a 24-Hour WindowLab Locked
  14. Host Scorecard: Indexes, a Weighted Score with SUMPRODUCT and the Top HostLab Locked
  15. Show Time Slots: Average Revenue per Slot, a Mixed-Reference Grid, the Best Daypart and a Heat MapLab Locked
  16. Forecasting the Next Show: Slope, R Squared, FORECAST.LINEAR and a Revenue EstimateLab Locked
  17. Testing a Show Format: Pooled Conversion, z Score, p-Value and a Careful VerdictLab Locked
  18. Stock vs Expected Demand: Demand from Show Assumptions, Lost Sales, Sell-Through and Stock-Out FlagsLab Locked
  19. Break-Even and What-If Grid: Break-Even Orders and Viewers, Mixed References and a Loss Heat FlagLab Locked
  20. Year Scorecard for Live Commerce: Conversion, Net Revenue after Commission, Return Alerts and a Combo ChartLab Locked