Find lapsed customers and draft win-backs
Customer stopped buying. The CRM still says 'active'.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Get purchase history summary
Use business customer code, last purchase date and opt-out; keep personal contact details local.
Privacy Remove customer phone numbers, addresses, payment details and personal identifiers. Use ticket/order refs instead.
As on: [As on] Lapsed after days: [Lapsed after days] Approved offer: [Approved offer] I'm attaching winback.xlsx. A. Calculate days since purchase, flag at least threshold, missing dates and opt-outs. B. List eligible, not due, unknown and opt-out; count each once. C. Short (up to 6 lines) win-back template per eligible code, using approved offer only. Use only supplied facts and policy. Never admit legal liability or promise refund/replacement unless approved policy permits and an authorised person confirms. No invented dates, prices or outcomes. A person checks before sending or deciding. Line limits count body lines only, not subject, greeting or sign-off. Keep every required fact; if they do not fit, say so instead of dropping one.
Which model? Use your tool's strongest model with thinking turned on.
In your AI tool: attach the files with the + button, paste, send.
Keep your actual records in your own workbook; ask AI for the local method using headings and rules only.
Excel A:C customer code, last purchase date, opt-out. As on [As on], lapsed after [Lapsed after days] days. Give age formula and eligibility flag for no opt-out and threshold, unknown date separate; FILTER eligible rows and counts. Keep contact mapping local; no auto-send. Tell me exactly where to paste formulas or set up the local steps. Use fictional examples only; do not ask for actual customer, employee or vendor records.
Run the method locally; verify every exception against source records and obtain approval before acting.
- C1105 days. Eligible.
- C3Opt-out. No message.
- C4Unknown. Check history.
Then send this: Recheck ages and opt-outs; no invented incentive or past purchase.
Contacts opt-out
Reply: "Exclude opt-out."
Adds discount
Reply: "Only catalogue offer."
Guesses last date
Reply: "Mark unknown."
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.