Why Your Pipeline Is Lying to You

The number on your dashboard is a stack of guesses. How to catch the three guesses inside it, and what fixing it involves.

Hassaan Ahmad6 min read

Your pipeline number is a stack of guesses wearing the costume of a fact. It isn't lying because anyone is dishonest. We rebuild revenue systems for B2B teams, and the cause is almost always the same: nobody ever agreed what the number means. Here's how to catch it, and what fixing it involves.

It's Monday. The pipeline review opens with £1.4M on the dashboard, and everyone in the room quietly discounts it by a different amount. The CEO reads it as £1.4M. The CRO reads it as "maybe £800k". The rep who owns the biggest deal in it knows something the CRM doesn't, and is deciding whether this is the week to say so. One seller on r/sales described that gap landing at the worst possible moment: "Champion on one my commits just left the company. It is essentially resetting the entire process and I only found after I submitted forecasts this week." [1]

The forecast was wrong before the champion left; that risk existed for weeks, unrecorded. The champion leaving just made it visible. That's the thing about pipeline metrics: they don't fail loudly at the moment they go wrong, they fail quietly at the moment you rely on them.

The three guesses baked into every pipeline number

The stage probability is an average pretending to be a prediction. Your CRM says stage three deals close at 40%. That's an average across every deal, rep and quarter you've ever had, applied to a deal that will either close or won't. Run the arithmetic on a real quarter: twelve deals at stage three, "worth" £480k at 40%. Four or five will close. Which four matters enormously, because your deals aren't the same size. That 40% summarises your history and says nothing about this quarter. The Forecast Delusion chapter walks through why the arithmetic collapses at small numbers, which is the only kind a quarterly forecast has.

The close date is a hope with a calendar attached. Reps put down the date the deal could close if everything goes right. Then it slips in weekly increments: procurement surfaces, legal redlines, the champion goes on holiday. The tell in your own CRM: the close date moves eleven times, two weeks at a time, and the stage never moves at all. Every one of those dates was written in good faith. None of them carried information.

The deal value is whatever somebody said in a good meeting. The £100k in the CRM came out of a room where everyone was enthusiastic; then procurement benchmarks it, scope gets trimmed, and the deal closes at £62k. Sometimes it goes the other way, when a second stakeholder pulls the product into their team. Either way, your pipeline carried that first number for five months, and every report built on it inherited the error.

All three guesses trace to one root: stage gates based on what a rep did (sent the proposal) instead of what a buyer verifiably did (agreed the problem is funded this year). When stages record activity, the pipeline measures effort. Effort doesn't close.

Those stages sit inside a bigger machine. We map a revenue engine as five phases with a gate between each, and a pipeline is the middle two: Activate, where interest becomes conviction, and Capture, where conviction becomes revenue. Record activity instead of buyer movement and both gates go dark. That darkness is what the dashboard dresses up as a number.

Better dashboards won't fix it, and Gartner has the numbers

The instinct at this point is to buy a forecasting tool or rebuild the dashboard. Gartner surveyed 303 sales leaders in July 2023: 84% agreed that sales analytics has had less influence on sales performance than leadership expected, and 44% named poor data quality among the top barriers. [2] The same survey carries the finding that should redirect your budget: analytics led by the Chief Sales Officer were 2.3 times more likely to achieve higher forecast accuracy than analytics led elsewhere. Ownership of the system beats sophistication of the tooling, and it costs nothing to adopt.

Your reporting layer shows whatever the layer beneath it records. If "qualified" means three different things to three different teams, the dashboard is confidently wrong, and a better one renders the confusion in higher resolution, faster, with export to PDF. You'll have spent the money and bought back none of the trust.

So start with definitions. One qualification standard, written down, applied on live calls. Stage gates tied to buyer commitments: the buyer named a budget line, the buyer agreed an evaluation plan, the buyer introduced procurement. Then, and only then, instrumentation that records those definitions as deals move. That order is the whole of an honest revenue-system rebuild: the CRM comes last, because it can only be as truthful as the definitions it records.

The ten-minute test you can run today

Pull last quarter's closed-won deals and trace three of them backwards through every stage change. Read the history like a stranger would, without the memory of the meetings. Two patterns should worry you. The first is a deal whose recorded story you don't recognise, even though you were in the room: stages that skipped, notes that stop in month two, a close date that moved nine times. The second is the batch update, where every stage change was logged in one sitting the week the deal closed, because somebody was doing admin rather than keeping a record. Both mean your CRM is recording fiction, and every number downstream inherits it.

An honest history reads differently. Each stage change carries the buyer commitment that earned it, dated when it happened. It's boring to read and impossible to argue with, and it buys you the thing every forecast tool promises: a slipping deal announces itself weeks early, because the commitment that should have arrived didn't.

If the test stings, we've written down where it goes next. Qualification debt explains how loose definitions compound into a forecast nobody trusts, and the Revenue Debt whitepaper prices the damage. Or go straight at it: the free PACED diagnostic scores your five gates against your own numbers and names the one the fiction is coming from, in one sitting.

Frequently asked questions

Why is my pipeline number always wrong?

Your pipeline number aggregates three guesses: an average stage probability applied to specific deals, close dates that record hope rather than buyer commitments, and deal values that carry the opening conversation instead of the likely outcome. The fix is definitional: tie stage gates to things buyers verifiably did, and the number starts aggregating evidence.

How do I make my forecast more accurate?

Stop tuning the forecast and start tightening what feeds it. One qualification standard reps apply on live calls, stage gates tied to buyer commitments, and a CRM configured to record both. Forecast accuracy is downstream of definitions, and teams that fix them usually see trustworthy numbers inside a quarter.

What is qualification debt?

Qualification debt is the compounding cost of letting under-qualified deals into the pipeline. Each one inflates the number, absorbs rep time, and dies late, which is the most expensive place to lose. It's the pipeline equivalent of technical debt: invisible at first, then suddenly the reason nothing ships. Our Pipeline Physics playbook covers the full mechanics.

Sources

  1. r/sales, Champion on one my commits just left the company, June 2023. https://www.reddit.com/r/sales/comments/14axyvj/champion_on_one_my_commits_just_left_the_company/
  2. Gartner, Sales Analytics Has Less Influence on Sales Performance Than What Leadership Expected, press release, 6 February 2024 (survey of 303 sales leaders, July 2023)

Hassaan Ahmad

More in Capture