Tabellab

Replenishment Intervals from Real Reorder Gaps: Average vs Median per Product, the Reminder Day and Who Reorders Before It

Lesson 18 of 20 Lab 🔒 Locked

Lessons in this course

  1. Revenue per Recipient by Flow: Email-Level RPR, Placed-Order Rate and a Five-Flow Scorecard with SUMIFSLabFree
  2. The Welcome Series: First Orders per Email, Subscriber-to-Customer Rate and Revenue per Subscriber by Signup SourceLab Locked
  3. The Abandoned-Cart Flow: Reach Rate, Recovery Rate and Margin per Recipient After the DiscountLab Locked
  4. Browse Abandonment: RPR by Category, an Index Against the Flow Average and a Keep-or-Review Rule with UnsubscribesLab Locked
  5. The Post-Purchase Flow: Review Rate, 60-Day Repeat Rate, a Target per Product Type with XLOOKUP and a Status with IFSLab Locked
  6. Replenishment Reminders: Days of Supply, Run-Out Date, Reminder Date and a Send-Now Status with Date ArithmeticLab Locked
  7. Flow vs Campaign Share: Flow Share of Email Revenue, Email Share of Store Revenue and the RPR Gap in a Stacked ChartLab Locked
  8. Timing Tests: RPR per Send Delay, Lift Against the Current Timing with SUMIFS and the Winning Variant per FlowLab Locked
  9. Flow Entry Filters: Consent, Already Purchased, Cool-Down and Minimum Cart Value in One Send-or-Skip RuleLab Locked
  10. Time to Convert: Daily and Cumulative Share of Flow Orders and the Attribution Window That Covers 90%Lab Locked
  11. Is the Flow Revenue Incremental? Holdout Groups, Incremental RPR, Incremental Revenue and the Share That Would Have Come AnywayLab Locked
  12. Forecasting Flow Revenue from Trigger Volume: Revenue per New Subscriber, SLOPE, FORECAST.LINEAR and R²Lab Locked
  13. What-If Grid: Margin per 1,000 Cart-Flow Recipients for Every Discount and Recovery Rate, a Heat Map and the Break-Even RateLab Locked
  14. How Long Should a Flow Be? Net Value per Email After Unsubscribes, a Keep-or-Cut Rule and the Cumulative Revenue CurveLab Locked
  15. Flows by Customer Segment: an RPR Matrix with Two-Criteria SUMIFS, the Repeat-to-Prospect Ratio and Each Segment's Share of RecipientsLab Locked
  16. Discounts in Flows: Margin per Recipient With and Without a Code, the Gain per Email and the Emails Where the Code Loses MoneyLab Locked
  17. When Flows Collide: Emails per Subscriber in 7 Days, a Frequency Cap, the Share Over the Cap and the Emails to Hold BackLab Locked
  18. Replenishment Intervals from Real Reorder Gaps: Average vs Median per Product, the Reminder Day and Who Reorders Before ItLab Locked
  19. Prioritising the Flow Backlog: Incremental Revenue per Build Hour, a Rank, Cumulative Hours and a Build-or-Later DecisionLab Locked
  20. Final Project: the Annual Flow Dashboard with Revenue, RPR and Share per Flow, Flow Share of Email Revenue, a Flag Rule and a Combo ChartLab Locked