Find praise and complaints in reviews
Reviews say 'good' and 'bad'. The report needs slightly more detail.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Prepare review notes
Use random code, rating, topic and anonymised comment; remove personal details.
Privacy Remove personal names, phone numbers, email IDs, photos and customer identifiers. Use approved business facts, anonymous codes or aggregate data.
Period: [Period] Counting rule: [Counting rule] I'm attaching review-mining.xlsx. A. Count reviews by topic and positive/negative supplied sentiment; include Unknown. B. Summarise actual themes and anonymous examples; no invented quotes or cause. C. Three suggested improvements and questions for service team. Use only supplied facts. No invented statistics, awards, testimonials, customer names, No. 1, guaranteed, health, finance or legal claims. Do not copy competitor copy or use real people's names or photos. Write regional-language versions only if I request them in a box. A person checks before publishing 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.
- Delivery2 negative. Check dispatch updates.
- Product2 positive. Supplied product praise only.
- R6Topic unknown. Do not guess.
Then send this: Recount topics and sentiment; verify examples and missing fields.
Invents quote
Reply: "Summarise actual text only."
Guesses cause
Reply: "Suggest checks, not cause."
Drops unknown
Reply: "Count 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.