Wave | Hit your number

Pipeline coverage calculator

Work out how much pipeline you need to hit quota, using your real win rate by count and by value, and see how stale Salesforce data skews the number.

1Your closed deals, last 12 months

Deals that went quiet or the buyer did nothing.

2Your target and pipeline

Everything currently open that is meant to close this quarter.

3How accurate is the data?

Still open in Salesforce, but the close date has passed.
Counted inside your open pipeline above.
Duplicates, test records, or deals closed only to tidy the pipeline.

4Your pipeline coverage

Pipeline coverage needed

4.3x

Win rate by count

22%

Win rate by value

23%

Pipeline needed

$6.51M

Clean coverage now

2.4x

Gap to close

$2.91M

Possible true win rate, by deal count

0% to 0%

0%dot = reported50%

Get this report in your inbox

Your numbers, ready to share with your team.

Please enter a valid work email.

Thanks! Your report is on its way.

How we calculate this

  • Win rate by count = won / (won + lost, plus no-decision deals if you count them as losses).
  • Win rate by value = $ won / ($ won + $ lost, plus the value of no-decision deals if counted).
  • Pipeline needed = quarterly target / win rate by value. Coverage needed = pipeline needed / target.
  • Clean pipeline = open pipeline minus the value of deals already past their close date. Clean coverage = clean pipeline / target.
  • Possible true win rate: the low end treats open deals past their close date as lost, won / (closed + past-due). The high end removes closed-lost records that were never real deals, won / (closed minus those records).
Read the pipeline clean-up guide →

Pipeline coverage calculator FAQs

Common questions about pipeline coverage and win rate
What is a good pipeline coverage ratio?
There is no single right ratio. Many sales teams use 3x as a rule of thumb, which assumes a win rate of about 33%. The ratio you actually need is 1 divided by your win rate by value: at a 25% win rate you need 4x, and at 20% you need 5x. Count only clean pipeline, so deals past their close date don't make you look covered when you're not.
Should I use win rate by count or by value?
Use win rate by value for pipeline planning, because large deals move your quota more than small ones. Win rate by count is still useful for judging how well your team converts opportunities, and the two can differ a lot when deal sizes vary.
Why does stale Salesforce data change the answer?
Open deals past their close date inflate your pipeline, and closed-lost records that were never real deals drag your win rate down. The calculator shows a possible range for your true win rate and a clean coverage figure, so you can see how much the data is skewing both.
Abstract purple outline of four connected circles inside a rounded square frame on a black background.
Abstract geometric logo featuring a circle above layered semicircles within a rounded square border.
Venn diagram with three overlapping purple circles on a black background.
Purple crescent shapes forming a circle on a black square background with rounded corners.
Purple outline icon of a briefcase inside a rounded square border on a black background.
Abstract black and purple geometric design with layered squares and rounded corners.
Green spreadsheet file icon representing an Excel document on a light background.
Abstract black and purple geometric design with layered squares and rounded corners.
Icon with three nested rectangles inside a rounded square outline, representing a scaling or resizing concept.
Microsoft Excel app icon with an overlapping white X on a green abstract background.
Purple geometric icon with three nested diamond shapes on a black background.
Green Google Sheets spreadsheet icon on a light background.
Icon with three stacked rounded rectangles in purple outline on a black background.
Abstract purple outline of four connected circles inside a rounded square frame on a black background.
Icon showing four interconnected circles forming a square with a horizontal line extending from the right circle.
Google Chrome web browser logo.
Salesforce logo with white text inside a blue cloud shape.
Abstract geometric design with multiple rounded squares outlined in purple on a black background.
Purple circular abstract icon with overlapping partial rings on a black square background with rounded corners.
Three overlapping purple circles forming a triangular Venn diagram on a black background.
Abstract geometric logo featuring a circle above layered semicircles within a rounded square border.