Outbound Wiki

Pipeline coverage math

Calculating how much qualified pipeline is needed to support a bookings or revenue target.

Pipeline coverage math starts with the revenue you must close and works backward from the conversion rate your business can support. Keep the target, period, opportunity population, and conversion basis consistent. High coverage can give false comfort when pipeline quality is poor.1 Before relying on the ratio, check which opportunities it includes, which conversion rate produced the target, and when those opportunities can close.

Define the target

Put the outcome and time window on the same line before you calculate anything. Then choose the type of revenue the pipeline should support.

For a new-business model, coverage means coverage of the new-business ARR target from new customers.2 Publish the ratio separately for every rep, team, and opportunity source across both New ARR and Expansion ARR at the beginning and end of each month or quarter.3

Calculate required pipeline

Work backward from the target instead of choosing a coverage multiple first. The conversion rate must describe the share of starting pipeline that reaches closed business by the end of the period.

Reverse funnel math sets the starting pipeline target by dividing the bookings goal by the average conversion rate through quarter end.4 For a next-quarter bookings goal of $2.5 million and a 25 percent conversion rate, the starting pipeline target is $10 million.5

Write the conversion rate beside the target. If it changes by segment, deal type, or stage, calculate the requirement on that same basis so the result remains usable in review.

Turn required pipeline into coverage

Once you have the required starting pipeline, express the amount already available as a ratio. This gives you a consistent way to compare the current position with the amount the target requires.

For a quarterly view, divide quarterly starting pipeline by the quarterly sales target to calculate coverage.6 Divide total qualified pipeline by quota to determine whether the team has enough opportunities to reach the target.7

The ratio shows how much of the required pipeline is present. Audit the opportunities before acting on the gap.

Allocate the requirement

A total pipeline number becomes useful when you can turn it into source and stage goals. Keep the allocation rules visible so you can trace the total back to the target.

The model reduces the ARR goal by an agreed percentage, multiplies it by the desired pipeline coverage ratio, and allocates the result across pipeline sources using agreed percentages.8 Use that calculation to set pipeline goals for the core pipeline-generation sources while building the bookings model.9

Split the requirement by stage when the conversion history supports it. One reverse-funnel example requires $3.1 million of late-stage pipeline and $6.7 million of early-stage pipeline entering the quarter to reach a $2.5 million bookings goal.10

Check deal count alongside total value. A 2468 pipeline model matches the number of deals to the required pipeline coverage.11 The quarterly quota example contains two $125,000 deals and four $62,500 deals.12

Audit the numerator

Before publishing the ratio, test every opportunity counted in it. Coverage counts opportunities that already exist in the pipeline.13 Pressure-test every deal in your CRM before allowing it to support the target.14 When the close rate is 20 percent, a $300,000 pipeline spread across four opportunities cannot be judged by value coverage alone.15

Recalculate effective coverage after removing dead deals. A 4x coverage figure that includes 30 percent dead deals represents 2.8x effective coverage and will not achieve quota.16

Recheck the gap during the period

Coverage is a planning number that needs a reporting rhythm. Recalculate it when the time window or pipeline source changes, then use the gap to decide whether more pipeline is needed.

Measure the percentage of Closed-Won revenue coming from pipeline developed in the same period, and factor it into the coverage ratio and current-period pipeline development goals.17 In a business with a short average sales cycle, examine day-3 monthly coverage by dividing starting monthly pipeline by the monthly sales target, then use to-go coverage for an ongoing view.18

Low pipeline coverage can signal that a rep needs to generate more pipeline.19 If current coverage is 1.2x and required coverage is 3x, show that gap explicitly because it makes the business problem visible.20 Ask, "How are you planning on hitting quota?"21

What not to do

These mistakes make the ratio look healthier than the pipeline can support.

  • Do not treat a 3x coverage ratio as universal.22 It is a benchmark built on averages that may not apply to your business.
  • Do not count stale deals, opportunities without next steps, or discovery calls as late-stage pipeline.23
  • Do not use an overall win rate when a segment-specific win rate is needed, because that can overstate coverage.24

Sources

  1. 1
    “When your pipeline quality is poor, high coverage is a false comfort.”
  2. 2
    “Therefore, when we’re looking at coverage, we really mean to say coverage of the newbiz ARR target (i.e., new ARR from new customers).”
  3. 3
    “Calculate, communicate, and publish "pipeline coverage ratio" for every rep, team, and “source” of opportunities for both New ARR and Expansion ARR at the beginning and end of every month or quarter.”
  4. 4
    “Here is the basic premise of reverse funnel math: if you know the portion of your pipeline, on average, that converts by the end of the quarter (i.e., conversion rate), and you know your bookings goal, you can divide the two to set your starting pipeline target.”
  5. 5
    “If your bookings goal next quarter is $2.5M, all else being equal, you should have $2.5M / 25%, or $10M, in pipeline at the start of the quarter.”
  6. 6
    “you can meaningfully calculate “coverage” for the quarter by dividing the quarterly starting pipeline by the quarterly sales target.”
  7. 7
    “divide your total qualified pipeline by your quota to determine whether you have enough at-bats to hit your number.”
  8. 8
    “So, we first reduce the ARR goal by a percentage and then multiple it by the desired pipeline coverage ratio and then allocate the result across the pipeline-sources by presumably agreed-to percentages [6].”
  9. 9
    “For extra credit and to help maintain organizational alignment -- while you’re making a bookings model, with a little bit of extra math you can set pipeline goals for the company’s core pipeline generation sources [4], so I recommend doing so.”
  10. 10
    “Doing the reverse funnel math, you should have $3.1M of late stage pipeline and $6.7M of early stage pipeline entering the quarter in order to hit your bookings goal of $2.5M.”
  11. 11
    “number of deals to make sure you always have the right pipeline coverage.”
  12. 12
    “You'd have two deals that are 125K, four deals that are 62.5 and so on and so forth.”
  13. 13
    “the definition of “coverage” is based on opportunities that already exist in the pipeline.”
  14. 14
    “You need to pressure test every deal in your CRM.”
  15. 15
    “But if my close rate's 20% and I only have four opportunities that add up to 300K,”
  16. 16
    “A "4x coverage" number that includes 30% dead deals is really 2.8x, which means you're not going to hit quota.”
  17. 17
    “Measure the % of Closed-Won revenue from pipeline developed in the same period (month or quarter) and factor that into the pipeline coverage ratio and current period pipeline development goals.”
  18. 18
    “Examining monthly pipeline coverage. Instead of week-3 quarterly pipeline coverage [6], we should look at day-3 monthly pipeline coverage -- dividing the starting monthly pipeline by the monthly sales target.  (After that, you can use to-go pipeline coverage to get continuous insight.)”
  19. 19
    “Then we know, do we need to drive more pipeline because your pipeline coverage is low?”
  20. 20
    “coverage, but they need 3x pipeline coverage. That shows the gap. The gap is what people buy”
  21. 21
    “How are you planning on hitting quota?”
  22. 22
    “A 3x pipeline coverage ratio is a benchmark built on averages that don't apply to your business.”
  23. 23
    “Deals that hadn't moved in weeks, opportunities with no next steps, discovery calls that got counted as late-stage pipeline.”
  24. 24
    “Most teams overstate coverage by including stale deals, using overall win rates instead of segment-specific rates, and measuring at the wrong point in the quarter.”