Numbers and Planning
How to Clean an Old Customer List Before You Contact Anyone
Duplicates, dead numbers, and people who asked you to stop can sink a reactivation campaign before it starts. Six steps to a list that is safe to message and personal enough to get replies.
Want to know what your own list is worth? Book a 15-minute strategy call and we'll map it out with you.
Before you contact anyone on an old list, merge the duplicates, remove anyone who asked not to be contacted, drop names with no real relationship to your business, fix or flag bad numbers and emails, and add what you know about each customer's last job. A clean list protects your phone number and email reputation, and it makes every message more personal.
Most customer lists are messier than their owners think. They live in three places: the CRM, the invoicing tool, and a spreadsheet someone started years ago. Numbers change, people move, and the same customer shows up four times under slightly different names. Sending to that list as is can lead to blocked texts, bounced emails, and annoyed customers.
Step 1: Pull everything into one place
Export every source you have: past jobs, open estimates, missed calls, web form inquiries, and old leads. Put them in one spreadsheet with the same columns. At a minimum:
- Name
- Phone number
- Date of the last service or quote
- What it was for (job type, quote amount)
- Where the record came from
Step 2: Merge duplicates
The same customer often appears as "Bob Smith," "Robert Smith," and "R Smith" with one phone number. Match on phone first, then email, then name and address. Keep the newest contact details and the full history, so a message can mention their latest job instead of their oldest.
Step 3: Remove people who should not hear from you
- Anyone who asked to stop. Opt-outs from any channel, any year. If someone said stop by text, do not email them either.
- No real relationship. Bought lists, scraped numbers, and contacts you cannot trace to a job or an inquiry.
- Unhappy endings. Disputes, refunds, or bad reviews that were never resolved. Handle those personally, if at all.
- People who are not customers. Vendors, suppliers, and other contractors who ended up in the CRM.
Step 4: Check the contact details
Old lists lose good contacts every year as numbers change hands and inboxes are abandoned. Before sending:
- Phone numbers. Fix the formatting, remove obvious fakes (555 numbers, the same digit repeated), and find the landlines, which cannot receive texts. A phone validation service can flag disconnected and reassigned numbers.
- Emails. Fix obvious typos, set aside shared addresses like info@ or office@, and run the rest through an email verification tool. Sending to lots of dead addresses can hurt how inbox providers treat every email you send.
Step 5: Add what makes the message personal
The best reactivation messages mention something specific: the furnace tune-up last October, the roof estimate from spring, the treatment package that ran out. Fill in the last service, job type, and date wherever you can. One real detail turns a blast into a conversation.
Step 6: Sort and segment
| Segment | Why it matters |
|---|---|
| Open estimates | Highest intent, and a natural reason to reach out |
| Past customers due for service | The timing gives you a useful message |
| Lapsed plans or packages | They already paid for ongoing care once |
| Missed calls and old inquiries | They reached out first and never got a real answer |
Give each segment its own message, then send in waves your team can answer.
How much of my list will survive?
It depends on how old the list is and how it was kept. Lists that go back several years can lose a real share to duplicates, dead numbers, and opt-outs. That is fine. A smaller clean list books more than a big messy one, and it keeps your sending reputation intact.
Common questions
Is it worth cleaning a small list?
Yes. A few hundred names takes an afternoon, and one avoided complaint or blocked number is worth it.
Can I text someone who only gave me an email?
Be careful. Reach people through the channels they gave you, and when in doubt, start with email. Texting rules are stricter and vary by state.
What if I am not sure someone opted out?
Leave them off. One fewer message costs little. Contacting someone who asked you to stop can cost a lot.
How often should I clean it?
Before every campaign, and whenever you import new records. Opt-outs should come off the moment they arrive.
A note on how we work. Rekindle IQ reaches a business's past customers in that business's name and books the ready ones back onto its calendar. Every engagement is scoped on a strategy call. Nothing here is a promise of results, which vary with the list, the offer and the season.
