Lost deal reasons and follow-up actions
Lost reason: 'Price'. The notes field contains exactly the same word.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Get the lost deal export
Use deal ID, value, supplied reason and rep note. Do not infer why a buyer declined.
Confirm reporting period
Use the same period and stage definition across all rows.
Privacy Remove phone numbers, email IDs and payment details where not needed. Use only approved business names and facts.
I'm attaching lost deals for [Period]. Basis: [Value basis]. A. Count deals and sum quoted value by recorded reason; blank reason = Unknown. Flag missing amount; show known totals only. B. List most frequent recorded reasons, unknowns and examples by deal ID. Do not turn a rep's guess into a confirmed customer reason. C. Separate factual observations from three suggested follow-up actions for sales review. No fake competitor claims or blame. Use only supplied facts. Never invent customer names, testimonials, urgency, prices, discounts, delivery dates or credit terms. A person reviews before sending or deciding.
Which model? Use your tool's strongest model with thinking turned on.
In your AI tool: attach the files with the + button, paste, send.
- Price2 deals, ₹90,000. Recorded reason; verify what customer actually said.
- D4Reason missing. ₹40,000; ask rep for evidence.
- D5Value and reason missing. Exclude from value total; retain deal count.
Then send this: Recount reason groups, sum known values and reconcile to overall count; confirm missing reason and amount are flagged.
It guesses reason
Reply: "Unknown stays Unknown."
It counts missing value zero
Reply: "Show partial known total."
It blames rep
Reply: "Describe evidence and process questions only."
Sir ne bola urgent. Ab bolo: ho gaya.
Did it work?
Doing this every week? Save it once.
Save the prompt in your AI tool, so next time you only drop the files in. Pick your tool at the top to see how.
What is that?
A Project is a folder in ChatGPT that keeps your instructions and files for every chat inside it. It's on the free plan too. Checked 14 Nov 2026.
What is that?
A Project in Claude is a workspace with its own instructions and files that every chat inside it uses. Checked 14 Nov 2026.
What is that?
A Gem is a custom Gemini that loads your instructions before every chat. Free on every plan; you create it on a computer. Checked 14 Nov 2026.
What is that?
Signed in with a work account, Microsoft's Copilot Chat applies enterprise data protection: your prompts aren't used to train its models. Checked 14 Nov 2026.
If your whole team does this, we'll set it up for all of them in one session.