Best neighbourhoods to target ads around a store

What it does

Every month: who lives in every block within 3 km of each of your stores, the 20 blocks with the most adults, a targeting brief from xMap AI, saved to a sheet for your ad campaigns and shown on a map.

In one sentence: Monthly on the 1st at 08:00, take your table, count who lives around, sort them by adults_20_59 and keep the top 20, write a report with xMap AI, then add row in Google Sheets, show them on a map and email the list to you.

Why it is useful

Ads around a store work when they reach the people who live there. This flow picks the blocks to target.

Who it is for

Marketing & agencies. Agencies and marketing teams looking for clients, targeting areas and watching reputations. Every use case for marketing & agencies

Best use cases

• A retail marketing team
• A clinic group
• A gym chain

What each run gives you

• A sheet of target areas
• A map

The time it saves

Monthly on the 1st at 08:00. Doing the same work by hand takes about 120 minutes each time; it runs about 1 time a month, so it saves about 2 hours a month (an estimate). It is medium: 8 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. People in every block around itxMap 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).
4. Best 20 firstLogic · Sort and limitPuts the items in order, and can keep only the first ones: the 10 best rated, the 20 nearest, the highest fit scores.
5. Write the targeting briefxMap AI · xMap LLMTell the AI what to do in plain words.
6. Save the target areasApp · Google SheetsCreate, edit, and collaborate on spreadsheets online
7. Show them on a mapAction · Show on a mapShows the results as points on a map, with the area of interest.
8. Email me the resultsAction · 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.