I’ve seen it in every CRM I audit. Ken Lundin has walked through hundreds of pipelines. The pattern never changes. Half the deals sitting in your forecast are already dead.

They’re zombie deals. No momentum. No next step. No real buyer engagement.

But they’re still there. They inflate your numbers. They make you feel better about Q4 than you should.

When I run a CRM pipeline audit with a founder, we usually kill 30-50% of their pipeline in the first hour. Not because the deals were bad when they entered. Because nobody had the guts to admit they’d gone cold three months ago.

The math is brutal. If your $2M pipeline is really $1M after you strip out the dead weight, your entire hiring plan just changed. Your cash runway calculation just changed. The story you told your board last week just became fiction.

Key Takeaway: A thorough CRM pipeline audit typically eliminates 30-50% of forecasted deals because most pipelines are bloated with stalled opportunities that lack real buyer engagement or defined next steps. Dead deals create false confidence that derails hiring, spending, and board communications. The audit forces an honest conversation about what’s actually closeable this quarter versus what you’re pretending might close because admitting the truth hurts.

TL;DR

Step 1: Flag Every Deal That Hasn’t Moved in 30+ Days

I’ve run this audit with hundreds of sales teams. The pattern never changes. At least a third of your pipeline is already dead. Your reps just haven’t admitted it yet.

Here’s how to find the corpses.

Step 1: Pull last activity date for every open deal

Sort your entire pipeline by last activity date. Not “last updated.” That’s when your rep changed the close date for the third time.

Last activity means the last actual conversation. Meeting. Substantive email exchange with the prospect.

If it’s been more than 30 days since real contact, the deal is stalled. Period.

I don’t care what the rep says. “Waiting on their budget cycle.” “They’re reviewing internally.”

Enterprise deals now involve an average of 6-10 decision-makers spread across multiple departments, with each stakeholder bringing distinct success criteria and veto power to the buying process. If none of those people are talking to you, you’re not in the deal.

Step 2: Identify deals without a scheduled next step

This is where reps get creative with their excuses. Pull every deal that doesn’t have a calendar-confirmed next meeting, call, or deliverable.

“They said they’d get back to me” doesn’t count. “Waiting on contract review” without a scheduled follow-up doesn’t count.

If there’s no meeting on the calendar with a named decision-maker, the deal doesn’t belong in your forecast.

Step 3: Flag deals past their expected cycle length

According to Gartner (2024), average enterprise sales cycles range from 6-18 months depending on deal size. Cycles over 12 months require executive sponsorship to maintain momentum.

If a deal has been open longer than your typical cycle and hasn’t closed, something’s broken.

Pull a list of every deal that’s been “in play” for longer than your average close time. Not your longest deal. Your average.

These deals need immediate executive review. Or immediate disqualification. No middle ground.

Step 2: Validate Every Deal with the Multi-Stakeholder Test

I’ve watched hundreds of pipeline reviews. The moment I ask this question, reps start sweating.

Can you name every decision-maker involved in this deal? What success looks like for each of them? When you last spoke to them?

Nine times out of ten, they can’t. They’ll name one champion. Maybe two contacts.

But enterprise deals now involve an average of 6-10 decision-makers spread across multiple departments, with each stakeholder bringing distinct success criteria and veto power to the buying process.

If your rep can’t map the buying committee, you don’t have a deal. You have a contact who likes your product.

Here’s how to run this part of the audit:

Step 1: Pull up the deal and ask for the org chart

Not the official one. The real one.

Who’s involved? Who has budget authority? Who can kill this deal with one email?

If your rep draws a blank after naming their main contact, the deal isn’t qualified. Period.

Step 2: Ask what success looks like for each stakeholder

The VP of Sales cares about quota attainment. The CFO cares about payback period. IT cares about integration overhead.

If your rep thinks everyone wants “better results,” they haven’t done the work.

Each stakeholder has different success criteria. Your rep should be able to recite them like they’re reading from a script.

Step 3: Check the last conversation date with each decision-maker

Not an email. Not a forwarded deck. An actual conversation.

If your rep hasn’t spoken to the economic buyer in 45 days, that deal is stalled. If they’ve never spoken to procurement, you’re about to get blindsided in the final stretch.

Step 4: Apply The Pipeline Truth Test

This is where the lies live. Reps will tell you a deal is “progressing.” What they mean is “I sent an email and nobody responded.”

If there’s no next meeting scheduled with a decision-maker, remove it from your forecast. If your rep can’t explain what each stakeholder needs to see before they’ll sign, it’s not a deal.

FAQ

How often should I run a CRM pipeline audit?

Quarterly at minimum. Monthly if you’re serious about forecast accuracy.

I’ve seen teams that only audit once a year. By then, they’re making decisions based on fiction.

The Pipeline Truth Test requires answering three questions for every deal. (1) When was the last real conversation? (2) Is there a defined and scheduled next step? (3) Are you counting this because it’s real or because killing it makes the number smaller?

In every audit, 30-50% of pipeline disappears. Deals lack next steps. Deals lack real momentum.

Run it monthly. You’ll catch the rot before it spreads.

What’s the difference between a stalled deal and a long sales cycle?

A long sales cycle has momentum. Scheduled next steps. Named stakeholders.

A stalled deal has excuses.

According to Gartner (2024), average enterprise sales cycles range from 6-18 months depending on deal size. Cycles over 12 months require executive sponsorship to maintain momentum.

