Marketplace Seller Analytics Path · Mission 18 of 25Expert

Cross-marketplace cannibalization

Detecting the same product across marketplaces via product_title equality. Practice GROUP BY on a string column with COUNT(DISTINCT) on a related dimension, HAVING to filter cross-listed products, and producing the cannibalization report the seller-strategy team uses to plan platform exclusivity.

Unlock with Pro→Back to Marketplace Seller Analytics

The Brief

You'll practice

Same-SKU joinMulti-CTEChannel split
← Previous
Mission 17
Next →
Mission 19
All 25 missions in Marketplace Seller Analytics Path ↓
  1. 1. Browse the listings table
  2. 2. Daily orders by marketplace
  3. 3. Top 10 listings by units sold
  4. 4. Refund rate by marketplace
  5. 5. Top 10 active listings by gross revenue
  6. 6. Orders by marketplace × month (last 12 months)
  7. 7. Marketplace fee breakdown by type
  8. 8. Listing CTR from views
  9. 9. Marketplace revenue concentration
  10. 10. Refund rate by category
  11. 11. Buy Box win-rate by hour of day
  12. 12. GMV-vs-payout drift detection (Q1 2026)
  13. 13. Fee-as-%-of-revenue trend (last 6 months)
  14. 14. ROAS at listing grain (top 20)
  15. 15. Listing dead-stock detection
  16. 16. Settlement reconciliation across 4 fee types
  17. 17. Buy Box loss-window listings
  18. 18. Cross-marketplace cannibalization
  19. 19. Marketplace ad-attribution waterfall
  20. 20. Listing dead-zone cohort (sponsored views, zero orders)
  21. 21. Three-way settlement reconciliation per (marketplace, month)
  22. 22. Top 25 profitable listings by all-in margin
  23. 23. Buy Box defense playbook
  24. 24. Cross-marketplace pair revenue split
  25. 25. Marketplace year-end capstone (last 12 months)