How to rank businesses by number of reviews, and when stars should decide
Three ways to order a list of local businesses: by review count, by rating, or by a rating weighed by its reviews. Which question each one answers, with a worked example.
Part of the guide Location intelligence automation
To rank businesses by number of reviews, sort the list by its review count, highest first, and you get the busiest and most established places at the top. That answers one question well: who has the most customers talking about them. If you want the best places rather than the busiest, sort by rating but push places with only a handful of reviews down, or work out one score that weighs each rating by how many reviews stand behind it.
This article is for sales teams building a call list, buyers choosing suppliers, and anyone shortlisting partners or rivals from a list of local businesses. It sets out the three orders you can put a list in, what each one is good for, a worked example with made-up numbers, the usual mistakes, and how to do it with blocks in xMap Flows.
Why stars alone do not sort a list
In many local markets most businesses with a rating sit in a narrow band near the top. xMap's places database lists 692 gyms within 10 km of the centre of Sydney (November 2026); of the 347 nearest the centre, 301 have a rating, 4.6 out of 5 on average, and 228 are rated 4.5 or more. Sorting those by stars alone puts hundreds of places within a few tenths of each other, and the order among them is decided by small differences that a few reviews can move.
Worse, a place with one five-star review beats a place rated 4.7 by eight hundred people. That is rarely what anyone means by best. The number of reviews is what tells you how much a rating can be trusted, and how widely known a business is.
Three orders, three questions
| Order by | Answers | Good for |
|---|---|---|
| Review count, highest first | Who is busiest and most talked about? | Supply pitches that need volume, partner shortlists, the rivals that matter most |
| Rating, few reviews last | Who is best regarded, among places with enough reviews to judge? | Choosing suppliers, recommending places, benchmarking your own branches |
| A rating weighed by its reviews | Who is both good and proven? | One ranked list when you want quality and confidence together |
Which order to use for which job.
Ranking by count suits jobs where size matters more than taste. A coffee roaster looking for cafes that go through a lot of beans, a payments company that wants high-volume merchants, or a brand choosing which rival branches to watch first all care about traffic. Review count is a reasonable stand-in for it, though not a measure of it: some trades get reviewed far more than others, so compare counts only within one kind of business.
A worked example
This example and its numbers are made up. A sports nutrition brand has five gyms in a city and wants to know where to place its first display stands.
| Gym | Rating | Reviews |
|---|---|---|
| A | 5.0 | 6 |
| B | 4.8 | 40 |
| C | 4.6 | 900 |
| D | 4.4 | 1,500 |
| E | 4.9 | 300 |
Five made-up gyms.
- By stars alone: A, E, B, C, D. Gym A, with six reviews, comes first.
- By number of reviews: D, C, E, B, A. The two busiest gyms lead, which is what a display stand needs.
- By rating with few reviews last: E, C, D, then B and A behind them, if the cut-off is 50 reviews. Gym E is both loved and proven.
- By a weighed score (below, with a typical rating of 4.6 and a weight of 50 reviews): E about 4.86, C about 4.60, A about 4.64, B about 4.69, D about 4.41. Sorted, that is E, B, A, C, D: a short record pulls a rating towards the typical one instead of throwing it away.
The brand chose by review count for stands, because it wants footfall in front of the product, and kept the weighed order for a second list: gyms to approach for a sponsored class, where reputation matters more.
Working out a weighed score
The simple version adds some imaginary reviews at a typical rating to each place, so a short record is pulled towards the middle and a long record keeps its own rating. Pick a typical rating for the market (the average of the list is fine) and a weight, the number of reviews at which you start trusting a rating, then:
With a typical rating of 4.6 and a weight of 50, a place rated 5.0 from 6 reviews scores (30 + 230) / 56, about 4.64; a place rated 4.9 from 300 reviews scores (1,470 + 230) / 350, about 4.86. The larger the weight, the more reviews a place needs before its own rating counts.
Mistakes to avoid
- Comparing counts across trades. Restaurants and cafes collect reviews far faster than accountants or plumbers. Rank within one kind of business.
- Reading count as customers. A review count is people who chose to write, not visitors or sales. Use it to order a list, not to estimate revenue.
- Penalising new businesses you want. If you are looking for newly opened places to sell to, a low count is the signal, not a flaw. Rank those by opening date instead.
- Dropping places without reviews. Some lists have no counts for many rows. Decide whether those go last or on a separate list, rather than silently losing them.
Doing it with blocks
In xMap Flows, Nearby places brings each place with its rating and number of reviews from xMap's places database. Sort and limit then does the first two orders: Reviews, highest first, for the busiest; or Rating, where places rated by fewer than 10 people come after the others, so one five-star review does not beat 4.7 from hundreds. For the weighed score, a Calculated field block takes one line such as weighed = (rating * reviews + 4.6 * 50) / (reviews + 50), and Sort and limit orders by that field. A place with no rating leaves the field empty and goes last.
To split rather than sort, a Branch on reviews sends established places one way and smaller ones another. The template New businesses routed by size does exactly that, sending places with 100 reviews or more to a key account team. For rivals, How customers rate competitors lists them every week, the weakest first. Whatever the order, the email that ends the flow keeps it, so the list arrives ranked.
Questions
Is a business with more reviews better?
Not necessarily. More reviews mean a better-known, usually busier business and a rating you can trust more, but the rating itself still says whether people liked it.
How many reviews make a rating trustworthy?
There is no fixed number. Sort and limit puts places with fewer than 10 reviews after the others when sorting by rating; in a busy market you may want a higher cut-off.
Can I compare review counts between a cafe and a law firm?
Not fairly. Some trades are reviewed far more often than others, so rank within one kind of business.
What if many places have no review count?
They go last when you sort, and a weighed score leaves them empty. Decide whether to keep them on a separate list instead of dropping them.
Templates that do this
Read next
More on business and places data · Every article · Templates