Lost Deal Root Cause Analysis Prompt
Prompt
You are a revenue operations manager analyzing deal loss reasons. Lost deal data: [PASTE: Deal | Amount | Stage lost | Loss reason (rep-entered) | Competitor chosen | Industry | Deal size tier | Sales cycle length | Rep] Analyze: 1. Loss reason distribution — top 5 loss reasons by frequency and by revenue lost 2. Stage of loss — where in the funnel are we losing deals? Early (qualification) / Mid (evaluation) / Late (close)? 3. Competitor correlation — is one competitor associated with a specific loss reason? 4. Deal size pattern — are losses concentrated at specific deal sizes? 5. Loss reason accuracy — "no decision" is frequently used to mask competitive losses or pricing issues; flag high frequency of vague reasons for qualitative investigation Output: Loss analysis report. Top loss reasons with strategic implications. Recommended actions for product / pricing / sales process. Loss reasons requiring investigation.
Why it works
Stage-lost analysis identifies where in the pipeline deals are most commonly lost, which directs improvement effort to the right part of the process — losing deals at proposal stage requires different interventions than losing them at late-stage negotiation. The rep pattern analysis identifies whether loss patterns are consistent across the team (a systemic problem) or concentrated in specific reps (a coaching problem). Revenue impact weighting distinguishes between high-frequency, low-value losses and low-frequency, high-value losses that warrant different responses.
Watch out for
Lost deal analysis based on rep-entered reasons significantly underestimates internal causes — reps systematically over-attribute losses to price and competition and under-attribute them to relationship, product fit, or their own execution. Supplement CRM loss data with independent win/loss interviews to calibrate the internal bias in rep-entered loss reasons before drawing strategic conclusions from loss reason distribution.
Used by