What it means
In business planning, you rarely win every deal you pursue. The pipeline coverage ratio helps you measure whether your sales team is working on enough potential deals to absorb the inevitable losses and still reach the finish line.
If your sales target is $1,000,000 and your team is currently pursuing $2,000,000 worth of potential deals, your coverage ratio is 2 to 1. This means you need to win half of your pipeline to hit your target, which is usually unrealistic.
Most businesses aim for a coverage ratio between 3 and 4 to 1, depending on their historical win rate. If your win rate is 25%, you generally need four times your target in the pipeline to feel secure.
Monitoring this metric helps you spot trouble early. If the ratio drops too low, you know immediately that you need to generate more leads or close deals faster.
On the flip side, a very high ratio might seem great, but it can sometimes hide poor data quality, where reps keep dead leads in the system, making the pipeline look much healthier than it actually is. Finance teams use this ratio alongside historical conversion rates to forecast future cash flow and plan operating expenses safely.
Think of it like casting a wide net when fishing. If you need to catch ten fish to feed your family, and you only drop a small hook for ten fish, you might catch nothing.
But if you use a large net that could catch forty fish, you give yourself a much better chance.
In practice
Real-world examples
Example 1
A software startup needs to make $500,000 in sales this quarter. Their CRM shows $1,500,000 in active deals, giving them a healthy 3 to 1 pipeline coverage ratio. The sales lead still checks that every deal in the report has had contact in the last 30 days.
Example 2
A manufacturing SME targets $2,000,000 for the year. Their current sales pipeline stands at only $2,500,000, resulting in a risky 1.25 coverage ratio that flags an urgent need for new leads. The finance team warns the board that revenue could fall well short without action.
Example 3
A boutique design agency with a 40% win rate has a target of $200,000. They maintain $800,000 in active proposals, achieving a 4 to 1 coverage ratio. Because 4x is more than the 2.5x their win rate requires, the owner feels able to turn down two low-margin projects.
Think of it
Think of it like casting a wide net when fishing. If you need to catch ten fish to feed your family, and you only drop a small hook for ten fish, you might catch nothing. But if you use a large net that could catch forty fish, you give yourself a much better chance.
Formula
Calculation
Pipeline Coverage Ratio = Total Value of Sales Pipeline / Sales Target. For example, if your sales target is $250,000 and the total value of all deals currently in your sales funnel is $750,000, your calculation is 750,000 divided by 250,000, which equals 3. This gives you a coverage ratio of 3x.
To judge whether 3x is enough, compare it with the ratio your win rate requires: Required Coverage = 1 / Win Rate. At a 25% win rate, 1 / 0.25 = 4x is needed, so $750,000 of pipeline would be short of safe. At a 40% win rate, 1 / 0.40 = 2.5x, so the same $750,000 would be comfortable. Expected revenue at a 25% win rate is $750,000 x 0.25 = $187,500, which is $62,500 short of the $250,000 target.Case study
Seen in the real world
This is a fictional, illustrative scenario. BrightWeb Solutions, a growing digital agency, set a challenging revenue target of $1,000,000 for the financial year. Historically, the agency closed about one in every four deals it pitched, meaning their average win rate was 25%. At the start of the second quarter, the finance director reviewed the sales report and noticed the total pipeline value sat at $1,200,000. This translated to a pipeline coverage ratio of 1.2 to 1.
Realising this was far too low for their 25% win rate, the director raised the alarm. Based on their conversion rate, they actually needed $4,000,000 in the pipeline to safely hit their $1,000,000 target. Management immediately redirected marketing funds into lead generation campaigns and incentivised the sales team to accelerate pending proposals. Over the next six weeks, the team added $2,000,000 of qualified prospects to the funnel, bringing the ratio up to a safer 3.2 to 1. By keeping a close eye on this metric, BrightWeb avoided a major revenue shortfall and successfully hit their annual target.
The expected value of the pipeline shows why the change mattered. At the start, $1,200,000 x 25% = $300,000 of expected wins, only a third of the target. After the additions, $3,200,000 x 25% = $800,000, much closer to the goal, and further wins came from the faster-moving deals.
Watch out
Common mistakes
- Including dead or lost deals in the pipeline value, which artificially inflates the ratio.
- Using a one size fits all ratio instead of basing it on your actual historical win rates.
- Failing to update deal stages and values regularly, leading to inaccurate forecasting.
Questions
People also ask
What is a good pipeline coverage ratio?
A ratio between three to one and four to one is standard for most businesses, though it depends heavily on your historical win rate.
How often should I check this ratio?
Most companies review their pipeline coverage weekly or monthly to catch potential shortfalls before the quarter ends.
What should I do if my ratio is too low?
You need to either increase marketing efforts to generate more leads, or find ways to improve your sales team's win rate.