Customer review analysis

How to find recurring complaints in your customer reviews.

Your reviews already say what keeps going wrong. The trick is reading them as a list of repeats, not a pile of one-offs. Here is a method any local or multi-location business can run in a spreadsheet this week.

Get started

Not a restaurant or cafe? Talk to us first

Works by hand in a spreadsheet Any business with reviews A pattern at three
Short answer: Pull the last 90 days of reviews for each location. Tag every complaint with one theme, written in the customer's own words. Count the themes by location. Call it a pattern when the same theme shows up three times at one location inside 30 days (Replio's own rule is "a pattern at three"). Give that pattern one owner and a due date, then re-check the reviews that come next to see whether the complaint stopped.

Why your star average hides recurring complaints

A star average tells you how customers feel overall. It does not tell you what keeps breaking.

A location can sit at 4.5 stars for a year while the same complaint shows up every few weeks. Five-star reviews from happy regulars pull the average up and bury the repeat. Across several locations it gets worse: a group average blends a strong store with a struggling one, and the problem at one address disappears into the number.

Stars also flatten very different complaints into one score. A one-star review about a rude phone call and a one-star review about a billing mistake count the same, even though they need different people to fix them. The fix lives in the words, not the rating.

So stop asking "what is our rating?" and start asking "what did customers complain about, how many times, and where?" That is a counting problem, and you can solve it by hand.

How to find recurring complaints, step by step

You need a spreadsheet, your review profiles, and about an hour per location the first time. After that it is a short weekly habit.

1. Pull the last 90 days of reviews for each location.

Go to each location's Google Business Profile, plus any other site where your customers leave reviews, and copy every review from the last 90 days. Keep each location separate. Ninety days is long enough to see repeats and short enough that the complaints still describe how you run today.

2. Read the low-star reviews and the 4-star reviews.

Start with the 1, 2 and 3 star reviews. Then read every 4-star review, because that is where the polite complaints live: "great food, but the wait was long", "love this gym, but the showers are dirty". A customer who still gives you four stars and mentions a problem anyway is telling you something worth counting. Five-star reviews rarely carry a complaint, but skim them for a "but".

3. Tag each complaint with one theme, in the customer's words.

Give every complaint one short theme. Use the language customers use, not your internal jargon: "no update on my car" beats "communication gap", and "billed after cancelling" beats "membership process". If one review has two separate complaints, give it two rows. Keep your theme list short and reuse the same wording every time, or your counts will split across near-duplicates.

4. Count themes by location and by 30-day window.

Sort or filter the sheet by location, then by theme, then by date. For each location, count how many times each theme appears in each 30-day window. This is the step that turns a pile of reviews into a short list of repeats.

5. Separate one-off bad days from repeats.

Three complaints from the same Saturday, when you were short two people, is a bad day. Note it and move on. The same complaint spread across different days, shifts and customers is a repeat, and repeats are what this method exists to find. Look at the dates before you call anything.

6. Call it a pattern at three.

When the same theme shows up three times at one location inside 30 days, call it a pattern. Replio's own threshold is the same three: at least three complaints in one theme at one location inside its measurement window. One complaint is a story. Two might be coincidence. Three, at the same place, inside a month, is something in how that location runs. The threshold keeps your team working on what keeps breaking, not on every loud review.

7. Give the pattern one owner, a due date, and a re-check.

Write one name next to the pattern, one due date, and what proof looks like when it is done. Then put a date on the calendar to re-read the reviews that come in after the fix. The next section covers how to make that concrete.

The spreadsheet

Eight columns. One row per complaint.

Set it up once and reuse it every week. Every column earns its place.

ColumnWhat goes in it
DateThe day the review was posted, so you can see repeats inside a 30-day window.
LocationThe address or store name. Never blend locations into one row.
RatingThe star rating, so you can see when 4-star reviews carry the same complaint as the 1-stars.
ThemeOne short theme in the customer's words. Reuse the exact same wording every time.
QuoteThe sentence that carries the complaint, copied word for word. This is what you show the owner.
OwnerOne person's name, filled in once the theme becomes a pattern.
DueThe date the action should be in place.
StatusOpen, in progress, done, or re-checking. Leave it open until the re-check is complete.

Add a simple count per location and theme next to the rows, or use a pivot table, and the patterns show themselves.

What recurring complaints look like, by industry

Themes differ by business, but they are always concrete. Here is what customers actually write about in four kinds of local business. Use these as a starting list for your tags, then rename them to match what your own customers say.

Restaurants and cafes

  • Missing items in takeout and delivery orders, or the wrong order.
  • Long waits at peak times.
  • Cold food, or food that sat too long before it went out.
  • A mobile order that was not ready at the promised time.

Auto repair shops

  • No updates while the car was in the shop.
  • The wait ran past the time they were quoted.
  • Surprise charges on the final bill.
  • Being sold work they did not need.
  • The repair did not fix the problem.
  • Different service advisors saying different things.

