How to Analyze Customer Reviews and Complaints with Claude and Find What to Fix
Drop your reviews, complaints and chat logs into one file and ask Claude to surface the recurring problems, how often each shows up, and what to fix first. A task list instead of a vague feeling that things are bad.
Reviews usually get read one at a time and forgotten one at a time. A customer says they waited too long for a reply, you sigh, answer, close the tab. A week later someone else says the same thing, but the link between the two is already gone. So you remember the last complaint, not the one that repeats for the thirtieth time and actually costs you money.
Claude (an AI assistant from Anthropic) is good at exactly one boring move: it takes a pile of scattered text and turns it into a clear picture. It does not invent solutions for you, it shows what customers repeat most often and a sensible order to fix things in. Here is how to do it in one evening.
Why bother pooling reviews at all
One review is emotion. A hundred reviews are data. As long as you read them one by one, you react to the loudest voice: whoever wrote most sharply is the one you remember. But a business runs on frequency, not volume. A problem twenty people mentioned calmly costs more than a single dramatic rant.
The job of the analysis is to turn a stream of complaints and praise into a short list of five to seven points that shows what hurts many people, what they love, and what to tackle first. With a list like that you decide with your head, not with the last email you happened to open.
Where to get the reviews
Gather everything you can reach into one text file. Good sources:
- reviews from maps and marketplaces (copy them as text, not screenshots);
- support chat and direct messages;
- answers to a customer survey, if you ran one;
- complaint emails and returns with a stated reason;
- call transcripts, if you record calls.
Do not clean or polish them. Claude reads raw text with typos and swearing just fine. All that matters is that each review starts on a new line and, where possible, carries a date and the channel it came from. That helps later to tell whether things got better or worse.
If you have a lot of reviews and they do not fit in one window, split them into batches of a couple of hundred, run them in parts, then merge the conclusions with a separate prompt.
What prompt to give Claude
The prompt (the text command you give the AI) should ask for structure, not a retelling. Here is a working template, paste your text at the end:
You are a customer experience analyst. Below are reviews and complaints from my customers. Do the following. First, pull out recurring themes and for each count in how many reviews it appears. Second, split themes into praise and complaints. Third, for complaints rate how painful it is for the customer on a scale of 1 to 3. Fourth, put it all in a table with columns theme, type, mentions, pain, example quote. Invent nothing, rely only on the text below. Here are the reviews:
Then you paste your file. Claude returns a table that shows the balance of power at a glance: here are the three complaints that repeat most often and hurt the most, here are the two things people praise that you must not break.
How to decide what to fix first
Once the table is ready, ask a second question: have Claude sort the problems by frequency times pain and suggest which three to take on first. Separately, ask which problems you can probably solve with a rule or a script, and which need money and people.
This is the important turn. Some complaints get fixed for free in a day: prepare an answer to a frequent question, reword a line on the site, add a step to a staff instruction. Others need investment: hire another support person, rebuild logistics. Claude helps you keep these two stacks apart, so you do not postpone the cheap wins while waiting on the big ones.
How not to fool yourself
Two honest warnings. Claude counts themes from the text you gave it and has no idea whether the sample is representative. If you only collected angry reviews from one platform, the picture will look darker than reality. Try to pull every channel, not just the ones where people complain.
Second: spot-check the quotes and numbers in the table. The AI sometimes rounds and generalizes. Open a couple of rows, find those reviews with your own eyes, confirm the theme really shows up that many times. It takes a minute and adds a lot of trust to the conclusion.
What to do with the result
Do not leave the analysis sitting in the chat. Move the three main problems into tasks, assign an owner and a deadline. A month later collect a fresh batch of reviews and run the same prompt: if the problem that used to top the list has dropped, the fix worked. That turns the analysis from a one-off exercise into a loop that quietly improves the product.
You can try it right now on your own reviews, no signup: take our first free lesson at /try/b0-01-unit, and the prompts and cheat sheets live in our free materials.
AGINE Academy is an independent product, not affiliated with Anthropic. Claude belongs to Anthropic.
Questions
It starts to pay off at around twenty to thirty: with fewer than that you already remember each one. There is no upper limit. If you have thousands, split them into batches of a couple hundred, run them in parts, then merge the conclusions with a separate prompt.
No, and it should not. Its job is to show what repeats most and what hurts most, that is, to bring order to the chaos. You make the calls: what to fix with a rule, what with money, and what to leave as is.
Treat them as a draft. Claude counts themes from the text you gave it, but it sometimes generalizes and rounds. Spot-check two or three rows: find those reviews yourself and confirm the theme really appears that many times. A minute of work, noticeably more trust in the result.
Strip out unnecessary personal data before you upload: names, phone numbers and order IDs are not needed for the analysis, you only care about the themes. Anonymized reviews are safer to analyze and the result does not suffer for it.