PROMPT BRO
Sales desk

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

By handRarely done
With AI20 min
Each time · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Get the lost deal export

Use deal ID, value, supplied reason and rep note. Do not infer why a buyer declined.

First time? Try it on fake data first:

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.

Fill the orange boxes
You send (the "prompt": the message you paste into your AI tool)
lost-deals.xlsx

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.

What you'll get back (example, from the practice files)
5lost deals
₹1.8 Lknown value
2reason gaps
  • 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.
Before you trust it

Then send this: Recount reason groups, sum known values and reconcile to overall count; confirm missing reason and amount are flagged.

If it goes wrong
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?