Sales prospecting

6 steps and 6 indicators to build good sales forecasts

Reliable sales forecasts rely on data rather than on reps' gut feeling. You first standardize the stages of the sales funnel, calculate the historical conversion rate of each one, then track six indicators per opportunity: stage, age, potential, actions taken, prospect engagement and estimated closing date.

Maxime Ben Bouaziz
CEO Salesdorado
September 16, 2020, updated November 16, 2026, 7 min read
Main qui coche au stylo une liste de tâches dans un carnet à petits carreaux
★ CE QU'IL FAUT RETENIR
  • Funnel stages are defined by the customer’s buying process, not by the sales process.
  • The historical conversion rates of each stage are the basis for calculating the forecast.
  • An opportunity 2 or 3 times longer than the average sales cycle is « at risk ».
  • No activity over the last 2 weeks while a close is planned this month: the opportunity is in danger. Same if its close date is pushed back several times.
  • Forecast meeting every week, pipeline review meeting held separately and less often.

Here are the key steps to build solid sales forecasts based on objective & quantitative data.

Whatever stage opportunities have reached in the sales funnel, sales reps and managers are asked to make a qualitative assessment of their opportunities. It’s an approach that relies mostly on gut feeling. Relying on hard data limits several major biases.

6 steps to build good sales forecasts

1. Standardize your sales funnel

To build more accurate sales forecasts, the first thing to do is to define the different stages of your sales funnel as objectively as possible.

Start with a clearly defined sales process and formal definitions of each stage of the sales funnel. Stage definitions must be driven by the buying process, not the sales process: even if the rep does everything right, their stages don’t reflect the customer’s likelihood to buy.

You need to define and document all your sales processes to make sure the sales team has a firm grasp of the qualification rules, your sales system and the different stages an opportunity must go through to close.

sales forecasts funnel

Source: insightsquared.com

The stages must cover the entire sales funnel, from “New” to “Lost/Won”. You shouldn’t have any opportunity that isn’t in one of the stages. They must be distinct enough that you never see two stages happen at the same time; otherwise, there isn’t enough differentiation between them to be meaningful.

By defining these stages, you’ll be able to measure the percentage of opportunities that reach the “Lost/Won” phase. You can access this information in most good CRM software.

2. Calculate your historical conversion rates at each stage of your sales funnel

You need to know the historical conversion rates of your sales stages to get effective, objective sales forecasts.

Figure 2 below shows a sales funnel with the conversion rates from one stage to the next. It helps the sales manager understand the nuances of pipeline value, how it changes over time and the most important stage where the teams should focus their efforts.

For example, in figure 2 below, only 31% of all opportunities go from stage 1 to “Deal”, while 84% of stage 4 opportunities will turn into a Deal for your organization. Studying the history of your sales funnel accurately is a key first step to understand your team’s performance in the short and long term.

sales forecasts conversion

Source: insightsquared.com

With this information, you can quickly move from estimating which opportunities will close to a more accurate forecast of each opportunity’s value based on size, rep and stage. These historical win rates let you estimate the value of a deal more realistically, based on track record.

Going furtherOnce you’ve defined these different stages of the conversion funnel by following the customer journey, you can look at the sales process that moves each prospect from one stage to the next, to optimize these conversion rates. If it isn’t formalized, make a point of formalizing it. For example: 3 emails & one call after a product demo. Beyond that, the opportunity is lost.

You can start by doing this at the level of a whole team, then segment gradually. By region for example, down to the level of each rep to optimize their performance.

3. Define the key indicators that drive your sales forecasts

The data-driven forecasting method looks at the conversion rates at each stage and simply multiplies opportunity values by those rates. It’s more mathematical, but it doesn’t account for the nuances in your pipeline. Your team must also factor in your conversion rate from start to finish, or per opportunity.

4. Require estimated closing dates & track date changes

Most CRMs have a “Close date” field that lets your reps enter their own forecast of when a deal will close. Look for cases where the close date doesn’t match the data (current stage + sales cycle from that stage).

Sit down with your rep and talk it through to find out what’s going on. Even if your whole organization loves numbers, you can’t ignore all the subjective data your rep gathers throughout the process.

Require accurate, up-to-date data from your reps and hold them accountable for all their opportunities. All the forecasting tools in the world can’t help you make correct forecasts if you don’t have reliable data to analyze.

