wowprompt

Service counter wait time analysis from token or queue logs

Uses token or queue system logs to measure how long people wait and how long service takes at each counter, finds the hours when queues build, and works out how many counters or staff each hour needs to keep waits under a target. Use it for clinics, bank branches, service centres, labs, RTO-style offices and quick-service restaurants.

Wait and service time by hour and counter, a heat table of when queues build, the counters needed each hour to meet a wait target, and staffing changes
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Place and what is served: [e.g. a diagnostic lab with three sample collection counters]
  • Queue log: [paste rows: token number, service type, time issued, time called, time service ended, counter]
  • Days covered: [e.g. two full weeks]
  • Opening hours and counters open by hour: [paste]
  • Wait time target: [e.g. 90 percent of people called within 15 minutes]

Task

Show where and when waits go wrong and what staffing would fix them.

Steps

  1. Wait time is time called minus time issued; service time is time ended minus time called.
  2. Median and 90th percentile of each, by hour of day, day of week, service type and counter.
  3. Arrivals per hour against people served per hour to find when the queue grows.
  4. Counters needed each hour so service capacity covers arrivals with the target met.

Output format

  1. | Hour | Arrivals | Median wait | 90th percentile wait | Counters open | Counters needed |
  2. A day by hour heat table of the 90th percentile wait.
  3. Service types or counters that take much longer than the rest, with possible reasons.
  4. Five changes ranked by effect: staffing by hour, a separate counter for quick services, appointments, pre-filled forms, or others the data supports.

Rules

  • Exclude tokens never called from wait times and report them as walk-aways.
  • Show the method used for counters needed in two or three lines.
wait time analysisqueue analysistoken system datacounter staffingservice time analysiscustomer waiting time

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity