Win Loss Analysis: A Practical Guide and Template

Win loss analysis investigates why buyers chose your offer, chose another option, or made no purchase. Combine closed-deal records with direct buyer feedback, then look for patterns you can test. A CRM outcome tells you what happened; it does not establish every reason behind the decision.

This guide is for B2B founders and sales managers with about 5 to 20 reps. It gives you a process, interview questions, a win loss analysis template, and simple calculations. It also explains how Ask Quokka's won and lost history can inform a review of an open deal.

Start with one question about the sales process

Choose the decision the analysis should inform. You might want to understand why qualified prospects stop after a proposal, whether a competitor changes the buyer's criteria, or why renewal opportunities take longer. A specific question helps you select the right deals and avoid a report nobody uses.

Define the population before reviewing individual stories. For example, choose closed opportunities from a set period, product, or customer segment. Keep the definition stable so the comparison covers the same kind of sales opportunity.

Look at both wins and losses. Winning deals can show what buyers valued, while a lost deal can reveal a mismatch or a gap in sales execution. Studying only disappointed buyers misses the reasons people chose you.

The Qualtrics explanation of win/loss analysis emphasizes post-decision feedback alongside CRM information. Use that distinction throughout the review. The rep's interpretation and the buyer's perspective are separate evidence sources.

Clozd's guide, updated in August 2026, reports that buyer and seller explanations for lost deals aligned only 15% of the time in its research. That implies an 85% mismatch. It is a vendor-reported observation about those explanations, rather than proof that 85% of every company's CRM records are wrong.

The useful lesson is to check the recorded reason against direct buyer feedback. Keep both accounts when they differ and investigate the difference. A closed-lost label identifies an outcome; the buyer can explain the decision behind it.

How to conduct win loss analysis

1. Define wins, losses, and no decision

A win should have a clear commercial outcome, such as a signed agreement. Define a loss just as carefully. A prospect choosing a competitor and a prospect postponing the purchase may require different responses from your team.

Keep a separate no-decision category if your records support it. Explain whether you include those deals in the loss count for your headline calculations. The choice affects the number, so the report needs to state the rule.

An opportunity still open is not a closed loss because it has gone quiet. Record uncertainty separately and inspect the next action. The closed-deal sample should contain outcomes that fit the definition you agreed.

2. Collect CRM data and its source

Collect outcome, close date, owner, deal size, segment, product, and the sales cycle where available. Include the recorded loss reason, but keep it labeled as an internal reason until it is supported. Add links to relevant emails, proposals, or interview notes.

Check the completeness of the record before calculating patterns. A missing competitor field is different from a confirmed absence of competition. An unknown amount should stay unknown rather than becoming a guessed value.

Use comparable time periods and deal types. Enterprise deals and smaller projects may have different approval processes and sales cycle lengths. Combining them without a segment view can hide what your team needs to change.

3. Choose a representative sample

Start with the full set of eligible closed deals, then select across wins, losses, owners, segments, and deal sizes. Include ordinary deals as well as memorable ones. Letting reps choose only the stories they want to discuss can distort the review.

Track which buyers you invited and which responded. Interview feedback can be useful without representing every buyer. A small response set should stay visible beside the findings.

If one segment has only a few deals, describe those as cases to investigate. Don't present a handful of conversations as a stable market pattern. Keep the count with any percentage or theme.

4. Gather direct buyer feedback

Speak with buyers after the decision, while the evaluation is still reasonably fresh. Include people involved in the choice, not only the contact who was easiest to reach. Explain why you want the feedback and how you intend to use it.

Use a neutral interviewer where practical. A person who sold the deal may find it harder to hear criticism, and the buyer may soften their answer. Clozd's discussion of interview design explains the value of a neutral third party and a transparent process.

Keep the interview about the decision. It is not another attempt to close the opportunity. Ask follow-up questions when a buyer's answer is unclear, and avoid defending the pitch while they are explaining it.

5. Categorize findings without erasing the detail

Use a short set of categories that fit your business. Examples include fit, perceived value, timing, implementation concerns, the buying process, and sales experience. Allow more than one factor when the buyer describes a combined decision.

Keep the underlying wording in the buyer's own words, with permission to retain and share it as appropriate. A category such as Price can hide different issues. The buyer may mean a limited budget, an unclear value proposition, or concern about the cost of implementation.

Separate what the buyer said from what the team inferred. Write down competing explanations when the evidence is mixed. The purpose is to identify patterns, not make every deal fit one simple story.

6. Compare patterns and decide what to test

