Pipeline coverage calculator: The ratio you need from your own win rate and slippage

Pipeline coverage is qualified pipeline divided by the revenue target for the same period, and the ratio you need is 1 / (win rate x (1 minus slip rate)). A 25% win rate with no slippage needs 4x coverage. Add a 20% slip rate and the requirement rises to 5.0x. The calculator takes five inputs and returns required coverage, required pipeline, current coverage and the pipeline gap.

How much pipeline coverage do you need

Pipeline coverage is qualified pipeline divided by the revenue target for the same period. The formula, as vonlabs.ai writes it: Qualified pipeline value ÷ Revenue target for the same period. Two conditions decide whether the result means anything. The pipeline and the target cover the same dates, and only deals that pass your qualification bar count.

The ratio you need is a separate number, and it comes from your own conversion history. HubSpot says most successful sales organizations keep 3:1 to 5:1. But a flat 3x only works for teams that win about one deal in three. The base rule is to divide 1 by your win rate. A 25% win rate needs 4x coverage, and a 40% win rate needs 2.5x.

Miss that rule and a healthy-looking ratio hides a gap. A team with a 25% win rate and 3x coverage should expect about $375K against a $500K target, a 25% shortfall. Lative reports a Landbase 2026 analysis that put the average B2B win rate at 21% across all opportunities and 29% for qualified pipeline. At 29%, the base rule gives 1 ÷ 0.29, about 3.45x.

Add slippage

Win rate alone assumes every qualified deal closes or dies inside the period. Some move out instead, and HubSpot notes that higher ratios give more buffer against deal slippage. We fold that in directly. Define slip rate as the share of qualified pipeline dollars dated to the period that end the period still open with a later close date. Measure win rate and slip rate on the same population as the pipeline you count.

Our formula: required coverage = 1 ÷ (win rate × (1 − slip rate)).

To turn that pipeline figure into opportunity and lead counts by stage, run it through the reverse funnel calculator and check your stage rates against our funnel conversion benchmarks.

The rest of this page builds on three figures from your own data: qualified pipeline for the period, win rate on that same pipeline, and slip rate.

How to calculate pipeline coverage, with every input defined

The basic ratio, covered above, divides qualified pipeline value by the revenue target for the same period. Read the other way, it tells you what share of pipeline value has to close. At a ratio of 3, you need to close 33% of the pipeline's value to make the number. At a ratio of one or less, you don't have enough funnel to meet your revenue goal. Not even if you win every deal.

Required coverage = 1 ÷ (win rate × (1 − slip rate))

Win rate tells you how much pipeline converts. Slip rate tells you how much of it closes in a later period than planned. Both shrink what lands in this period, so both raise the coverage you need.

The inputs

Two definitions decide whether the inputs hold. Win rate can be the total amount of bookings you close, per dollar of pipeline you open. Or you could measure it as the number of deals you close divided by the number of opportunities you create. Pick one and keep it. Then use a win rate calculated on the same population as your pipeline. For pipeline in hand, apply a stale rule: Clari suggests discounting or removing deals that have been open more than twice your average sales cycle.

Netting closed deals out of the target matters mid-period. Partway through the year, when you already have many won deals, you need to carefully compare the remaining quota with open deals that are well-advanced in the buying process.

Worked example

Required coverage is 1 ÷ (0.25 × 0.80) = 1 ÷ 0.20 = 5.0x. Against the $500K remaining, the team needs $2.5M of qualified pipeline. It holds $1.8M, which is 3.6x current coverage. The gap is $700K of pipeline, created early enough in the quarter to close.

Without the slip term, the same team would aim for 4.0x and need $2.0M. The slip rate alone adds $500K to the requirement.

What the calculator does

The Take the Market calculator takes five inputs: the revenue target, the period, pipeline already in hand, win rate and slip rate. It returns four figures: required coverage, required pipeline in dollars, current coverage, and the pipeline gap. To turn that gap into opportunity and lead counts by stage, carry it into the reverse funnel calculator.

Is 3x pipeline coverage enough

A flat 3x rests on two assumptions at once: the one-in-three win rate covered above, and a pipeline where every deal closes inside the period. If either assumption breaks, 3x stops matching the target. In our reading, slippage is the share of pipeline value whose close date moves out of the period, and it is the input most teams leave out of the formula.

Required coverage rises at every win rate as the share of pipeline that slips goes from 0 to 30 percent, and it rises fastest at the lowest win rates.

The adjusted formula is our method: required coverage = 1 ÷ (win rate × (1 − slip rate)). A deal that slips is not lost. It still cannot count toward this period's number, so it comes out of the pipeline before the win rate applies.

Read down the 20 percent column. At a 40 percent win rate, the requirement rises to 3.1x, just above the rule of thumb. At 30 percent it is 4.2x. At 25 percent it is 5.0x, and at 15 percent it reaches 8.3x.

Worked example: 25 percent win rate, 3x coverage, 20 percent slippage

The no-slippage shortfall at this win rate came earlier. With slippage added, the gap widens.

