Quick Commerce Analytics Path · Mission 14 of 25Hard

Customer retention by substitution exposure

Split customers by whether they ever experienced a substitution and compare repeat-order rates. Practice an EXISTS-driven exposure flag and a cohort comparison.

Unlock with Pro→Back to Quick Commerce Analytics

The Brief

You'll practice

CohortCASE filterRetention curve
← Previous
Mission 13
Next →
Mission 15
All 25 missions in Quick Commerce Analytics Path ↓
  1. 1. Orders by merchant
  2. 2. Shopper roster basics
  3. 3. Customer acquisition by month
  4. 4. Substitution volume
  5. 5. Dispatch timing distribution
  6. 6. Pick-to-deliver time distribution
  7. 7. Substitution rate by merchant
  8. 8. Shopper completion rate
  9. 9. Basket size by customer cohort
  10. 10. Batch-size distribution
  11. 11. Substitution impact on GMV
  12. 12. Shopper batching efficiency
  13. 13. Tip allocation across parties
  14. 14. Customer retention by substitution exposure
  15. 15. Merchant-level fulfillment SLA
  16. 16. Shopper quality scoring composite
  17. 17. Customer LTV with substitution exposure controls
  18. 18. Multi-sided fee waterfall
  19. 19. Surge pricing impact on volume
  20. 20. Shopper attrition cohort analysis
  21. 21. Three-sided unit economics (shopper + platform + merchant)
  22. 22. Shopper attrition cohort decay
  23. 23. Merchant churn forensics
  24. 24. Multi-sided P&L capstone
  25. 25. Substitution policy optimization