Demographic profile of each city
The demographic profile of each city, compared, every quarter.
What it does
Every quarter: the people living in each of your cities (men and women, age groups, density), saved to a sheet and summarised by xMap AI.
In one sentence: Monthly on the 1st at 08:00, in Toronto, Vancouver and 2 more, count who lives around, write a report with xMap AI, then add row in Google Sheets and email the list to you.
Why it is useful
Comparing cities by who lives there is the first step of any market entry. The profiles land in one sheet.
Who it is for
Investors, analysts & consultants. Investors, analysts and consultants who need location numbers they can trust, on a schedule. Every use case for investors & consultants
Best use cases
- A consultant comparing markets
- A retailer choosing a city
- A fund analyst
What each run gives you
- Profiles in a sheet
- A comparison by email
The time it saves
Monthly on the 1st at 08:00. Doing the same work by hand takes about 240 minutes each time; it runs about 1 time a month, so it saves about 4 hours a month (an estimate). It is easy: 6 blocks.
The flow, block by block
- On the 1st of every monthTrigger · ScheduleStarts the flow on a timetable.
- The citiesWhere · Area of interestSets where the flow looks: countries, cities or specific places, or areas you draw on a map.
- Who lives in each cityxMap 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).
- Compare the citiesxMap AI · xMap LLMTell the AI what to do in plain words.
- Save the profilesApp · Google SheetsCreate, edit, and collaborate on spreadsheets online
- Email me the listAction · EmailSends one email per run with all the items, or one email per item.
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.
How to set it up
- Build your first flow in ten minutes: From a blank page to a flow that emails you a ranked list every morning.
- Ask the map a question: How many of a kind of place, how many people for each, and where the gaps are, answered on the spot.
- Enrich a list once: A CSV of addresses or companies back with phone, website, rating and an AI score.
- Count what is around each of your places: Competitors, footfall magnets or services within a distance of each site.
- Location intelligence: Using where things are, and what is around them, to make business decisions.
- Site selection: Choosing where to open a store, branch, clinic or facility.
- How to score candidate store sites: Compare sites on residents, competitors and neighbours, with an AI score and a reason.
More for Investors, analysts & consultants
- Market entry study, refreshed monthly: A market entry study refreshed every month: size, chains, demand, the best areas and the risks.
- Competitor density around each site: People per competitor around each of your sites, ranked.
- Store visit route for a due diligence trip: The branches of a chain you are studying, the strongest and the weakest marked, in the best order to visit them.
- Who lives around new places: The new cafes in your city with the people living around each.
- Market size of a category across cities: Every coffee shop in five cities, counted and summarised every month.
- New openings into my database: New openings saved to your own database every week, classified.