Hundreds of customer comments, in six themes with counts and quotes
Reviews, surveys or tickets: group them into themes, count how many fall in each and come away with the exact words that prove it.
How it is done today
You have a spreadsheet with hundreds of comments. You read the first fifty, keep the impression and the report says "customers complain about delivery times" without knowing whether it is ten or two hundred.
Estimated times
- By hand4 h
- With AI30 min
Estimated times, not measured with users.
What you need
- The comments in an Excel or CSV file, one row per comment, with no customer names or emails.
- If you have them, each comment's date and score.
Steps
- Remove names, emails and phone numbers from the file. Keep only the text, the date and the score.
- Attach the file to your AI assistant and paste the request below.
- Check three quotes of each theme yourself by finding them in the original file.
- Ask for the count again with the themes now fixed: the second pass is usually more exact.
- Keep the table and the quotes for your report; write the conclusions yourself.
The request
Attached are [number] customer comments about [product or service] from [period]. Group them into at most six themes. For each theme give me: a short name, how many comments it has (count them, do not estimate), two or three quotes copied exactly from the file, and whether the tone is mostly positive or negative. A comment may sit in two themes; tell me how many do. If a theme has fewer than five comments, put it under "other". At the end, a table of the themes from most to fewest comments.
What to check
- Every quote is in the file, word for word. Look for three per theme with Ctrl+F. AI sometimes "improves" a quote.
- The counts add up to something sensible against the total. If they do not, ask it to explain.
- No theme is your starting hunch in disguise: if you expected something, check it is really there.
Privacy
Customer comments often carry names, orders or addresses. Remove them from the file before uploading it, and use the assistant your company has approved.
What you take away
Asking for exact quotes and counts turns an impression into evidence. And checking three quotes tells you how far to trust the rest.
Do it in RUMBO with your files
RUMBO has a customer service trick that practises it with sample tickets, and then you do it with your own file in Work.
Do it in RUMBOOne guide like this every week
One task a week. Free, and you can leave with one click from any email.
More guides
- Managers and team leads
Rehearse a difficult conversation with AI playing the other person
Before giving bad news or awkward feedback, rehearse it three times in writing with somebody who pushes back.
- By hand2 h
- With AI30 min
- Operations
A twenty-page procedure, as a one-page checklist for each role
The document nobody reads becomes short sheets each person can follow standing at their station.
- By hand3 h
- With AI25 min
