Win/Loss Analysis · Worksheet

Win/Loss Analysis Template for Notion Users

Four linked databases in Notion that convert win/loss interviews into structured, searchable findings. The specific schema, the cross-database relations, and the one view that makes the quarterly synthesis fast.

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

Notion is the home for most small-company strategic work, and win/loss analysis belongs in the same workspace as the positioning brief, the messaging framework, and the battle cards. The four-database setup below is the minimum viable structure that keeps win/loss data useful instead of buried.

The four databases

The four linked Notion databases

    Findings relate many-to-many with Interviews (one finding can come from multiple interviews; one interview produces multiple findings). Themes relate many-to-many with Findings (one theme aggregates multiple findings; one finding may support multiple themes). Actions relate one-to-many with Themes (an action usually addresses one theme, though some themes generate multiple actions).

    The linkage is what makes the system work. A reader landing on a Theme can see every finding that supports it, and every interview those findings came from. A reader landing on an Action can trace back to the theme, to the findings, to the interviews — the full evidence chain.

    The one view that makes the quarterly synthesis fast

    Create a view on the Findings database filtered by: (a) created in the trailing 90 days, (b) confidence = high, (c) theme = empty. This view shows "uncategorized high-confidence findings" — the things interviews have surfaced that haven't yet been clustered into themes.

    The quarterly synthesis ritual: open this view, cluster the uncategorized findings into themes (either existing or new), route to actions. Ninety minutes. Done.

    The three filters worth building

    Beyond the synthesis view, three filters produce most of the day-to-day value.

    Filter 1: Findings by competitor. Pull every finding tagged with a specific competitor's name. This is your real-time competitive intelligence feed.

    Filter 2: Open actions by owner. Pulls the action items each team owns. Used in weekly team standups to track win/loss-derived work.

    Filter 3: Themes by status. Separates emerging themes (needing more data) from confirmed themes (ready for action) from resolved themes (archived). Prevents the theme database from becoming a graveyard.

    The setup takes 30 minutes. Populating the first five interviews takes another 30. By interview twenty, the system is producing insights the team would have missed otherwise. The four-database structure is what separates Notion-based win/loss from a folder of meeting notes that nobody reads — which is where most Notion-based win/loss ends up without explicit structure.

    Related Stratridge Tool

    Win/Loss Review

    Turn every lost deal into something your team can actually act on.

    Win/Loss Review takes your lost-deal notes and turns them into objection patterns, rebuttal suggestions, and positioning gaps — then writes the learning back to Strategic Context so the next deal benefits from it.

    • Surfaces patterns across lost deals, not one-off anecdotes
    • Generates rebuttal suggestions from real objections
    • Feeds findings back into your strategic memory
    Analyze your losses →
    The Stratridge Dispatch

    One sharp B2B marketing read, most Thursdays.

    Practical frameworks, competitive teardowns, and field observations across positioning, messaging, launches, and go-to-market. Written for working CMOs and PMMs. No listicles. No vendor roundups. Unsubscribe whenever.

    Keep reading