01The formula
| To get | Calculate |
|---|---|
| Deals needed | Revenue target ÷ average deal size |
| Opportunities needed | Deals ÷ win rate |
| Pipeline needed | Revenue target ÷ win rate |
| Pipeline coverage | 1 ÷ win rate |
| Leads needed | Opportunities ÷ lead-to-opportunity rate |
| Budget | Leads × cost per lead |
02How to use it
Start from the revenue number and work down. A $1M target at a $50K average deal is 20 deals. At a 25% win rate that takes 80 opportunities and $4M in pipeline, which is 4x coverage. At a 10% lead-to-opportunity rate it takes 800 leads.
Then look at which input is cheapest to move. It's rarely the lead count.
03The rate is usually the cheaper lever
At Pipe17, MQL-to-SQL conversion went from about 20% to 40% after I rebuilt lead scoring and routing with Sales. Doubling that rate halves the leads you need for the same pipeline, with no extra spend. In the same two quarters, cost per sales-qualified opportunity fell from $14,450 to $3,700, and $66.5K in paid media influenced $1.3M in pipeline in one quarter.
How I did it is in MQL to SQL conversion rate and B2B lead scoring model.
04What the math hides
- Time. With a six-month sales cycle, the pipeline for this quarter's revenue had to exist two quarters ago.
- Definitions. Use one written definition of an opportunity. I've seen a default report read 18 when the real count from stage-entry dates was 21.
- Deal mix. An average deal size hides a few large deals and many small ones. Run it per segment if they behave differently.
FAQQuestions people ask
- How much pipeline do I need to hit my revenue target?
- Divide the revenue target by your win rate. A $1M target at a 25% win rate needs $4M in pipeline, which is 4x coverage. A lower win rate needs more pipeline for the same revenue.
- What is pipeline coverage ratio?
- Pipeline divided by the revenue target for the same period. The coverage you need is 1 divided by your win rate, so a 25% win rate needs 4x and a 33% win rate needs 3x.
- How many leads do I need to hit a sales target?
- Divide the target by average deal size to get deals, divide by win rate to get opportunities, then divide by your lead-to-opportunity rate. $1M at $50K a deal, a 25% win rate and a 10% lead-to-opportunity rate needs about 800 leads.
- How do I reduce the number of leads I need?
- Raise the conversion rates. Doubling lead-to-opportunity conversion halves the leads required. At Pipe17, Farhan Munshi doubled MQL-to-SQL conversion from about 20% to 40% by rebuilding lead scoring and routing with Sales.
MoreMore free tools
CPM calculatorROAS calculatorCAC calculatorLTV calculatorCPA calculatorMarketing ROI calculatorGoogle Ads budget calculatorStatistical significance calculatorUTM builderllms.txt generatorAEO checker