Pipeline Coverage Ratio: How to Calculate the Right Target

Use this simple formula on the opportunities that could close in the period:

1. Take the target you still need. Use quota or bookings goal minus what's already closed. Say your quarterly goal is $600,000 and you've closed $150,000, leaving $450,000.
2. Add up open, qualified pipeline whose expected close date falls inside the period. Say that's $1,350,000.
3. Divide pipeline by the remaining target. Here, that's three to one.
4. Compare it with the target ratio for your business (next section).

Measure at a fixed point each week, such as Monday morning, so you can watch the ratio change as the quarter runs. Track it by team and by segment as well as in total, because a healthy total can hide a weak segment.

The required ratio is the reverse of your win rate. If you win one in four qualified opportunities, you need about four times your target in pipeline. If you win one in five, you need about five times.

The average B2B new-logo win rate is 19 percent¹, which points to needing roughly five times the target in pipeline for new business. Your own number matters more. Pull the last four quarters of closed opportunities, count wins divided by all closed (won plus lost), and use that rate.

Use different rates for different work. Enterprise deals often convert at lower rates than small, fast deals, so they need higher coverage. Renewals and expansion usually convert higher, so they need less. Setting one blended target for all of them will leave you over-covered in one place and under-covered in another. For more on segments, see managing coverage ratios by deal size.

Coverage only counts pipeline that can close in the period. The average new-business sales cycle is 91 days², so a new-business deal created today closes, on average, about a quarter from now.

Two practical checks follow from that:

• Exclude deals whose close date is unrealistic. An opportunity created last week with a close date at month-end belongs in the next period unless your cycle is short.
• Look at pipeline creation as a leading indicator. With a long cycle, the pipeline you create this month decides next quarter's coverage. If creation is falling now, coverage will fall later even if today's ratio looks fine.

For example, if you typically need a full quarter of lead time and today's pipeline creation is half of last quarter's, expect a gap two quarters from now.

A ratio can look healthy while the forecast is at risk. Watch for:

• Counting unqualified opportunities. Only include deals that passed your qualification stage. Early-stage leads inflate the number.
• Keeping stale deals open. Opportunities with no activity for months still count in the CRM. Clean them out before you calculate.
• Ignoring stage. A dollar at the proposal stage is worth more than a dollar at discovery. Some teams weight pipeline by stage probability as a second view.
• Using a rule of thumb. A ratio borrowed from another company's win rate tells you little about yours.
• Measuring only the total. One large deal can carry coverage while the rest of the pipeline is thin. Check how much of the pipeline sits in your five largest deals.

Compare current coverage with your target and act on the gap:

• Below target early in the period: increase pipeline generation now, since new pipeline takes a full cycle to mature.
• Below target late in the period: focus on conversion and deal acceleration, since new pipeline won't close in time. Look for ways to shorten cycles, such as involving the decision maker earlier.
• Above target but missing forecast: look at quality. Check qualification standards, stalled stages and win rate by source.

Forecasting tools such as Clari can track coverage and deal health as the period runs, and a CRM such as Close can report opportunity conversion rates on its own data. Either way, your leadership view should show coverage by segment and week, as covered in pipeline coverage dashboards.