Quick Commerce Analytics Path · Mission 15 of 25Hard

Merchant-level fulfillment SLA

Compute a p90 delivery time per merchant with PERCENTILE_CONT and flag SLA breaches against a threshold. Joins orders to dispatches to carry the merchant onto the timing row.

Unlock with Pro→Back to Quick Commerce Analytics

The Brief

You'll practice

PercentileGROUP BY merchantSLA threshold
← Previous
Mission 14
Next →
Mission 16
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