Get started now
+

Your Pipeline Number Is Probably a Lie. Here Is How to Find the Real One

By Amazing Business Results | Certified Zoho Premium Partner

Automation #7 from The Top 20 CRM Automations in the World by Lior Izik

Topics: Pipeline Accuracy · Stalled Deals · Stage-Time Limits · Expected Revenue · Sales Management

Open your CRM pipeline right now. Look at the total expected value. Now ask yourself honestly: if every one of those deals closed, would that money actually arrive in your bank account? For most businesses we work with, the answer is no — by a significant margin.

This is the fake pipeline problem. It is not unique to one industry or one size of business. It shows up everywhere, and it costs businesses real money — not because deals are being lost, but because decisions are being made on numbers that do not reflect reality. Automation #7 in The Top 20 CRM Automations in the World is the system that finds the real number and keeps it accurate automatically.

The $2.5 Million That Was Not There

Here is what a fake pipeline looks like in practice. A business pulls their CRM report. Expected revenue: $2.5 million. The pipeline total — the sum of all deal amounts regardless of stage — sits at $3.7 million. The owner looks at those numbers and starts making decisions. Maybe it is time to hire two more salespeople. Maybe the office needs to expand. Maybe a dividend is warranted.

Then the quarter ends. The actual revenue is nowhere near either number. The pipeline was inflated with deals that were never real — dead opportunities still sitting in active stages, conversations that ended months ago, prospects who had already bought from a competitor. The business made structural decisions based on fiction.

One of our clients in the medical equipment manufacturing space had 72% of their pipeline classified as fake.

Nearly three quarters of every deal their sales team was “working” did not represent a real opportunity. The business was forecasting, hiring, and planning around numbers that simply did not exist.

The Two Types of Salespeople Who Create Fake

Pipelines

A fake pipeline is almost never the result of deliberate fraud. It comes from two very human patterns that show up in every sales team.

The first is the busy salesperson. This person is genuinely working hard. They are closing deals, talking to prospects, and moving fast. What they are not doing is updating the CRM. Deals that closed last month are still sitting in the pipeline. Prospects who went cold three weeks ago are still listed as active. Not malicious — just a backlog that never gets cleared. The CRM is always behind the reality.

The second type is harder to deal with: the zombie salesperson. This person has a pipeline full of deals that are functionally dead, but they keep them alive in the system. Every check-in produces a reason why this deal is still possible. Every pipeline review surfaces a story about how close this one is. The deals never move. The stages never change. But they stay in the pipeline, inflating the forecast and protecting the salesperson from a difficult conversation.

If you are a business owner, you have met a zombie salesperson.

They are not always underperformers in every dimension — some are strong relationship builders who just cannot close. But their pipeline is fiction, and without a system to catch it, you are making decisions based on their stories.

Stage-Time Limits: The First Line of Defence

The most straightforward fix for a fake pipeline is also one of the most underused features in most CRMs: stage-time limits. The idea is simple — every stage in your pipeline has a maximum time a deal should reasonably sit there before something is wrong.

If a prospect is in the “Book Consultation Meeting” stage, how long should that realistically take? Two weeks is a generous maximum. If a deal has been sitting in that stage for three weeks with no movement, something has happened — the prospect went cold, the salesperson stopped following up, or the deal was never real to begin with. The system should flag it.

From proposal to negotiation or close, another two weeks is a reasonable benchmark for most businesses. These thresholds vary by industry and deal size — a $500 transaction moves faster than a $500,000 contract. But every business can define what normal looks like, and anything outside normal should appear on a report automatically.

The implementation has four parts. Set a maximum time limit for every stage in your pipeline. Build a dashboard that surfaces every deal currently breaching its stage limit. Review that dashboard in every pipeline meeting — not the total pipeline number. Require a clear explanation or a stage change for every breach.

When salespeople know that stalled deals will appear on a report, the behaviour changes. Deals get updated. Closed-lost gets marked correctly. The pipeline starts reflecting reality because there is accountability built into the process.

Stage-time limits are defined during playbook design — which is why this automation builds directly on Automation #6 — Stage-Based Deal Playbooks NOTE: Verify against actual published Automation #6 URL. The playbook defines what should happen at each stage and how long it should take. The stalled-deal system enforces it.

The Communication Problem: When the CRM Is Blind

Stage-time limits catch deals that have gone quiet in the system. But there is a deeper problem: deals that look active in the CRM because the salesperson is logging touchpoints, while the actual conversations are happening somewhere the CRM cannot see.

