
Step-by-step instructions to train models on previous customer complaints and generate high-retention response profiles.
Every business receives refund requests. Most treat them as losses to be minimized — process the refund, close the ticket, move on. The businesses that grow fastest treat them as the most honest feedback they will ever receive. A customer who complains in writing, in detail, about why your product failed them has handed you a rare document: an unfiltered account of the gap between your promise and your delivery. For $1, this article shows you exactly how to turn those documents into a retention system using a large language model in under 20 minutes.
The audit has three stages. First, you extract the real reason behind each refund — not the stated reason, but the underlying expectation that was not met. Second, you use an AI model to find the patterns across those complaints that your customer service team has not spotted. Third, you build a response profile that addresses those patterns before they become refund requests. None of this requires a technical background. It requires a spreadsheet, a folder of complaint emails, and 20 focused minutes.
Stage One: Collect and Categorise Your Complaint Data
Pull the last 30 to 50 customer complaints or refund requests from your email or support system. Export them as plain text. If you have fewer than 30, use all of them — the system still works, it just produces a narrower set of patterns.
Create a simple spreadsheet with three columns: the complaint text (or a summary), the stated reason the customer gave, and the underlying expectation (leave this blank for now — you will fill it with AI help). The stated reason is what the customer wrote. The underlying expectation is what they actually needed that they did not get.
This distinction matters. A customer who says 'the product was too complicated' may actually be saying 'I expected to be able to use this without reading a manual.' A customer who says 'it didn't do what I expected' may be saying 'your sales page implied a result that your product cannot deliver.' These are very different problems requiring very different fixes.
Stage Two: Run the LLM Analysis
Open your AI tool. Paste in ten complaint summaries at a time. Use this prompt: 'Read these ten customer complaints. For each one, identify: (1) the stated reason for dissatisfaction, (2) the underlying unmet expectation, and (3) the point in the customer journey where the expectation was set. Format your response as a numbered list.'
The third element — where the expectation was set — is the most valuable output. Was it the sales page? The onboarding email? A specific feature promise? When the AI points to the moment the expectation was created, you have identified the source of the problem. Fixing the refund rate means fixing that moment, not improving your refund process.
Run this across all your complaints in batches of ten. Once you have the full output, paste all the 'underlying unmet expectations' into a second AI prompt: 'Identify the top five recurring patterns across these customer expectations. Rank them by frequency. For each pattern, write one sentence explaining what a customer who holds this expectation actually needed from the product.'
Stage Three: Build the Retention Response Profile
You now have five named patterns. For each one, write: the expectation, the point where it was set, and three specific interventions — what you change in your sales copy, what you change in your onboarding sequence, and what you change in your product or service delivery.
Ask the AI to draft a response template for each pattern — not a generic 'we're sorry' email, but a response that acknowledges the specific expectation the customer had, explains clearly why the product works the way it does, and offers a concrete next step. 'I can see this wasn't what you were expecting when you signed up, and I want to address that directly' is a better opening than 'Thank you for contacting us.'
These templates become your retention playbook. Train your customer service team — or your AI support tool — on them. Every future complaint gets matched to one of the five patterns and receives the corresponding response.
What Changes After the Audit
The businesses that run this audit consistently see two things happen. Their refund rate drops because they fix the expectation-setting moments upstream. And their negative reviews become less frequent because customers who receive a specific, intelligent response to a genuine complaint often decide not to leave one.
The audit takes 20 minutes the first time. After that, run it quarterly — 10 minutes per session. Your complaint patterns will shift as your product and your marketing evolve. The AI does not replace your judgment about which patterns matter most. It surfaces the patterns faster than any manual review could.
Why This Works Better Than a Survey
Post-purchase surveys have a response bias problem: the customers who complete them are not representative of the customers who left. Refund complaints and negative reviews are written by customers who felt strongly enough to act — which makes them a higher-signal data source than survey responses from customers who were mildly satisfied.
The AI analysis works on this signal because language models are exceptionally good at finding semantic patterns across large bodies of unstructured text. What would take an analyst two days of manual reading and categorisation takes an AI model three minutes. The quality of the output depends entirely on the quality of the input — which is why the collection and preparation stage matters as much as the analysis prompt.
Final Thought
Your refund complaints are already written. The AI analysis takes 20 minutes. The retention system that comes out of it runs indefinitely. The only cost is the time you have already spent avoiding the exercise.
—
