Phone retail footprint across India

What it does

Every month: phone shops in two big cities, every part searched, sorted by xMap AI into operator, brand and independent stores, each once, the people around them, a footprint report, saved to your database and Google Drive, emailed and mapped.

In one sentence: Monthly on the 1st at 08:00, in Mumbai and Delhi, find cell phone stores in the area, clean up their categories, remove duplicates, count who lives around, work out new fields, write a report with xMap AI, save them to your database, then create file from text in Google Drive, email the list to you and show them on a map.

Why it is useful

Market studies of phone retail are costly and quickly stale. This flow counts every shop each month and keeps the history.

Who it is for

Telecom & connectivity. Mobile operators, internet providers and phone retailers planning shops, dealers and network capacity. Every use case for telecom

Best use cases

• An operator entering a market
• A device brand planning distribution
• A consultant

What each run gives you

• A footprint report
• Data in your database and Drive
• A map

The time it saves

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

The flow, block by block

1. On the 1st of every monthTrigger · ScheduleStarts the flow on a timetable.
2. CitiesWhere · Area of interestSets where the flow looks: countries, cities or specific places, or areas you draw on a map.
3. Phone shopsxMap data · Nearby placesPlaces around a point from xMap’s own places database (300M+ places, refreshed every month): pick the types of place (more than 5,000, such as Restaurant, Cafe, Pharmacy, Hospital or Gas station, or a whole group of them) and how far to look.
4. Operator, brand or independentxMap AI · Place classifierAssigns clean categories and merges duplicate places.
5. Each shop onceLogic · Remove duplicatesKeeps one of each item when the same one arrives more than once, for example from two searches that overlap.
6. 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).
7. People per shopLogic · Calculated fieldAdds fields worked out from the others: a number, a text or a yes/no.
8. Write the footprint reportxMap AI · xMap LLMTell the AI what to do in plain words.
9. Save to my databaseYour data · Save to my databaseSaves the items into a table of your own database (PostgreSQL, BigQuery or Snowflake): each field goes into the column of the same name, the others are left out.
10. Save the data to Google DriveApp · Google DriveCloud storage and file backup
11. Email me the listAction · EmailSends one email per run with all the items, or one email per item.
12. 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.