Most operators think win rate is a single number. I've watched teams lose millions because they never split it by deal size—the $20K motion that converts at 68% dies at $200K, and nobody notices until the pricing strategy is already broken.
Step 1: Pull Every Closed Deal from the Last 12–24 Months
Your win/loss analysis is only as good as the data you feed it. I've seen teams make pricing decisions off incomplete datasets and wonder why their forecasts miss by 40%.
You need every closed deal. Won and lost. With accurate dollar values and clear outcomes.
Twelve months gives you enough data. Twenty-four months is better if your sales cycle is long or you don't have high volume. I worked with an operator running a scaled infrastructure business who pulled six months of data and got wildly optimistic results. His $200K+ tier showed a 60% win rate. When we pulled 18 months, it dropped to 22%. He'd had a lucky quarter with three enterprise wins that skewed everything.
Export Your CRM Data with Deal Value and Outcome Fields
Go into your CRM and build a report. You need these fields at minimum:
- Deal name or ID
- Close date
- Deal value (annual contract value, total contract value, or first-year revenue—pick one and stay consistent)
- Outcome (Closed Won, Closed Lost)
- Deal source or channel
- Sales rep owner
Export to CSV. Open it in Google Sheets or Excel.
If your CRM doesn't have clean deal values, you have a data hygiene problem that goes deeper than this analysis. Fix that first. Across 101 sales teams I've built, the ones with sloppy CRM data always have sloppy forecasting and sloppy compensation plans.
Clean and Normalize Deal Sizes into Consistent Buckets
Your raw data will be messy. I guarantee it.
Some reps enter monthly recurring revenue. Others enter annual. Some include implementation fees. Others don't.
Pick one standard. I prefer annual contract value because it's clean and comparable. If you sold a $10K setup fee plus $2K/month, that's a $24K ACV deal.
Normalize everything to that standard. Create a new column called "Normalized Deal Value" and convert every deal to the same unit.
Remove any deals with $0 value. Remove duplicates. Remove deals marked as "Closed Won" that never actually closed—yes, this happens more than you think.
Flag Outliers and Non-Standard Deals to Exclude
Not every deal belongs in your analysis.
I exclude deals that are:
- Strategic partnerships with non-standard pricing
- Pilot programs or beta customers
- Friends-and-family deals
- Deals won through acquisition or merger
- Anything priced more than 3x your standard package range
One operator I worked with had a $2.4M deal in his dataset. It was a government contract that took 18 months and involved an RFP process nothing like his normal sales motion. Including it made his $500K+ tier look amazing. Removing it revealed the truth: he couldn't consistently close anything above $180K.
Create a column called "Include in Analysis" and mark TRUE or FALSE for each deal. Filter to TRUE only.
Here's what your cleaned dataset should look like compared to common mistakes:
| Approach | Data Included | Result | Accuracy |
|---|---|---|---|
| Clean 12–24 month export | Standard deals, normalized ACV, clear won/lost | Reliable win rates by tier | High—actionable insights |
| Last 6 months only | Too small sample, seasonal bias | Volatile percentages, false patterns | Low—misleading |
| Mixed ACV and MRR | Inconsistent deal values | Tiers don't align with reality | Medium—requires rework |
| Includes pilot and beta deals | Non-standard pricing and terms | Inflated win rates at high tiers | Low—false confidence |
| Open pipeline included | Deals not yet won or lost | Win rate calculation is broken | None—mathematically wrong |
| No outlier flagging | One-off enterprise deals skew data | Overestimate capability ceiling | Low—dangerous for planning |
You should now have a clean dataset with 100–500+ deals depending on your volume. If you have fewer than 80 closed deals total, you need more time or more deal flow before this analysis will tell you anything useful.
Step 2: Segment Deals into 4–6 Deal Size Tiers
Now you're going to slice your clean dataset into deal size bands. This is where most operators screw up by using arbitrary round numbers that don't reflect their actual business.
Your tiers need to follow natural breakpoints in your pricing and market structure. Not what looks pretty on a slide.
Define Your Deal Size Bands Based on Natural Breakpoints
Look at your deal distribution. Sort your normalized deal values from smallest to largest. You're looking for clusters and gaps.
If you have 40 deals between $8K and $15K, then nothing until $28K, that gap is a natural breakpoint. Your tiers should reflect that.
I typically see these patterns:
- Self-serve or low-touch deals cluster at the bottom
- Standard packages create a thick band in the middle
- Custom or enterprise deals spread out at the top with bigger gaps between them
Your breakpoints should align with how you actually sell. If you have a $25K standard package and a $75K premium package, those are natural tier boundaries.
One operator I worked with sold HR software. His tiers were $5K–$12K (small business), $12K–$30K (mid-market standard), $30K–$60K (mid-market premium), $60K–$120K (enterprise lite), and $120K+ (enterprise). Those bands matched his packaging and buyer profiles perfectly.
Don't force five tiers if you only have three natural bands. Don't create ten micro-tiers because you like granularity. Four to six tiers is the sweet spot for actionable analysis.
Ensure Each Tier Has at Least 20–30 Deals for Statistical Validity
Here's the rule: if a tier has fewer than 20 deals, you can't trust the win rate.
I've seen operators create a "$200K+" tier with seven deals. Four wins, three losses. That's a 57% win rate. They thought they were crushing it at the high end.
Two quarters later, they closed one deal and lost nine. The real win rate was 25%. The early sample was noise.
Count the deals in each proposed tier. If any tier is too thin, merge it with an adjacent tier or acknowledge you don't have enough data yet to analyze that segment.
This is why you need 12–24 months of data. If you only close 100 deals a year and you want five tiers, you need 20 deals per tier minimum. That's the whole year. One bad quarter will skew everything.
Across two decades building sales systems, I've learned that operators would rather have a pretty chart than an accurate one. Resist that urge. Empty tiers tell you nothing.
Label Tiers with Business Context (SMB, Mid-Market, Enterprise)
Don't just call them "Tier 1" and "Tier 2." Give them names that mean something to your business.
Use labels like:
- SMB or Small Business
- Core or Standard
- Mid-Market
- Enterprise
- Strategic or Whale
This makes the analysis useful when you're talking to your team. "Our win rate in Mid-Market is 41%" means something. "Our win rate in Tier 3 is 41%" means nothing.
The labels should match how your reps and leadership already talk about deals. If everyone calls deals over $100K "enterprise," use that label even if it's not technically accurate.
I worked with an operator running a scaled consulting business. He labeled his tiers: Starter ($10K–$25K), Growth ($25K–$60K), Scale ($60K–$150K), and Transform ($150K+). Those names aligned with his service packages and made the win/loss data immediately actionable in pipeline reviews.
Create a new column in your spreadsheet called "Deal Tier" and assign every deal to its tier. You should now be able to filter and count deals by tier instantly.
Step 3: Calculate Win Rate for Each Deal Size Tier
This is where the insight lives. You're about to see exactly where your team's effectiveness breaks down.
Most operators have a gut feeling about their pricing ceiling. This step gives you the numbers to prove it or disprove it.
Use the Formula: Wins ÷ (Wins + Losses) per Tier
Win rate is simple math. For each tier:
Count the Closed Won deals. Count the Closed Lost deals. Divide wins by total closed deals.
If you had 30 wins and 20 losses in your Mid-Market tier, that's 30 ÷ 50 = 60% win rate.
Do this for every tier. Create a summary table that looks like this:
- Tier name
- Deal count (wins + losses)
- Wins
- Losses
- Win rate (%)
I use a pivot table in Google Sheets. Rows are deal tiers. Values are count of deals, filtered by outcome. It takes 90 seconds once your data is clean.
The pattern you'll see is almost always the same: win rate declines as deal size increases. The question is where and how fast.
Exclude Open Pipeline and Disqualified Deals from the Calculation
Only include Closed Won and Closed Lost in your win rate calculation. Nothing else.
Open pipeline deals haven't been won or lost yet. Including them breaks the math.
Disqualified deals—where the prospect wasn't a fit or you chose not to pursue—aren't losses. They're non-events. If you include them, your win rate looks artificially low.
I worked with an operator who had a 31% win rate in his enterprise tier. He was panicking. When we dug in, he was counting disqualified deals as losses. His reps were correctly walking away from bad-fit enterprise prospects. Once we excluded those, his real win rate was 48%. Still not great, but not a crisis.
Some CRMs have a "Closed Lost - Disqualified" status. Use it. If yours doesn't, create a filter rule: if the loss reason is "Not a fit," "Budget disappeared," or "Went dark before discovery," exclude it.
Your win rate should only measure deals you actually competed for and lost to a competitor, the status quo, or a "no decision."
Visualize Win Rates on a Chart to Spot the Cliff
Numbers in a table are fine. A chart makes the pattern obvious.
Create a simple column or line chart. X-axis is your deal tiers in order from smallest to largest. Y-axis is win rate percentage.
You're looking for the cliff.
In a healthy sales system, win rate declines gradually as deal size increases. You might see 65% in SMB, 58% in Core, 50% in Mid-Market, 42% in Enterprise.
In a broken system, you see a cliff. You might see 60%, 58%, 55%, then 18%. That drop from 55% to 18% is your pricing ceiling. You've exceeded your team's current capability.
I've run this analysis across 101 teams. The cliff is always there. The only question is where.
One operator I worked with had win rates of 71%, 68%, 64%, 61%, 23%. The cliff was at $85K. Everything below that was strong. Everything above was a coin flip at best. He thought his problem was rep skill. It wasn't. His problem was that his $85K+ deals required a different sales motion, longer cycles, and executive buyers his team wasn't equipped to handle.
The chart makes this visible in five seconds. Without it, you're guessing.
Step 4: Identify the Deal Size Where Win Rate Drops Below 25%
You've calculated win rates by tier. You've visualized the data. Now you're going to draw a line in the sand.
This is your pricing ceiling. The dollar amount above which your team cannot consistently win.
Pinpoint the Exact Threshold Where Performance Collapses
Look at your chart. Find the tier where win rate drops below 25%.
That's your ceiling.
If your Mid-Market tier ($30K–$60K) has a 47% win rate and your Enterprise tier ($60K–$120K) has a 22% win rate, your ceiling is somewhere around $60K.
You can get more precise. Look at the individual deals in that Enterprise tier. Sort them by deal size. Find the point where wins become rare.
Maybe you won three deals at $62K, $68K, and $71K. Then you lost eight straight deals from $74K to $115K. Your real ceiling isn't $60K. It's around $72K.
I worked with an operator running a scaled marketing agency. His data showed a 56% win rate up to $45K, then 19% above $80K. But when we zoomed in, he had a 41% win rate in the $45K–$65K range. His actual ceiling was $65K, not $45K. That $20K difference was worth an extra $180K in annual revenue per rep.
Document this number. Write it down. This is the most important output of your entire analysis.
Understand Why 25% is the Red Zone for Sustainable Growth
Why 25%? Why not 30% or 20%?
Because at 25% win rate, your cost of sale becomes unsustainable.
If you're closing one in four deals, you're burning three opportunities for every win. Your reps are spending 75% of their time on deals that go nowhere. Your pipeline needs to be 4x your quota. Your lead gen costs are quadrupled.
I've watched operators chase deals at 15% win rates because the dollar amounts were sexy. They'd celebrate a $200K win and ignore the fact that they lost twelve other $200K deals to get it. The math doesn't work.
At 25% win rate, your sales efficiency collapses. Your reps get demoralized. Your forecast becomes a joke. Your CAC payback stretches to 18+ months.
Across two decades, I've seen the pattern repeat: teams that chase deals above their ceiling burn cash, miss targets, and blame the reps. Teams that respect their ceiling build predictable revenue engines.
If your win rate is below 25% in any tier, you have three options:
- Stop selling deals in that tier
- Change your sales motion to handle that buyer complexity
- Accept the inefficiency and price it into your CAC model
Most operators should choose option one. You're not ready for that tier yet.
Document the Dollar Range of Your Current Pricing Ceiling
Write this down in a document your leadership team can see:
"Our current pricing ceiling is $X. Below this amount, we win at Y%. Above this amount, we win at Z%. Until we change our sales structure, we should not pursue deals above $X."
Be specific. Include the date of the analysis and the data range you used.
This becomes your guardrail for pipeline planning, territory design, and comp structure. If a rep brings you a $150K opportunity and your ceiling is $70K, you know it's a long shot. You can choose to pursue it, but you're doing it with eyes open.
I worked with an operator who ran this analysis and found his ceiling was $52K. He'd been pushing his team to close $100K+ deals for a year. His win rate in that range was 11%. Once he documented the ceiling and refocused the team on $30K–$50K deals, his overall win rate jumped from 38% to 61% in two quarters. Revenue grew 40% because they stopped wasting time on deals they couldn't close.
Your pricing ceiling isn't permanent. You can raise it by changing your sales process, hiring different talent, or building new capabilities. But you can't raise it by pretending it doesn't exist.
This analysis shows you where you are today. What you do with that information determines whether you build a scalable revenue engine or keep grinding through inefficient deals wondering why growth is so hard.
Your revenue doesn't have a people problem. It has a structure problem. I've watched operators spend $150K on bad hires before they'd spend $5K on getting the system right. Run the SalesFit assessment first →
Step 5: Analyze Loss Reasons by Deal Size Tier
Your loss reasons tell you where your ceiling actually sits. I've seen teams celebrate a 40% win rate while bleeding out on deals over $75K because they never looked at why they lost by tier.
Most CRMs let you tag loss reasons. Pull every loss from the past 12 months and sort them by your deal size tiers. You're looking for patterns that reveal whether you're losing on price, positioning, or capability.
Group Loss Reasons into Categories (Price, Competitor, No Decision, Capability Gap)
Create four buckets. Price objections are straightforward: "too expensive," "budget constraints," "ROI unclear." Competitor losses mean they picked someone else. No Decision means they ghosted or stayed with status quo. Capability Gap means you couldn't deliver what they needed—wrong features, missing integrations, lack of industry experience.
I worked with an operator running a marketing agency who thought he had a pricing problem. His $15K–$30K tier had a 38% win rate. His $50K+ tier dropped to 19%. When we coded his losses, 61% of high-tier losses were Capability Gap—prospects needed multi-channel attribution and his team only ran paid media. Not a pricing problem. A service delivery problem.
Tag every loss in your CRM. If your team didn't log reasons, pull the reps in and reconstruct the last 90 days from memory and call recordings. Across 101 teams I've built, the ones who skip this step never find their real ceiling.
Compare Loss Reason Distribution Across Small vs. Large Deals
Build a simple table. Rows are your tiers. Columns are your four loss categories. Fill in the percentage of losses in each bucket.
Your small deals might show 40% Price, 30% Competitor, 20% No Decision, 10% Capability. Your large deals might flip to 15% Price, 25% Competitor, 35% No Decision, 25% Capability. That distribution tells you everything.
If No Decision spikes in higher tiers, your sales process isn't built for complex buying committees. If Capability Gap climbs, you're selling beyond what you can deliver. If Competitor jumps, you're in crowded waters without differentiation that matters at scale.
I track this quarterly. When No Decision in our $100K+ tier hit 42%, I knew our reps weren't running multi-threaded deals. We implemented stakeholder mapping and dropped No Decision to 23% in 90 days.
Identify Which Objections Spike in Higher Tiers
Look for the objection that doubles or triples as deal size increases. That's your constraint.
If "ROI unclear" shows up in 12% of $20K losses but 38% of $60K losses, your value story doesn't scale. If "chose incumbent" jumps from 8% to 31%, you're not displacing established relationships. If "missing feature X" appears only in top-tier losses, you've hit a product ceiling.
One operator I worked with saw "needs board approval" spike to 47% of losses above $100K. His reps were selling to VPs who couldn't close at that level. We shifted targeting to C-suite, added executive briefing decks, and his win rate in that tier went from 17% to 34% in five months.
Your loss reasons by tier are a diagnostic tool. They show you exactly where to fix your process, positioning, or product to move your ceiling up.
Step 6: Map Sales Cycle Length and Touch Count by Tier
Deal size and sales cycle length should correlate. If they don't, you're either closing small deals too slowly or rushing large deals and losing them.
Pull your won deals from the past year. For each tier, calculate average days from first contact to close and total activities logged. You're looking for the resource cost per tier and where your process becomes inefficient.
Calculate Average Days to Close for Won Deals in Each Tier
Most CRMs give you this in a report. Sort won deals by tier and average the cycle length. Your $10K deals might close in 18 days. Your $30K deals in 34 days. Your $75K deals in 62 days.
If your cycle length doesn't increase proportionally with deal size, something's broken. I've seen teams take 45 days to close a $15K deal and 52 days to close a $60K deal. That's a process problem—they're over-engineering small deals and under-resourcing large ones.
One operator I worked with had a $50K–$100K tier averaging 89 days to close with a 22% win rate. His $20K–$50K tier closed in 41 days at 39%. We mapped his process and found he was requiring the same number of discovery calls and proposal revisions regardless of deal size. We built a tiered sales process—three touches for small deals, seven for large—and his $50K+ cycle dropped to 64 days while win rate climbed to 31%.
Count Activities and Stakeholder Touches Required per Tier
Pull activity counts for won deals: calls, emails, meetings, demos, proposals sent. Break it down by tier. Your $15K deals might need 12 activities. Your $60K deals might need 34.
Now calculate activities per closed dollar. If your $15K deals need 12 touches, that's 800 activities per million in revenue. If your $60K deals need 34 touches, that's 567 activities per million. The higher tier is more efficient—if your win rate holds.
I track stakeholder count separately. How many people were in the buying process for won deals in each tier? Your small deals might involve one decision-maker. Your large deals might involve five. If your reps are only talking to one person in a $75K deal, they're going to lose when that champion gets overruled.
Across 101 sales teams I've built, the ones that scale profitably know their activity-to-revenue ratio by tier. They staff and comp accordingly.
Spot Where Your Process Becomes Inefficient or Stalls
Look for the tier where cycle length jumps disproportionately or where activity count explodes without a corresponding win rate increase. That's your friction point.
If your $30K deals close in 38 days and your $50K deals take 91 days, you've hit a complexity wall. Maybe you're entering enterprise buying processes without the tools to navigate them. Maybe your reps don't know how to run a champion-led deal with multiple stakeholders.
I worked with an operator whose $75K+ deals took 127 days to close on average with a 19% win rate. His $40K–$75K deals closed in 56 days at 34%. We pulled five lost $75K+ deals and found the same pattern: deals stalled in legal review for 40+ days because his contracts weren't enterprise-ready. We hired a contracts specialist, built pre-approved MSA templates, and cut that tier's cycle to 78 days while win rate jumped to 28%.
Your process should scale with deal size, not break under it. If cycle length or activity count spikes without revenue efficiency improving, you've found your operational ceiling.
Step 7: Determine Your Operational Pricing Ceiling and Stretch Zone
Your pricing ceiling isn't where you want it to be. It's where your win rate proves you can consistently close.
You've got your tiers, win rates, loss reasons, and cycle data. Now you draw the line between where you're operationally strong and where you're guessing.
Set Your Ceiling as the Highest Tier with 30%+ Win Rate
Thirty percent is the threshold. Below that, you're burning pipeline and rep capacity on deals you can't reliably win. Above that, you've got a repeatable motion.
If your $20K–$40K tier wins at 37% and your $40K–$75K tier wins at 18%, your ceiling is $40K. That's where you win consistently. Everything above is aspiration, not operation.
I worked with an operator who insisted his product was worth $100K. His data showed a 41% win rate at $30K–$50K, 26% at $50K–$75K, and 11% at $75K+. His ceiling was $50K. He was spending 40% of his sales capacity chasing deals above $75K with an 11% close rate. We redirected that capacity to the $30K–$50K tier and revenue jumped 34% in one quarter without changing team size.
Your ceiling is a fact, not a goal. Acknowledge it. Build revenue there while you work to raise it.
Define Your Stretch Zone (Next Tier Up with 15–30% Win Rate)
The tier just above your ceiling is your stretch zone. You're winning some deals there, but not consistently. This is where you experiment and build capability.
If your ceiling is $40K and your $40K–$75K tier wins at 22%, that's your stretch zone. You're proving you can play there, but you haven't mastered it yet. Allocate 20–30% of your pipeline capacity to this tier. Use it to test positioning, refine your process, and train reps on higher-complexity deals.
I run stretch zone deals differently. I put my best rep on them. I get involved in key calls. I track loss reasons obsessively. Every stretch zone loss gets a post-mortem within 48 hours. What did we miss? What capability did we lack? What would it take to win next time?
Across two decades, I've seen operators try to jump two tiers at once. It never works. You move your ceiling up one tier at a time by mastering your stretch zone first.
Establish No-Go Thresholds Where You Currently Lack Capability
Any tier below 15% win rate is a no-go zone. You don't have the product, process, or positioning to win there. Stop chasing those deals.
If your $100K+ tier wins at 8%, you're wasting resources. Your reps are burning time. Your prospects are getting a bad experience. Your team is learning that losing is normal at high price points.
I worked with an operator whose team kept chasing $150K+ enterprise deals because "one would change the year." His win rate in that tier was 6% over 18 months. Twelve deals, zero closes, 340 days of aggregate sales capacity burned. We implemented a no-go rule: no deals over $100K until we hit 25% win rate at $75K–$100K. Six months later, we'd raised the $75K–$100K tier to 29% and started selectively testing $100K+ again. First deal closed at $130K.
Your no-go threshold protects your team from demoralization and your pipeline from waste. Set it clearly. Enforce it ruthlessly. Revisit it quarterly as your capability grows.
Step 8: Build Your 90-Day Plan to Raise the Ceiling
You've found your ceiling. Now you raise it systematically.
Most operators try to jump tiers by raising prices and hoping. That's not a plan. You raise your ceiling by identifying the specific capability gaps blocking wins in your stretch zone and fixing them one at a time.
Prioritize One Tier Above Your Current Ceiling to Attack
Pick the tier immediately above your ceiling. If you're winning at 36% in the $25K–$50K range and 19% in the $50K–$75K range, your target is $50K–$75K. That's your 90-day focus.
Set a pipeline allocation: 30% of your opportunities should be in this tier. Not 5%, not 60%. Thirty percent gives you enough volume to learn without risking your revenue base.
I worked with an operator whose ceiling was $40K with a 38% win rate. His $40K–$80K stretch zone was at 21%. We committed 90 days to moving that stretch zone to 30%+. We allocated 35% of inbound leads in that range to his two senior reps. We tracked every deal weekly. We hit 32% win rate in that tier by day 87 and moved his operational ceiling to $80K.
One tier. Ninety days. Measurable improvement. That's the game.
Identify the Top 3 Capability Gaps Blocking Higher-Tier Wins
Go back to your loss reason analysis. What are the top three reasons you're losing in your stretch zone? Those are your capability gaps.
If "missing executive alignment" shows up in 34% of stretch zone losses, your gap is stakeholder management. If "ROI unclear" appears in 41%, your gap is value articulation at scale. If "chose competitor X" dominates, your gap is competitive positioning.
Pick three. Not five, not ten. You can't fix everything in 90 days. I prioritize gaps that appear in 25%+ of losses and that I can address with training, process, or positioning changes—not product rebuilds.
One operator I worked with identified three gaps blocking his $60K–$100K tier: reps couldn't navigate procurement, proposals lacked executive-level business cases, and demos focused on features instead of outcomes. We built a procurement playbook, rewrote proposal templates with CFO-friendly ROI models, and retrained demos using the Human-Centric Selling framework. Win rate in that tier moved from 18% to 29% in one quarter.
Set a Target Win Rate Improvement and Track Monthly Progress
You need a number. If your stretch zone is at 19%, target 28% in 90 days. That's a 47% relative improvement—aggressive but achievable if you're fixing real gaps.
Track monthly. Pull your stretch zone win rate at day 30, day 60, day 90. If you're not seeing movement by day 45, your interventions aren't working. Adjust.
I track three metrics in 90-day ceiling-raising sprints: stretch zone win rate, average deal size in stretch zone, and loss reason distribution. If win rate climbs but average deal size drops, reps are cherry-picking easier deals in the tier. If win rate climbs but loss reasons don't shift, you're getting lucky, not better.
Across $500M+ in client revenue, the operators who raise their ceilings fastest treat it like a product sprint. Clear target. Specific interventions. Weekly tracking. Ruthless iteration. Ninety days later, they're selling at a tier they couldn't touch before.
Your ceiling isn't fixed. But you don't raise it by wishing. You raise it by diagnosing exactly why you lose at the next tier up and systematically building the capability to win there.
Stop letting your pipeline decide your ceiling. Every operator I've worked with had the same problem — not a revenue problem, a structure problem. Book a revenue architecture session →