Compare buyer feedback with internal CRM reasons. Look for themes repeated across comparable opportunities. Then identify the change, owner, and result you will inspect.

A pattern can suggest a test without proving a cause. If lost prospects repeatedly mention unclear implementation work, try a clearer explanation of that work. Don't assume it is the only reason they did not buy.

Share the findings with the relevant internal teams. Sales enablement may need a new resource, product may need to assess a feature gap, and marketing may need clearer positioning. Keep the source evidence available to each team.

Win loss interviews: Understand the buyer's evaluation criteria

Ask open questions first. Let the buyer describe the evaluation before introducing the categories in your internal report. Their priorities may differ from the ones the sales team assumed.

Use these questions as a starting point.

1. What problem were you trying to solve when you began looking?
2. Which options did you consider, including keeping the current approach?
3. What mattered most when comparing those options?
4. Who influenced the decision, and what did each person need to know?
5. At what point did your preferred option become clearer?
6. What made our offer easier or harder to evaluate?
7. Which information was missing, unclear, or late?
8. What would you want a team like ours to do differently next time?

Use follow-up questions to understand the meaning of an answer. If the buyer says the offer felt risky, ask which part created the concern. If they say the competitor fit better, ask which evaluation criteria mattered.

Discuss wins with the same care as losses. Ask the winning buyer what nearly stopped the purchase and what increased their confidence. Praise alone does not tell you which parts of the sales approach are worth repeating.

For a no-decision outcome, ask why the purchase stopped or moved. A buyer who chose to wait may have faced an internal constraint unrelated to your competitive positioning. Record that distinction before changing the pitch.

Win loss analysis template

Copy this structure into a spreadsheet or document. Each row represents one closed opportunity. Use links or references for evidence instead of relying on a short label alone.

Add a separate summary tab for counts by outcome, segment, and theme. Keep the source rows available behind the summary. A theme count should be traceable to the deals included in it.

Use one row per deal even when you interview several people. Keep each person's feedback attached to that row. Otherwise the most interviewed opportunity can appear to represent several independent sales deals.

Calculate win rates and the win-loss ratio

Two common calculations answer different questions. State the denominator so another person can reproduce the result. Keep no-decision handling visible.

The win rate is:

Won deals / (Won deals + Lost deals) x 100

The win-loss ratio is:

Won deals / Lost deals

For a fictional worked example, suppose a defined cohort has 12 won deals and 8 lost deals. The win rate is 12 / 20 x 100 = 60%. The win-loss ratio is 12 / 8 = 1.5, or 1.5 wins for each loss.

If the same cohort also has 5 no-decision outcomes, state whether they belong in your headline denominator. Including them as non-wins gives 12 / 25 x 100 = 48%. That is a different calculation, not evidence that the underlying outcomes changed.

If there are no losses, the ratio has a zero denominator. Report the win and loss counts rather than forcing a numeric ratio. Small samples also need their counts shown beside the percentage.

Deal-count win rate and revenue-weighted results differ. A small number of larger wins can produce substantial revenue even when the count-based win rate is lower. Choose the measure that matches the question, and explain how much revenue the calculation includes.

Turn customer feedback into a cross-functional program

In its 2025 State of Win-Loss findings, Clozd reports that 63% of companies with programs saw increased win rates. It also reports that 97% planned to maintain or increase their investment. These are the vendor's reported program findings, not a guaranteed improvement for a new program or a result demonstrated by Ask Quokka.

A review should end with a defined action, not only a presentation. Choose a small number of changes the team can maintain. Assign an owner and decide when to inspect the result.

Identify strengths and gaps in sales execution

If buyers describe unanswered questions, unclear handoffs, or late information, review the part of the sales process that produced those experiences. A better checklist or earlier stakeholder conversation may be a useful test. Keep the buyer evidence beside the proposed change.

Sales performance should be assessed across comparable opportunities. A rep with difficult enterprise deals may face different conditions from someone selling short projects. Use the findings for coaching and process improvement before treating them as a ranking of people.

Use competitive intelligence to sharpen the explanation

Competitor mentions can show which alternatives buyers considered. They do not establish that every loss had the same competitor or cause. Inspect what the buyer valued about the alternative and how your offer was understood.

Compare the stated decision criteria with your positioning. Buyers may value a feature you barely explained, or struggle with a claim your team considers obvious. Use those findings to test marketing messaging and the sales explanation.

Review product fit and the sales experience

Feature gaps can inform product priorities, but a single request should not automatically become the roadmap. Check how often the gap appears, the affected segment, and whether the requested change addresses a wider problem. Include the uncertainty in the recommendation.

