Calculator Inputs
Use this form to measure deal count efficiency, value efficiency, funnel conversion, and target attainment.
Example Data Table
This sample table shows how monthly performance can be organized before entering summary values into the calculator.
| Month | Won Deals | Lost Deals | Open Deals | Won Revenue | Win Rate |
|---|---|---|---|---|---|
| Jan 2026 | 9 | 6 | 14 | 125,000.00 | 60.00% |
| Feb 2026 | 7 | 5 | 12 | 102,000.00 | 58.33% |
| Mar 2026 | 12 | 6 | 9 | 193,000.00 | 66.67% |
| Apr 2026 | 10 | 8 | 11 | 154,000.00 | 55.56% |
| May 2026 | 11 | 7 | 13 | 171,000.00 | 61.11% |
| Jun 2026 | 8 | 4 | 10 | 138,000.00 | 66.67% |
Formula Used
- Count Win Rate = Won Deals ÷ (Won Deals + Lost Deals) × 100
- Value Win Rate = Won Revenue ÷ (Won Revenue + Lost Revenue) × 100
- Lead-to-Win Rate = Won Deals ÷ Qualified Leads × 100
- Demo-to-Win Rate = Won Deals ÷ Demos Completed × 100
- Proposal-to-Win Rate = Won Deals ÷ Proposals Sent × 100
- Pipeline Close Rate = (Won Deals + Lost Deals) ÷ Total Pipeline × 100
- Weighted Open Forecast = Open Pipeline Value × Count Win Rate
- Cycle Pressure Index = Average Cycle Days ÷ Benchmark Cycle Days × 100
- Sales Efficiency Score = 35% Count Win Rate + 30% Value Win Rate + 15% Proposal-to-Win Rate + 10% Pipeline Close Rate + 10% Target Attainment
Weighted Open Forecast uses the current count win rate as a decimal multiplier. Use one consistent currency across every revenue input.
How to Use This Calculator
- Enter the team name and the reporting period you want to analyze.
- Fill in won, lost, and open deals using the same pipeline definition.
- Add qualified leads, demos completed, and proposals sent for the same time range.
- Enter won revenue, lost revenue, and open pipeline value in one currency.
- Provide your average cycle days and the benchmark cycle for comparison.
- Set target count win rate and target value win rate percentages.
- Click Calculate Sales Win Rate to show the results above the form.
- Review the cards, interpretation notes, Plotly charts, and export files if needed.
FAQs
1. What does sales win rate measure?
Sales win rate measures how often closed opportunities become wins. It helps teams judge closing effectiveness, pipeline quality, and overall sales execution across a specific period.
2. Why track both count and value win rate?
Count win rate shows how many deals were won. Value win rate shows how much closed revenue was won. Together, they reveal whether you win often, win big, or both.
3. Should open deals be included in win rate?
Open deals should not be included in the core count win rate formula. They are still useful for forecasting, coverage analysis, and estimating weighted open pipeline value.
4. What is a good win rate?
A good win rate depends on market, deal size, qualification rules, and sales motion. Many teams view 25% to 35% as workable, while higher rates often reflect tighter qualification or stronger positioning.
5. Why is proposal-to-win rate important?
Proposal-to-win rate focuses on late-stage execution. A weak number may signal pricing problems, slow follow-up, unclear value communication, or weak stakeholder alignment near the finish line.
6. What does cycle pressure index tell me?
Cycle pressure index compares your average cycle days with the benchmark. Values above 100% mean sales are taking longer than planned, which can hurt forecasting accuracy and conversion.
7. Why use weighted open forecast?
Weighted open forecast estimates expected value from open pipeline using the current win rate. It gives a more realistic revenue view than assuming every open opportunity will close.
8. How often should teams review win rate?
Teams usually review win rate monthly and quarterly. Frequent reviews help catch conversion shifts early, improve coaching, and keep forecasts aligned with real pipeline performance.