Gyms and fitness studios

  • Hard to cancel, or billed after cancelling.
  • Unhelpful staff.
  • Not enough classes.
  • Too busy at the times people want to train.
  • Broken equipment.
  • Hygiene: dirty showers, changing rooms or machines.

A 2022 UK analysis reported, from more than 1,800 Trustpilot gym reviews, that unhelpful staff came up in 24.3% of negative reviews, not enough classes in 17.0%, too busy in 15.8%, equipment in 14.8%, and hygiene in 8.6%. Your own counts will differ by location, which is exactly why you count them per location.

Home services: HVAC, plumbing and similar

  • Late arrivals, and no call ahead.
  • A rude technician.
  • Upselling, or a scare diagnosis to sell a bigger job.
  • Repeat visits without a fix.

Notice that none of these are "bad service". Each one names a moment in the job that someone can own. That is the level of detail your themes need.

Turn the pattern into an action item

Finding the pattern is half the job. A pattern with no owner just becomes a longer list next month. Every pattern needs four things written down:

  • One owner. A single named person, not "the team" or "management". If two people own it, nobody does.
  • A due time. A date, or a shift, when the action is in place.
  • What proof looks like. Decide up front how you will know the action happened: a photo, a checklist, a log entry, a text sent. Proof that the work happened is not proof the complaint stopped; that comes later.
  • A re-check at 30, 60 and 90 days. Re-read the reviews for that location and theme after the action. Did the complaint keep showing up, slow down, or stop? If too few reviews came in to tell, say so and keep watching.

The action itself should be small and specific enough that anyone could check whether it happened. Here is one example for each industry above.

PatternAction and ownerProof
Restaurant: missing items in takeoutThe shift lead checks every takeout bag against the ticket before it leaves the counter, starting Monday.A checked ticket stapled to each bag.
Auto repair: no updates while the car is in the shopThe service advisor texts a status update by noon on every car held overnight.The sent texts in the shop's messaging log.
Gym: billed after cancellingThe front desk manager confirms every cancellation in writing the same day and stops billing before the customer leaves.A cancellation confirmation on file for each request.
Home services: late with no call aheadThe dispatcher calls the customer whenever a technician will be more than 15 minutes late.The call noted on the job in the dispatch system.

Then do the re-check. If the complaint stops showing up at that location, close it. If it keeps coming, the action was the wrong one or it did not stick, and the owner tries again with the next reviews as the scorecard.

Where software helps, and where Replio fits

The spreadsheet method works. Its weak point is time: copying reviews, tagging, and counting by hand gets old fast, especially across several locations. Software helps with the collecting and the counting. It cannot replace the owner.

Here is what Replio does today, plainly:

  • One place for reviews. Replio pulls Google reviews, and Yelp, for each location into one place.
  • Replies a person approves. Replio drafts replies. A person on your team approves and posts them, and nothing posts without that approval. Replio can publish an approved reply to a connected Google Business Profile.
  • Rex, by text. Rex, Replio's assistant, answers questions about your reviews by text.
  • Automatic complaint grouping, for food and drink today. Replio groups complaints for you, calls a pattern at three, and gives it an owner, a due time, proof, and a later check that measures whether the complaints stopped. That grouping is tuned today for restaurants, cafes, coffee shops, bakeries and bars.

If you run a different kind of business: the review inbox and approved replies work for any business with a Google Business Profile. Automatic theme grouping for your industry is not built yet. Use the spreadsheet method above for the patterns, and talk to us if you want to be early.

Replio costs $149 per location per month, billed monthly. See the pricing page.

Your customers already told you what to fix.

Bring your reviews into one place, approve every reply, and keep the complaint that keeps coming back from getting lost.

Get started

Not a restaurant or cafe? Talk to us first

FAQ

Frequently asked questions

How many reviews do I need to see a pattern?

Three complaints about the same theme at one location inside 30 days is enough to call a pattern. You do not need hundreds of reviews. A location with only a handful of reviews a month can still show a pattern, because the test is repeats of one theme, not total volume.

Should I count 4-star reviews?

Yes. Many 4-star reviews carry a complaint in the second half of a sentence, like "great service, but the wait was long". Count those complaints the same way you count complaints in low-star reviews.

How often should I review my reviews for patterns?

Do a full 90-day pull the first time, then update the sheet once a week. Weekly is often enough to catch a pattern inside its 30-day window, and it keeps the habit short.

What is a recurring complaint versus a one-off?

A one-off is a complaint tied to a single bad day, like three reviews about the same short-staffed Saturday. A recurring complaint is the same theme showing up across different days, shifts and customers at one location. Check the dates before you call it.

Can I do this without software?

Yes. A spreadsheet with eight columns (date, location, rating, theme, quote, owner, due, status) is enough. Software saves the copying and counting time, especially across several locations, but the method is the same.

Does Replio work for my industry?

The review inbox and approved replies work for any business with a Google Business Profile. Replio's automatic complaint grouping is tuned today for restaurants, cafes, coffee shops, bakeries and bars. For other industries, automatic theme grouping is not built yet, so use the spreadsheet method on this page, and talk to us if you want to be early.

Keep reading

Sources