How to build a local prospect list that stays fresh

Do not build a prospect list; build the thing that rebuilds it. Sweep your area once for every business of the kinds you sell to, take out the ones that already buy from you, and then every week add only the businesses that are new and flag the ones that closed or changed. A list kept that way is never more than a week old, and nobody has to start again from a spreadsheet.

This guide is for sales teams and distributors who sell to local businesses: suppliers to restaurants and salons, software for clinics, services for offices, wholesalers calling on shops. It walks through the first sweep, removing existing customers, the weekly refresh, and where the list should live.

Why a list goes stale

A list of local businesses starts ageing the day it is made. Places open, close, move, change their phone number or are bought and renamed. A list bought or scraped once misses every newcomer and keeps sending reps to places that are gone. Beauty salons in one city show how fast the first part happens:

838Beauty salons listed

415Nearest counted

409Independent, of those

31Opened in the last year, of those

Of the 415 salons nearest the centre alone, 31 opened in the twelve months before November 2026. A list of Toronto salons made a year earlier would be missing them, and they are the ones still choosing their suppliers. 409 of those 415 are independent, which is typical of the trades where one owner decides what to buy. More on the beauty salons in Toronto page.

Step one: the first sweep

Start with an Area of interest for the cities or districts you cover, then pick the source that suits your trade.

• Nearby places searches xMap's own database of more than 300 million places, refreshed every month. It gives each place its brand, a chain flag, rating, number of reviews, phone, website and, often, the date it opened. Up to 500 places come back for each type in each search, nearest first.
• Map business scan searches online maps live, which catches places the monthly database has not reached yet. Its Cover the whole area option sends a grid of searches across a big district instead of one search in the middle.

Pick the kinds of place by the database's own names, and include the neighbouring kinds your product suits: a supplier to hair salons usually also sells to barbers and nail bars. If two searches overlap, add Remove duplicates so each business appears once.

Step two: take out who already buys from you

Nothing annoys a customer more than a cold call from their own supplier. Upload your customer list to My data and add Match with my table after the sweep, set to keep only the items it does not find. Match on the phone number or the website rather than the name: names are spelled in many ways, while a phone number compared by its last nine digits rarely lies. If your customers live in a CRM, CRM lookup asks the CRM itself.

Step three: the weekly refresh

Now make the flow run on its own. Two blocks do the work:

• Only new remembers every business the flow has found in real runs and lets through only the ones it has never seen. Each gets a first_seen date. Put it straight after the sweep, before any scoring, so you only spend effort on what is new.
• What changed does the opposite job: it lets through only the businesses the flow found before whose details moved. Ask it for closures, a new phone or website, or a new name or address. A new name often means a new owner, which is a fresh sale.

The whole flow, in order:

1. Schedule: every Monday at 07:00 in your time zone.
2. Area of interest: your cities or districts.
3. Nearby places (or Map business scan): the kinds you sell to.
4. Match with my table: drop existing customers.
5. Two links out of that step: one to Only new for new prospects, the other to What changed for closures and changes.
6. An Email or a Google Sheets row for each, so new prospects and changed ones arrive separately.

The first real run finds everything and remembers it, so it is the big list. From the second run on, only the week's news comes through.

Where the list should live

Every result a flow finds is also kept on the Results page, where the team can filter by flow, city or kind, save a view, and open each business with its facts. For reps who live in spreadsheets, send new rows to Google Sheets. For a manager who wants the numbers in a dashboard, Results can be read live by business intelligence tools through a feed. Pick one home for the list and point the team to it; three copies drift apart within a month.

Mistakes that let a list rot again

• Testing instead of running. Only real runs (a schedule, Run once) are remembered. Test runs show everything as new, every time.
• Matching customers by name. Use phone or website, or you will call your own customers.
• An area far bigger than your reps can cover. A long list nobody visits is not a pipeline.
• Never removing closures. Without What changed, closed places sit on the list until a rep drives to an empty unit.
• Scoring before filtering. Put Only new and the customer match before any AI step, so you only score businesses that matter.