wowprompt

Customer complaint log analysis by issue, product and resolution time

Groups a complaint log into clear issue types, finds the products, channels and teams behind most of them, measures how long each type takes to close, and ranks fixes by impact. Use it for a monthly quality review or before deciding where to spend on support and product fixes.

A table of complaint types with counts, share, median resolution time and repeat rate, a list of top products by complaints, and five ranked fixes
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Complaint log: [paste rows: date, product or service, channel, complaint text or category, date closed, outcome]
  • Period: [e.g. 2026-07-01 to 2026-09-30]
  • Orders or customers in the same period: [total, so complaint rates can be worked out, or unknown]
  • Current categories, if any: [list, or none]
  • Promised resolution time: [e.g. 48 hours]

Task

Find what customers complain about most, what takes longest to fix, and which fixes would remove the most complaints.

Steps

  1. Sort every complaint into 6 to 10 issue types written in plain words, such as "late delivery" or "wrong size sent". Merge near-duplicates.
  2. Work out count, share of total, complaint rate per 1,000 orders if orders are given, median days to close and share closed late.
  3. Find repeat complaints from the same customer or about the same order.
  4. Cross the top three issue types with product and channel to find where they concentrate.

Output format

  1. Five-bullet summary with the biggest numbers first.
  2. | Issue type | Count | Share | Per 1,000 orders | Median days to close | Closed late |
  3. Top five products or services by complaint count, each with its main issue.
  4. Five fixes ranked by complaints removed, each with the owner team and an effort level of low, medium or high.
  5. Three numbers to track monthly from now on.

Rules

  • Quote no customer names, phone numbers, emails or order numbers.
  • If a complaint text is unclear, put it in "Unclear" rather than guessing a type.
  • Base every rate on the counts pasted and state the sample size.
complaint analysiscustomer complaints reportresolution timeissue categoriesquality reviewsupport data analysis

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