Is my pipeline real or full of stale deals?
A $400K pipeline looks healthy until you realize half of it hasn't been touched in 30 days. Here's how to separate real deals from dead weight.
The short answer
Check three things for every open deal:when was the last activity, how many times has the close date been pushed, and how long has it been in the current stage. If a deal has no activity in 14+ days, has been pushed twice, or has sat in one stage for longer than your average cycle time, it's probably stale.
Zombie deals destroy your forecasting accuracy
Reps are reluctant to close deals as lost. It feels like admitting failure. So deals that are effectively dead stay open in the pipeline, inflating your numbers and giving you false confidence about next month's revenue.
A pipeline full of stale deals leads to missed forecasts, wasted time chasing deals that were never going to close, and an inability to see whether you actually have enough real pipeline to hit your target. Pipeline hygiene is boring. It's also the difference between a forecast you can trust and one that lies to you.
Three signals that a deal is stale
- No activity in 14+ days.If nobody has logged a call, email, meeting, or note on a deal in two weeks, the deal is cooling. After 30 days of silence, it's effectively dead until someone re-engages.
- Close date has been pushed more than once. Every time a rep moves the close date from one month to the next, the probability of that deal closing drops significantly. Two pushes is a yellow flag. Three is red.
- Stuck in one stage longer than your average cycle time. If your average deal spends 10 days in “Proposal Sent” but this deal has been there for 35 days, something is wrong. Either the prospect went dark or the deal was never real to begin with.
How to find stale deals in HubSpot
- 1Go to Sales → Deals, switch to List view
Click Advanced filters. Add a filter for “Last activity date is more than 14 days ago” and “Deal stage is not Closed Won or Closed Lost.” This shows all open deals with no recent engagement.
- 2Check for pushed close dates
Add the “Close date” column and sort ascending. Deals with close dates in the past that are still open have already missed their expected close. Open each one and check the activity timeline to see if the close date was moved.
- 3Use the “Deals won vs. lost” report
Go to Reports → Analytics Tools → Sales Analytics. Select Deal lost reason analysisto see why deals are being closed as lost. If “No response” or “Went dark” is a top reason, you likely have more stale deals still sitting open.
- 4Set up deal stage automation (optional)
In Automation → Workflows, create a workflow that sends an internal notification when a deal has had no activity for 14 days. This catches stale deals before they accumulate.
Total time: 15-20 minutes for the manual review. Setting up automation takes another 15 minutes but saves you time every month.
How to find stale deals in Salesforce
- 1Open Pipeline Inspection
Navigate to Opportunities → Pipeline Inspection. Key columns to watch: “Last Activity,” “Days in Stage,” “Push Count” (how many times the close date moved to a later month), and “Age.”
- 2Sort by push count and days in stage
Deals with a push count of 2 or more are slipping. Sort by “Days in Stage” descending to find deals that have been parked in one stage for too long. Anything over 30 days in a single stage warrants a review.
- 3Create a “Stale Pipeline” report
Go to Reports → New Report → Opportunities. Filter for open opportunities where “Last Activity” is more than 30 days ago. Add columns for Amount, Stage, Owner, and Close Date. This is your stale pipeline list. Review it weekly.
Total time: 15-20 minutes. Pipeline Inspection makes this faster in Salesforce than in most CRMs because push count and days in stage are built in.
Cross-reference stale CRM deals with your books
Sometimes a deal looks stale in the CRM but the customer already paid. Or a deal looks active but was never invoiced. Here's what to check:
- Check for deals marked “Closed Won” with no matching invoice. If a deal closed in your CRM but there's no invoice in QuickBooks or Xero, either the billing fell through the cracks or the deal wasn't real.
- Check for invoices with no matching deal.Revenue showing up in your accounting software that doesn't correspond to a CRM deal means your pipeline was never tracking that customer. Your CRM is missing data.
Pipeline cleanup as a monthly discipline
A proper pipeline scrub takes 20-30 minutes once a month. Review every deal with no activity in 14+ days. Decide: re-engage or close as lost. Update close dates that are in the past. Remove deals that were never real. The result is a pipeline number you can actually trust for forecasting.
Or get stale deals flagged automatically every month
Bottomline connects to your CRM and flags pipeline health issues in your monthly report. No manual scrubbing required.
Instead of manually reviewing every deal, you get a clean separation: here's your real pipeline, and here's the dead weight. Plus, Bottomline cross-references with your accounting data to catch deals that closed but were never invoiced.