Marketplace Seller Analytics Path · Mission 15 of 25Hard

Listing dead-stock detection

First anti-join (NOT IN subquery). Practice identifying listings that have view traffic but zero orders — the canonical 'why are we paying for views that don't convert' question. The HAVING filter cuts to listings with meaningful traffic.

Unlock with Pro→Back to Marketplace Seller Analytics

The Brief

You'll practice

Anti-joinDate arithmeticVelocity
← Previous
Mission 14
Next →
Mission 16
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)