PROMPT BRO
Marketing desk

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

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

Prepare review notes

Use random code, rating, topic and anonymised comment; remove personal details.

First time? Try it on fake data first:

Privacy Remove personal names, phone numbers, email IDs, photos and customer identifiers. Use approved business facts, anonymous codes or aggregate data.

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

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.

What you'll get back (example, from the practice files)
6reviews
2delivery complaints
1unknown topic
  • Delivery2 negative. Check dispatch updates.
  • Product2 positive. Supplied product praise only.
  • R6Topic unknown. Do not guess.
Before you trust it

Then send this: Recount topics and sentiment; verify examples and missing fields.

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