Clean up your customer list in five steps

Most home service businesses have years of records sitting idle. Treat the list as an asset and work it on purpose.

1. Clean. Remove duplicates, fix phone numbers, and flag moved and do-not-call records.
2. Segment. Group by recency, equipment age, history and open estimates.
3. Sequence. Plan the calls, texts and email for each group.
4. Convert. Use trained people who book the visit.
5. Measure and recycle. Track results by group and feed non-converts into the next pass.

Repeat quarterly, timed to the seasons that drive your trade.

Why this comes first

Dialing a dirty list wastes the most expensive thing you have: a trained person's time. It also annoys customers. Calling someone about a furnace they replaced three years ago, or a house they sold, tells them you don't actually know them.

Step 1: Export everything

Pull customers, service locations, equipment, jobs, invoices, plans and estimates from your software. If you've changed systems over the years, get the older data too. Keep the original files untouched and work on a copy.

Step 2: Fix the basics

• Merge duplicates. Check by phone number first, then address, then email.
• Standardize phone numbers to ten digits.
• Split combined fields, so street, city, state and ZIP each have a column.
• Mark landlines and mobile numbers, if you can.
• Remove test records, vendors and employees.
• Separate the customer from the service address. Owners move, houses don't.

Step 3: Flag what you can't call

Do this before anyone sees the list. Mark internal do-not-call requests, people who complained, and active disputes or collections. Scrub against the National Do Not Call Registry and any applicable state lists. Note whether you have consent for texting. Read the calling rules and check with your attorney.

Step 4: Segment by what you know

A segment is worth having if it changes what you say. Good starting segments:

• Equipment age: systems and water heaters by install year
• Recency: seen in the last 6, 12, 24 and 36 months
• Plans: active, expiring, lapsed
• Open estimates: by date and amount
• Repair history: repeat calls on the same equipment
• Value: total spent over the life of the account
• Location: ZIP code, so bookings can be clustered

Step 5: Match the message to the segment

A customer with a 14-year-old system and an open estimate should get a different call than someone who had a faucet fixed last spring. Write a short script for each segment. Offer two windows. Book the visit, and let the technician handle the diagnosis.

Step 6: Plan the sequence

Set the number of attempts, the time between them, and the channels you'll use. Decide when a record rests. A common mistake is working the list once, hard, and never coming back. It's better to run a pass, rest the list and return next season with a new reason to call.

Step 7: Record every outcome

Use a short, fixed set of outcomes: booked, not interested, call back later, wrong number, moved, already replaced, do not call. Update the record right away. "Already replaced" is valuable: note the equipment and ask who did the work. "Moved" tells you to reach out to the new owner, within the rules. Every call should leave the list better than it was.

How often to clean

Run duplicates and bad-number checks every quarter. Update do-not-call status on the schedule your attorney recommends, and before any campaign. Assign one person to own data quality.

Stop new mess at the door

Most list problems start at booking. Make phone, address and equipment fields required. Teach your CSRs to confirm details on every call, and give your techs a quick way to add equipment information. Once you've cleaned the list, estimate its value.

Sources: White Paper 05.

Published by Service ProCall. Last reviewed November 2026.