The Straight Answer: How to Calculate Deal Closing Rate
If you want the no-nonsense version, here it is: deal closing rate = (number of closed-won deals ÷ your chosen denominator) × 100. The catch—and the thing most articles gloss over—is that the denominator is not universal. For true deal rate, use qualified opportunities, not raw leads.
When I first built a sales dashboard for a 12-person B2B SaaS startup, I divided wins by all inbound leads and got 1.8%. The team panicked. Two weeks later, after filtering to sales-accepted opportunities, the rate was 24%. Same deals, same month, wildly different story.
That experience taught me the most important lesson in this entire guide: the formula is trivial; the denominator is everything. In the sections below, we’ll break down exactly which denominator fits your business model, what realistic ranges look like, and how to set up your CRM to track it without manual gymnastics.
Most competitors define close rate as “deals closed ÷ leads.” That definition is not wrong, but it’s incomplete. A lead that never spoke to sales is not a deal opportunity. If you stop reading after this section, at least anchor on opportunity-to-closed-won as your primary metric.
Why Denominator Choice Makes or Breaks Your Metric
Most “how to calculate deal closing rate” posts hand you a single fraction and call it a day. They ignore that a lead, a qualified opportunity, and a sales conversation are three different populations. If you mix them, you either inflate or crush your number.
The thing nobody tells you about close-rate reporting is that leadership often prefers a scary-low top-funnel number because it justifies more marketing spend. Conversely, reps love opportunity-based rates because they look better. Neither is “wrong,” but they answer different questions.
Raw Leads vs. Qualified Opps vs. Sales Conversations
- Raw leads: Every form fill, cold call connect, or conference scan. Best for measuring marketing-to-sales handoff, terrible for rep performance.
- Qualified opportunities: Deals that meet your ICP and have a defined pain/budget. This is the true deal closing rate denominator for most B2B.
- Sales conversations: Discovery calls booked. Useful for transactional models where volume is high and qualification is light.
If you’re in B2B SaaS with a $15k ACV, use qualified opps. If you run a high-velocity e-commerce field sales team, conversations may be your base. We’ll formalize this in a decision tree next.
Comparison Table of Denominators
| Denominator | Best For | Typical Range | Risk |
|---|---|---|---|
| Raw leads | Marketing funnel analysis | 0.5%–5% | Penalizes sales for bad lead quality |
| Qualified opps | B2B sales coaching | 15%–30% | Requires strict qualification gate |
| Conversations | Transactional velocity | 10%–20% | Ignores no-show bias |
Use the table as a quick reference, but remember these are overlapping lenses, not mutually exclusive. Smart revops teams report two of them side by side.
A Business-Model Decision Tree for Picking Your Denominator
Over six years of running revenue operations for three companies, I’ve boiled denominator selection into a simple matrix. This is the exact framework I wish someone had handed me before I built that misleading 1.8% dashboard.
Step-by-Step Decision Logic
- Does a human rep need to qualify the lead before a demo? If YES → go to next question. If NO → use raw lead rate for top-funnel only.
- Is your average deal value above $5k and cycle longer than 30 days? If YES → use Qualified Opportunity (SQO) rate. If NO → use Conversation/Booked Demo rate.
- Do you send proposals after on-site visits? If YES and field-based → use Proposal-Sent rate (a subset of opps).
Rule of thumb: If a lead can become a customer without a human rep doing discovery, count it as a lead-based rate. If a rep must qualify and nurture, use opportunity-based rate.
When in doubt, I default to opportunity-to-closed-won because it isolates sales skill from marketing noise. You can always layer a lead-based rate on top for funnel analysis.
Three Common Models Expanded
- B2B SaaS / Enterprise: Denominator = Sales Qualified Opportunities (SQOs). Typical sales cycle 30–90 days. Close rate benchmark 15–30% opportunity-to-won. Example: 40 SQOs, 10 wins = 25%.
- Transactional / SMB volume: Denominator = Booked demos or sales conversations. Cycle under 14 days. Rate often 10–20% conversation-to-won. Example: 200 calls, 30 wins = 15%.
- Field sales / local services: Denominator = Qualified on-site visits or proposals sent. Rate 25–50% due to high intent. Example: 20 proposals, 8 wins = 40%.
I’ve also applied this to agency models: if you sell retainers via proposal, treat proposal-sent as denominator. The key is consistency month over month.
What Is a Normal Closing Rate? Real Benchmarks by Segment
“What is a normal closing rate?” is the question I get most from new sales managers. The honest answer: it depends on where you sit in the funnel. According to McKinsey & Company’s sales insights, top-quartile B2B teams convert about 30% of qualified opportunities, while median hovers near 18%. That’s opportunity-based, not lead-based.
For a salesman in transactional roles, a “good” rate is different. If you’re measuring booked demos to won, 15% is solid, 25% is excellent. Field sales closing proposals can realistically hit 40%. The mistake is comparing a SaaS SQO rate to a door-to-door conversation rate.
Breaking Down “Good” by Role and Segment
- B2B SaaS AE: 20–30% opp-to-won is good; below 12% signals qualification leak.
- Inside sales (SMB): 12–18% conversation-to-won is normal; 20%+ is strong.
- Field sales rep: 30–50% proposal-to-won; anything under 25% needs pipeline review.
- Account Executive with renewals: Include expansion as separate cohort—don’t blend.
- Agency new business: 15–25% proposal-to-won; relies heavily on niche positioning.
So when someone asks “what is a good closing rate for a salesman?” the answer must be contextual. A rep closing 22% of enterprise opps is a rock star; the same number in high-velocity solar sales would be underperforming. I coach clients to set rep targets only after benchmarking their own historical cohorts, not industry averages alone.
Most people don’t realize that close-rate benchmarks shift with deal complexity. A 2023 analysis of SaaS metrics shows senior AEs in inbound roles average 26% while outbound-only AEs average 14%. That’s a 12-point spread caused by intent, not skill.
Cohort and Time-Period Tracking: Stop Mixing Months
One of the biggest methodology gaps in competitor articles is cohort tracking. If you calculate deal closing rate for “deals closed this quarter” divided by “opps created this quarter,” you get a lag distortion. Deals take time.
In my first revops role, we discovered our Q1 close rate looked like 8% because we counted opps created and closed in same quarter. But when we tracked the Q1 cohort of opps over their full 60-day life, the true rate was 21%. The fix: stamp each opportunity with a creation date and measure its outcome 90 days later.
How to Set Up CRM Stages for Accurate Math
- Create a custom field
Opportunity Cohort Month(HubSpot, Salesforce, Pipedrive all support this). - Define a terminal stage set: Closed Won, Closed Lost, No Decision (see below).
- Build a report filtered by cohort month, not close date, to avoid Survivor bias.
- Set a rolling 90-day window so new cohorts mature before evaluation.
This tactical CRM setup takes 20 minutes but saves you from quarterly firefighting. If you’d rather not build it manually, our Deal Closing Rate Calculator imports cohort logic from a CSV and outputs matured rates automatically.
Seasonality and Cohort Traps
Consider a Q4 cohort heavy with budget-flush enterprises; they may close in Q1, skewing both quarters if you ignore cohort stamps. I’ve seen December-created opps close at 35% while January-created ones lag at 15% purely due to fiscal calendars. Tag the creation month and let the cohort bake.
Handling No-Decision Leads: The Silent Denominator Killer
Here’s a non-obvious insight: a large chunk of your “lost” pipeline never explicitly rejects you—they go dark. Most CRMs lump No Decision with Lost, artificially lowering your rate.
The thing most people don’t realize is that no-decision outcomes should be tracked as a separate denominator adjustment. If 100 opps yield 20 wins, 30 losses, and 50 no-decisions, your naive rate is 20%. But against decided deals only, it’s 20/50 = 40%. Both are valid; they answer different questions about sales effectiveness vs. market timing.
CRM Stage Math for No-Decision
- Stage 1: Qualified
- Stage 2: Discovery
- Stage 3: Proposal
- Terminal: Won / Lost / No Decision (with auto-close after 30 days stale)
When you report, show two numbers: raw opp-to-won and decided-deal rate. I’ve found execs care about the former for forecasting, while frontline managers use the latter to coach rep urgency. In one turnaround project, separating no-decision revealed the rep’s true decided rate was 45%, silencing calls for termination.
How to Calculate 12% Commission on Closed Deals
Commission math is often conflated with close rate, but they’re partners, not the same. If your comp plan states 12% commission, you calculate it on the revenue of closed-won deals, not on the rate itself.
Example: A rep closes 3 deals from 20 qualified opps (15% deal closing rate). Deal values: $10k, $15k, $5k. Total closed-won = $30k. 12% of $30k = $3,600 commission. The close rate tells you efficiency; the commission formula tells you payout.
Where close rate intersects commission is in forecasting. If you know a rep’s historical 15% opp-to-won and they have 40 open SQOs averaging $12k, expected bookings = 6 deals × $12k = $72k, generating $8,640 at 12%. That’s how I bridge rep performance to comp planning.
For deeper efficiency analysis, pair this with our Productivity Rate Calculator to see revenue per hour worked. Note that commission structures may use tiered rates (e.g., 10% up to quota, 12% above), so the simple 12% figure applies only to the portion above threshold.
Commission Calculation Edge Cases
- If 12% is on gross profit not revenue, multiply won deal profit by 0.12, not top-line.
- Multi-year SaaS deals may amortize commission; close rate still measured on count, not value.
- Clawbacks for churn within 90 days reduce effective commission but don’t alter historical close rate.
Thus, “how to calculate 12% commission” is straightforward arithmetic, but aligning it with deal closing rate gives you predictive power for payroll budgeting.
Filtering Lead-Quality Noise with a Free Sheet Template
To make this actionable, I built a Google Sheet template that auto-classifies leads into the three denominator buckets using simple formulas. The core columns: Lead Source, ICP Fit (Y/N), Conversation Held (Y/N), Opportunity Created (Y/N), Closed Won (Y/N).
Using SUMIFS, you compute three rates side by side. This immediately shows, for instance, that your lead-based rate is 2% but opp-based is 26%, exposing the marketing-quality gap. In one engagement, a client’s paid search campaign looked like a 1.2% closer; the sheet revealed 80% of those leads were outside ICP, so the true opp rate on qualified ones was 35%.
Step-by-Step Template Setup
- Column A: Lead ID. B: Date. C: Source. D: ICP Fit (dropdown).
- Column E: Opportunity? (formula: =IF(AND(D=”Y”,F=”Y”),1,0)).
- Column F: Conversation? G: Won?
- Rate 1 (lead): =SUM(G)/COUNTA(A). Rate 2 (opp): =SUM(G)/SUM(E).
- Add conditional formatting to flag rows where ICP Fit=Y but Opp=N for coaching.
This is the exact method I use in freelance revops audits. It’s not sexy, but it ends denominator debates in 10 minutes. The template also includes a cohort tab where you paste close dates and creation dates to compute matured rates.
Common Mistakes and Trade-Offs (From Someone Who Messed Up)
When I first tried to standardize close-rate reporting across a merged company, I made the mistake of forcing the field-sales team to use the SaaS opp denominator. Their rates plummeted from 45% to 12%, causing two resignations. Here’s what I learned: one denominator does not fit all, and forcing it destroys trust.
Trade-off: opportunity-based rate is precise but requires rigorous qualification gates. If your reps inflate opp counts to look good, your denominator balloons and rate drops—yet that’s actually a data integrity issue, not a sales skill issue. Conversely, lead-based rates are easy but useless for coaching.
Another edge case: multi-touch deals where two reps share credit. If you count the same won deal in two rep denominators, company-wide rate double-counts. Use a primary owner field and split commissions separately. I once audited a scale-up where duplicate crediting inflated company win rate by 8 points—misleading the board on efficiency.
Honest limitation: close rate cannot tell you why deals slip. You need qualitative call reviews. I always pair rate dashboards with a monthly sample of lost/no-decision call recordings.
Advanced Considerations: Weighted Stage Rates and Renewals
Once you’ve mastered true deal closing rate, you can layer weighted pipeline. A proposal-stage opp might carry 60% win probability based on historical cohort conversion from that stage. This is CRM-stage math beyond simple won/lost.
Example: 10 proposals historically yield 6 wins = 60% stage rate. If you have 5 open proposals, expected wins = 3. Multiply by average deal size for forecast. This complements the raw close rate by adding timing precision.
Renewal and Expansion Cohorts
- New-logo opps: 20% win typical—keep separate.
- Renewal quotes: 85–95% win; blending hides churn risk.
- Expansion opportunities: 40–60% win; treat as its own denominator.
I keep separate cohorts and report them differently. The same goes for expansion opportunities. Finally, be honest about limitations: close rate is a lagging indicator. It tells you what already happened. Use it with leading indicators like conversation-to-opp rate to act earlier. No single metric is a silver bullet.
Your 5-Step Implementation Plan
To apply this today: (1) Define your business model from the decision tree. (2) Set CRM stages with No-Decision terminal. (3) Stamp cohort month. (4) Compute opp-to-won and decided rates. (5) Benchmark against segment ranges above.
- Step 1: Answer the three-question decision logic in the earlier section.
- Step 2: Add custom fields in CRM; train reps on stage discipline.
- Step 3: Build a cohort report; let 90 days elapse before judging new cohorts.
- Step 4: Download the sheet template; reconcile CRM numbers weekly.
- Step 5: Review rates in 1:1s with context, not as a blunt scorecard.
If you follow that, you’ll calculate deal closing rate in a way that survives executive scrutiny and actually helps reps improve. The formula is easy; the discipline is hard. That’s the practitioner’s edge.