Skip to content
Guides

Multi-Location Review Analytics: Which Branch Drags Your Rating?

Multi-location review analytics from 650 locations: how far branch ratings spread, why the lowest-rated branch is often not the problem, and how to find it.

ReplyOnTheFly Team

Content Team

18 min read
Pizzeria owner at a wall map of her five shops, holding one rating card with a shorter bar next to one location's pin
On this page9 sections
  1. Google Shows a Rating per Branch, Not per Brand
  2. How Far Apart Branch Ratings Really Are
  3. The Lowest-Rated Branch Is Often Not the Problem
  4. Small Branches Swing, in Both Directions
  5. Lifetime Rating Hides the Branch That Is Slipping Now
  6. How to Do Multi-Location Review Analytics in a Spreadsheet
  7. Where the Monthly Numbers Come From
  8. Frequently Asked Questions
  9. The Bottom Line

You open Google, look up your own shops, and one of them shows 4.3 while the others sit at 4.7. It feels obvious which location is dragging your rating down. Often it is not that one, and sometimes it is not a problem at all.

Quick answer

Multi-location review analytics means reading your reviews by branch three ways, not one: which location has the lowest rating, which produces the most low-star reviews, and which is slipping against its own history. In our data those three questions point at different branches a third to a half of the time. The lowest-rated location is frequently just the smallest, where one bad review moves the number. Rank by all three, set a minimum of about 20 reviews before you trust a branch's recent rating, and then read the complaints at the branch that shows up on more than one list.

This post is part of our Google review analytics guide series. If you are still setting up the basics, such as business groups, manager logins and who gets which alert, start with our guide to multi-location review management and come back. This one is about reading the numbers once the reviews are flowing.

Google Shows a Rating per Branch, Not per Brand

Start with what your customers actually see. Every Google Business Profile carries its own star rating and its own review count. Google does not publish a brand-wide average anywhere on Search or Maps.

So "dragging my rating down" can mean two different things, and they call for different fixes.

The first is a branch whose own number is low. That hurts that branch, because the people searching near it see 4.1 beside a competitor's 4.6. It does nothing to the number shown on your other locations.

The second is a branch that produces most of your unhappy customers. That hurts the business, in refunds, lost regulars and word of mouth, even if the branch's rating looks respectable because it also collects hundreds of happy reviews.

Salon owner holding up two rating cards, one with a long bar and one with a clearly shorter bar, surprised at the gap
Salon owner holding up two rating cards, one with a long bar and one with a clearly shorter bar, surprised at the gap

Any combined average is your own invention for reporting. That is fine, as long as you pick one method and keep it. The simple average of your branch ratings treats a 40-review kiosk the same as a 1,200-review flagship. The pooled average of all reviews lets the flagship dominate.

In the data below, those two methods disagreed by 0.05 stars or more in 29% of multi-location groups, and by a tenth of a star or more in 15%.

How Far Apart Branch Ratings Really Are

We measured it across the multi-location accounts connected to ReplyOnTheFly.

To compare like with like, we grouped locations that sit under one account and share the same primary Google category, and kept groups with at least two locations holding 20 or more reviews each. That gave 146 groups, 650 locations and 417,731 reviews, measured on November 16, 2026. Seventy groups had two locations, 44 had three to five, and 32 had six or more.

The first surprise is how high the baseline is. The median location's lifetime rating was 4.77. Almost half of the locations, 47%, sat at 4.8 or higher, and only 43 of the 650 were below 4.0.

The second is the gap between the best and worst branch in each group:

Gap between best and worst locationShare of groups
Median gap0.23 stars
0.3 stars or more40%
0.5 stars or more23%
1.0 star or more4%

A quarter of groups had a gap of 0.47 stars or more, and a tenth had 0.80 or more. So a 4.7 next to a 4.4 is not unusual. It is roughly what four in ten multi-location businesses are looking at.

Where these numbers come from

The set is businesses connected to ReplyOnTheFly on November 16, 2026, with a live Google connection and a sync in the previous seven days, excluding our own test accounts. Locations are grouped by account and primary Google category, so that an agency's unrelated clients are not compared with each other. Ratings are the average of the reviews currently on each profile, and reviews Google has removed are excluded. These are businesses that chose a review tool, so their ratings are more likely above average than below it.

