How to clean up your sales pipeline
A dirty pipeline is worse than a small one because it lies. Inflated coverage and a padded forecast lead to bad hiring and spending decisions that a clean, smaller pipeline would have prevented.
The cleanup itself is a one-time purge followed by a maintenance habit. Do the purge honestly once, then never let it get that bad again.
Short answer
Clean up a sales pipeline by making one ruthless pass: close-lost every deal with no activity in 30 to 45 days, move deals to the stage their evidence supports, add a dated next step to any deal missing one, and reset close dates to what the buyer actually confirmed. Then protect the cleanup with a weekly hygiene rule.
Step by step
Pull every open deal into one view
Sort by last activity date and close date. You want the oldest and most neglected deals at the top where you cannot avoid looking at them.
Age out the zombies
Any deal with no buyer activity in 30 to 45 days and no scheduled next step gets closed lost. These are the deals inflating your coverage. Removing them hurts for a minute and helps forever.
Correct the stages
For each survivor, ask what the buyer has actually committed to and move the deal to the matching stage. Reps drift deals forward on optimism; pull them back to where the evidence sits.
- No confirmed budget owner: not past Qualified
- No proposal sent: not in Negotiation
- No verbal yes: not in commit
Fix fake close dates
Replace any close date that was set to please a manager with one the buyer confirmed or one your average cycle supports. Guessed dates are the root of chronic slippage.
Add a next step to every deal that survives
A deal with no scheduled next action is a deal about to go stale. Book the next meeting or task before you consider the deal clean.
Keep it clean after the purge
Add one standing rule: any deal untouched for 30 days auto-flags for review, and any deal without a next step cannot stay open. Enforced continuously, these two rules mean you never need a big cleanup again.
Resist the urge to keep deals alive for the coverage number. Padded coverage that never closes is how a quarter quietly misses.
How Ardovo helps
Rook runs the cleanup continuously: it flags stale deals, spots stages that do not match the deal's evidence, and nudges reps to add next steps. The one-time purge becomes an always-on background process.
Frequently asked questions
When should you close a deal as lost?
When there is no path forward: no buyer response for 30 to 45 days, no scheduled next step, no compelling event. Keeping it open only inflates coverage. A lost deal you can revive later is better than a fake-open deal skewing the forecast.
How often should you clean your pipeline?
Do a full purge quarterly and light hygiene weekly. Better still, automate the flags so cleanup happens continuously and no deal ever sits stale long enough to need a big purge.
Does removing deals hurt my numbers?
It lowers a vanity number (raw pipeline) and improves the numbers that matter (coverage accuracy, forecast reliability, win rate). Dead deals never close, so removing them costs you nothing real.