How to keep your prospect list clean so calls do not go to the wrong person

A prospect list decays on its own. People change jobs, numbers get reassigned, and the purchase manager you wrote down is now in accounts. To keep calls from landing on the wrong person, add three fields to every row: last verified, status of the number, and whether the name is confirmed. Set aside a morning each quarter to re-verify the rows that matter most. Move unreachable numbers to a separate sheet instead of deleting them.

Why do calls go to the wrong person?

Think of the last time your team called a name from the list and a stranger answered. Wasted minutes are the small cost. The larger cost is the impression: you rang a company and asked for someone who left a year ago, which tells the next person that you do not know them.

It happens because a list records a moment. The row says "Sharma, purchase, 98xxx" and nothing says when that was true. Everything else in this routine is a way of putting a date on the facts.

What are the three fields that mark a row stale?

Add these columns to your sheet or CRM, even if you already have a dozen.

The date of "last verified" matters more than any other. A name confirmed last week is worth far more than one copied from a directory two years ago. Do not count an email being sent as verified. Count a reply, a call that connected, or an order.

What is the quarterly routine?

Set a fixed morning and follow the same order each time.

1. Sort by last verified, oldest first. You do not need to clean the whole list, only the part you plan to call in the coming quarter.
2. Drop the rows with two failed attempts into the unreachable sheet, with the date and the reason.
3. Verify by a short call to the switchboard or the main number, not to the person. The script below shows the wording.
4. Update three fields in the same sitting. If you leave updating for later, it will not happen.
5. Mark duplicates, usually the same company under two spellings, and merge them by hand.

Script for the verification call: "Good morning. I am calling from [your firm]. Could you confirm who looks after [purchase / maintenance / admissions] now? I have the name [old name] and want to be sure before I write to them." Then ask for a direct number or email, and the name's spelling. Write the answer into the row before you end the call.

For example: a packaging tape distributor in Kolkata

Take an invented distributor supplying printed and plain tape to small manufacturers around Howrah and the Dankuni area. Its list holds a few hundred names gathered from a trade association directory and two exhibition visits. When the team calls down it in alphabetical order, say only one call in three or four reaches the person it was meant for (an illustrative figure, not a measured one).

The mistake was treating every row as equal. The correction started with a sort: they pulled the rows with a recorded order or a reply in the last year and called those first. Every other name got a plain email asking one question, whether the person named still looked after packaging purchases. Replies updated the rows. Names that stayed silent got a second attempt and then moved to the unreachable sheet.

The team now knows which rows are alive and which are guesses. The cost is that the first sort put mostly existing customers at the top, so calls to new prospects dropped for a quarter until the email replies refreshed the rest.

What do I do with numbers that never answer?

Do not throw them out, and do not keep calling them either. The rule: two attempts on different days and at different hours, one of them in the morning. If both fail, try one other route, such as the company's general line, email or a listed WhatsApp number for business. If that also fails, move the row.

Your unreachable sheet is a short table, not a graveyard.

Once a year, check that sheet against a business listing or a visit. A company that changed its number may come back to life.

For the rows you cannot call, the plain email to a silent name is one question and nothing else: "We have you down as looking after packaging purchases at [company]. Is that still right, and if not, who does?" No brochure, no attachment. A one-line reply is the whole prize.

When is this not worth doing?

If your list is under fifty names and you are on first-name terms with most of them, you do not need a routine. You will hear when someone moves. The routine pays when the list is large, when more than one person calls from it, or when salespeople leave and take their memory with them.

It is also pointless if nobody owns it. Name one person who runs the quarterly morning, and if that person leaves, hand the job over by name. A shared list that belongs to everyone is cleaned by no one.

Do not use verification calls as a way to sell. A person who answers a clerical question and then receives a pitch will stop answering the next one.

Do the first sort today

Open your list and sort by the oldest date. If the column does not exist, add it and fill it with what you know, and leave the rest blank. Blank is honest: it tells you what has never been checked. If the list lives across several phones and sheets, how to clean and organise CRM data covers merging them first. The sales process hub shows where the list sits at the start of prospecting. For the larger version, see CRM data cleansing, or tell us what you need.