1. Required coverage from the table: 5.0x.
2. Coverage the team holds: 3.0x.
3. Expected attainment: 3.0 ÷ 5.0 = 60 percent of target.
4. Gap: 40 percent of target, which takes 2.0x of additional pipeline (5.0 − 3.0) to close.

HubSpot describes the same risk from the other side: when coverage falls below 3:1, even minor deal delays can derail quarterly results. In our reading, the table shows that delays raise the bar even for teams sitting at 3x.

How to measure your own slip rate

1. Take the pipeline value with close dates in the period, as it stood on day one of each of the last several quarters.
2. For each quarter, sum the value whose close date moved past the period end, whether the deal was won later, lost later or is still open.
3. Divide that sum by the day-one pipeline value.
4. Use the median across quarters, not the best quarter.

Then find your row and column in the table, or run the numbers through the reverse funnel calculator to turn required coverage into the pipeline you need to create.

How slippage changes the ratio

Slippage is pipeline that is dated to close this period but closes in a later one, or not at all on schedule. It does not lose, so it never shows up in your win rate. It simply leaves. HubSpot notes that low coverage leaves teams exposed when deals "extend beyond expected timelines." The earlier point about higher ratios buffering slippage is the reason the ratio has to rise with your slip rate.

Define slip rate as a measured share

We define slip rate as the value of pipeline dated to close in a period at the start of that period, whose close date had moved past the period's end by the time it ended, divided by the total value dated to close in that period at the start. In our reading, measure it in dollars, not deal counts, because a few large deals often account for most of the slip.

Pull it from snapshots, not the live pipeline. Take the pipeline dated to close in the period as it stood on the period's first day, then check where those same deals sat on the last day. Average several past periods so one bad quarter does not set the number.

Remove slipped pipeline before you divide

Slipped deals inflate the numerator. GSP Solutions warns that the pipeline may contain "deals that slipped from previous periods and have seen little change in their likelihood of closing successfully," which overstates coverage. So strip out the share you expect to slip, then apply the win rate to what stays.

The formula is: required coverage = 1 ÷ (win rate × (1 − slip rate)).

Use a win rate calculated only on deals that closed won or lost in the period. If slipped deals sit in that win rate's denominator, you count slippage twice.

Worked example: 25% win rate, $500K target

With no slip, 1 ÷ 0.25 = 4.0x, or $2.0M of pipeline. Each row below keeps the win rate fixed and changes only the slip rate.

Now run it the other way. A team reports $2.0M against $500K, so 4.0x on paper. With a 20% slip rate, $400K moves out, leaving $1.6M, or 3.2x. At a 25% win rate that $1.6M yields about $400K, a $100K gap the headline ratio hid.

In our reading, slippage raises the requirement faster than many teams expect: a 30% slip rate adds more coverage than moving from a 25% to a 20% win rate. Feed the adjusted ratio, not the raw one, into the reverse funnel calculator when you set pipeline creation targets.

Worked example for a $1,500,000 quarter

Here is one quarter run end to end, using the formula from the earlier sections with both win rate and slippage applied. The inputs are illustrative. Swap in your own and every row recalculates the same way.

In this example, the quarter needs $7,500,000 of pipeline, $4,000,000 is already in hand, and $3,500,000 is left to create.

The new bookings target is $1,500,000. Treat it as the remaining target: whatever the quarter's number is, minus closed-won to date. Coverage only has to carry the dollars still open.

Reading the rows

Slippage takes the 25% win rate down to an effective 20%, because only 80% of the pipeline stays in the quarter. One divided by 0.20 gives 5.0x. Multiply $1,500,000 by 5.0 and you get $7,500,000 of pipeline needed.

The team holds $4,000,000 of qualified pipeline. That leaves $3,500,000 to create. At a $50,000 average deal, that comes to 70 new opportunities. Those opportunities still have to be opened early enough to run the full sales cycle inside the quarter.

The win rate alone would point to 4x. The extra 1x of coverage is the price of the slippage.

Template for your own quarter

Copy these rows into a sheet and fill them top to bottom:

1. Quarter target: new bookings for the period.
2. Closed-won to date: bookings already signed this quarter.
3. Remaining target: row 1 minus row 2.
4. Win rate: measured on the same population as the pipeline you count.
5. Slip rate: share of in-quarter pipeline that historically moved to a later period.
6. Required coverage: 1 / (row 4 x (1 minus row 5)).
7. Pipeline needed: row 3 x row 6.
8. Qualified pipeline in hand: open, qualified, dated to close this quarter, with stale deals removed.
9. Gap to create: row 7 minus row 8. If the result is negative, there is no gap.
10. Average deal size: from closed-won deals in a comparable period.
11. New opportunities needed: row 9 / row 10, rounded up.

Row 11 is where the handoff to marketing happens. Run it back through stage conversion rates in the reverse funnel calculator to get the leads and meetings that the opportunity count implies.

How often to rerun it

Bigtincan advises measuring coverage "for both the current and future periods at least every week." The same source says reps with weak coverage need their energy "directed at the top of the sales funnel." In our reading, a positive row 9 is the signal to make that shift, and the earlier in the quarter it shows up, the more of the 70 opportunities can still close in time.

