Quick Commerce Analytics Path · Mission 11 of 25Hard

Substitution impact on GMV

Quantify the GMV leakage hidden in substitutions: the customer pays the original price but the merchant is only paid for the cheaper item picked. Aggregate that gap per merchant.

Unlock with Pro→Back to Quick Commerce Analytics

The Brief

You'll practice

Self-joinDiff (original → sub)Aggregate
← Previous
Mission 10
Next →
Mission 12
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