Calculator
Example data table
| Owner | Opportunities | Wins | Losses | Opps per win | Win rate |
|---|---|---|---|---|---|
| Ayesha | 40 | 7 | 6 | 5.71 | 53.85% |
| Bilal | 35 | 5 | 8 | 7.00 | 38.46% |
| Hina | 25 | 6 | 3 | 4.17 | 66.67% |
| Usman | 20 | 0 | 5 | — | 0.00% |
Use this structure when testing exports or training new team members.
Formula used
Interprets how many opportunities you need for one win.
These help separate volume issues from conversion issues.
How to use this calculator
- Enter total opportunities created for your chosen period.
- Add closed-won and closed-lost counts from your CRM.
- Set targets for closes and revenue to estimate needed volume.
- Click Calculate to show results above the form.
- Use the download buttons to share the summary.
Insights for CRM & pipeline reviews
1) Why the ratio matters in weekly pipeline cadence
Opportunity-to-close ratio turns activity into an actionable benchmark. If your team averages 8.0 opportunities per win, a target of 30 wins implies roughly 240 opportunities created in the same window. Use this to align SDR output, AE coverage, and marketing-sourced volume.
2) Close rate converts volume into a forecast lever
Close rate equals wins divided by total opportunities. A 15% close rate means every 100 opportunities yields about 15 wins. When close rate improves from 12% to 16%, required pipeline for the same target drops by 25%. Track it by segment and source.
3) Win rate isolates qualification quality
Win rate uses only closed deals: wins ÷ (wins + losses). A 40% win rate with a long sales cycle can still hide pipeline bloat if too many deals remain open. Pair win rate with open opportunities to reveal stalled stages and weak exit criteria.
4) Target coverage: translating goals into required opportunities
This calculator estimates required opportunities for target closes using your current close rate. Example: target 25 closes at 18% close rate needs about 139 opportunities. Add a buffer for seasonality, pricing changes, or new reps, then compare “needed” versus “created” each week.
5) Revenue planning with average deal value
Expected revenue from wins equals wins × average deal value. If average deal value is 6,500 and you win 18 deals, expected revenue is 117,000. For a 180,000 target, you need about 28 wins at the same deal size, then back-solve to opportunities.
6) Practical ways to improve the ratio
Reduce opportunities-per-win by improving lead scoring, tightening discovery, and enforcing stage progression. Shorten cycle time with clear mutual action plans and early stakeholder mapping. Monitor losses by reason; fix one high-frequency loss driver to lift both win rate and close rate.
FAQs
What does “opportunities per win” mean?
It is total opportunities divided by closed-won deals. Lower values indicate better conversion efficiency, assuming similar deal sizes and qualification standards.
Should I include open opportunities in the ratio?
Include them when measuring creation efficiency for a period. Use closed-only when you want a clean view of conversion among decided deals.
Why do I see a high ratio but a decent win rate?
Win rate looks only at closed deals. A high ratio can occur when many deals remain open, inflating total opportunities without changing closed outcomes.
How often should I update these inputs?
Weekly updates work well for teams with steady volume. For high-velocity funnels, update daily to catch leakage early and recalibrate activity targets.
What is a good close rate?
It varies by market and stage definition. Compare close rate by segment, source, and deal size, then set improvement goals quarter over quarter.
How do exports help pipeline reviews?
Exports create consistent snapshots for leadership, coaching, and retro analysis. Use CSV for dashboards and the PDF summary for fast stakeholder sharing.