Local sports clubs to sponsor near my stores

Sports clubs near each store, approved for sponsorship.

MediumMonthly

Marketing & agenciesMarketingSports

Use this template

What it does

Every year: sports clubs and academies within 3 km of each store in your table, the best-rated first, with the club chair from Apollo, for a local sponsorship programme.

In one sentence: Monthly on the 1st at 08:00, take your table, find sports clubs and soccer clubs nearby, remove duplicates, find the President, Chairman and Director with Apollo, wait for approval, then add row in Google Sheets and email the list to you.

Why it is useful

Local clubs bring whole families to a brand. Sponsoring those nearby builds loyalty.

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 chain
  • A fast food brand
  • A car dealer group

What each run gives you

  • A Google Sheet

The time it saves

Monthly on the 1st at 08:00. Doing the same work by hand takes about 90 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. Our 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. Sports clubs 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.
  4. Each club onceLogic · Remove duplicatesKeeps one of each item when the same one arrives more than once, for example from two searches that overlap.
  5. Club chair from ApolloYour data · ApolloThe people to talk to at each company, and the company’s details, from your own Apollo account (apollo.io): decision makers by job title with their LinkedIn and work email; or the company’s size, industry, revenue and LinkedIn page; or a person from their email.
  6. Approve the clubsLogic · ApprovalStops the run until someone says yes.
  7. Add them to the sponsorship planApp · Google SheetsCreate, edit, and collaborate on spreadsheets online
  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.

How to set it up

More for Marketing & agencies