In the medical equipment company with 72% fake pipeline, we found that salespeople were conducting the majority of their prospect conversations over personal WhatsApp, personal phone numbers, and Telegram. The company had no visibility into those conversations. The CRM showed activity — calls logged, emails sent — but the real sales conversations were invisible.

This is not just a pipeline accuracy problem. It is a data problem with compounding consequences. The business cannot see what is actually being said to prospects on behalf of the brand. Sentiment — whether a deal is warm, cold, or actively problematic — is invisible to management. When a salesperson leaves, all of those conversations leave with them. And AI cannot analyse what it cannot access — the value of AI in sales is directly proportional to the quality of the data it can work with.

The fix is to connect every communication channel to the CRM. Phone calls, WhatsApp, email, SMS, Telegram, meeting transcripts — all of it should flow into the system automatically, logged against the relevant deal record. When that is in place, the CRM does not just track what salespeople report. It tracks what is actually happening.

Channel-connection architecture is a core part of our Zoho CRM customisation service — connecting phone systems, messaging platforms, and email into a single source of truth on every deal record.

What Management Can See When the System Works

Once stage-time limits are set, a stalled deals dashboard is built, and communications are connected, the view from management changes completely. Instead of a pipeline report that shows a total number and a list of deals, management has:

Every deal currently breaching its stage time limit, sorted by how long it has been stalled. Every deal where the last logged communication was more than a defined number of days ago. AI sentiment scores on recent conversations — whether the tone of the last few exchanges was positive, neutral, or declining. A comparison between the total pipeline amount and the expected revenue based on real probability — not optimistic stage assignments. And a clear view of which salespeople have clean pipelines and which have inflated ones.

This does not require micromanaging every deal. It requires building the right reports and reviewing them consistently. The system does the flagging. Management provides the judgment and the intervention.

AI sentiment analysis on sales conversations is exactly the kind of capability our AI consulting services implement — reading the tone of connected communications and surfacing deals that are cooling before the salesperson reports it.

Expected Revenue vs Pipeline Amount: The Number

That Matters

Most business owners look at the pipeline total — the sum of all deal amounts across all stages. That number is almost always too optimistic, because it counts every deal at full value regardless of how likely it is to close.

Expected revenue is a more honest number. It weights each deal by the probability assigned to its current stage. A $400 deal in negotiation at 50% probability contributes $200 to expected revenue, not $400. A deal in early qualification at 20% probability contributes a fraction of its face value.

When stage probabilities are set realistically — based on your actual historical conversion rates at each stage, not aspirational percentages — expected revenue becomes a genuinely useful forecast. It is the number to make decisions from. Pipeline total is vanity. Expected revenue is the signal.

The Quick Self-Assessment

If any of these are true in your business, a fake pipeline is likely distorting your decisions:

Deals older than 60 days sitting in early pipeline stages with no recent activity. Salespeople conducting prospect conversations on personal devices outside the CRM. Pipeline reviews that focus on the total number rather than deal-by-deal movement. No stage-time limits defined — deals can sit anywhere indefinitely. Forecasts that consistently miss actual revenue by more than 20%.

Each of those is fixable with the right system design. The pipeline does not need to be perfect — it needs to be honest. And an honest pipeline, built on real data and enforced by smart automation, is one of the most valuable tools a business owner can have.

Stalled deals that are genuinely dead do not simply get deleted — they move into the nurture and resurrection system from Automation #5 — Nurturing Not-Ready Leads NOTE: Verify against actual published Automation #5 URL. An honest pipeline and an active nurture lane work together: the pipeline shows only real opportunities, and nothing of value is thrown away.

The Top 20 CRM Automations Series

This post is part of an ongoing series covering all 20 automations from Lior’s book:

NOTE: Verify all six URLs above against the actual published URLs before this post goes live.

Ready to Find Out What Your Pipeline Actually

Looks Like?

At Amazing Business Results, we build CRM systems that show business owners the real numbers — accurate pipelines, connected communications, and dashboards that surface problems before they become losses. If you suspect your pipeline is telling you a story rather than the truth, we would be glad to take a look together.

The Top 20 CRM Automations in the World covers all 20 automations with real client stories and the exact systems behind each one.

Get the Book

Explore our related services:

Book a free consultation

Start your free Zoho One trial (no credit card required): USA | Canada | Europe

Subscribe to the ABR Dispatch — Free Weekly AI and CRM Newsletter: zfrmz.com/54B40ZnE2NSRhC3s1Yoh

Top Zoho Extensions: ABR on Zoho Marketplace

Zoho CRM Course: amazingbusinessresults.com/zoho-crm-course

Recent Posts