Follow up on time
Set a next-step date on every open lead and client, and review the list each week.
What needs to be clean: One record per person, with a current email and phone.
The most successful companies grow by using what they know about their customers. A small business already has the raw material in its contact list, invoices, and files. Here is how to use it.
Your contact list, invoices, and files already hold the answers to who your best customers are, who is due for a follow-up, and what to offer next. Large companies like Amazon and Netflix use that kind of data to decide what to offer each customer next. A small business can do the same on a smaller scale, once the data is clean enough to trust.
More than most owners think. A typical small business has:
Each one is useful alone. Connected and clean, they tell you who your customers are, what they buy, and when to reach out.
They use what they already know about each customer to decide what to offer next. McKinsey reported in 2013 that 35 percent of what consumers purchase on Amazon and 75 percent of what they watch on Netflix come from recommendations based on customer data.
Those companies have data teams and custom software. The underlying idea is simple enough for any business: look at what a customer has already bought, and offer the next thing they are likely to need. The key point: the advantage comes from the data, and a small business has plenty of it.
Here are eight practical ways to use the data you already have, and what has to be clean for each one to work.
Set a next-step date on every open lead and client, and review the list each week.
What needs to be clean: One record per person, with a current email and phone.
Pull everyone who bought from you a year ago and has not bought since, and reach out with something relevant.
What needs to be clean: Contacts linked to their purchase history.
Do what Amazon does on a small scale: when a client buys one service, offer the one that usually comes next.
What needs to be clean: Invoices labeled consistently by service.
Rank clients by revenue and by how often they come back. Spend your time accordingly.
What needs to be clean: Client names that match between your CRM and your accounting.
Segment your list by industry, location, or what they bought, instead of sending everything to everyone.
What needs to be clean: Consistent fields, like one way of writing each state.
Look back at similar past jobs to see what they really took and cost.
What needs to be clean: Project and time records tracked the same way every time.
A new person can find the right proposal or contract on day one.
What needs to be clean: Folders and file names that follow one rule.
Ask an AI assistant about your clients or files and get answers built on the right records.
What needs to be clean: No duplicates, no five versions of the same file.
Every use case above breaks if the data underneath is wrong. A duplicate contact means two follow-ups or none. A misspelled email means an offer that never arrives. Inconsistent client names mean your accounting and your CRM cannot be matched.
This is common even at large companies. Gartner research from 2020 put the average cost of poor data quality at $12.9 million a year per organization. A 2017 study in Harvard Business Review found that 47 percent of newly created data records had at least one critical error. IBM describes clean data as crucial for adopting AI and automation tools.
The takeaway: clean the data first, then put it to work.
Start with a question, not a cleanup project. The question tells you which data matters.
Who are my best customers? Who has not heard from us in six months? Who do we know in Los Angeles?
Usually your CRM or contact list, plus your accounting tool for what each client bought.
Merge duplicates, fix formats, match client names across systems, and fill in missing websites and details that can be confirmed.
A saved view in your CRM, a filter or pivot table in a spreadsheet, or an AI assistant working from the clean records.
Enter every new contact and sale the same way. Each good record makes the next answer faster, and over time the data becomes a real advantage. That ongoing care has a name: data stewardship.
Weighing who should do the cleanup? See the best way to clean up your contact lists, CRM, and files.
Start with the data you already have. Use your contact list and sales history to follow up on time, win back past customers, suggest the next service, and focus on your best clients. Each of these works only if the underlying records are clean and consistent.
Usually not. Most small businesses can do a lot with the CRM, accounting tool, and spreadsheets they already have, once the data in them is clean and organized.
Usually, yes, once more than one person uses your contact list, spreadsheets, or shared drive, or once they feed another tool. Each duplicate, typo, or missing field costs a follow-up, an invoice, or a wrong answer.
More answers in the Well Kept data cleaning FAQ.