Marketplace Seller Analytics Path · Mission 22 of 25Master

Top 25 profitable listings by all-in margin

Per-listing profitability ranking. Practice computing margin (net_payout / gross_amount × 100) per listing with HAVING revenue threshold, and producing the top-25 profit leaderboard the merchandising team uses for promo and inventory decisions.

Unlock with Pro→Back to Marketplace Seller Analytics

The Brief

You'll practice

All-in marginWindow RANKMulti-CTE
← Previous
Mission 21
Next →
Mission 23
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)