Quick Commerce Analytics Path · Mission 16 of 25Expert

Shopper quality scoring composite

Build a composite shopper score from three independently-ranked metrics (completion, speed, rating) using NTILE quintiles in a multi-CTE pipeline, handling NULL ratings with COALESCE.

Unlock with Pro→Back to Quick Commerce Analytics

The Brief

You'll practice

Multi-metric NTILEComposite scoreMulti-CTE
← Previous
Mission 15
Next →
Mission 17
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