Sales Process

Your Pipeline Number Is Lying to You

September 2026 · 8 min read

A dashboard that adds up every open deal at face value isn't measuring your pipeline — it's measuring your optimism. Here's what actually separates a healthy pipeline from a thin one, and the confidence-scoring model we built into The Drip Suite to make the difference visible.

The Problem With "Total Open Pipeline"

Ask most sales teams how their pipeline looks and you'll get one number: total open value. It's the sum of every deal sitting in Prospect, Quote, and Negotiation, added together like each one is equally likely to close. It isn't a forecast — it's an inventory count.

The problem is that number treats a deal that's been sitting in Quote for three months, waiting on a customer's internal budget approval, exactly the same as one that had a great call this morning and is a signature away from closing. Sort either of those lists by expected close date and you'll see the same distortion from a different angle: a date field only tells you when someone typed in that the deal might close, not how likely that date actually is to hold.

What Salesforce, Pipedrive, and HubSpot Actually Do

This isn't a new problem, and the major CRM platforms have mostly converged on the same answer: weight each deal by how likely it is to close, not just by whether it's still open.

The baseline everywhere is stage-based probability — every pipeline stage carries a default percentage, and weighted pipeline value is the sum of each deal's value times its stage's percentage. That's a start, but it assumes every deal at a given stage is equally likely to close, which is rarely true in practice.

Pipedrive's model goes one step further, and it's the one we ended up closest to: every deal can carry its own manual probability that always overrides the stage default when it's set. Two deals sitting in the same stage can carry different weight, because a rep's read on the account is allowed to matter.

Salesforce takes a related but distinct approach with its Forecast Category field — Pipeline, Best Case, Commit, Omitted — kept deliberately separate from Stage. Stage says where a deal sits in the process; Forecast Category is a confidence judgment layered on top. The two aren't supposed to be the same field wearing two names.

Why a Free-Text Percentage Field Fails

Give a rep an open percentage field and the research on how that plays out is consistent, and not flattering. Reps anchor on the last positive signal and rarely revisit a number once it's set — a deal can sit at 80% for weeks after the prospect goes quiet, because nothing forces anyone to look at it again. And the precision is fake: one rep's 80% is another's 55%, so a spreadsheet full of percentages looks rigorous while actually just averaging together a room full of different personal calibrations.

There's a simple logic check that exposes the problem. If two competing vendors are chasing the same deal, and each rep honestly self-reports a 75% chance of winning it, something has to be wrong — their odds can't both be that high at the same time. A gut-feel percentage isn't measuring the deal. It's measuring the rep's mood.

25-40% Typical forecast variance with an unstructured probability field
<10% Forecast variance teams report with a structured, disciplined qualification process

The Confidence Model We Built Into The Drip Suite

We didn't want a free-text field, and we didn't want a full enterprise qualification framework either — The Drip Suite is built for reps and small teams running real pipelines, not a Fortune 500 RevOps org. So we kept the two ideas that mattered most from the research and left the rest out.

01

Stage and confidence are two separate fields, never one

Stage says where a deal sits in the process — Prospect, Quote, Negotiation. Confidence says how likely the rep thinks it is to land. Collapsing those into one field is exactly what makes "Quote stage" get used as a stand-in for "pretty likely," which is how a stalled deal ends up looking healthier than it is.

02

Confidence is quantized, not typed

A rep picks from five fixed values — 20%, 40%, 60%, or 80% while a deal is open, 100% only once it's actually won — instead of typing a number. Quantizing kills the "63% vs. 61%" false precision that makes a spreadsheet of gut-feel percentages look more rigorous than it is.

Every open deal still has a probability even before a rep touches this field: it inherits a default from its stage, the same baseline every CRM ships with. Five stages, five defaults — and one value that's deliberately not a default anywhere: 80%. It's the strongest override a rep can apply on purpose, one step short of the fact-only 100%, which is why it's marked differently below instead of sitting quietly between two stages as if it were a sixth one.

Prospect — 20%

Early — nothing's been qualified yet.

Quote — 40%

A number's on the table, but it's still a guess until a rep overrides it — up to 60% or 80% if it's actually going well.

Negotiation — 60%

Terms are being worked, not just price.

Override, not a stage

80%

No deal defaults here — a rep sets this by hand on a Quote or Negotiation deal that's going better than its stage suggests.

Closed Won — 100%

A fact, not a forecast — see below.

Closed Lost — 0%

Also a fact, not a forecast.

A rep can override any open deal's default with one of the four manual values (20/40/60/80%) — a Quote-stage deal that's actually going well can be marked 60% or 80% without the app pretending it's already in Negotiation. But the override only ever wins while the deal is still open. The moment a deal reaches Closed Won or Closed Lost, the stage default takes back over completely, ignoring whatever the rep last set — because a decided deal isn't a forecast anymore, it's an outcome. That's also the only mechanism that ever sets a deal to 100%: nothing lets a rep mark an open deal "100% confident," which is exactly the discipline behind "Won is 100% only."

A percentage a rep can set and forget isn't a forecast. It's a number that used to mean something.

Reading Your Weighted Pipeline Number

Once every open deal carries a real confidence value — set manually or inherited from its stage — the math for a more honest forecast is one line: multiply each deal's value by its confidence, and sum across every open deal. That's weighted pipeline, and The Drip Suite's Pipeline page shows it right next to raw open value, on purpose.

The gap between those two numbers is the actual answer to "how healthy is this pipeline." A team with $2M open and $1.8M weighted is close to as strong as it looks. A team with $2M open and $600K weighted has a pipeline that's mostly early-stage hope — worth knowing before it shows up as a missed quarter instead of a Tuesday afternoon dashboard.

Two Guardrails That Keep the Number Honest

A confidence field is only as useful as the discipline behind it. Two small design decisions do most of the work here, and neither needs a rep to remember a rule.

The scale is fixed, not free text

Five options, no typing. It's a small constraint, but it's the one that stops the field from becoming decoration — every value on it means the same thing to every rep, every time.

Closing a deal overwrites its own forecast

The moment a deal closes, its confidence field stops being a guess about the future and becomes a record of what happened. No stale 80% sits on a deal that actually lost, quietly waiting to skew next quarter's report the next time someone reopens it.

The Bottom Line

Total open pipeline answers "how much is in motion." Weighted pipeline answers "how much of it should you actually expect." Both numbers matter, but only one of them should be the one you plan around — and until you're tracking both, you don't actually know which deals in your open pipeline are doing the heavy lifting and which ones are just sitting there.

The short version: if your pipeline review only ever looks at one number, it's the wrong one. Weight it, then decide.

Keep reading
See it in your own pipeline

This model runs in The Drip Suite today.

Confidence scoring and the Weighted Pipeline number are built into the Opportunities and Pipeline pages, ready to run against your own deals.

Explore The Drip Suite →