How to Stop Guessing About Your Pipeline and Start Actually Knowing

How to Stop Guessing About Your Pipeline and Start Actually Knowing

At some point in the quarter, someone in a leadership meeting is going to ask whether you’re on track to hit the revenue target. And at that moment, someone on the sales or marketing side is going to pull up the total value of open deals in the CRM, try to do some quick mental math, and offer a number that sounds confident but is really just optimism.

That’s not forecasting, and anyone who’s had to explain numbers understands that – awkward. Forecasting uses historical data to estimate what’s actually likely to close, based on how your pipeline has performed in the past, not on how you hope it performs this quarter.

The difference between those two approaches is the difference between walking into a board meeting with a story and walking in with a guess.

What Most Teams Get Wrong About Pipeline Math

The most common mistake is treating all pipelines as though they’re all equal. If there’s $500,000 in open deals, the assumption is that some percentage will close. But the math behind “some percentage” is almost always based on instinct, and instinct is a notoriously unreliable forecaster.

The issue is that a deal that has just entered discovery is statistically very different from a deal where the proposal has been sent, a follow-up call has been confirmed, and the client has been referencing it in internal conversations. Counting both of these at the same value in your forecast is like saying “I have flights booked to two cities” without mentioning that one is confirmed and the other is a flight you’re hoping to catch on standby.

How to Build a Forecast That Uses Real Historical Data

Start by pulling your deal data from the last 12 months and calculating the historical conversion rate for each stage in your pipeline. What percentage of deals that entered the “Proposal Sent” stage actually closed? What percentage of discovery calls turned into proposals? What about contacts who requested a demo but haven’t had a sales conversation yet?

If 100 deals entered “Proposal Sent” last year and 40 eventually closed, your historical close rate from that stage is 40%. If there’s currently $200,000 sitting in deals at that stage, your probability-adjusted contribution from that bucket is $80,000, not $200,000.

Apply that logic to every stage in your pipeline and add up the weighted values. What you end up with is a forecast that reflects the real conversion behaviour of your business, not just a sum of what’s currently open.

In HubSpot, the deal pipeline report and the built-in forecasting tool in Sales Hub give you the foundation to run this analysis. On Professional or Enterprise tiers, custom reports can calculate weighted pipeline value by stage using your own historical data, so you’re not relying on default estimates.

Why This Makes a Meaningful Difference in a Boardroom

A probability-adjusted forecast is more credible than a raw pipeline number because it’s grounded in evidence. When you say, “based on how our pipeline has converted historically, we expect to close approximately $X from what we’re currently working,” you are demonstrating that your team understands your own business well enough to model it.

That kind of analysis also surfaces something valuable beyond the forecast number itself. If one stage in your pipeline consistently converts at a lower rate than the others, that’s telling you something is breaking down at that particular point in the buyer journey. Maybe the proposal isn’t landing the way it should. Maybe there’s a pricing objection that keeps coming up after demo calls. Maybe the follow-up cadence after discovery goes too quiet. The forecast data doesn’t just predict revenue, it points to where the process needs attention.

The goal is to be the person in the room who can say “Here’s what we expect to close this quarter and here’s why,” instead of the person who says, “we have a strong pipeline,” and then holds their breath.

You’ve got this.

more insights