Accurate sales forecasting

Accurate sales forecasting

February 14, 2018

No company can perfectly predict how much revenue they will make in a given month, quarter or fiscal year just like no meteorologist can perfectly predict the weather. There are simply too many variables to consider. But perfection is not the goal. Forecasting is about getting close enough to make good decisions.

So how do you start to forecast when there are so many moving parts? Neil Ryland, CRO at Peakon and previously at Huddle, found out the hard way when his team’s estimates were off by 40 percent. Ryland asked himself how the company could get its sales forecast so wrong and started to develop a new model. Here's how it evolved.

Deal forecasting methodology

Often sales forecasting can feel like a guessing game but the deal forecasting methodology is based on hard numbers. And it’s simple. Write down the deals you expect to close and tally up the sales revenue. That’s it — and at small organizations it works well. There’s very little admin overhead and it gets your sales team in the habit of clearly keeping track of future wins.

The problem with this model is that you’ll quickly run into limitations if you want to forecast beyond your average sales cycle. For example, if your sales cycle is 30 days, it's impossible to forecast the following month as those respective opportunities wouldn't have been created. Seeing this first-hand, Ryland realized he needed a different model if he was going to forecast past 30 days.

Weighted forecasting

When you start looking for more advanced sales forecast methods, you’ll run into weighted forecasting (or Opportunity Stage Forecasting). This involves taking a deal, and based on its pipeline stage, assign it a probability to close. For example all deals in stage 4 in a 5-stage system may have a 75% chance to close.

Ryland and his sales reps collaborated to build out a clear sales pipeline that included BANT and the typical steps to close a deal. Then, using historical sales data, he gave each stage a closed won probability.

The final model looked like this:


Huddle’s sales managers could weigh each deal according to the pipeline stage it was in and forecast from opportunities created.

This model is perfect as you start scaling up and have reps juggling 8-12 deals a month. You’ll need to make sure reps are disciplined and educated in determining the stage of a deal.

Category forecasting / predictive model

One of the problems with the weighted forecasting model is that it requires a decent amount of time and energy to be effective and doesn’t account for how a representative is feeling about a deal.

A solution to this, at least for Huddle, was adding a field in Salesforce that was required for the representative to express more than just hard data. Reps had to mark whether the deal was:

1. Commitment - there is verbal or written intent to sign

2. Upside - the deal is likely to close

3. Pipeline - no clear understanding of decision-making process

Combining this with the weighted data was a game-changer: it meant representatives needed to follow a sales process which forced a higher forecast accuracy and included data from the rep working the deal.

Later, Ryland moved on to Peakon and iterated on this model further to weigh leads individually rather than by a probability attached to each pipeline stage. Each lead was assigned a unique close probability based on historical conversion rates of similar leads.

Data points like the opportunity’s age, vertical and company size meant they were able to better determine if an incoming lead could have a good business match and subsequently a higher chance of closing.

data points for sales forecasting

The reality

All sales forecasting methods involve educated guesswork, and it’s important to remember that. There are too many variables to consider and outside factors which can influence your business in ways that are impossible to predict. The goal is not to have a perfect model, but rather have a way to make predictable, informed decisions in a repeatable manner.

For more about these prediction models, each of their pros and cons, and how to implement them in your business grab a copy of our free e-book Data-Driven Sales and jump into chapter five today.

The 4 rules for sending cold email that converts

Salesby Guillaume Cabane on January 01, 2021

Guest post by Guillaume Cabane, ex-VP of Growth at Drift [] and co-founder of HyperGrowth Partners [] The days of “spray and pray” email are over. Just consider these statistics: The average cold email response rate is 1%, which means for every 100 people you email, you’re getting through to one person (and probably bothering the other 99). Meanwhile, the average success rate of an email phishing attack is 0.1%, which really isn’t that much

Automate data-driven alerts for B2B sales and success

Salesby Bradley Gula on June 03, 2020

Instead of reviewing accounts one-by-one, what if reps could get a heads-up about key intent signals throughout the buying and customer journeys? And what if they knew who's most important to contact, when, and why?

Join our newsletter

Engaging stories and exclusive data, designed for our best customers. One useful issue each month.