How to build a prospect list from scratch for a local business

A prospect list is only worth having if every name on it looks like a customer you would be glad to win. To build one from scratch for a local business, start with the kind of buyer you already serve best, find more of them in public places around your town, and write each into a sheet with eight fields. Aim for fifty to a hundred names, and correct a row every time you touch it.

Who goes on the list, and who does not?

Only people who look like your best existing customers. If your last good orders came from small schools, the list is small schools, not "educational institutions". Write the one-line description of your target before you collect a single name. Anyone who does not fit that line stays off, however easy they are to find.

Imagine an invented commercial cleaning firm in Madurai that serves hospitals' non-clinical areas, hotels and marriage halls. After looking at its best contracts, the owner finds the profitable ones are marriage halls and small hotels that need deep cleaning before the wedding season. The list is therefore marriage halls and small hotels within reach of the city. Not offices, not hospitals. A typical deep-clean contract here might be ₹25,000 (an invented figure), which is why the target is narrow.

Where can I find names for free?

Look where your buyer is already visible:

• Google Maps. Search "marriage halls in Madurai", scroll the pins, copy name, address, phone. Check the photos to see if they fit.
• Trade and local associations. Hotel associations, marriage hall owners' groups, chambers of commerce often publish member names or hold meetings you can attend.
• Your own phone and invoices. People who enquired and never bought, old customers, friends' recommendations.
• Signboards and hoardings. Walk or drive a main road with a notebook. A new hall under construction is a prospect.
• Existing customers. Ask a happy one: "Who else do you know who has the same problem?"
• Directories such as JustDial. Fine for names, but a listing can be years old, so check each one yourself.

Pick two or three sources, not all.

Which fields should the list hold?

Eight fields is enough:

Resist adding columns for turnover, number of employees, social handles and the owner's birthday. If you will not use a field in the next call, leave it out. An overstuffed sheet is not filled in.

How do I check that a name is worth keeping?

Before you add a row, answer "Why do they fit?" in one line. If you cannot, delete it. In the Madurai example, "Hall near the temple, hosts weddings most weekends, photos show carpets and a large kitchen" earns its place. "Marriage hall, number found online" does not, yet.

Then verify the phone number with a call or message before the real contact. A wrong number found early costs nothing. Found after you have written a careful pitch, it costs a day.

What goes wrong with a list built in one evening?

Suppose the same imagined owner builds the first list in one long evening on Google Maps. It has 120 rows, every pin that says "marriage hall" or "convention centre". The first fifteen calls go badly. Four numbers belong to an event decorator listed under the hall's name, three halls are closed for renovation, and two are small community halls with no kitchen or carpets and no budget for deep cleaning. All of this is made up to show the pattern. With no column saying why any of them fitted, the owner cannot tell the good rows from the bad.

The repair would take an afternoon: add the "Why they fit" column, delete every row without a real reason, and keep perhaps 58. The shorter list is the one the owner would actually work through, though two good halls are lost in the cull and only found again by a customer's referral.

Who may you contact, and how?

A public listing is not permission. Contact a business on its business number, say who you are in the first sentence, and keep a short opt-out list: anyone who says no goes on it, and stays off every later list you build or buy. Rules on calling and messaging, including do-not-call registers, differ by channel and change, so check yours with your own adviser. The same caution applies to a ready-made list: those are often stale and may include people who never agreed to be contacted.

What is the best way to keep it clean?

Make correcting the list part of every contact, not a separate chore. After each call, update the phone, the person, the status and the next date. If a number is dead, mark it, do not delete it, with the reason, so you do not add it again from a different source. If someone asks not to be contacted, write that and keep the row so they stay off. Our post on cleaning and organising CRM data goes further if the list grows into software.

Once a quarter, sort by last contact. Anything untouched and not worth another try goes to a second tab called Parked. Keep it there, not in the live list.

When is a list the wrong tool?

A list helps when you sell to a defined set of businesses that you can name, such as halls, schools, workshops or dealers. It does not suit a product that anyone can buy, such as groceries or a haircut; there, location and a good Maps profile do the work. It also fails when it becomes a hiding place. If you have forty names and have called none, adding fifty more is avoidance. Work through the list before you extend it.

For a more formal build with scoring, see how to build a qualified B2B prospect list. This post is the small, local version.

Opening the sheet today

Open a sheet, add the eight columns, and enter the ten best fits you already know. Call three of them and record what happens. The sales process hub shows how a list feeds the stages after it. If you want help building the list, see prospect research and list development and tell us what you need.