Bad CRM data does not announce itself. It shows up as leads that never get called, automations that fire on the wrong records, and a forecast nobody trusts. This playbook is the practical companion to our article on why your CRM data is quietly costing you revenue. The article explains the problem. This gives you the fix, as a sequence you can actually run.
What is inside
- The money fields. How to find the handful of fields that actually drive routing, automation, and your forecast, and why those are the only ones worth defending at first.
- The 30-minute audit. A quick way to measure fill rate and duplicates and put a real number in front of leadership, on one screen.
- Dedup and validation. How to merge what is there and stop new duplicates and bad values from ever being created again.
- Enrichment done right. Where automated backfill helps, and the order that keeps you from paying to refill a leaking bucket.
- Governance and the 90-day plan. Who owns it, the weekly ritual that holds the line, and a week-by-week plan to get from mess to trustworthy.
- The data hygiene scorecard. A simple rubric to grade where you are today and track it over time.
Get the full playbook
Enter your work email and we will unlock the complete playbook right here, including the step-by-step process and the data hygiene scorecard. No fluff, no five-part email course.
We will send the occasional useful thing and you can unsubscribe anytime. No spam.
The playbook
Run these in order. The whole point is that you do not try to fix everything at once. You protect what matters, measure it, and hold the standard.
Step 1. Name your money fields
Before you clean anything, decide what is worth cleaning. For almost every B2B SaaS team, five fields carry most of the revenue weight: the record owner, the lifecycle or deal stage, the deal amount, whatever field your routing keys off, and the primary contact email. These are the fields your pipeline, automations, and follow-up actually depend on. Write them down. This short list is what you will defend.
Step 2. Run the 30-minute audit
You cannot manage what you have not measured, and the number is usually worse than anyone guesses. For each money field, pull a simple report: what percentage of active records have it filled, and does the value look plausible. Then run a duplicate check on accounts and contacts. Put the results on one screen. A slide that says "31 percent of new leads have no region, and we have 1,900 duplicate accounts" does more to unlock budget than any argument you can make.
Step 3. Merge duplicates, then block new ones
Merge the obvious account and contact duplicates first, because they distort every account-level number you report. Then turn on duplicate prevention so the same mess cannot rebuild itself: matching rules on create, and a single agreed way that accounts get made. Cleaning duplicates without blocking new ones is bailing a boat without patching the hole.
Step 4. Add validation on the money fields
Lock down the five fields at the point of entry so they cannot go blank or wrong. Make the routing field required on the form and on record creation. Constrain stages and amounts to sane values. Keep it to the few fields that matter, because fifty required fields just teach reps to type "n/a" to escape the form. Validation is what turns a one-time cleanup into a standard that holds.
Step 5. Enrich the gaps, in that order
Only now, once the process cannot re-dirty itself, point enrichment at the fields that are still thin. Automated firmographic and contact backfill fills blanks with a system instead of a rep who would rather be selling. Doing enrichment before Steps 3 and 4 is the classic mistake: you pay every month to refill fields that keep emptying, because you never fixed why they empty.
Step 6. Give it an owner and a weekly ritual
Data quality survives when one person is clearly responsible for it, even part time, with a simple written definition of what a complete record looks like. Add a fifteen-minute weekly ritual: check the fill-rate report on the money fields, merge any new duplicates, and note anything drifting. That is it. The houseplant lives because someone owns the watering, not because everyone agrees it should be watered.
The data hygiene scorecard
Grade yourself honestly on each row. Anything below "Good" is a place to start. Re-run it monthly and watch the column move.
| Area | Weak | Good |
|---|---|---|
| Money-field fill rate | Below 80 percent, and no one is watching it | Above 95 percent, measured on a report |
| Duplicates | Common, tolerated as a fact of life | Rare, blocked on create, merged fast |
| Validation | Free-text everywhere, blanks allowed | Money fields required and constrained |
| Enrichment | Manual or none, gaps sit for months | Automated backfill on the fields that matter |
| Ownership | Everyone's job, so no one's | One owner, a weekly ritual, a written standard |
The mindset that makes it stick: data quality is not a cleanup project you finish, it is a standard you hold. Cleanups end and decay wins. Standards run every day, and they are the only thing that keeps a clean CRM clean.
Want us to run this with you?
Take the free RevOps Health Check for a scored read on where your data is leaking, or book a call and we will walk your CRM and point at the actual holes.
Take the RevOps Health Check Book a Free Consultation