If your rep can’t tell you the exact date of the next meeting and who will be in the room, it’s stalled. Doesn’t matter if they call it “enterprise complexity.”

Should I delete deals from the CRM or just move them to a different stage?

Move them to a “Nurture” or “Parked” stage. Never delete.

You need the data trail to spot patterns in why deals actually die.

But here’s the rule. Once a deal moves to Nurture, it doesn’t count in your forecast. It doesn’t count in pipeline coverage calculations.

Your CRM should reflect reality, not hope.

If a rep wants to resurrect it later with real evidence of renewed interest, fine. But it starts over at qualification. Not where they left it.

What’s a healthy pipeline coverage ratio after an audit?

3:1 minimum for most B2B sales teams. 4:1 if your close rates are below 25%.

But here’s what matters more than the ratio. The quality of what’s left.

I’d rather have 3:1 coverage with deals that have real next steps than 5:1 coverage full of zombie opportunities.

Enterprise deals now involve an average of 6-10 decision-makers spread across multiple departments, with each stakeholder bringing distinct success criteria and veto power to the buying process.

After a brutal audit, your coverage will drop. That’s the point.

How do I get my sales team to buy into a CRM pipeline audit without tanking morale?

Lead with the truth. Inflated pipelines hurt them more than anyone. They’re chasing ghosts instead of real deals.

Frame it as protecting their time. Not punishing their performance.

I tell teams, “We’re killing deals that are already dead. So you can focus on the ones you can actually close this quarter.”

Show them the math. If 40% of their pipeline is fiction, they’re wasting 40% of their effort.

Most reps know which deals are real. They’re just afraid to admit it. Because the number gets smaller.

Can I automate parts of the CRM pipeline audit process?

Yes. But automation finds the suspects. You still need human judgment to convict them.

Set up alerts for deals with no activity in 30 days. No scheduled next step. No contact with decision-makers in 45 days.

Your CRM can flag these automatically.

But don’t let a workflow kill deals without a conversation. Use automation to surface the problem children.

Then make your reps defend them in a pipeline review. With specific evidence. Not hopeful narratives.

What metrics should I track after running a pipeline audit?

Track four things. Average deal velocity (days from create to close). Win rate by stage. Pipeline coverage ratio. Percentage of deals with defined next steps.

These tell you if the audit actually worked.

If your win rate doesn’t improve within 60 days of a brutal audit, you didn’t cut deep enough.

Watch deal velocity. According to CSO Insights (2023), optimal sales compensation splits 60% base / 40% variable for complex B2B sales. Accelerators kick in at 100% quota attainment.

Faster cycles mean reps hit quota sooner. They earn more.

Bottom Line

A real CRM pipeline audit will kill 30-50% of your deals. That’s exactly the point. You’re not cleaning up the forecast to hit a number. You’re forcing an honest conversation about what’s actually closeable versus what you’re pretending might close because admitting the truth hurts. Stop managing theater. Run the audit this week. Delete the dead weight. Coach your team on the deals that matter.

Related Reading

• Sales Management
• Sales Forecasting Methods: Weighted Pipeline vs Stage-Based vs AI Pred
• Sales Hiring Assessment Tools: Predictive Index vs Kolbe vs OMG vs Cus
• How to Build a Sales Team: The 5-Stage Hiring and Onboarding System
• The 3-5x Pipeline Coverage Rule: How Much Pipeline You Actually Need t

Frequently Asked Questions

How often should I run a CRM pipeline audit?

Run a pipeline audit at minimum quarterly, but monthly is ideal for forecast accuracy. Monthly audits catch stalled deals before they inflate your numbers and derail planning decisions, whereas annual audits result in decisions based on outdated pipeline data that no longer reflects reality.

What’s the difference between a stalled deal and a long sales cycle?

A long sales cycle has momentum and scheduled next steps with named stakeholders, while a stalled deal has excuses but no forward progress. If your rep can’t tell you the exact date of the next meeting and who will attend, it’s stalled—regardless of how long it’s been in the pipeline. Enterprise cycles typically range from 6-18 months, but deals over 12 months require executive sponsorship to maintain momentum.

What counts as ‘last activity’ in a CRM pipeline audit?

Last activity means the last actual conversation, meeting, or substantive email exchange with the prospect—not when your rep updated the close date. If there’s been no real contact in 30+ days, the deal is stalled and should be flagged for review or removal from the forecast.

How many decision-makers should I expect in an enterprise deal?

Enterprise deals typically involve 6-10 decision-makers spread across multiple departments, each with distinct success criteria and veto power. If your rep can’t name each stakeholder, explain what success looks like for them individually, and confirm recent conversations with each, the deal isn’t truly qualified.

Why do 30-50% of deals disappear during a pipeline audit?

Most deals are removed because they lack scheduled next steps or real buyer engagement, not because they were bad deals when entered. Reps often keep ‘zombie deals’ in the pipeline too long because admitting they’ve gone cold hurts the numbers—but this inflates forecasts and derails hiring, spending, and board decisions.

What should I do with deals that are past my average sales cycle?

Deals exceeding your average cycle length need immediate executive review or disqualification—there’s no middle ground. Something is broken if a deal hasn’t closed within your typical timeframe, and these stalled opportunities should be evaluated for real momentum before remaining in your forecast.