E-commerce & Retail Analytics Path · Mission 26 of 30Master

Repeat-buyer cohort retention

Build the cohort × months-since-first-order retention table that drives every DTC retention conversation.

Unlock with Pro→Back to E-commerce & Retail Analytics

The Brief

You'll practice

Cohort matrixSelf-joinDate arithmetic
← Previous
Mission 25
Next →
Mission 27
All 30 missions in E-commerce & Retail Analytics Path ↓
  1. 1. Meet the orders table
  2. 2. What financial statuses exist?
  3. 3. Customers by country
  4. 4. Drop the voided / refunded orders
  5. 5. Orders over $200 by customer
  6. 6. Revenue by financial status
  7. 7. Orders by month
  8. 8. Repeat-customer rate
  9. 9. Average order value by channel
  10. 10. Products with zero orders
  11. 11. Top 10 products by units sold
  12. 12. Refund rate by product
  13. 13. Source/medium attribution — last-touch
  14. 14. Top 3 products per category by revenue
  15. 15. Refund-aware net revenue by month
  16. 16. Most recent order per customer
  17. 17. Shopify vs Stripe reconciliation
  18. 18. Repeat-purchase cohort retention
  19. 19. GA4 conversion-value vs Shopify revenue
  20. 20. Discount-driven AOV impact
  21. 21. RFM segmentation — customer scoring
  22. 22. Three-system revenue reconciliation
  23. 23. Abandoned-cart funnel by source
  24. 24. DTC growth dashboard
  25. 25. Board-ready DTC KPI summary
  26. 26. Repeat-buyer cohort retention
  27. 27. Multi-touch attribution — last-click vs first-click vs linear
  28. 28. GA4 vs Shopify drift forensics
  29. 29. FX-adjusted net revenue per channel
  30. 30. DTC year-end capstone — board KPI summary