FlowsBook a callSign inCreate free accountSign up
Business and places data

How to make a list of chain stores in a city, brand by brand

Find every branded outlet of a kind in a city, count the branches each brand has, and see where each one clusters. A method for sales, real estate and competitor teams.

Part of the guide Location intelligence automation

By the xMap team · · 5 min read

To make a list of chain stores in a city, search a places database for the kind of outlet you care about, keep only the places that carry a chain brand, and then count the rows per brand. The result is two things at once: a full list of branches with addresses and positions, and a short table of brands with how many branches each one has in the city. Repeat it monthly and you also see which brands are growing.

Landlords and retail brokers use such lists to know which brands are present before pitching a unit. Suppliers who sell to head offices use them to rank accounts. Competitor teams use them to see a rival's footprint. This article shows how to build one, how to read the brand counts honestly, a worked example and the traps.

What counts as a chain store

In xMap's places database each place can carry a brand and a yes or no for whether it belongs to a chain. A Tesco Express and a Tesco Extra share the brand Tesco; an independent corner shop has no brand and is marked as not part of a chain. Franchise outlets usually count as chain branches, because they trade under the brand. A local business with two shops of the same name may or may not be marked as a chain; judge that case by case.

What a city's figures look like

The mix changes a great deal by trade and city. Some figures from xMap's places database, November 2026:

City and kindCountedIn a chainBiggest brands
London supermarkets437 nearest the centre296Tesco (110), Sainsbury's (101), Waitrose & Partners (29)
Toronto gyms246 within 10 km72F45 Training (23), GoodLife Fitness (15), Anytime Fitness (5)
Sydney hotels414 nearest the centre78Accor (23), InterContinental Hotels Group (8), Rydges (5)

xMap's places database, November 2026. London lists 1,332 supermarkets within 10 km of the centre and Sydney 543 hotels; the chain figures are of the places nearest the centre shown.

Read the brand counts against the number of places searched, not against the city total. In London, two brands hold most of the branded supermarkets among the 437 nearest the centre; in Toronto's gyms, one boutique brand outnumbers the big-box club.

Building the list

  1. Decide the kind of outlet: supermarkets, pharmacies, fuel stations, coffee shops. Pick the matching types in Nearby places; a small group such as all gas station types can be picked at once.
  2. Cover the city in parts with an Area of interest of up to 8 districts, or switch on Cover the whole area so a wide city is searched in seven parts.
  3. Set Chains to Only chains. Places with no brand are left out before anything else happens.
  4. Add Remove duplicates set to the same place, because district searches overlap at their edges.
  5. Add a Data analyst block with the question "how many branches does each brand have, and in which districts?" It writes a small program, runs it on every row and returns a table and a chart.

If you care about one brand only, Nearby places has an Only this brand setting that keeps the places whose brand or name has the words you type, every branch of that chain and nothing else.

A worked example

The figures are made up. A shelving maker in Mexico City wants to sell to pharmacy chains through their head offices.

  1. Nearby places searches the pharmacy types across eight central boroughs, chains only, and finds 640 branches.
  2. Remove duplicates takes out 38 that sat in two boroughs' searches.
  3. Data analyst returns the counts: four brands hold most branches, the largest with 190, then a long tail of brands with fewer than ten each.
  4. The sales lead puts the four large brands on the head-office call list, and the tail on a list for regional distributors.
  5. A map of the 602 branches coloured by brand shows one brand thin in the south, a talking point for its expansion team.

Mistakes to avoid

  • One search at the city centre. A single search returns the nearest few hundred places, so outer branches are missing and the counts tilt to brands that favour the centre.
  • Brand spelling. A brand can appear in two forms, such as with and without a word like Express or Pharmacy. Look at the brand table before you trust the ranking.
  • Dividing by the wrong total. If you searched the 437 nearest places, a brand's share is of those 437, not of every outlet in the city.
  • Forgetting the parent. A hotel group trades under several brand names; decide whether you count the group or each name.
  • Old lists. Branches open and close every month. Treat any list as a snapshot.

Let an AI employee keep the brand table current

A monthly run turns a one-off list into a record of who is growing. See the location intelligence automation guide for the wider picture.

  1. Schedule, the first day of each month.
  2. Area of interest with the city's districts.
  3. Nearby places, Only chains, your types.
  4. Remove duplicates.
  5. Only new in one branch, to list branches that appeared since last month.
  6. Data analyst on the full list for the brand table.
  7. Email with the new branches and the table, and Show on a map coloured by category.

Each month the email names new branches by brand and repeats the table, so a brand that added six outlets stands out. The template New fuel stations in my region, by brand is built this way for fuel, and Chain pet stores opening near my independent shop watches chains from the other side.

Questions

Does a franchise count as a chain store?

Usually yes: a franchise outlet trades under the brand and is listed with it. Check the brand field if your question is about who owns the outlet rather than who it trades as.

How do I count branches per brand?

Keep only chain places, remove duplicates, then count rows by brand. The Data analyst block does the counting and returns a table and a chart.

Can I list every branch of one brand only?

Yes. Nearby places has an Only this brand setting that keeps places whose brand or name contains the words you type.

Why do my counts differ from a brand's own store finder?

The database is refreshed monthly and may lag a new opening, and a brand may list kiosks or concessions inside other stores that the places data names differently.

Templates that do this

Read next

More on business and places data · Every article · Templates

Put it to work

An AI employee in xMap Flows does this on live data, on its own timetable. Start from a template or describe it in plain words.