Dr. Paul Borosky, DBA, MBA
Business Consultant & Author
What Is Data Quality, and Why Clean Your Customer List?
A Machine Repeats Your Mistakes Faster Than You Ever Could.
By the time anyone looks closely, a typical small business customer list is about a third wrong. Lists grow for years and almost never get cleaned. Dr. Paul Borosky, DBA, MBA, sees the result when an owner automates messages for the first time: duplicates, closed businesses, and customers who asked never to be contacted, all reached in one afternoon.
Last Updated: 11/15/2026 · Written by Dr. Paul Borosky, DBA, MBA
The Definition
What Is Data Quality?
Short Answer
Data quality is how correct, complete, and current your records are. A healthy customer list has a single line per customer, contact details that still work, no businesses that have closed, and a clear flag on anyone who asked to be left alone. It also has one named keeper who reviews it on a schedule.
Garbage in, garbage out, now at machine speed
Doctor Owl, in Plain English
“If someone asks you to stop writing, record it. They won’t forget, even if you do.”
How This Guide Works
Need the cleanup steps? The Short Answer and the four steps cover them. Want to see what a dirty list does? Follow Marco, a marten from Dr. Paul’s Fabled Forest Business School Series left in charge of Frankie’s pizza business for a week, the same week an automated message goes out to the old customer list. His story runs in gold notes, and the list math has its own section.
Want Your Customer List Cleaned Before You Automate?
Clean it with Dr. Paul, plan your marketing from it, or learn the steps first. Start with the list your next message will go to.
Business Consulting
FeaturedCustomer list full of duplicates and old names? Dr. Paul helps you clean it and set up a simple owner and schedule.
See consulting options →Business Plan Writing
Dr. Paul writes plans with customer and marketing numbers built on clean data.
Start your plan →Business Plan Templates
A Word plan and Excel model with customer and sales sections ready for real numbers.
Browse templates →Small Business Education
Free lessons and Fabled Forest books on records, marketing, and data.
Start learning →From Dr. Paul’s Fabled Forest
Meet Marco: A Marten With the Keys and a Note
Frankie has finally taken a week off. In Dr. Paul’s Fabled Forest Business School Series, his general manager Marco is left with the keys, the route board, and a note telling him not to send Frankie any messages. The trucks go out on time, because the routines are written down.
At a quarter to nine, a mouse arrives at the gate with a message from Fast Frankie’s: your weekly order is ready, collect from Truck Two on Tuesday. The mouse used to help at a bakery that closed in the autumn. “We don’t have a bakery,” she says. By ten there are four more creatures at the gate, including a hedgehog who got the same message three times. Before leaving, Frankie had set the office disc to send reminders every Monday to every name on his customer list. At seven that morning it sent two hundred and twenty.
Why It Matters
Why Does a Dirty Customer List Matter Now?
Because tools act on lists without judgment. A person writing to customers by hand would skip the closed shop and the person who complained last spring. An automated message goes to every line, instantly, including the duplicates and the people who asked to be left alone. That’s garbage in, garbage out, at machine speed.
Data quality is the cleanup that makes automation safe. It belongs in the Fix job, next to data management: decide where the list lives, then keep what’s on it true. It’s also part of the Organize step in Dr. Paul’s Organize-Plan-Grow™ Strategy.
Signs you have this problem:
- The same customer appears two or three times.
- Messages bounce or go to businesses that have closed.
- Nobody tracks who asked not to be contacted.
- The list has never been cleaned since it was started.
- Several people add to it, and nobody owns it.
- Customers reply asking why they got a message at all.
In the Fabled Forest
The hedgehog wanted to know whether he had ordered three of something. A pair of finches had moved to the jungle in the summer. It did what it was told, Doctor Owl said later at the yard: every name on the list.
What Clean Looks Like
What Does a Clean Customer List Look Like?
- One entry per customer. Duplicates merged.
- Current contact details. Bounced or wrong addresses fixed or removed.
- No departed entries. Closed businesses and people who moved away are archived.
- A do-not-contact list. Kept separately and checked before every message.
- An owner and a schedule. One named person checks it on a set day.
In the Fabled Forest
Marco went down all two hundred and twenty names with a pencil. Forty were doubles. Eighteen were gone. Eleven had wrong numbers. Six had asked never to be sent anything, and Frankie had remembered most of them without writing it down. Seventy-five bad lines: a third of the list.
Keeping It Clean
How Do You Keep Customer Data Accurate?
Clean it before any big send, then keep it clean with a short routine. Fix bounces right away. Add every “please don’t contact me” to the separate list the moment it’s said. Review the whole list on a set day, monthly or quarterly depending on how fast it changes.
Give one person the job, and make it part of their week, not an extra. And keep only what you actually use, which also helps with data privacy.
In the Fabled Forest
Marco set the wrong numbers aside until the drivers could track them down, and gave the people who had said no a list of their own. When Frankie came back and saw the clean list, he handed it straight to Marco to keep, checked on the first Monday of every month.
The Numbers
How Much of Your Customer List Is Wrong?
Here is Marco’s cleanup. Run the same count on your own list before the next message goes out.
| Customer list cleanup | Names |
|---|---|
| Names on the list | 220 |
| Doubles merged | −40 |
| Closed, moved, or gone | −18 |
| Wrong numbers, held until found | −11 |
| Asked never to be sent anything | −6 |
| Clean list | 145 |
Illustration. Counts from the book. The cost per send below is an example.
Step 1: Find the bad share. 40 + 18 + 11 + 6 = 75 bad lines out of 220, or 34 percent.
Step 2: Count the cost of each send. If each message or mailer costs $0.60, sending to 75 bad lines wastes about $45 a send.
Step 3: Count the damage. At two sends a month that’s about $1,080 a year in waste, plus the harder cost: 6 people who asked to be left alone and heard from you anyway.
List counts from the book; the cost per send is illustrative.
Step by Step
How Do You Clean a Customer List Step by Step?
Four steps before the next automated message goes anywhere.
Merge duplicates.
Sort by name, phone, and email, and combine entries for the same customer.
Remove the departed.
Archive closed businesses, bounced addresses, and anyone who has moved away.
Build the do-not-contact list.
Record everyone who asked not to be contacted, keep it separate, and check it before every send.
Name an owner and a schedule.
One person checks the list on a set day. The common mistake is automating first and cleaning later.
In the Fabled Forest
Doctor Owl’s scroll for Marco covered the same ground in five short lines: doubles, departed, wrong details, every no honored, and one keeper.
Marco’s Full Story
Did Frankie Ever Read the Wire?
The book has the whole week: the mouse at the gate, the hedgehog with three messages, Marco’s pencil going down every line, and the hawk’s old sales list sent out across the square.
Technology and AI for Small Businesses shows why clean records come before every automation.
A Business Consultant’s View
What Do Business Consultants Find in Small Business Customer Lists?
Dr. Paul Borosky, DBA, MBA · Business Consultant
When Dr. Paul reviews a client’s customer list, roughly a third is often out of date: duplicates, closed accounts, wrong contact details, and no record of who asked to be left alone. It rarely matters until the owner automates a message. Then every error goes out at once, and the owner hears about it from customers. Dr. Paul has owners clean the list before any automation and name one person to own it. It is one of the least exciting jobs in the business, and one of the most protective.
FAQ
What Else Do Owners Ask About Data Quality?
What is data quality?
How often should I clean my customer list?
What is a do-not-contact list?
Keep Going
Where This Leads
This is foundation 17 of twenty. Every data term is in the technology and AI glossary.
Written by Dr. Paul Borosky, DBA, MBA, business consultant and author of books on Amazon. About to send to an old list? Clean it with Dr. Paul first.
This page is for general education. It is not legal, security, or other professional advice. No real products are named or endorsed, the numbers are illustrations, and the Fabled Forest is invented.