We use cookies to provide visitors with the best possible experience on our website. These include analytics and targeting cookies, which may also be used in our marketing efforts.
This website stores data such as cookies to enable essential site functionality, as well as marketing, personalization and analytics. By remaining on this website, you indicate your consent.

How successful sales leaders are transforming their forecasts with win rate data

Learn how to leverage historical win rates for more accurate pipeline-based forecasts, and the impact of quantitative and qualitative factors on the outcome.
Saurav Bhagat
Planning
9 min
Table of contents
Understanding the significance of historical win rates in SaaS businesses
How to incorporate historical win rates into pipeline forecasting
Challenges in leveraging historical win rates for pipeline-based forecasting
Enhance your sales forecasting with Drivetrain 
Frequently asked questions
Subscribe to our blog
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Summary

Historical win rates form the basis of pipeline-based forecasts. However, there are also qualitative factors to consider. In this article, you’ll learn more about how to use historical win rates in your pipeline-based forecasts, including the factors that influence them and the challenges involved in the process. 

A SaaS company’s planning hinges on its pipeline-based revenue forecast.

Historical win rates help determine the probability of leads making it through your entire pipeline. That’s just the starting point. Qualitative factors, such as shifts in the competitive landscape or any changes in your sales team composition can also have a significant impact on your pipeline-based forecast.

In this guide, we look at how to use historical win rates for better predictions and what other factors you need to consider to make your forecasts more accurate.

Understanding the significance of historical win rates in SaaS businesses

Sales win rates are one of the most telling metrics for any sales team. It represents the percentage of deals won out of the total number of qualified opportunities. The number of customers you expect to close not only influences your cash flow predictions and cash runway status, but also determines your headcount planning and infrastructure investment to support growth. 

Historical win rates provide the foundation for well-informed forecasts because they ground your sales predictions in actual performance data (i.e., past sales win rates). You can look at win rates over time by sales rep, segment, deal size, or product to spot meaningful patterns and make strategic decisions.

For example, enterprise deals may have a lower win rate but a higher payoff, or you may notice Q3 always sees a slump.

Why does this matter? Because sales forecasting isn’t just about forecasting revenue. It’s about planning headcount, cash runway, and customer success capacity.

Historical win rates bring objectivity into the process. They enable your team to accurately model future outcomes by providing insights into factors influencing revenue, such as seasonality and sales cycle changes.

Calculating sales win rates

SaaS businesses use win rate information to determine which sales reps, time periods, and win/loss factors are most likely to turn a prospect into a paying customer. Here’s the formula they use:

Sales win rate equals the number of deals closed won divided by the sum of the deals closed won and deals closed lost.
The sales win rate formula.

Let’s see how the sales win rate calculation works.

Clara is the VP of Sales team at a mid-sized SaaS company. The sales team is great at doing demos, booking meetings, and filling the pipeline with qualified opportunities. However, at the end of Q4, Clara once again finds herself in the unenviable position of having to explain to the CXOs the likelihood of the sales team not closing even half of the projected $1.6M in revenue.

Out of 200 qualified opportunities last quarter, they only successfully closed 40—a win rate of 20%:

Sales win rate = (40 / 40 + 160) = 20%

While Clara can’t fix the past, she can use these findings to make smarter, more-data-backed decisions, by:

  • Fixing overoptimism in forecasts: Digging a little deeper, Clara learned that her team was building forecasts based on total pipeline value, optimistically assuming they’d close 80% of deals. With a 20% historical win rate, it’s clear the forecasts were built on hope, not history. To fix this, Clara plugs that 20% into the forecast model and arrives at a more realistic projection of $320,000 in closed revenue from a $1.6M pipeline.
  • Addressing sales training gaps: Sales win rate analysis is a powerful tool for evaluating rep performance. For example, Clara also noticed that while one rep was closing at 45%, another was stuck at 10%. The latter is great at booking meetings but struggles to move deals past the proposal. So, Clara now arranges for coaching sessions for any reps who are struggling at moving deals forward to help them improve their win rates.
  • Optimizing marketing spend: Clara also filtered win rates by vertical. Turns out, their win rate in healthcare is 38% compared to a dismal 8% in fintech. She then works with the marketing team to reallocate the marketing budget and retarget campaigns to focus more on healthcare. This results in lower CAC and higher win rates, not to mention a stronger pipeline.

How to incorporate historical win rates into pipeline forecasting

Pipeline forecasting is essentially an exercise to calculate the expected value of deals in your pipeline. Each deal in the pipeline is assigned a probability of closing based on the  historical win rate). The probability may be based on deal stage, customer segment, or any other logical basis.

