Weighted pipeline vs total pipeline: our $2M pipeline was really $250K to $500K

Sunny Ray · Mar 31, 2026 · 5 min read

Total pipeline adds up every open deal at full value. Weighted pipeline multiplies each deal by the realistic chance it closes, based on its stage and intent. Total pipeline is a ceiling. Weighted pipeline is closer to what you can actually bank, and it's the only one you should plan around. Ours, on March 31, was the difference between two million dollars and somewhere around a quarter of a million.

The number at the top of your CRM is a wish.

Two million, really a quarter of a million

Our closers call that day opened with urgency: "We need to close. We've got two million dollars in pipeline value."

And then, in the same breath, the honest version. It's an exaggeration. Once the deals were qualified, the real figure was more like 250K to 500K.

I respect that both parts got said out loud. Most founders only say the first. The pipeline was more than 600 leads, mostly brand new from cold outreach. New leads are real, and some will close. But a lead that replied last week isn't worth its full deal value, and adding them all up at face value tells you nothing.

That gap, between two million and a quarter of a million, is what weighted pipeline is for.

What the honest weight was

Do the division on our own numbers. A realistic 250K to 500K out of a 2M headline means our true weight on the whole pipeline was somewhere between one eighth and one quarter. Every dollar on the screen was worth twelve to twenty-five cents.

That's not a disaster. Most of the 600 were brand new from cold outreach, and new leads should carry a low weight until they qualify. The disaster would have been planning hires or spend against the 2M. The weighted number is the one you can make decisions with. The total is the one you show yourself when you need cheering up.

Filter by stage before you offer anything

The first thing we did with the real pipeline wasn't forecasting. It was filtering.

We had a new offer to test, and the obvious move was to blast it to everyone. That's a mistake. Some of those prospects were already in the middle of closing on our existing offer. Pitch them something new and you've just reopened a decision they were about to make. You can turn a near-close into a "let me think about both".

So the rule: before you offer anything, filter by stage. People closing on offer A don't hear about offer B until they've decided. People who went cold on A are fair game for B.

The 12 who know you and went cold

Running an AI filter over the CRM with that logic, we found 12 prospects worth testing the new offer on. They knew our offer. They'd been interested. Then they'd gone price-sensitive or quiet.

Twelve. Out of more than 600. That's the weighted pipeline in miniature. Most of the 600 were too new to judge. A few were actively closing. And a dozen were sitting in the exact spot where a different offer might move them.

Twelve right people is a better test than 600 wrong ones.

Scarcity that's true: 20 open seats

The offer we tested on that group was a limited one: 20 open seats. I'm careful with scarcity, because fake urgency gets spotted and punished. But real limits are fine to state. If you can only take on a certain number of clients and do the work well, say so.

A real cap does what a discount can't. It gives a price-sensitive prospect a reason to decide now that has nothing to do with lowering your price.

Renewals at 60%: the number under the number

Then the conversation got more uncomfortable. We weren't getting anywhere near a full renewal rate. The figure said on the call: maybe 60%.

Part of the reason was budget cycles. Part was the nature of an agency: we run a 30-day campaign, deliver the meetings, and when the campaign ends the client's sense of value ends with it. If the value only shows up during the campaign, it disappears when the campaign does.

That matters for weighted pipeline too. A pipeline full of new deals looks great until you remember that four in ten clients may not come back. The real number isn't just new deals weighted by close probability. It's also existing revenue weighted by renewal.

The fix we talked about was making value show up daily, not monthly. A dashboard the client logs into, follow-ups surfaced for them, results they can see between campaigns. If the client sees value every morning, renewal stops being a monthly referendum.

It's an ICP problem

One more line from that team call that I wrote down: "It's an ICP problem, bro. When you're targeting everyone under the sun you're gonna get haters."

That's the line I'd frame for every founder staring at a big pipeline number. A bloated pipeline usually isn't a closing problem. It's a targeting problem that shows up later, as 600 leads of which twelve are real.

How to weight yours

• Assign each stage a realistic close probability based on your own history, not hope.
• Multiply. Add. That's your weighted number. Plan around it.
• Filter by stage before any new offer goes out.
• Find the warm-then-cold group. It's small and it's where tests belong.
• Weight your existing revenue by renewal, too.

If you want to see what your pipeline should really produce, run your numbers.

Frequently asked questions