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 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 →

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 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 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.

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.

How Much of Your Customer List Is Wrong?

List math ahead. Skip it if the steps are enough.

Here is Marco’s cleanup. Run the same count on your own list before the next message goes out.

Customer list cleanupNames
Names on the list220
Doubles merged−40
Closed, moved, or gone−18
Wrong numbers, held until found−11
Asked never to be sent anything−6
Clean list145

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.

How Do You Clean a Customer List Step by Step?

Four steps before the next automated message goes anywhere.

  1. Merge duplicates.

    Sort by name, phone, and email, and combine entries for the same customer.

  2. Remove the departed.

    Archive closed businesses, bounced addresses, and anyone who has moved away.

  3. Build the do-not-contact list.

    Record everyone who asked not to be contacted, keep it separate, and check it before every send.

  4. 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.

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.

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.

What Else Do Owners Ask About Data Quality?

What is data quality?
It is how accurate, complete, and current your records are. For a customer list, that means one entry per customer, current details, no departed entries, and a record of anyone who asked not to be contacted.
How often should I clean my customer list?
Before any large or automated send, and on a set schedule after that, often monthly or quarterly. Fix bounces and opt-outs as they happen.
What is a do-not-contact list?
A separate list of customers who asked not to hear from you, checked before anything goes out, so they are never contacted again by mistake.

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.