The Lowest-Rated Branch Is Often Not the Problem

Here is the pattern that catches most owners. Locations differ enormously in volume. In the median group, the busiest location had 4.1 times as many reviews as the quietest.

Take a made-up chain with three shops. The flagship has 1,200 reviews at 4.6. The second shop has 300 at 4.7. The new kiosk has 40 at 4.1.

Everyone's eye goes to the kiosk. Now count unhappy customers. If the kiosk's 4.1 comes from about eight low-star reviews and the flagship's 4.6 comes from about a hundred, the flagship is where twelve times as many people left unhappy.

The same thing shows up in the average. Pool all 1,540 reviews and the chain sits at 4.61. Take the kiosk out and it rises to 4.62. Take the flagship out and it rises to 4.63.

The 4.6 branch pulls harder than the 4.1 branch, because it is thirty times the size.

Auto repair owner at a corkboard with three columns of index cards of very different heights, pointing at a coral card in the tallest column
Auto repair owner at a corkboard with three columns of index cards of very different heights, pointing at a coral card in the tallest column

That is not a quirk of the example. In the 76 groups with three or more locations, the lowest-rated branch was not the one pulling the pooled average down the most in 22 of them, 29%.

It is also worth knowing how small that pull usually is. Removing the single most damaging branch raised the group's pooled average by a median of 0.04 stars. In 58% of groups it moved the average by less than 0.05, and in only 15% did it move it by a tenth of a star or more.

One branch rarely sinks the brand's average. What it does is produce a concentrated share of the complaints.

We looked at 57 groups with three or more locations and at least ten low-star reviews in the past year, with a median of five locations each. The branch with the most one-to-three-star reviews carried a median 38% of the group's complaints while handling 29% of its review volume. In 32% of those groups, a single branch produced half or more of all low-star reviews.

That branch, not the one with the smallest number beside its name, is usually where a fix pays back fastest.

Small Branches Swing, in Both Directions

A low number on a small branch has a second explanation: arithmetic.

One new one-star review takes a 20-review location from 4.8 to 4.6. The same review takes a 400-review location from 4.80 to 4.79, which still displays as 4.8.

Nothing about the service differs between those two cases. Only the sample size does.

The statistician Howard Wainer called the formula behind this "the most dangerous equation", because people keep mistaking small-sample swings for real differences. His example was 1,662 Pennsylvania schools ranked by test scores, where, in his words, "the highest- and lowest-performing schools tend to group at low enrollment." Small schools were not better or worse. They were just noisier.

Branches behave the same way. In our 76 groups with three or more locations, the branch with the fewest reviews was the lowest-rated in 27 groups and the highest-rated in 21. Chance alone would put it in each spot about 16 times.

Put together, the smallest branch sat at one extreme or the other in 63% of groups.

Florist leaning on her counter beside a large jar full of white paper slips and a small jar holding only five, one of them coral
Florist leaning on her counter beside a large jar full of white paper slips and a small jar holding only five, one of them coral

So before you call a meeting about your worst branch, check whether it is simply your smallest. And apply the same doubt to your best branch before you hold it up as the model for everyone else.

The same caution applies to recent numbers. A quarter of the 650 locations received fewer than 20 reviews in the past twelve months, and 15% received fewer than ten.

A "last 12 months" rating on those branches is a handful of opinions. Read the reviews themselves instead of ranking the average. Our guide to review analysis mistakes covers this trap for single locations, and it only gets worse when you split the data by branch.

See every location's month side by side

Connect your locations and ReplyOnTheFly shows each one's new reviews, rating, response rate and pending replies in one sortable table, and emails you a ready-to-approve reply for every new review.

Get started

Lifetime Rating Hides the Branch That Is Slipping Now

The number on Google is a lifetime average. A branch with six good years and one bad one still shows the six good years.

So we compared each location's rating over the past twelve months with its lifetime rating, for the 552 locations that had at least ten reviews in the year.

Sixty of them, 11%, were running 0.2 stars or more below their own lifetime rating. Those slipping branches were spread across 44 of the 146 groups, so three in ten multi-location businesses had at least one.

Here is the part that matters for where you look. Of those 60 slipping branches, 39 were not the lowest-rated location in their group. Twenty-three still showed a lifetime rating of 4.5 or higher. On a table sorted by the rating Google displays, they look fine.

