The Hidden Cost of a Messy Contact List
A landscaping company in its third year has 800 customers in its system. About 200 of those records have wrong phone numbers, wrong addresses, or duplicate entries. Every time they send a seasonal promotion or try to schedule a follow-up visit, 25% of their outreach fails silently.
That's not a marketing problem. It's a data problem.
Where Local Service Business Data Goes Wrong
Wrong or outdated phone numbers: Customers move. Numbers change. A phone number captured 2 years ago may no longer reach the same person. For service businesses that rely on phone calls for booking, this is immediate lost revenue.
Duplicate customer records: The same customer booked online once and called in once. Two records. The next time you try to do a promotional mailing, they get it twice — or worse, one version of the record gets all their service history and the other gets the promotional outreach.
Sohovi automatically finds every duplicate in your dataset — including near-matches — and shows you exactly which rows are affected.
Wrong service addresses: For businesses that service a location (not a person), the address IS the customer. A wrong address means a missed appointment and a wasted technician trip.
Missing service history: When a tech shows up to a job without knowing what work was done last time, it looks unprofessional and wastes time on-site. Incomplete service history is a customer experience problem that starts in your data.
Manual entry errors: "123 Main St" vs. "123 Main Street" vs. "123 Main" — all the same address but stored as three different records in many systems.
The Revenue Impact
Calculate it directly:
- How many customers in your database have undeliverable phone numbers? (test a sample)
- How many duplicate records do you have? (each duplicate is a potential double-send or missed communication)
- How many appointments in the last 6 months were missed or rescheduled due to wrong address data?
For most local service businesses, this calculation produces a number that justifies a serious cleanup project.
The Fix: A Quarterly Data Hygiene Session
Once per quarter, spend 2 hours reviewing your customer database:
- Call any number that hasn't been used in a contact in 12 months
- Merge duplicate records (same name + same neighborhood is usually the same customer)
- Flag and follow up on records with missing addresses
- Archive customers you haven't served in 3+ years
This isn't exciting work. But a clean database means every dollar you spend on marketing or outreach reaches a real person who might actually book.
Where to Start
The quarterly hygiene session above works, but it's manual. If you want a faster first pass, export your customer list as a CSV and run it through Sohovi — it flags duplicate records, missing fields, and format inconsistencies (like the "123 Main St" vs. "123 Main Street" problem) automatically, in your browser, with nothing uploaded to a server. The same clean export also improves your review request pipeline, since both problems trace back to the same underlying contact records.
