Quick Commerce Analytics Path · Mission 21 of 25Master

Three-sided unit economics (shopper + platform + merchant)

Capstone: build the monthly three-sided P&L from delivered orders, rolling GMV and each party's take into a contribution-margin view that reconciles to the per-order identity.

Unlock with Pro→Back to Quick Commerce Analytics

The Brief

You'll practice

Multi-CTE pipelineThree-party P&LCapstone
← Previous
Mission 20
Next →
Mission 22
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