Win/Loss Analysis Report Generator
By Adam Weinroth
Your sales team closes (or loses) dozens of deals each quarter, but the insights from those outcomes never make it back to marketing in a structured way. You need to synthesize CRM notes, call transcripts, and deal data into a clear win/loss report that reveals messaging gaps, objection patterns, and competitor weaknesses, without spending a full week on manual analysis.
Estimated Time Savings
7 hours
saved per use
Why this tool?
Cowork is ideal for this recipe because it handles file uploads and persistent project context. You can upload an entire CRM export, and Claude maintains context across multiple follow-up questions — perfect for iterative analysis of complex deal data.
Step-by-step workflow
- 01
Export deal notes, call summaries, and outcome data from your CRM for the last quarter (focus on closed-won and closed-lost deals).
- 02
Upload the deal data to a Cowork project and ask Claude to categorize each deal by outcome, deal size, industry, and competitor involved.
- 03
Prompt Claude to identify the top 5 reasons deals were won and the top 5 reasons deals were lost, citing specific evidence from the notes.
- 04
Ask Claude to generate a competitive breakdown: which competitors appeared most often in losses, and what messaging or features were cited as differentiators.
- 05
Have Claude draft an executive summary with 3-5 actionable recommendations for marketing: messaging updates, new content assets needed, and objection-handling scripts.
Example prompts
You are a senior marketing strategist conducting a quarterly win/loss analysis. I've uploaded our CRM export with deal notes from Q4. For each deal, you have: outcome (won/lost), deal size, industry, competitor mentioned, and rep notes. Please: (1) Identify the top 5 win themes and top 5 loss themes with supporting quotes from rep notes, (2) Create a competitor frequency table showing which competitors appeared in lost deals and why, (3) Recommend 3-5 specific actions for our marketing team — including messaging changes, content gaps to fill, and sales enablement materials to create.
What to expect
A polished executive report with three sections: (1) Win/Loss Theme Analysis with ranked themes and evidence quotes, (2) Competitive Landscape table showing competitor frequency, cited strengths, and your vulnerabilities, (3) Marketing Action Plan with prioritized recommendations, each tied to specific deal evidence. Ready to share with leadership or drop into a quarterly business review deck.
Keep Exploring
Related recipes
Customer Interview Synthesis & Persona Builder
ABy Anthro Marketing
You've completed 8-12 customer interviews but the synthesis is sitting in a shared drive collecting dust. You need actionable personas and messaging recommendations.
Marketing Budget Reallocation Optimizer
By Adam Weinroth
Every quarter, your marketing team debates where to shift budget — but the decisions are driven by gut feel instead of data. You have channel performance data scattered across platforms, and building a proper budget optimization model in a spreadsheet would take your ops team a week. You need to quickly analyze spend vs. performance across all channels and generate data-backed reallocation recommendations.
SEO Content Gap Analyzer
By Adam Weinroth
You know your competitors are ranking for keywords you're missing, but manually auditing their content libraries against yours takes forever. You need a systematic way to identify high-value content gaps—topics your competitors cover well that you haven't addressed—and turn them into a prioritized content roadmap with estimated traffic potential.