Lead List Hygiene: A Quarterly Checklist for Clean Data

Lead list hygiene is the routine of checking and correcting a lead list so that every row is accurate, complete, current and allowed to be contacted. A quarterly checklist keeps the work small: remove repeats, re-check the fields that go stale fastest, bring the opt-out list up to date, and write back what each campaign taught you about wrong numbers and dead email addresses. This guide gives the checklist as a table, ranks the fields by how fast they rot, says who should own the list, and walks through one quarter for a list of 3,000 rows.

The short answer

1. Give the list one owner and one master file; every other copy is read-only.
2. Before each campaign, remove duplicates, check the rows against the opt-out list and confirm the fields the campaign depends on.
3. After each campaign, record bounces, wrong numbers, replies and opt-outs on the rows themselves within a week.
4. Every quarter, re-check phones, emails and addresses older than six months and archive rows that have failed twice.
5. Keep a short change log so the next person knows what was done and when.

What is lead list hygiene?

Lead data quality has four parts. A row is accurate when the details are right, complete when the fields you need are filled, current when they still hold today, and permitted when the business has not asked you to stop. Lead list hygiene is the set of habits that keep all four true as the list ages. Without it, a business that opted out six months ago gets a message because its opt-out sat in a copy nobody uses, reps waste calls on numbers that no longer connect, and reports count rows that are not real prospects. None of it needs a special tool; it needs a routine.

Which fields go stale fastest?

Not every column ages at the same speed.

1. A named person's mobile and email. Staff leave, and their number and address go with them. These are the first fields to re-check.
2. The main email address. A company changes its domain when it rebrands, or drops a general inbox that nobody reads.
3. Phone number and address. Landlines change when an office moves, and the listing may show the old address for months.
4. Status. A business can close, merge, rename or change trade. The row stays, but the prospect is gone.
5. Website, business name and trade. The slowest to change and the easiest to verify.

Add a "Last verified" date column. Then "which rows need a check this quarter" becomes a filter, not a guess.

The lead list hygiene checklist

Who owns the list?

A list with no owner rots fastest. Name one person, even in a team of two. The owner keeps the single master file in a shared folder, runs or signs off the campaign checks, keeps the Opt-out sheet and adds to it the same day a request arrives, writes the change log (date, what was done, how many rows changed) and decides what gets archived. Reps edit their own rows: status, notes, last contacted, next action. Our guide to lead management covers that split as the team grows.

What do you check before a campaign?

1. Filter the segment. Pull only the rows the campaign is for, by trade, area and status, and copy them to a dated sheet so the segment is frozen.
2. Run the keys. Add the phone key and domain key, count repeats, and merge or drop the extras; our guide on how to remove duplicate leads has the formulas.
3. Check the opt-out sheet. Every row with a match is removed from the segment, not just marked.
4. Confirm the required field. Email needs an address and a fallback for the name; WhatsApp needs a mobile with its country code and no landlines; calling needs a number and a best time.
5. Spot-check 20 rows by hand. If more than a couple are wrong, verify the whole segment first. Our guide on how to verify business email addresses shows checks that need no paid tool.

What do you update after a campaign?

Within a week, write the results back to the rows:

1. Bounces. A hard bounce (the address does not exist) clears the email field and sets a flag; a soft bounce (mailbox full) stays, with a note to retry once.
2. Wrong numbers. Clear the number, set the flag, and look for a current one on the listing.
3. Replies. Move the status to "Replied", add the name and role of the person who answered, and set the next action.
4. Opt-outs. Add the phone key, email and domain to the Opt-out sheet the same day, and set the row's status to "Opted out".
5. Dates. Set "Last contacted" on every row the campaign touched, and "Last verified" where a reply confirmed the details.

How do you keep the opt-out list current?

The opt-out list is the one sheet you never prune. Requests arrive by reply ("STOP", "remove me"), by unsubscribe link, by phone or by a website form. Each goes on the Opt-out sheet with the date, the channel, the phone key, the email and the domain, so a second row for the same business under another spelling is still caught.

UK PECR, the UAE rules on marketing messages from the TDRA, Saudi Arabia's PDPL and the US federal rules for commercial email all expect a working opt-out that is honoured. This is general information, not legal advice; check the current rules for the country you send to.

Worked example: one quarter for a 3,000-row list

Say a Riyadh supplier of office furniture holds a list of 3,000 businesses across Al Olaya, Al Malaz and King Fahd Road: fit-out contractors, clinics, training centres and small offices. The owner runs the quarter like this:

• Week 1. Keys and COUNTIF find 140 repeats; 95 are merged and 45 dropped. The Opt-out sheet gains 12 rows from last quarter's replies that were never written back.
• Week 2. A filter on "Last verified" older than six months returns 900 rows. A junior checks 60 a day against listings and websites: 70 businesses have moved, 40 have closed, 110 have a new number or email.
• Weeks 3 to 11. Three campaigns run (email to clinics, WhatsApp to contractors, calls to training centres), each with the checks before and the updates after. Together they produce 85 bounces, 30 wrong numbers, 9 opt-outs and 140 replies, all written to the rows.
• Week 12. Rows that failed twice (62 of them) move to the Archive sheet, and the change log gets its quarterly line.

The list ends the quarter at about 2,850 live rows: smaller, but every row is verified or dated and no opt-out sits in a copy.

Where Rovero fits

Rovero is B2B lead generation software for Windows. It finds the businesses of a chosen type in a chosen city, area by area, and collects the emails, phone numbers and address details they publish themselves. Smart filters hide closed businesses and keep only rows with a phone, an email or a claimed listing before you export, so fewer empty fields reach the list. Marketing-ready lists give WhatsApp numbers with their country code and leave landlines out, which removes a whole class of wrong-number results. And an area can be searched again next quarter, with each find checked against everything already saved, so the refresh adds no repeats.

One honest limit: details change over time, so a Rovero lead is a snapshot taken when the search ran; check a lead before an important campaign.

Frequently asked questions

How often should you do lead list hygiene?

Run the duplicate and opt-out checks before every campaign, write results back within a week after it, and do the full re-check of stale rows once a quarter. A monthly pass on status values, owners and a backup keeps the quarterly job small.

What is lead data quality?

Lead data quality is how accurate, complete, current and permitted the rows in a lead list are. A high-quality row has the right details, the fields you need, values that still hold today, and no opt-out against it.

Should I delete bad rows or keep them?

Keep them, in an Archive sheet. A deleted row can come back with the next import and be contacted again; an archived row keeps its history and flags and stops the same business being added as new.

What goes on the opt-out list?

The date, the channel the request came by, the phone number in international format, the email address and the website domain. All three identifiers together catch a second row for the same business under a different spelling.

Next step

Add two columns to your list today, "Owner" and "Last verified", and fill them for the rows you plan to contact this month. When you need fresh rows to replace the ones that aged out, start a free trial of Rovero and search the areas you work in.