How to Do a Win-Loss Analysis (Questions, Template, and Steps)

What is a win-loss analysis?

A win-loss analysis is a process for finding out why prospects bought from you or did not. You pick a set of recently decided deals, talk to the buyers, record their reasons in a consistent way, and look for patterns you can act on in your offer, your pricing, your messaging, or your sales process.

My strong opinion: the reason a salesperson writes in the CRM after a lost deal is usually the least useful data you have. "Price" is the default answer because it is easy to say and hard to argue with. When you actually ask the buyer, price often turns out to be a stand-in for something else, like not seeing enough value, not trusting the timeline, or a competitor who simply followed up faster.

Win-loss analysis vs reviewing lost deals

A lost-deal review is something one salesperson does after a single no, to learn and move on. How to Handle Rejection in Sales (and Learn From Every No) covers that habit. A win-loss analysis is bigger and more structured: it covers wins and losses, it uses the buyer's own words, and it looks across many deals at once so you can see what is really driving results.

How to do a win-loss analysis step by step

1. Pick the deals. Choose recently decided deals, both won and lost, that reached a real proposal or decision stage. Skip leads that never qualified; How to Qualify Sales Leads (Questions, Scoring, and When to Walk Away) is the place to fix those.
2. Contact buyers soon after the decision. Memories fade fast. Send a short, friendly request for a 15 to 20 minute call, and make it clear you are not trying to reopen the sale.
3. Have someone other than the salesperson run the call if you can. Buyers are more honest with a neutral person, such as the owner or someone from operations.
4. Ask open questions and listen. Use the question list below. Follow up on vague answers with "Can you tell me more about that?"
5. Pull the deal data. Note deal size, how long it took, which offer, the source of the lead, and who the competitor was, if any.
6. Code the reasons. Tag each deal with one main reason and any secondary reasons from a fixed list, such as value, price, trust, timing, product fit, competitor, or sales experience.
7. Look for patterns. Count how often each reason shows up in wins versus losses, and by lead source, offer, or deal size.
8. Turn the top patterns into changes. One owner, one change, one date per pattern. Then check the next batch of deals to see if it worked.

Win-loss interview questions to ask

Use the same core questions for every call so the answers are comparable. Pick six to eight, not all of them.

• What was going on in your business that made you start looking for a solution?
• What other options did you consider, including doing nothing or doing it yourselves?
• What mattered most to you when you made the decision?
• How did we compare with the other options on the things that mattered most?
• Was there a moment in the process when you leaned toward one option? What happened?
• What almost stopped you from choosing the option you chose?
• How did you feel about the price compared with the value you expected?
• How was the experience of working with our salesperson?
• What could we have done differently?
• Is there anything I have not asked that I should have?

Many of these mirror good discovery questions, which is no accident. How to Run a Discovery Call That Leads to a Clear Yes or No helps you ask the same things earlier, before the decision is made.

Win-loss analysis template

A spreadsheet with one row per deal is enough. Use these columns.

1. Deal name and date decided.
2. Outcome: won, lost, or no decision.
3. Deal size and offer.
4. Lead source.
5. Competitor or alternative chosen, including doing nothing.
6. Main reason code from your fixed list.
7. Secondary reason codes.
8. Best buyer quote, in their exact words.
9. Salesperson.
10. Action taken, if this deal led to a change.

Keep the reason code list short, around six to eight codes. If you have twenty codes, every deal looks unique and no pattern ever shows up.

Win-loss analysis mistakes to avoid

• Only reviewing losses, so you never learn what is working.
• Relying on the salesperson's notes instead of asking the buyer.
• Waiting months to call, when the buyer no longer remembers why they decided.
• Using the call to try to win the deal back. Buyers can tell, and they stop being honest.
• Changing your offer or price because of one loud buyer instead of a pattern across several deals.
• Collecting answers and never acting on them. Track each change and check it against your numbers in Sales KPIs for Small Business: What to Track and How to Calculate Each One.

When a pattern points at a specific step, fix that step in How to Create a Sales Process for a Small Business (Steps and Template). When it points at what buyers push back on, update your responses using How to Handle Sales Objections Without Sounding Pushy.

How to analyze win-loss notes with Claude

Claude is good at the slow part: reading through a pile of call notes and pulling out themes. Use the Claude desktop app with your spreadsheet export and call notes.

1. Remove anything sensitive you do not need, then paste in your call notes or transcripts along with your reason code list.
2. Ask Claude to tag each deal with a main reason and secondary reasons from your list only, and to quote the line from the notes that supports each tag.
3. Ask it to count reasons for wins versus losses, and to break them down by lead source, offer, and deal size.
4. Ask it which patterns rest on only one or two deals, so you do not overreact to them.
5. Check a handful of the tags against the original notes yourself, then pick the top one or two changes to make.