The most common reason a contractor or home services operator hesitates to start a reactivation engagement is some version of "our data is too messy." We hear it on almost every discovery call. It's almost always wrong.
This piece walks through what "messy data" actually looks like, what it costs, and why it doesn't disqualify you from running a reactivation campaign that produces real revenue.
What "messy" usually means
When clients describe their data as messy, they're typically referring to one or more of these:
- Records spread across multiple systems (CRM, spreadsheets, email, paper files)
- Handwritten notes that never made it into a digital format
- Inconsistent fields (some records have phone numbers, some have email, some have both, some have neither)
- Duplicates from people who got entered twice
- Old contact info (phone changed, email bounced, person moved)
- Free-form text where structured data should be (service notes mixed with addresses mixed with project descriptions)
- A mix of customers, leads, vendors, and personal contacts in the same database
If three or more of those describe your situation, congratulations. You have normal small business data. Almost everyone we work with starts here.
What it costs to clean
The instinct most owners have is that cleaning the data is going to cost more than it's worth. That's reasonable on the surface. The math actually goes the other way.
In a typical engagement we look at:
- 1,000 to 5,000 contacts across whatever sources the client has
- 30 to 60% missing email addresses
- 20 to 40% missing or stale phone numbers
- 10 to 25% duplicates
- A wide range of project history quality
Cleaning that takes between 15 and 40 hours of structured work depending on volume and chaos level. Enrichment, which means filling in missing emails and phones using third-party data sources, runs another 5 to 15 hours plus a small per-record data cost. Total time investment to get a 2,000-contact list to a workable state is usually 30 to 60 hours.
Compare that to the math on the other side. A clean reactivation list of 2,000 contacts in any of our target verticals reliably produces between $50,000 and $300,000 in recovered revenue based on our case work. The cleanup cost is a fraction of one project.
What gets fixed in a real cleanup
The work isn't glamorous but the steps are clear:
- Consolidation. Pull every record from every source into one place. Spreadsheets, CRM exports, email, paper notes if there are any. Doesn't matter if it's ugly. Get it in one file.
- Deduplication. Match records by name, address, phone, and email. Merge duplicates. Flag conflicts.
- Standardization. Make sure every record has the same fields in the same format. First name, last name, primary phone, primary email, address, last project, last touch date, source.
- Enrichment. Fill in missing data using external sources. Email verification services. Phone validation. Address standardization. Decision-maker lookups for B2B records.
- Verification. Test deliverability on emails. Flag bounces. Mark records that are clearly dead so you don't waste time on them.
- Segmentation. Tag records by project type, last interaction, vertical, replacement-cycle status, anything else that's useful for prioritizing outreach.
After all that you end up with a structured database that's usable. The "messy" version becomes a tool.
A real example
The case study on our results page covers AJV Contracting in detail. The starting state was eight years of records spread across handwritten notebooks, scanned files, scattered spreadsheets, and a couple of half-used CRM exports. The data was as messy as anything we've seen.
The cleanup took roughly 35 hours of structured work to consolidate, dedupe, enrich, and verify. The output was a clean database of past customers and unconverted estimates with verified contact information. The reactivation campaign that ran on top produced over $200,000 in new business inside 47 days, with three closed projects in the first 60 and ongoing referral revenue from contacts who hadn't been touched in nearly a decade.
The data wasn't a disqualifier. It was the asset. It just needed someone to take the time to make it usable.
What to look for before you start
If you're sitting on data and wondering whether it's worth working, three questions tell you most of what you need to know:
- Roughly how many contacts do you think you have? If the answer is more than 500, the engagement math probably works.
- Is the data anywhere, even if it's scattered? If you have records, even ugly ones, they can be cleaned.
- Do you have any field that ties back to project history? Even rough notes about what someone inquired about, when, and what the project was. That's enough to power personalized outreach.
If those three answer yes (and almost always they do), the data isn't the obstacle. The only real question is whether the project type and ticket size justify the work. Run the math on what 5% reactivation against your average job value would produce. If that number is above $50,000 you have a real opportunity.
The bigger point
Messy data is a normal starting point, not a disqualifier. The companies that build long-term advantage in their market are the ones who invest in turning operational records into usable assets. The ones who don't end up paying for ads to generate new leads while sitting on a pile of warm contacts that already raised their hand.
If your data feels too messy to work with, that's usually a sign there's more opportunity in there than you've estimated. Not less.