Back to blog

Why Half Your Pipeline Is Already Dead (And How to Find Out)

Why Half Your Pipeline Is Already Dead (And How to Find Out) cover

The pipeline review is supposed to be the moment clarity arrives. In practice, for most SMB sales teams, it is the moment they realize how little they actually know about what is moving and what is not. A rep with 40 active deals sits down on Monday morning and opens the CRM. Forty rows. Forty stage names. Forty last-activity dates that were entered by someone, at some point, with varying degrees of accuracy.

Pipeline rot is what happens when deals stay alive in a CRM past the point where they should have been acted on or closed out. It accumulates quietly. A deal that has been in "Proposal Sent" for 63 days does not show up as red unless someone has written a rule to flag it. Most CRMs do not write that rule by default. Most revenue teams do not either, because setting up those alerts requires a configuration session and someone to own it, and the team's time goes to the next call.

What pipeline rot actually costs

There are two costs, and the less obvious one tends to matter more.

The direct cost is forecast accuracy. A pipeline that includes 15 deals with no realistic chance of closing this quarter produces a forecast that is off by the value of those 15 deals. For a five-person team with a $40K to $50K average deal size, phantom pipeline can amount to $600,000 or more sitting in whatever spreadsheet someone sends to the founder on Friday. When the founder asks why revenue came in at 60% of forecast, the honest answer is often that the forecast included deals that had already quietly died weeks earlier.

The indirect cost is rep attention, and this one compounds. Every dead deal that stays in the active pipeline gets reviewed, considered, and set aside during the meeting. A rep reviewing 40 deals where 15 are already gone spends roughly a third of the review on noise. Over a quarter that adds up to several hours of decision-making capacity directed at the wrong things. In a small team where each rep is also handling onboarding, demos, and customer questions, those hours are not recoverable.

The anatomy of a rotting deal

Pipeline rot does not happen all at once. It moves through recognizable phases. The first is activity silence: the last logged contact was 15 to 20 days ago and there is nothing scheduled. The second is stage freeze: the deal has not changed stages in 30 or more days. The third is contact degradation: the people who were engaged at the start of the deal have stopped appearing in logged activities, which usually means the internal champion went quiet.

Any one of these signals in isolation might be explainable. A prospect on vacation, a deal with a longer-than-usual evaluation cycle, a contact who moved their communication to a channel the rep uses but does not log. The problem appears when two or three of these signals overlap on the same deal. At that point the deal is almost certainly rotting, regardless of what stage it shows in the CRM.

The other distinguishing feature of rotting deals is that they tend to cluster around a specific stage. For most SMB sales cycles, the highest-rot stages are "Proposal Sent" and "Negotiation," because those are the stages where the action has shifted to the buyer's side. The rep has done their work; now they are waiting. Waiting is when deals go cold without generating any CRM activity that would flag the problem.

How to find the rot in your current pipeline

The basic version requires no tooling beyond your existing CRM filters: sort by last activity date, then cross-reference against stage entry date. Any deal where both of these fields are older than your typical close time for that stage is a candidate for review. In most CRMs, this takes about 10 minutes to run as a saved filter view.

The more precise version uses stage-specific benchmarks derived from your own closed deals. If your won deals spend an average of 9 days in "Proposal Sent" before moving to negotiation, then a deal that has been in "Proposal Sent" for 26 days is a meaningful outlier, not just an old deal. Building this table for each stage in your pipeline, even roughly, gives you a calibrated threshold rather than a generic one. Generic thresholds like "30 days in any stage" produce noise because they do not account for the fact that some stages are supposed to be slower than others.

A useful illustration: a growing software services company running a 6-person sales team had 34 deals in their active pipeline heading into Q4 of last year. When they ran a stage-age analysis against their own historical averages, 11 deals flagged as outliers for their current stage. After reviewing those 11 deals in a single one-hour meeting, the team agreed that 7 of them were effectively dead. The pipeline value they had been reporting dropped by roughly $280,000 in that meeting. That was uncomfortable. But it also meant the remaining forecast was actually credible for the first time in months.

What to do when you find it

The right response to a rotting deal is not to send a desperate follow-up sequence. It is to make a decision. Either the deal gets a specific, time-bound recovery attempt, or it gets moved out of active pipeline. The recovery attempt should be direct: acknowledge that things have gone quiet, ask a specific question about where things stand, and set a clear date after which you will close the deal out if you do not hear back.

This feels aggressive the first time a team does it. The fear is that closing out a deal means giving up on it. The practical reality is different: a deal that is cleanly closed out can be reopened when circumstances change. A deal that sits in pipeline rot takes attention away from deals that are actually alive, and it inflates a forecast that someone is relying on to make real decisions about headcount or spend.

A boundary worth drawing

Not every old deal is a dead deal. This is worth being explicit about before running a pipeline cleanup exercise. Some buyers work on longer cycles by necessity. Enterprise procurement processes, budget cycles, and internal approval chains all create legitimate pauses. The key difference is whether those pauses were communicated. A deal where the prospect told you in March that they are revisiting budget in Q3 and you have a follow-up scheduled is not rotting. It is waiting. A deal where the prospect went quiet three weeks ago with no explanation is a different situation entirely.

The goal of pipeline hygiene is not to have fewer deals in the CRM. It is to have a pipeline where every deal that appears in the count actually has a plausible path to closing. When you can look at your list and say "every deal here has had contact in the last 14 days or has a documented next step," you have a pipeline report that is worth reading. That is what clean looks like, and clean forecasts are a competitive advantage for small teams that need to make fast resource decisions.

Building that habit is harder than it sounds, because it requires making uncomfortable calls about deals that reps have invested time in. But the alternative, reviewing the same stalled deals week after week while hoping something changes, is a much larger drain on the team's energy than the discomfort of closing things out cleanly.

Ready to see your pipeline signals?

Connect your CRM and get your first ranked action list in the same week.

Get Early Access