Marketplace Seller Analytics Path · Mission 16 of 25Expert

Settlement reconciliation across 4 fee types

Single-row reconciliation of all settlement components. Practice computing 7 parallel SUM aggregates in one query, producing the path-total reconciliation row that proves the GMV ≠ payout equation. Foundation for M21's per-marketplace per-month variant.

Unlock with Pro→Back to Marketplace Seller Analytics

The Brief

You'll practice

Multi-CTEReconciliationVariance
← Previous
Mission 15
Next →
Mission 17
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)