Coffee shop owner and her branch manager looking at a phone together, the three newest review rows marked with coral dots and the older ones with green
Coffee shop owner and her branch manager looking at a phone together, the three newest review rows marked with coral dots and the older ones with green

Ranking by recent reviews reshuffles the table. Among 124 groups with at least two locations that had enough recent reviews to compare, the lowest-rated branch over the past twelve months was a different branch from the lowest-rated over its lifetime in 34%. In groups with three or more such locations it was 47%, close to a coin flip.

It cuts the other way too. Seventy-one locations, 13%, were running 0.2 stars or more above their lifetime rating. A branch with a poor historic number and a strong recent year has usually already been fixed, by a new manager or a refit, and the lifetime average simply has not caught up. Leave it alone.

If one branch's displayed rating dropped suddenly, the cause is not always a new bad review. Google also removes reviews, and a lost batch of five-star reviews lowers a small branch's average just as surely. Our guide to why a Google rating drops walks through telling those causes apart, and you can get alerted when a review is removed at any location.

How to Do Multi-Location Review Analytics in a Spreadsheet

You can read your reviews by branch in a spreadsheet in under an hour, once a quarter.

1. Build one row per location

For each branch, collect five numbers:

  • Reviews received in the last 12 months
  • Lifetime rating, the one Google displays
  • Rating over the last 12 months
  • Count of one-to-three-star reviews in the last 12 months
  • Share of last year's reviews that got a reply

Google shows each location's rating and review count on its own profile, but it will not give you the last three columns.

The quickest route is a file of every review with a column naming the location, and a pivot table on top of it. Our guide to exporting Google reviews covers the ways to get that file. ReplyOnTheFly's export puts all your locations in one Excel or CSV sheet with the business name in the first column.

2. Compare like with like

A drive-through and a sit-down restaurant, or a dental office and an orthodontic office, draw different reviews. If your locations are not the same kind of business, split them into groups before you rank anything.

3. Set a minimum before you rank

Grey out the 12-month rating for any branch with fewer than about 20 reviews in the year. For those branches, widen the window to two years or skip the average and read the reviews.

4. Sort the table three ways

Sort by lowest lifetime rating. Sort by the most low-star reviews in the last 12 months. Sort by the biggest drop from lifetime rating to 12-month rating.

Write down the bottom branch on each list. If one branch is on two or three lists, that is your answer. If the three lists name three different branches, the one with the most low-star reviews comes first, because it is where the most customers are affected.

5. Read the complaints, branch against brand

Pull the one-to-three-star reviews from the last 12 months for the branch you picked, and the same reviews from all the other branches together. Sort each set by topic, the way our guide to finding patterns in customer reviews describes.

A topic that shows up everywhere is a brand problem: pricing, the menu, a booking policy. Fixing it at one branch fixes nothing. A topic that shows up mostly at one branch is local: staffing, a manager, parking, the building. That is the one to hand to the branch.

Restaurant owner and his location manager sorting coral paper slips into three piles of different heights at a table before opening
Restaurant owner and his location manager sorting coral paper slips into three piles of different heights at a table before opening

6. Check who is replying

Reply habits vary between branches more than most owners realize. In 124 groups, the median gap between the branch that replied to the largest share of last year's reviews and the branch that replied to the smallest was 22 percentage points. In 42% of groups the gap was 30 points or more, and in 28% it was 50 points or more.

We are not claiming replies cause ratings. But an unanswered complaint at a branch is a complaint nobody at that branch has acknowledged reading, and that is worth knowing before the conversation with its manager.

7. Give the branch a target and a date

Tell the manager what the reviews say, agree one fix, and write down the date. Then compare that branch's low-star count for the next quarter against the quarter before.

Be realistic about the displayed rating, because lifetime averages move slowly. A 40-review branch at 4.1 needs 32 five-star reviews in a row to show 4.5. The review calculator will work out how many five-star reviews any branch needs, so nobody is promised a number the math cannot deliver.

Where the Monthly Numbers Come From

Steps one and six are counting, and counting is the part worth handing off.

Once a ReplyOnTheFly account has two or more locations connected, the Report page opens on an all-locations view. For any completed month it lists every branch in one table: profile views, new reviews, the average rating of that month's reviews, response rate and replies still pending.

