Stores competing with each other

What it does

Every month: your stores that have another of your stores within 1 km, with how many people live around each, and how much they overlap from xMap AI, so you can see where branches split the same customers.

In one sentence: Monthly on the 1st at 08:00, take your table, find the nearest of your points, keep those where store_2_km ≤ 1, count who lives around, work out new fields, score and rank them with xMap AI, then email the list to you and show them on a map.

Why it is useful

Two stores too close split the same customers. This flow shows where branches compete with each other before you open another.

Who it is for

Retail & franchise expansion. Expansion, real estate and network planning teams deciding where the next store or franchise goes. Every use case for retail & franchise

Best use cases

• A chain reviewing its network
• A franchisor protecting franchisees
• A bank planning branch closures

What each run gives you

• An email of close stores
• A map

The time it saves

Monthly on the 1st at 08:00. Doing the same work by hand takes about 180 minutes each time; it runs about 1 time a month, so it saves about 3 hours a month (an estimate). It is medium: 9 blocks.

The flow, block by block

1. On the 1st of every monthTrigger · ScheduleStarts the flow on a timetable.
2. My storesYour data · My dataBrings in a table you uploaded or a list you saved on the My data page: your stores, customers, target accounts or sites.
3. My other stores nearbyWhere · Find nearestFor each place, finds the nearest of your own points from a CSV you upload, for example the nearest ambulance to each accident or the nearest branch to each new lead, and adds its name and the distance.
4. Another store within 1 kmLogic · FilterKeeps only the items that match a rule.
5. Who lives aroundxMap data · DemographicsWho lives in an area: the number of residents, men and women, and nine age groups, from xMap’s population grid (hexagons of about 0.1 km², about 100 countries).
6. People per storeLogic · Calculated fieldAdds fields worked out from the others: a number, a text or a yes/no.
7. Rate the overlap with xMap AIxMap AI · xMap LLMTell the AI what to do in plain words.
8. Email me the listAction · EmailSends one email per run with all the items, or one email per item.
9. Show them on a mapAction · Show on a mapShows the results as points on a map, with the area of interest.

Every block can be changed after you use the template: the city, the type of place, the score, where the results go.

Use it now

Answer a few questions, enter your work email, and it runs in your own account, kept running until you pause it. Use this template.