Forecast the Churn Impact of Adding an Investment Stage
Objective: Given a subscription company's current monthly churn rate and the lesson's cited 2-3x churn reduction for full-loop completers, forecast the retained-subscriber impact of shipping an investment-stage feature.
You're pitching Rent the Runway's retention team on building a 'saved closet' investment feature. You need a real before/after subscriber forecast, not just 'this should help retention.'
Using the lesson's cited churn-reduction stat for full-loop completers, model current monthly churn against a scenario where 40% of subscribers reach full-loop completion after the feature ships.
Before you start
What you'll need
Free path (everything below is enough to finish)
Free, formula-driven, sufficient for a pre-build business case
Paid upgrades (optional, faster/deeper)
Retention and cohort-analysis views replace the spreadsheet's assumed completion rate with observed data
No access? Google Sheets with manually logged monthly cohort churn
The process
1 step
Step 01 of 01
The lesson states users who complete a full loop cycle (trigger, action, reward, investment) churn at 2-3x lower rates than those who don't, and that loop completion rate is one of the three health metrics worth tracking alongside frequency and cohort delta.
Rent the Runway's current monthly subscriber churn sits at 8%, with 0% of subscribers completing a full loop today (no investment stage exists). If the new 'saved closet' feature gets 40% of subscribers to full-loop completion at a conservative 2x churn reduction, what's the blended monthly churn rate, and how many more subscribers are retained over 12 months on a 50,000-subscriber base?
Procedure
- Segment 1 (60% of base, non-completers): churn stays at 8%/month
- Segment 2 (40% of base, loop-completers): churn drops to 4%/month (2x reduction, conservative end of the cited range)
- Compute blended monthly churn: (0.6 x 8%) + (0.4 x 4%) = weighted average
- Run a 12-month retained-subscriber count at blended churn vs the current flat 8% churn on 50,000 subscribers, and read off the gap
Blended monthly churn = (0.6 x 8%) + (0.4 x 4%) = 6.4% Month 12 retained @ 8% churn (no feature): ~17,970 of 50,000 Month 12 retained @ 6.4% blended churn (feature shipped): ~22,960 of 50,000 12-month gap: ~4,990 additional retained subscribers
Healthy
The forecast uses the conservative 2x end of the lesson's cited 2-3x range and states the 40% completion assumption explicitly as an assumption, not a guarantee.
Unhealthy
Applying the full 3x reduction to 100% of subscribers, which overstates the case and won't survive a skeptical finance review.
What this means
Even a conservative, partial-adoption scenario produces a measurable retained-subscriber gap — the pitch doesn't need the optimistic case to be worth building.
So what do I do about it?
| Symptom | Action | Effort |
|---|---|---|
| Finance pushes back that 40% loop-completion is an unproven assumption | Propose a 90-day pilot on a 10% subscriber cohort to measure actual completion rate before committing to the full build | half day |
Final deliverable
A blended-churn forecast model showing the 12-month retained-subscriber gap between shipping and not shipping an investment-stage feature, with assumptions stated explicitly.
See a reference example
Chewy Autoship pilot forecast (excerpt) Current churn: 6% monthly, 0% loop-completion (no investment stage) Scenario: 35% reach full-loop completion at 2.5x churn reduction Blended churn: (0.65 x 6%) + (0.35 x 2.4%) = 4.74% 12-month gap on 80,000 subscribers: ~6,300 additional retained
Success criteria
You're done when you can:
- Uses the conservative end of the lesson's cited 2-3x churn-reduction range, stated explicitly
- Blended churn is calculated as a weighted average across the two segments, not a flat guess
- The 12-month retained-subscriber gap is computed and stated as a number, not a direction