Click a column to sort by it, and click a branch to open its own report. It is part of the free monthly performance report that every account gets.

That table answers "which branch had a bad month" in a few seconds. It does not replace the quarterly read above, because one month on a small branch is exactly the kind of small sample this post warns about. Use the monthly view to notice, and the 12-month table to decide.

The day-to-day part is the replies. Review Replies Pro is $9.99 a month with up to 50 locations included, and +$9.99 per additional 50.

Every new review at every branch arrives by email with a reply already written, ready to approve with one tap, or posted automatically in auto-post mode. Each location can have its own alert recipients, so a branch's reviews reach the manager who can act on them. You can connect your locations in a few minutes.

For the regular sitting itself, our monthly review check-in is a 15-minute routine you can run per branch.

Frequently Asked Questions

How do I compare Google reviews across multiple locations?

Build one table with a row per location and five columns: reviews in the last 12 months, lifetime rating, rating over the last 12 months, the count of one-to-three-star reviews in the last 12 months, and the share of reviews that got a reply. Compare only locations in the same line of business, and treat any 12-month rating built on fewer than about 20 reviews as too noisy to rank. Then sort the table three ways: by lowest rating, by most low-star reviews, and by biggest gap between the recent rating and the lifetime rating.

Is the lowest-rated location always the one hurting the business most?

No. In 76 same-brand groups with three or more locations in our data, the lowest-rated branch was not the one pulling the combined average down the most in 22 of them, 29%. A big branch a little below average produces far more unhappy customers than a tiny branch a long way below it. Across 57 groups with enough low-star reviews to measure, the branch producing the most complaints carried a median 38% of the group's one-to-three-star reviews.

How much do ratings normally differ between locations of the same business?

Less than most owners expect, but enough to notice. Across 146 groups of same-category locations under one account, measured on November 16, 2026, the median gap between the best and worst location's lifetime Google rating was 0.23 stars. A quarter of groups had a gap of 0.47 or more, 23% had half a star or more, and 4% had a full star or more.

How many reviews does a location need before its rating means something?

There is no official threshold, but the arithmetic is unforgiving below about 20 reviews. One new one-star review moves a 20-review location from 4.8 to 4.6, and moves a 400-review location from 4.80 to 4.79. In our data the smallest branch in a group was either the lowest-rated or the highest-rated branch 63% of the time, roughly one and a half times what chance alone would produce, which is sample size at work rather than management.

Does Google show one combined rating for a business with several locations?

No. Every Google Business Profile carries its own star rating and review count, and Google does not publish a brand-wide average on Search or Maps. A customer searching near your weakest branch sees only that branch's number. A combined average is something you calculate for your own reporting, so decide whether you want the simple average of the branch ratings or the average of all reviews pooled together. The two differed by 0.05 stars or more in 29% of the groups we measured.

What should I do once I find the location with the worst reviews?

Read that location's one-to-three-star reviews from the last 12 months next to the same reviews from your other locations, and sort the complaints by topic. A topic that appears at every branch is a brand problem such as pricing, the menu or a policy. A topic that appears mostly at one branch is a local problem such as staffing, a manager, parking or the building. Fix the largest local topic, write down the date, and compare the next quarter's low-star count for that branch against the quarter before.

The Bottom Line

The branch with the smallest number beside its name is the easy answer, and in our data it was the wrong one often enough to check. Small branches swing on a single review. Big branches hide most of your unhappy customers behind a healthy-looking average. And the branch that started slipping this year usually still looks fine on Google.

Multi-location review analytics comes down to three sorts and one read. Sort by lowest rating, most low-star reviews, and biggest recent drop. Trust only the numbers built on enough reviews. Then read the complaints at the branch that keeps turning up, and separate what is local from what is the brand.

Keep every location's reviews answered

ReplyOnTheFly watches each location's Google reviews around the clock and emails you a reply that is ready to approve with one tap. Up to 50 locations included on Pro.

Start Free - No Credit Card Required
  • Unlimited AI drafts
  • 5 free one-click posts/month
  • Works from your email inbox

Written by ReplyOnTheFly Team

Content Team

Free toolNo signup

Write this reply in seconds

Paste the review, pick your tone, get a reply that sounds like a person wrote it.

Write my reply

Or create a free account to automate replies

review analyticsmulti-locationgoogle reviewsfranchisereputation management