PROMPT BRO
Customer service desk

A satisfaction survey and response summary

Survey says 'quick question'. It has eighteen mandatory fields.

Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files

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

Prepare anonymous responses

Use random response codes, rating and topic; remove identifiable comments.

First time? Try it on fake data first:

Privacy Remove customer phone numbers, addresses, payment details and personal identifiers. Use ticket/order refs instead.

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

Rating scale: [Rating scale] Survey goal: [Survey goal] I'm attaching satisfaction.xlsx. A. Four neutral survey questions, two ratings and two open questions. B. Count valid ratings, missing ratings, average valid ratings and supplied topic counts; blank topic Unknown. C. Facts and suggested improvements, no invented quotes or representative claims. 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.

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)
5responses
3.50mean / 5
1missing rating
  • Updates2 mentions. Check status communication.
  • R5Rating missing. Exclude from mean.
  • R4Topic unknown. Do not guess.
Before you trust it

Then send this: Recalculate valid mean and counts, check topics and no invented quotes.

If it goes wrong
Blank counted zero

Reply: "Exclude blank."

Claims all customers

Reply: "Only this sample."

Invents quotes

Reply: "Use supplied comments only."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?