5. Know how accurate your reps’ forecasts are

Past performance is a leading indicator of future performance. By knowing the historical accuracy and performance of each of your reps, you can guide them and help them adjust their forecasts for better accuracy, based on the profile of their current deals and their historical data.

6. Separate your forecast meetings & your sales pipeline review meetings

Successful sales directors must tell the difference between sales pipeline review meetings and sales forecast meetings. Although both are meant to track sales, key indicators and strategy, each must have its own distinct goal and focus.

Pipeline review meetings aim to make sure there are enough leads at each stage of the sales funnel. They’re often less frequent than forecast meetings, since they deal with internal processes, not the customer.

Sales forecast meetings should take place every week, ideally on Monday, and during this meeting a sales director should inspect each deal (especially at the bottom of the funnel) and help reps close the deals in progress.

6 indicators to track for effective sales forecasts

1. Sales funnel stage

Look at which stage your opportunity is in. Based on what we covered earlier, you should now know which conversion rate applies to each stage and have a clear idea of the likelihood of turning the opportunity into a deal at that stage. Watch leads that make little or no progress in your sales cycle, as it’s a sign that this opportunity could be missed. If things traditionally go well, leads move faster and faster through your sales funnel.

2. Opportunity age

You probably have a number of opportunities that are no longer relevant and should have been removed from your database. If the opportunity is 2 or 3 times longer than your typical average sales cycle, your opportunity is “at risk”. Sales directors must know their sales cycle and look at how long a successful opportunity stays at each stage, then compare it to their current opportunities.

If successful leads usually go through the first stage in just a few days and your current pipeline stretches over a month on average, it’s a clear sign that you need to remove these opportunities that are no longer relevant. In your forecast meeting, you can now have that objective conversation with your rep.

3. Opportunity potential

Salespeople usually focus on big deals and sometimes lack objectivity because they’re drawn to the prospect of a big sale. As a result, most organizations waste time on big opportunities that were never realistic to begin with.

Effective managers must review their win/loss analysis, then look at win rates for large opportunities. There’s usually a wide gap between these two figures, which is why you should discuss these large or high-potential opportunities in forecast meetings and ask each rep for more objective data on why they think they’ll close.

4. Sales actions taken

Know how much effort has gone into a lead: this can be measured by tracking the activities your reps must log in your CRM. You should also apply some of the principles of “activity-based costing” and weigh some of your activities as more effective and more impactful than others: a product demo or trial would mean far more than a simple cold call.

If a lot of effort or activity has been invested in a lead, it has a better chance of closing, but it’s important to check the “quality” or type of activity and not just the “quantity”.

5. Prospect engagement

By looking at the tasks or activities carried out on the lead over the last 2 weeks (or 10 business days), you’ll know whether it has stalled or not. If there’s no activity and it’s scheduled to close this month, it’s a sign that the opportunity is in danger. If you traditionally have a longer sales cycle, adjust this threshold based on your historical data, but keep watching for drops in engagement.

6. Estimated closing date

When you review opportunities, if you see that the close date of a deal or opportunity is pushed back several times, the opportunity is in danger. Another obstacle to accurate sales forecasts, lead slippage should be a key indicator of stalled opportunities.

Going furtherFeel free to draw on the resources below to optimize your sales processes

The questions we get over and over.

How do you define sales funnel stages for a sales forecast?

Based on the buying process, not the sales process. The stages must cover the whole funnel, from "New" to "Lost/Won", with no opportunity outside a stage, and be distinct enough that two stages never happen at the same time.

How do you use historical conversion rates in a forecast?

The data-driven forecasting method looks at the conversion rates at each stage and multiplies opportunity values by those rates. In the article's example, 31% of opportunities go from stage 1 to the deal, against 84% of those at stage 4.

When is an opportunity at risk?

When it is 2 or 3 times longer than the average sales cycle, when there has been no activity over the last 2 weeks while a close is planned this month, or when its close date is pushed back several times.

What's the difference between a forecast meeting and a pipeline review meeting?

The pipeline review meeting checks that there are enough leads at each stage of the funnel; it happens less often. The forecast meeting takes place every week, ideally on Monday: the sales director inspects each deal there, especially at the bottom of the funnel, and helps reps close.

★ The conversation, 0 comments

What the community says.

Basic Markdown, moderated within 24 h
Loading…

    Read next