Win/Loss Analysis · Worksheet

Win/Loss Review Template for B2B SaaS

A working template for turning lost and won deals into pattern data — the five questions, the tagging taxonomy, and the one spreadsheet that keeps the loop honest.

4 min read·For all readers·Updated Apr 19, 2026

Win/loss programs fail the same way: the interviews happen, the notes go into a folder, the folder doesn't get read, and the next deal runs as if the last one never closed. The instrument below is designed for the opposite — a fifteen-minute structured interview per deal, a fixed tagging taxonomy, and one sheet that turns the qualitative into patterns the team can act on.

The template covers the minimum viable loop. If you're running a dedicated win/loss program, you need more depth. If you're running nothing today, this is enough to start.

The five questions

Every interview, same order, no deviation. The reason to keep the questions fixed is the whole value is in comparing answers across deals; rewording the question destroys the comparison.

The interview protocol

    Run each interview in twenty minutes. Record (with permission). Have a second person on the call for notes — the AE who lost the deal should not be the interviewer.

    The tagging taxonomy

    Every deal gets tagged against the same five categories. Consistent tags are the difference between a folder of interviews and a data set.

    Five tags per deal, one coachable moment. Ten minutes of work after the interview, no longer.

    The one sheet

    One row per deal, one column per tag. Weekly, the PMM sorts by primary reason and surfaces the three patterns most common in the last twelve deals. Monthly, the same view goes to sales leadership. Quarterly, it feeds the positioning audit.

    What to cut from the template

    There's a version of this instrument with forty fields and a weighted scoring rubric. Skip it. The failure mode of elaborate win/loss templates is the AE refuses to fill them out and the program dies. Five questions, five tags, one coachable moment. If a deal produces more information than fits, write a separate memo — don't expand the template.

    The discipline is the loop, not the instrument. A team running this exact template every week, talking about the patterns every month, will learn more in a quarter than a team running a twenty-page deep-dive on three deals will learn in a year.

    How this feeds other capabilities

    The win/loss sheet is an input to three other places: the battle cards (every "competitor displacement" tag updates the named competitor's card), the positioning audit (every "positioning delta" tag scores against message consistency), and the roadmap (every "product gap" tag with the same feature named twice gets a product-review slot). Stratridge's Win/Loss Review runs this loop automatically against your CRM; the template above is the manual version, and the one worth starting with.

    Related capability

    Win/Loss Review

    Turns lost-deal notes into objection patterns and rebuttals, then writes the learning to Strategic Context.

    See how it works
    The Stratridge Dispatch

    One sharp positioning read, most Thursdays.

    Field-tested frameworks, teardowns, and pattern notes from our working library. No "Top 10" lists. No launch roundups. Unsubscribe whenever.

    Keep reading