Compare location review performance
How do I compare review performance across locations?
Open Reviews Overview at All locations for a client. The screen is headed Reputation and reads "How every location is performing, and where to focus." It summarises Total reviews, Avg rating, Unreplied, Positive and New in 30d, calls out a Top performer and Needs focus, then lists every location in a table you can filter, re-order, export and reconfigure with Columns.
Key facts
| Where it lives | Reviews → All locations → Reviews Overview, headed Reputation. You must have a client chosen |
| What you need first | More than one location with reviews collected. Locations with no reviews do not appear |
| What it changes | Nothing. Filters and columns change the view only |
| What it counts | Recorded, present, third-party reviews. Internal feedback and removed reviews are left out |
| Period | Last 30 days by default; it affects some figures but not others (see below) |
| Your view | The columns, sort and period you choose are remembered in your own browser, not on the account |
Why this matters
Comparing locations one at a time makes it difficult to see which ones are getting worse. The leaderboard puts a client's locations in one view so you can use the change columns and the unreplied counts to decide which locations need attention first.
Steps
Open Reviews Overview at All locations. Read the summary row and the Top performer and Needs focus cards first to get the shape of the client before looking at individual locations.
Read the captions under the tiles, because they are not all scoped the same way. Total reviews, Avg rating and Positive are All time. Unreplied is the current backlog, all time, with a change figure for the selected period. Only New in 30d is limited to the period. The line under the tiles says the same: the date range applies to new reviews and backlog changes.
Set the period. The date control opens on Last 30 days, with All time, Last 7 days, Last 90 days, This month, This quarter and This year as presets, or pick your own dates and choose Apply. Some filters and columns compare against the previous period and need a period; the Declining filter, for example, is unavailable under All time.
Narrow to the locations that need you. Filters offers four under Needs attention that answer the question directly: Unreplied negatives, Stale, Low response and Declining. There are also Health (At risk, Watch, Healthy), Rating bands (4.0+, 3.0–4.0, Under 3.0) and a Min reviews threshold showing e.g. 10.
Choose what the table shows. Columns lists every column with a checkbox and a handle to drag it into order. Visible by default are Location, Rating, Reviews, Sentiment, Response, 30d, % ≤2★, New, Last review and Health.
Add the columns that fit the question you are answering. Also available are % 5★, Distribution, Net sentiment, Rating Δ, Health Δ, Volume/wk, Oldest unreplied, Days since neg. and % of book. Reset returns the default set.
Sort by a change column rather than an absolute one. Rating Δ and Health Δ find the locations that moved; Rating alone mostly finds the locations that have always been fine.
To find one location rather than a category, use the search field marked Search locations….
Select a location's name to open it. It opens that location's own review queue, so you can continue where the work is.
The charts under the cards
Beneath Top performer and Needs focus are three charts. Portfolio trend draws each location's review volume or rating over 6 or 12 months. Locations focus map places each location by rating and volume: the bottom right is high volume with a low rating, bubble size is the number of unreplied negatives, and the colour follows health (Healthy 70 and over, Watch 40 to 69, At risk under 40). Top movers shows the biggest health changes compared with the prior period, and says so when there is not enough prior-period history to compute them.
What you'll see when it's done
- A table of every location, ordered by whatever you chose
- Only the columns you selected, with Reset available
- Any active filter shown on its control rather than reading All
- Figures that follow the period you chose where the tile caption says they do
Watch out for
Questions people ask
What should I check before I begin?
The period, and the caption under each tile. Some tiles are all-time and some follow the period, so a quiet location can look alarming and a recovering one can look unchanged purely because of the window.
Why does one location show no rating at all, or not appear?
Only locations that have reviews appear in the table. If a location you expect is missing, widen the period first; if it stays empty, the problem is collection rather than performance.
Which column should I sort by?
Whichever matches the decision. Unreplied and Oldest unreplied for work to do today, Rating Δ and Health Δ for locations that are slipping, Volume/wk for locations that have stopped collecting reviews.
Is the lowest-rated location the one to work on?
Usually not. The bottom of the table tends to be stable and already known; someone has been aware of it for months. The location that deserves this week is the one that fell, which is why the change columns exist and why sorting by Rating alone keeps pointing you at the same place.
Can Sydekick produce this as a report?
Sydekick has a separate Reputation Performance Report that builds a PDF and an Excel spreadsheet of Google star ratings for every location of a client, with a fixed competitor comparison. It is a different document from this table: it covers Google only and the current calendar year. See the Reputation Performance Report.
Next
For the detail behind a single location's numbers, open review analytics. To see the themes driving a decline, see review topic trends. To start clearing the unreplied count, see finding the reviews that need attention.