Pipeline Generation Gap Calculator
See exactly how much new pipeline you need to create this month to hit next quarter's number at your team's real win rate and sales cycle, instead of guessing at activity targets.
What's inside
- Core formula: required pipeline = target revenue divided by win rate
- 4-input worksheet (target revenue, win rate, avg deal size, sales cycle length)
- Worked example converting a $600k target into a required pipeline and coverage ratio
- Timing-adjustment step reconciling sales cycle length against days left in the quarter
- Gap-to-goal table (required vs. current pipeline, converted to # of opportunities needed)
- Monthly pipeline-creation target breakdown
- Source-mix worksheet splitting the gap across outbound/inbound/expansion/partner
- Weekly tracking table against monthly targets
- Common calculation mistakes to avoid (win-rate window, timing, stale pipeline counted as current)
The core formula
`` Required New Pipeline ($) = Target Revenue ($) ÷ Win Rate (%) ``
If your win rate is 25% and your target is $500,000, you need $2,000,000 of pipeline created to hit that number — not $500,000, and not an arbitrary "more."
Step 1: Gather your 4 inputs
| Input | Where to get it | Your number |
|---|---|---|
| Target revenue (next quarter) | Your quota/plan | $_______ |
| Win rate (closed-won ÷ closed-won+closed-lost, trailing 4 quarters) | CRM report | _______% |
| Average deal size (ACV, trailing 4 quarters) | CRM report | $_______ |
| Average sales cycle length (days) | Sales Cycle Length Calculator output | _______ days |
Use trailing 4-quarter win rate, not last quarter alone — one hot or cold quarter will badly distort a single-quarter number.
Step 2: Calculate required pipeline
`` Required Pipeline = Target Revenue ÷ Win Rate ``
Worked example:
- Target revenue next quarter: $600,000
- Win rate: 22%
- Required Pipeline = $600,000 ÷ 0.22 = $2,727,273
This is also expressed as a coverage ratio: $2.73M pipeline ÷ $600k target = 4.5x coverage. Most B2B teams need 3x–5x coverage; if your calculated ratio falls outside that band, sanity-check your win rate input before trusting the output.
Step 3: Adjust for timing (sales cycle vs. quarter)
Pipeline created this quarter mostly closes in a future quarter if your average cycle is longer than the time remaining in the current quarter.
`` Days remaining in target quarter = Quarter end date − Today If Days remaining < Average sales cycle length: → New pipeline created NOW will mostly land NEXT quarter, not this one. → Required pipeline for THIS quarter's number must already exist (or be very close to closing). ``
Rule of thumb: pipeline you need for a quarter must be created, on average, one full sales-cycle-length before that quarter starts. If your average cycle is 75 days, pipeline for Q4 needs to be substantially built by early-to-mid Q3.
Step 4: Find the gap
| Amount | |
|---|---|
| Required pipeline (from Step 2) | $_______ |
| Current open pipeline already in Pipeline/Best Case/Commit for the period | $_______ |
| Gap to close (Required − Current) | $_______ |
| Gap ÷ average deal size = # of new opportunities needed | _______ |
Worked example continued: Required $2,727,273. Currently have $1,200,000 already in play. Gap = $1,527,273. Average deal size $45,000. New opportunities needed = 34.
Step 5: Break the gap into monthly targets
| Month | New pipeline $ target | New opportunities target |
|---|---|---|
| Month 1 | ||
| Month 2 | ||
| Month 3 |
Split evenly as a starting point, then weight earlier months more heavily if your sales cycle is long relative to the quarter (front-load creation).
Step 6: Source-mix worksheet
Required pipeline rarely comes from one motion. Break the gap down by source using your team's historical source mix (trailing 4 quarters, % of pipeline $ by source):
| Source | Historical % of pipeline | $ needed from this source | Activity implied |
|---|---|---|---|
| Outbound (rep-sourced) | # of meetings needed = $ ÷ avg deal size ÷ meeting-to-opp rate | ||
| Inbound/marketing | |||
| Expansion (existing accounts) | |||
| Partner/channel |
Weekly Tracking Table
| Week | New pipeline created | Cumulative | % of monthly target | On pace? |
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 |
Common Mistakes
- Using last quarter's win rate alone instead of a trailing 4-quarter average — one anomalous quarter skews the whole calculation.
- Ignoring timing — calculating the dollar gap correctly but creating the pipeline too late in the quarter for it to convert in time.
- Counting stalled/Omitted-category pipeline as "current pipeline" in Step 4 — only count what would survive an honest forecast-category audit.
- Using average deal size instead of median when your deal sizes are highly skewed — check for a few outlier enterprise deals distorting the average before using it to convert dollars to opportunity count.
How to use it
Plug your target revenue, trailing-4-quarter win rate, average deal size, and sales cycle length into the formula each month to get your exact pipeline-creation number and opportunity count, then track weekly progress against the monthly targets it produces.