RevOps & Sales Analytics Path · Mission 13 of 34Medium

Mid-cycle owner reassignments

WHERE filter on a specific changed_field value — surfacing ownership churn without aggregating the whole history

Unlock with Pro→Back to RevOps & Sales Analytics

The Brief

You'll practice

GROUP BY HAVINGCOUNT DISTINCT
← Previous
Mission 12
Next →
Mission 14
All 34 missions in RevOps & Sales Analytics Path ↓
  1. 1. Meet the opportunities table
  2. 2. What stages exist in the pipeline?
  3. 3. Open opportunities by owner
  4. 4. Drop the Closed-Lost deals
  5. 5. Deals over $50K by account
  6. 6. Pipeline value by stage
  7. 7. Deals by close quarter
  8. 8. Win rate by sales rep
  9. 9. Average deal size by region
  10. 10. Leads with no account match
  11. 11. Deals that reopened after Closed-Won
  12. 12. Stage regressions — deals that moved backward
  13. 13. Mid-cycle owner reassignments
  14. 14. Top 3 reps per region by closed-won revenue
  15. 15. Pipeline velocity — avg days per stage
  16. 16. Most recent opportunity per account
  17. 17. Point-in-time forecast snapshot (SCD2)
  18. 18. Closed-Won cohort retention by month
  19. 19. Quarterly bookings waterfall — new vs expand
  20. 20. Amount discount — committed vs closed
  21. 21. Pipeline hygiene — issue count per opportunity
  22. 22. ARR bridge — starting + new + expand per quarter
  23. 23. Sales cycle segmentation by deal-size bucket
  24. 24. Rep performance dashboard
  25. 25. Board-ready sales operations summary
  26. 26. Discount slippage by close-quarter
  27. 27. Stage conversion funnel with drop-off
  28. 28. Regional pipeline scorecard
  29. 29. Account expansion analysis — multi-opp customers
  30. 30. RevOps board capstone — quarter close panel
  31. 31. Quota attainment by rep (2025-Q1)
  32. 32. Forecast category pivot — per rep
  33. 33. Comp accelerator math (2025-Q1)
  34. 34. Clawback exposure on reopened deals