For example, if 25% of your leads in the “Discovery” stage have historically ended up signing a contract, you can estimate a similar percentage of the leads now in the “Discovery” stage will close.

Here’s a step-by-step guide on how you can use historical win rates to improve your pipeline-based forecast.

Step 1: Analyze historical win rates

Review and analyze lead movement and historical win rates data for each stage in the pipeline. Let’s say you have three stages in your pipeline. Your win rates for each stage could be:

  • Discovery: 10%
  • Proposal sent: 20%
  • Contract sent: 70%

Step 2: Assign probabilities to current opportunities

Let’s say you have deals worth $100,000, $250,000, and $500,000 in the “Discovery,” “Proposal Sent,” and “Contract Sent” stages, respectively. 

If you’ve got $100,000 worth of opportunities in the “Discovery” stage, which has a 10% historical win rate, the forecast value of those deals is $10,000, not $100,000. 

For our example, the probability-weighted value of those deals would be:

  • Discovery: 10% x $100,000 = $10,000
  • Proposal sent: 20% x $250,000 = $50,000
  • Contract sent: 70% x $500,000 = $350,000

Step 3. Adjust probabilities to reflect sales team dynamics

If you’ve recently hired more experienced sales reps, invested in a sales training program, or made other changes in your sales team, you’ll need to evaluate the impact of those changes on win rates. 

For example, one of your senior account executives (AE) has moved on from the company. Meanwhile, three new reps joined last month. In this situation, calculating the ramp-up time for AEs in your company can help you figure out how long it will take your new reps to become productive. So let’s say you’ve done that and have determined that you need to  adjust the win rate of 20% (given in Step 2) down to 10%. So now, our probabilities look like this:

  • Discovery: 10% x $100,000 = $10,000
  • Proposal sent: 10% x $250,000 = $25,000
  • Contract sent: 70% x $500,000 = $350,000

Understanding your ramp-up time allows you to build in the more realistic expectation that your win rate in the “Proposal Sent” stage is going to be lower without that senior AE and as your new reps learn about your product and how to sell it effectively.  

Since we’re talking about calibrating your predictions based on sales team dynamics, it’s worth mentioning that to the extent you make sales capacity planning a regular part of your sales operations, you make your business more resilient in the face of unexpected turnover in your sales team.  

Learn how to "right-size" your sales team with our sales capacity planning ebook.

Step 4: Calculate weighted pipeline forecast

Add the probability-weighted values (given in Step 2 and adjusted in Step 3) across your pipeline. The result is the expected value of the deals in your pipeline. 

In our example, the expected deal value for the entire pipeline works out to:

Expected deal value in current pipeline = $10,000 (Discovery) + $25,000 (Proposal sent) + $350,000 (Contract sent) = $385,000

Step 5: Monitor and refine the forecasting model. 

Document your assumptions and review them periodically. It is important to update assumptions in your forecasting model when warranted. 

To the extent possible, assumptions should be based on solid data, including information about macroeconomic conditions, market trends, win rate analysis and other relevant factors.  

For example, if your sales team’s performance improves and you see an uptick in win rates or your biggest competitor just filed for bankruptcy. In either situation, you may choose to revise your win rate upwards.

Challenges in leveraging historical win rates for pipeline-based forecasting

The challenges in pipeline forecasting mostly involve dealing with data accuracy and variability, as well as refining that data based on dynamic business conditions.

1. Data relevance and timeliness

Historical win rates reflect the reality of your past sales. But modern businesses are rarely static. Your product, pricing, ICP, or market positioning might evolve in accordance with market trends or macroeconomic conditions, making historical win rates less relevant.

Inaccurate or incomplete data—including deals stuck in the wrong pipeline stages, missing close dates, or dead deals that are never properly closed—resulting from poor CRM hygiene can pollute your data set.

The time of the data’s origin plays a role too. It’s tempting to grab as much historical data as you can to get statistically significant win rates. But longer windows dilute relevance. For example, your assumptions might be rooted in win rate data for the past year, but you run the risk of including outdated processes or trends. Conversely, while your current quarterly win rate data would have recency value, it could lack statistical significance.

2. Variability in sales cycles

Not all deals close at the same speed or at the average historical win rate. For example, SMB deals close faster than enterprise ones. Win rates and sales cycle length vary among products too—complex or customizable products tend to have longer sales cycles.

Your sales performance can vary even with similar deal sizes. Inbound leads often convert faster because they’re self-qualified, while outbound leads require more nurturing.