Customer success can add context about what happens after a won deal. A capability that helped win the sale may create onboarding expectations the delivery team needs to know. Share relevant feedback so the promise and experience stay connected.

Keep an ongoing win loss program

Set a review cadence that fits your deal volume and sales cycle. Repeat the same cohort definitions and categories where possible. If the definitions change, record the change before comparing the next period.

Include a sponsor who can help the team act across departments. A small team may need only one founder and the relevant owners rather than a large committee. Organizational support matters when a finding requires work beyond the sales team.

Monitor the chosen outcome after a change. Future win rates can move for reasons other than your intervention, including a different segment mix or market conditions. Compare like with like and avoid presenting correlation as causal proof.

Report key findings with their evidence

A useful summary turns win loss data into decisions without hiding its limits. State the cohort, the number of buyers invited, the number who responded, and which deal groups the feedback covers. Keep the structured data and interview notes behind each finding.

Separate themes from different evidence sources. A sales call may reveal the questions discussed before the decision; qualitative buyer interviews reveal how buyers describe that decision afterward. Both are useful, and their explanations may differ.

Use one-on-one conversations to collect real buyer feedback in the buyer's own terms. An interviewer can ask what a general phrase means without leading the answer. Third-party interviews can reduce some pressures, but don't assume the method produces perfectly unbiased insights.

When sharing buyer insights, explain how buyers perceive the offer and which evaluation criteria they emphasized. Competitive deals need the same care: confirmed alternatives and the buyer's reasons are more useful than guesses about a rival. These win loss insights can inform positioning and competitive strategy while preserving uncertainty.

Make the action specific enough for the go-to-market teams to use. Sales reps might test a clearer explanation; product might assess a recurring fit issue; marketing might revise a confusing claim. A cross-functional sponsor can help the relevant owners identify gaps and agree on the work.

Win loss programs should be a systematic process rather than a one-off project. Choose the next review date and keep the definitions stable. Actionable insights help improve sales performance when the team tests a change and examines comparable outcomes afterward.

Executive sponsorship gives the program someone who can resolve priorities across teams. Ask the sponsor to help allocate time or resources to the most consequential supported finding. Keep the proposed change, evidence, and expected review beside that request so investment follows the analysis.

Use closed-deal findings to ask better questions about active deals. A repeated implementation concern can guide an earlier conversation in the current sales strategy. It does not prove that the same concern determines every open opportunity.

Choose win loss analysis software by the job

Decide whether you need record comparison, buyer interview collection, survey management, or analysis across a larger feedback program. Those jobs use different inputs. A current pipeline record and direct buyer feedback are useful together, but one does not replace the other.

Ask Quokka compares open deals with the deals you already won and lost, including how long won deals usually took. It imports closed-deal history from a CRM export in CSV format, and an import can be undone within 48 hours. That gives a Gmail-based team useful history to inspect when reviewing an active opportunity. See Ask Quokka pricing for the workspace plan that includes this history comparison.

For interviews, dedicated platforms can organize the feedback and its themes. Clozd's decision-driver documentation describes tagging reasons found through interviews and surveys. Check how the chosen tool preserves the buyer's source and separates it from the team's interpretation.

The broader AI CRM software comparison covers record capture and assistance. Our post Every fact needs a receipt explains why source evidence matters. Choose around the information you need to review, rather than assuming every AI feature answers why a deal was lost.

The CRM adoption discussion examines how the way records are maintained affects what the team can trust. Keep that capture process in mind when deciding which internal fields to compare with buyer feedback.

FAQ

How do I do a win loss analysis?

Define the closed-deal cohort, collect records, and gather feedback from both winning and losing buyers. Compare themes across similar opportunities and separate the buyer's explanation from internal assumptions. Assign an owner to each change you decide to test.

How do I make a win/loss record in Excel?

Use one row per closed opportunity with outcome, date, segment, amount, internal reason, buyer feedback, and source. Add categories and an action owner after reviewing the evidence. Keep the original records available behind any summary table.

How is win loss calculated?

A win rate divides wins by wins plus losses and multiplies by 100. A win-loss ratio divides wins by losses. State how no-decision outcomes are treated and show the underlying deal counts.

What is a good win-loss ratio?

A useful comparison depends on the segment, deal size, sales cycle, and which opportunities qualify for the calculation. Start with a consistent definition and your own history. A higher ratio is not enough to judge sales effectiveness if the value or mix of deals changed.

Try Ask Quokka free

Use your closed-deal history to inspect the open pipeline built from Gmail. Get started free. Free for everyone during the current promotion. Normally $49/month for your whole team. No card, subscription or trial expiry.