We’re not in normal times right now. Your sales forecast and previous funnel models are going to be wrong. You need to pressure test every deal in your CRM. You need to test your model.
How do you plan for next quarter? In normal times, you’ll hear sales leaders talk about needing 4X sales pipeline coverage, or is it 3X coverage, or is it 2X coverage for just the gap?
But what do they actually mean when they say it? And how can a sales pipeline coverage model help you when the market is changing?
In a quick poll, most people I talked to simply use a sales pipeline coverage formula of target * 4. But that’s not the best way to do it. In this post, I want to break down what sales pipeline coverage is, how to calculate it using a sales pipeline coverage formula, and how it can be the early indicator that your business is changing (for better or worse).
There are 4 key metrics to build your sales pipeline coverage model around, which if you tweak any one of them, your projected revenue number goes up or down. These metrics should be considered for each segment or vertical in your market (i.e. SMB, Mid-Market, Enterprise, Channel).
If you improve any one of them your sales pipeline coverage changes. You can (and should) build your entire financial model off these numbers. Watching these numbers is the first indicator of your business changing and increasing risk to the model.
To calculate sales pipeline coverage, work down your funnel, adding each stage’s output to the next stages opening calculation:
First Stage N = If stage velocity is within close period[(Volume * Value) * Conversion]
Every other stage = N + If stage velocity is within close period[(Volume * Value) * Conversion]
A common misconception is that sales pipeline coverage, weighted pipeline, and forecasts are the same. They are not.
You should always model with one, but relying on a mathematical model for your forecast requires you to get your house in order. There are two things that will make coverage predictive:
Consistency vs volatility in your performance
CRM hygiene
If you have a consistent funnel (month over month or quarter over quarter performance) in terms of deal size, velocity, and conversion rates, it’s fairly straightforward. Make sure you segment it by the categories that create different value or velocity (i.e. mid-market vs enterprise, or government vs tech)
If you have inconsistent funnel performance (deal sizes swing wildly, conversion rates are unpredictable) you’re not going to be able to create an accurate coverage model. Aim for 4x, and then drill into why your funnel is inconsistent to create your company’s sales pipeline coverage model.
Here’s the thing, CRM hygiene – deal hygiene to be specific – is the number one thing that will make or break your model.
If your reps aren’t keeping Salesforce up to date, how do you know what’s real or what’s fake? Your sales pipeline coverage number could balloon by 30-50% because of zombie pipeline. Over the long term, requiring a high sales pipeline coverage ratio to make your number indicates bad system design and bad process enforcement.
Start with the Deal Health System (free ebook).
Weighted pipeline can be effective at scale, but I think the added work of coverage modelling gives you a more accurate picture. Here’s an issue that happens, particularly in smaller organizations:
This could come out in the wash if your sales pipeline is large enough (blending by volume) or segmented well (weighted pipeline calculated by segment), but it is still very fuzzy math.
If you’re using a weighted pipeline formula, you should design your model by using win rate from stage using recent conversion rates. For example, if Stage 1 is weighted at 10% probability, but your win rate from that stage is 7%, it’s going to dramatically skew your numbers. Since stage probabilities in Salesforce aren’t segment based, it’s going to skew the math.
Another method to get around this is to compare your conversion rates between count moved to next stage and dollars moved to next stage.
Lastly, sales velocity is another popular metric, and it’s useful for comparing reps across segments, but again it relies so much on deal hygiene that it can be very unreliable in practice.
Total sales pipeline coverage looks at the coverage number compared to your target number. This is useful for planning, and particularly useful for longer sales cycles for evaluating the health of future quarters that need to be set months in advance.
Gap coverage looks at the coverage number compared your target number, minus your closed won number. Gap coverage is very useful for in-month and in-quarter comparisons to the forecast, and particularly for high velocity sales cycles at any point in time.
We use both, in addition to a sales forecast model, when managing our own business.
Coverage modelling is a useful exercise because you can tweak your core metrics of volume, value, velocity, and conversion:
This will help you be prepared, and it will help you understand when you are coming out of the crisis – because the numbers will change once again.
Yes and no.
A sales pipeline coverage ratio of 4x is a great guideline for your team, but using it to manage individual contributors will set you up for failure. If reps feel they need to always keep a certain sales pipeline coverage ratio – lets say at 4x – at all times to keep their manager off their back, they will end up keeping bad deals open. They will play kick the can down the road, and you will have zombie pipeline in no time.
This is why you need to develop good habits with your team to keep good CRM hygiene.
Find the truth in your pipeline, face the scary reality of a shortfall, and then do something about it.