Marketplace Seller Analytics Path · Mission 14 of 25Hard

ROAS at listing grain (top 20)

Aggregating ad spend and revenue at listing grain, with HAVING-based threshold filter. Practice the canonical ROAS computation (revenue / ad_spend), restricting to listings with meaningful ad spend, and producing the top-20 ROAS leaders for budget reallocation.

Unlock with Pro→Back to Marketplace Seller Analytics

The Brief

You'll practice

JOIN to ad-spendRatioGROUP BY listing
← Previous
Mission 13
Next →
Mission 15
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)