Omnichannel Retail Analytics Path · Mission 11 of 25Hard

Channel cannibalization detection

Self-join via two CTEs — weekly channel buckets + a HAVING COUNT(DISTINCT) filter for dual-channel weeks. Pattern every cannibalization audit starts from.

Unlock with Pro→Back to Omnichannel Retail Analytics

The Brief

You'll practice

Self-joinSame-SKU dual channelWindow
← Previous
Mission 10
Next →
Mission 12
All 25 missions in Omnichannel Retail Analytics Path ↓
  1. 1. Orders by channel
  2. 2. Top stores by revenue
  3. 3. BOPIS pickup volume — Q4 2025
  4. 4. Inventory by store — snapshot date
  5. 5. Shipping SLA by carrier — January 2026
  6. 6. Channel mix month-over-month — H2 FY26
  7. 7. BOPIS completion rate by month
  8. 8. Store-level AOV — store_walk_in
  9. 9. Ship-from-store rate by region
  10. 10. Inventory turns by store-SKU — hot SKUs, H2
  11. 11. Channel cannibalization detection
  12. 12. Pickup window aging — distribution
  13. 13. Ship-from-store cost spread by zone
  14. 14. Inventory imbalance — z-score across stores
  15. 15. Allocation efficiency — units sold / units allocated
  16. 16. Store-level CM2 by channel mix
  17. 17. BOPIS lift attribution vs counterfactual
  18. 18. Foot-traffic-to-purchase funnel by store
  19. 19. Regional inventory rebalancing — top spread SKUs
  20. 20. Cross-channel cannibalization audit — SKU-level cannibal ratio
  21. 21. Omnichannel store P&L composite — capstone
  22. 22. Cross-channel cannibalization full report — (SKU, store) grain
  23. 23. BOPIS-vs-direct-ship CM2 by region
  24. 24. Ship-from-store ROI — incremental margin vs counterfactual
  25. 25. Store-level allocation capstone