Rural towns with people and no phone shop

Rural towns with people and no phone shop within 5 km.

MediumMonthly

Telecom & connectivityTelecomRetail

Use this template

What it does

Every year: markets and bus stations in your rural region, with the people around each and the phone shops within 5 km, the fewest first, for retail expansion.

In one sentence: Monthly on the 1st at 08:00, in Addis Ababa, find markets and bus stations in the area, count who lives around, count the cell phone stores within 5 km of each, sort them by nearby_count and keep the top 20, then show them on a map and email the list to you.

Why it is useful

Rural customers travel far for a SIM or a repair. A shop in the right town wins the area.

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

  • A mobile operator’s retail team
  • A phone franchise
  • A mobile money agent network

What each run gives you

  • An email with the list
  • A map of the results

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 regionWhere · Area of interestSets where the flow looks: countries, cities or specific places, or areas you draw on a map.
  3. Town centresxMap 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. 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).
  5. Phone shops within 5 kmxMap 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.
  6. The fewest nearby 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.
  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 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

More for Telecom & connectivity