Sports clubs with the fewest physios nearby

Sports clubs with the fewest physios nearby, for your partnerships team.

MediumMonthly

Fitness, beauty & wellnessFitnessHealthcare

Use this template

What it does

Every month: sports, football and rugby clubs in your city, the physiotherapists within 2 km of each, the 20 with the fewest, with details, saved and emailed to your partnerships team.

In one sentence: Monthly on the 1st at 08:00, in Auckland, find sports clubs, football clubs and rugby clubs in the area, count the physical therapists within 2 km of each, sort them by nearby_count and keep the top 20, then add row in Google Sheets and email the list to you.

Why it is useful

Sports clubs need injury care close by. Clubs with no physio nearby are the easiest partners for a clinic.

Who it is for

Fitness, beauty & wellness. Gym, studio, salon and spa brands choosing locations, watching rivals and filling classes. Every use case for fitness, beauty & wellness

Best use cases

  • A physiotherapy clinic
  • A sports medicine group
  • A sports insurer

What each run gives you

  • A sheet of clubs
  • An email

The time it saves

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

The flow, block by block

  1. On the 1st of every monthTrigger · ScheduleStarts the flow on a timetable.
  2. My cityWhere · Area of interestSets where the flow looks: countries, cities or specific places, or areas you draw on a map.
  3. Sports clubsxMap 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. Physios nearbyxMap 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.
  5. Fewest physios 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.
  6. Save the clubsApp · Google SheetsCreate, edit, and collaborate on spreadsheets online
  7. 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 Fitness, beauty & wellness