What Is Win Rate?
Win rate is the percentage of closed sales opportunities that resulted in a won deal, and it is one of the clearest signals of sales team effectiveness when measured consistently with the same opportunity definition. Most CRM exports make the calculation straightforward but the denominator — what counts as a closed opportunity — is where most teams introduce measurement errors.
See the exact formula, how to define the correct denominator, and how to segment it by rep, stage entry point, and deal size in a CRM export.
Drop your file in and ask a question — no account needed.
Upload your spreadsheet.xlsx .xls .csv — free to try, no accountWhat this export contains
| opportunity_id |
| close_date |
| stage |
| outcome |
| deal_value |
| owner_name |
| industry |
| lead_source |
| created_date |
| sales_cycle_days |
What usually goes wrong with it
Denominator definition varies by team
Some teams calculate on all created opportunities; others on opportunities that reached a late stage; others on all closed opportunities — using different denominators across periods makes trend data incomparable.
DataMimi Datamimi filters to closed-stage opportunities only before calculating so open deals don't dilute the denominator.
Open opportunities included in the closed count
CRM exports often include open opportunities with no close_date — if the total row count is used as the denominator without filtering for closed stage, the metric is understated.
DataMimi It normalizes outcome column values across all spelling and capitalization variants so all won deals are counted regardless of how they were entered.
Outcome field has inconsistent values
The outcome column may contain 'Won', 'Closed Won', 'win', and 'W' across different reps who entered deals differently — counting won deals by exact string match misses many closed-won rows.
DataMimi It calculates both unit win rate and value-weighted win rate in parallel columns so both views are available without separate formulas.
Deal value not factored into weighted win rate
Simple win rate treats a $500 deal the same as a $500k deal; teams that need to understand revenue efficiency need a value-weighted version that most CRM exports don't pre-calculate.
DataMimi It segments the metric by owner_name, industry, and lead_source so team-level and channel-level comparisons run without additional pivots.
Common questions
What is win rate?
Win rate is the percentage of closed sales opportunities that resulted in a won deal, calculated as closed-won opportunities divided by total closed opportunities (won plus lost) in a period.
What is a good win rate benchmark?
B2B SaaS win rates typically range from 20–30% of all closed opportunities; enterprise deals with longer cycles often have lower rates (15–25%) while SMB self-serve products may see 30–40% or higher.
How do I calculate win rate from a CRM export?
Filter to rows where stage indicates closed (won or lost); count rows where outcome is 'won'; divide by total closed rows; multiply by 100 to express as a percentage.
How is win rate different from close rate?
Win rate is typically measured on closed opportunities only (won divided by won plus lost); close rate sometimes includes all created opportunities in the denominator, making the two metrics incomparable without checking the definition.
How much does Datamimi cost?
Datamimi offers a Free plan at $0/month (40 credits, no credit card required), Lite at $9/month (400 credits), Starter at $24/month (1,500 credits, up to 3 simultaneous files), Pro at $59/month (5,000 credits with rollover), and Team at $199/month (20,000 credits, 5 users).
Try it with your own file
DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.
Ask about your file