Segmenting your pipeline by deal size, customer type, product complexity, and other factors can be tedious and inefficient. The goal here should be on maintaining a balance between accuracy and efficiency by focusing on categories that offer truly meaningful differentiation. This will vary by business. In some cases, focusing simply on small/mid-market and enterprise deals may be just as effective (and definitely easier) than defining segments in a more detailed way. 

3. Sales team dynamics

Your sales team composition is often overlooked but has a significant impact on the reliability of historical win rates. While you can choose to refine your assumptions and win rates to reflect any changes in your sales team, the process is inherently arbitrary and subjective. 

For example, will there be any changes in your assumptions and forecast when a new rep joins or a top performer leaves? You cannot expect your newly hired AEs to perform at the same level as the experienced AEs in your team. It takes time, effort, and patience to learn about the product, master the pitch, and navigate objections. 

Therefore, forecasts based on historical, team-wide win rates can be overly optimistic unless you factor in the initial ramp-up period. Another approach that experienced sales leaders often rely on to ensure their projections are more accurate is judgment-based forecasting. With this approach, any calculations you do to better understand ramp-up time in your business becomes one of several different factors you can include in your forecasting process. 

An even bigger problem is losing a top performer in your sales team. They carry institutional knowledge, such as anticipating objections or which features resonate the most with potential customers. While your overall pipeline would largely remain unchanged, the absence of high performers can slow down deal velocity and reduce win rates. 

You do have some control over sales team dynamics, though. Changes in compensation plans and commission structures, or even company culture can influence your win rates. A motivated team might close deals faster to hit bonus thresholds than a team with low morale or unclear targets.

4. Overlooking qualitative factors

Forecasting is never a purely technical process. Historical data and formulas give you a starting point, but you also need to account for experience and foresight for accurate forecasts.

For example, if your biggest competitor just undercut you on price or rolled out a new high-demand feature, your win rate will take a hit. But your historical data won’t show that.

At times, factors completely unrelated to sales can impact your win rate. For example, a major product outage could threaten your company’s credibility or a brand refresh might alienate legacy customers.

Your best bet is to seek inputs and guidance from experienced AEs and senior leaders on addressing qualitative factors and unprecedented conditions and adjusting your win rates accordingly. 

Enhance your sales forecasting with Drivetrain 

Pipeline forecasting gives you a financial blueprint, but it’s based on estimations. And one of the biggest challenges many businesses face is pulling all the data they need together so they can estimate more accurately. 

But here’s the thing. This is an easily solvable problem. Modern sales forecasting software like Drivetrain, improve forecasting accuracy by allowing instant access to your (updated and latest) data whenever you need it.  

With over 800 integrations, Drivetrain automatically consolidates and validates data from disparate systems and apps, including CRMs, accounting systems, ERPs, even billing tools. With the platform’s built-in formulas and templates, any changes in assumptions and data mean that your models are updated as well—without resorting to manual interventions or unwieldy spreadsheets. 

This leaves you with enough time and headspace to focus more on the strategic side of forecasting—such as, monitoring qualitative factors, team dynamics, and market shifts—and ensuring that the forecasts also reflect those changes. 

Explore how Drivetrain can enable you to refine your sales forecasting process and develop more accurate pipeline-based forecasts.

Screenshot showing how Drivetrain makes accurately forecasting sales automatic and easy.

Frequently asked questions

What are the two main methods of pipeline-based forecasting?

Qualitative and quantitative. Both play an important role in forecasting your pipeline. While quantitative forecasting just uses a few formulas, qualitative forecasting requires experience and making judgments.

How to create a pipeline forecast?

To create a pipeline-based forecast, calculate the estimated value of your pipeline. You can do this using probability-weighted values of deals across all stages of your pipeline. The probability values here are your historical win rates.

How can historical win rates help me improve my sales forecast?

Using win rate data can help you calibrate your current assumptions about how many opportunities in your current pipeline you can actually close based on quantitative data. This can help correct for the over-optimistic assumptions sales teams often fall victim to.

In addition, historical win rates can also help you:

  • Identify and address gaps in sales training that may be impacting your sales team’s success.
  • Optimize your marketing spend by identifying the best performing segments in your market.  
What is the win rate formula?

The sales win rate equals the number of deals closed won divided by the sum of the deals closed won and deals closed lost:

Sales win rate equals the number of deals closed won divided by the sum of the deals closed won and deals closed lost.
The sales win rate formula.

You might also like...

Ready to start your journey?
Book a Demo
The only financial model template you'll ever need—just plug in your actuals to see projections
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.