Weighted versus unweighted pipeline coverage

Unweighted coverage treats every open dollar the same. Weighted coverage does not. DealHub defines a weighted pipeline as a forecasting method that assigns a probability of closing to each deal based on its stage, so each deal counts at its value times that probability.

The arithmetic per deal is simple. In GSP Solutions' example, a $50,000 opportunity at 25% probability carries a weighted value of $12,500. Sum that across every open deal and you have the weighted pipeline.

HubSpot's forecast tool, for instance, uses deal stages to forecast revenue based on a deal's likelihood to close.

GSP Solutions names the core flaw of the unweighted ratio: it takes no account of opportunity stages or the customer buying cycle. Its stage example puts a deal in the negotiation stage at 90%, while deals at the Prospecting or Qualification Stages may be at 10 or 20 percent. A dollar at the qualification stage and a dollar at negotiation are not the same dollar.

Why the weighted target sits near 1x

Weighting has already applied the win probability, so you do not divide by win rate a second time. A weighted pipeline equal to the remaining target means the expected outcome is the target. Anything above 1x is buffer. Asking for 3x weighted would, in our reading, double count the risk.

Take GSP Solutions' quarter: the Target for the quarter is $100,000, and we have $40,000 in won revenue, and the weighted pipeline is $70,000.

1. Remaining target: $100,000 minus $40,000 equals $60,000.
2. Weighted coverage: $70,000 divided by $60,000 equals 1.17x.
3. Read it: expected revenue clears the target with $10,000 of buffer.

The method depends on the weights. DealHub lists two conditions where weighting should not be used: when there is not reliable data available to assign weights and when the sales funnel changes frequently. We suggest setting each stage probability from your own historical stage-to-close rates, which you can check against funnel conversion benchmarks, and running both ratios side by side in the reverse funnel calculator. In our reading, if the two disagree sharply, the stage mix is the reason.

Where the inputs come from

Every input in the coverage formula already sits in your customer relationship management (CRM) system. The work is pulling each one the same way every time, from the same population of deals.

Count or value

Pull both, then use the one that matches how you set the target. Suppose 40 opportunities closed over the last four quarters, 10 of them won. By count that is 25%, so 4x coverage. When your target is a dollar number and your large deals lose more often, the count rate understates the pipeline you need.

Slip rate from close-date history

Turn on field history tracking for the close date if it is off. For each of the past four quarters, take the deals forecast to close in that quarter at its start and count how many ended it with a later close date. If 42 of 120 moved, your slip rate is 35%. Use the average across quarters, not your one bad quarter.

The qualification bar

Write down the stage that counts as pipeline and apply it to both the win rate and the coverage sum. Ebsta's 2024 report described top performers as reps who, rather than creating opportunities in hope, disqualify them early. A stage bar that admits unqualified deals inflates coverage and deflates win rate at the same time.

How often to recalculate

Forecastio suggests weekly or monthly tracking of coverage itself. We recalculate the inputs, win rate and slip rate, once a quarter on a rolling four-quarter window, and sooner after a pricing change, a new segment or a change to stage definitions.

Common coverage mistakes and when coverage is the wrong number to manage

Blending causes a blind spot: Lative's example is an enterprise ratio of 4x hiding a mid-market ratio of 1.8x.

The fixed 3x target has a history. Lative traces the rule to an era when B2B win rates averaged around 33%, and cites a Landbase 2026 analysis putting the average B2B win rate at 21% across all opportunities and 29% for qualified pipeline.

When coverage is the wrong number to manage

Pipeline creation rate. Coverage is a snapshot. Lative notes that a 3.2x ratio at quarter start that declines to 2.1x by week six was a miss visible at week three. If coverage is falling, manage weekly new pipeline created against the amount the reverse funnel calculator says you need.

Win rate. When the required ratio climbs past what your team can realistically source, we think the cheaper lever is conversion. Compare stage conversion against funnel conversion benchmarks before adding volume.

Target realism. Lative argues the target should reflect productive capacity, not a top-down number. When the target fails that test, no coverage ratio fixes it. On Ebsta's podcast, Pavilion founder Sam Jacobs said CROs should challenge aggressive goals through mathematical analysis rather than emotional appeals.

Five steps for this quarter

1. Pull one dated CRM report and retire every other copy.
2. Filter to qualified deals with close dates inside the quarter.
3. Split coverage by segment and set each target from that segment's win rate and slippage.
4. Track new pipeline created each week next to coverage.
5. Rebuild the target from capacity, and take the math to finance if the gap is structural.

What this page does not cover

This page does not convert the pipeline gap into lead and meeting counts by stage, which the reverse funnel calculator handles, and it does not cover forecasting methods beyond weighted and unweighted coverage or how to build a target from sales capacity. It is not financial or legal advice.

Related on Take the Market: Demand generation calculator: reverse funnel math from a revenue target to visitors, leads, MQLs, SQLs and opportuniti; B2B marketing budget allocation calculator: split demand gen spend by pipeline per dollar; MQL to SQL conversion rate benchmarks and B2B funnel conversion rates by stage.

Where the defaults come from