PROMPT BRO
Customer service desk

Response times and open ticket gaps

Response time report is late. The irony has been noted.

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

By hand1–2 hrs
With AI10 min
Per week · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Export ticket times

Use ticket ref, received time, first reply time and close time in same timezone; blank means not recorded.

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)
response-times.xlsx

Whenever I send the next set of details, use this format. First reply target minutes: [First reply target minutes] Period: [Period] I'm attaching response-times.xlsx. A. Compute first reply minutes and close minutes from timestamps, hold negative or missing values; blank close means open. B. Count valid first replies, above target, missing/invalid, open; average valid first replies. C. List ticket refs and questions for manager. 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.

Set it up once. Save the approved rules and output format, without customer records. Pick your tool at the top to see how.

After that, each time: send the next masked details and current policy, then check the result.

First time? Try it in a normal chat: paste and send.

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)
3valid replies
60 minmean reply
1above target
  • T2120 min. Above 60-minute target.
  • T4No reply time. Unknown; not zero.
  • T5Negative time. Check export.
Before you trust it

Then send this: Recalculate minute differences and mean; check negative and missing values.

If it goes wrong
Treats blank as zero

Reply: "Exclude unknown."

Negative duration

Reply: "Hold invalid timestamps."

Includes closed only

Reply: "Check first reply regardless of close."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?