Data Quality Metrics That Matter
You could track a hundred data quality metrics. Field completion percentages, format compliance scores, freshness indicators, consistency ratios. Most of them won't tell you anything useful.
The metrics that matter are the ones that predict operational problems. The ones that, when they go bad, mean something breaks. Here are those metrics, how to calculate them, and what targets to aim for.
The Problem with Most Data Quality Metrics
Traditional data quality frameworks give you metrics like "correctness," "completeness," "consistency," and "timeliness" (the standard dimensions defined by DAMA International's DMBOK). These sound reasonable but often miss the point.
A single completeness percentage does not tell you what to fix. Report completeness by field and workflow, then identify which missing values affect routing, reporting, or outreach.
Good metrics connect directly to operational outcomes. When this metric gets worse, something specific breaks. When it improves, something specific works better. That's the test.
The Core Metrics
Email Validity Rate
Set separate completeness targets for active marketing contacts and the full database, then revise them from observed workflow failures.
Percentage of email addresses that are verified valid and deliverable. This directly predicts campaign bounce rates and deliverability health. Below 85%, you're risking sender reputation damage that affects all your email (email service providers like SendGrid recommend keeping bounce rates under 2% to protect sender reputation).
How to measure: Run your contact emails through a verification service. Count valid/total. Segment by marketing status since active contacts matter more than dormant ones.
When to check: Monthly for active marketing contacts, quarterly for full database.
Duplicate Rate
Set the duplicate-rate threshold from the cost of review and the risk of false merges, then track movement from the dated baseline.
Percentage of records that have one or more potential duplicates in the system. Duplicates break attribution, fragment engagement history, cause routing conflicts, and can lead to embarrassing double outreach.
How to measure: Run duplicate detection using email exact match, name + company fuzzy match, and phone number match. Count unique records flagged as having duplicates. Divide by total records.
When to check: Monthly. Track trend over time to see if duplicates are being created faster than they're being merged.
Routing Field Completion
Set a high completion threshold for fields used in lead routing, then report exceptions by queue and source.
Measure the percentage of leads and contacts with the fields your routing rules depend on. A missing routing field should be reported as an exception rather than silently assigned a default.
How to measure: Identify the specific fields your routing logic uses (typically: company size, industry, country, maybe title or revenue). Calculate completion rate for each on your active lead population.
When to check: Weekly if you have high lead volume. At minimum, before any routing rule changes.
Contact-Account Association Rate
Choose an association threshold that reflects which contact types should have an account, and review valid exceptions separately.
Percentage of contacts that are properly linked to company or account records. Unassociated contacts are absent from account-level campaign selection, scoring, sales views, and rollup reporting. Report the unassociated population by source and record type so valid exceptions do not mask a broken association workflow.
How to measure: Count contacts with no account/company association. Divide by total contacts. For HubSpot, this is contacts without company associations. For Salesforce, contacts without an account relationship.
When to check: Monthly. Spikes often indicate integration issues or import problems.
Why These Metrics Drift: Data Decay
A clean database changes over time as people move, companies are acquired, domains lapse, and phone numbers are reassigned. Measure field-level change between dated samples, then set the review cadence from changes observed in your own system.
That's why each metric above comes with a cadence. A single audit gives you a snapshot. The trend is what tells you whether your processes are keeping up with decay or losing to it.
Decay also concentrates in specific segments. Measure change against a dated baseline instead of applying a general decay benchmark, then set the review cadence from the changes observed in your own system. Contacts from purchased lists decay faster than inbound signups because the data was already stale when you bought it. When you run your quarterly deep dive, segment by record age and source. The averages hide where the rot is. We covered the ongoing maintenance side of this in our CRM hygiene guide .
The Operational Metrics
Beyond the core data metrics, track metrics that show data quality impact on operations.
Campaign Bounce Rate
Set hard-bounce and total-bounce thresholds from the sending platform's current definitions and the sender's own baseline.
Real-time indicator of email data quality. Rising bounce rates mean decaying data. A sudden spike often means a bad list was imported or a segment has old data.
Routing Exception Rate
Set the manual-routing threshold from queue capacity and the cost of incorrect assignments.
Percentage of leads that can't be automatically routed and require manual intervention. High exception rates mean missing or invalid data on routing fields.
SLA Miss Rate on Lead Response
Set the SLA-miss threshold from the service level your team has adopted and report it by source and queue.
If leads are missing SLA because they're sitting unrouted or assigned to inactive reps, data quality might be the cause. Track and investigate.
Metric Summary: Targets and Cadence
| Metric | Target | Check |
|---|---|---|
| Email validity (active contacts) | 95%+ | Monthly |
| Email validity (full database) | 85%+ | Quarterly |
| Duplicate rate | Under 5% | Monthly |
| Routing field completion | 95%+ | Weekly at high volume |
| Contact-account association | 95%+ | Monthly |
| Hard bounce rate | Under 2% | Per campaign |
| Routing exception rate | Under 5% | Weekly |
Building a Dashboard
Put these metrics on a single dashboard that gets reviewed regularly. Here's a structure that works:
Weekly Review (Ops Team)
- Campaign bounce rates from past week
- Routing exceptions from past week
- New duplicates created (if trackable)
- Any sudden changes in key metrics
Monthly Review (Leadership)
- Email validity rate (trend)
- Duplicate rate (trend)
- Routing field completion (current)
- Contact-account association rate (current)
- Month-over-month changes with context
Quarterly Deep Dive
- Full data quality audit with detailed metrics
- Decay rate calculation for the quarter
- Segment-specific analysis (by source, by age, by segment)
- Recommendations for next quarter's priorities
Setting Targets
The targets above are reasonable benchmarks, but your specific targets should consider:
- Where you are now: Use the dated baseline to set an incremental target that the current workflow can measure.
- Your tolerance for operational issues: Some businesses can tolerate more routing exceptions than others.
- The effort to improve: Review the exceptions remaining after each pass and stop when the next increment costs more than the workflow benefit.
What Not to Measure
Avoid metrics that have no owner, no decision threshold, or no connection to a workflow your team can change.
Some commonly tracked metrics aren't worth the effort:
- Overall "completeness score": Too vague. Completion of what fields? Weight fields by their operational importance.
- Format compliance: Unless bad formatting breaks something, it's not worth tracking.
- Data age: Age alone doesn't mean bad. A 3-year-old contact could be perfectly accurate.
- Record counts: Duplicate or invalid records can make a larger database less useful.
Focus on metrics tied to outcomes. If you can't explain how a metric affects operations, you probably don't need it.
Using Metrics to Prioritize
Once you have baseline metrics, use them to decide what to fix first:
- Fix what's broken: Prioritize the metric tied to an observed workflow failure, such as rejected mail or unresolved routing.
- Fix what blocks operations: Repair missing routing fields before lower-impact formatting inconsistencies.
- Maintain what's working: Keep dated baselines and alert when a stable metric begins to drift.
- Improve for optimization: Once basics are stable, improve metrics that drive better performance, like enrichment coverage and segmentation correctness.
Frequently Asked Questions
What data quality metrics should I track?
Focus on metrics that predict operational problems: email validity rate (affects deliverability), duplicate rate (affects routing and attribution), field completion for routing fields (affects lead distribution), and contact-to-account association rate (affects ABM and reporting). These directly impact revenue operations.
What's a good email validity rate for CRM data?
For actively marketed contacts, measure email validity against a dated baseline and define the acceptable status categories before sending. Set the review cadence from observed changes, campaign timing, and the sender's tolerance for rejected mail.
How do I calculate duplicate rate in my CRM?
Run duplicate detection on email, name plus company, and phone number. Count unique records with one or more potential duplicates and divide by total records. Interpret the rate alongside false-positive review effort and the workflows affected.
How often should I measure data quality?
Match cadence to how fast each metric moves. Bounce rates and routing exceptions change weekly, so review them weekly. Email validity and duplicate rate drift over weeks, so monthly works. Run a full audit with segment-level breakdowns once a quarter. Measuring everything monthly wastes time; measuring annually means you find problems a year late.
What is the difference between data quality dimensions and data quality metrics?
Dimensions are categories like correctness, completeness, consistency, and timeliness from frameworks like DAMA's DMBOK. Metrics are the specific numbers you calculate, like email validity rate or duplicate rate. Dimensions help you think about the problem space. Metrics are what you put on a dashboard and act on.
Can I automate data quality monitoring in Salesforce or HubSpot?
Partially. Both platforms report field completion and duplicate candidates natively, and reports can track routing exceptions. Email validity requires an external verification service since the CRM only knows an address bounced after you send to it. Most teams automate the platform-native metrics and run verification on a monthly or quarterly schedule.
Want to know where your data quality stands?
We'll calculate these metrics for your CRM and show you exactly what needs attention first.
Get My Data Quality ScorecardNeed help with your data?
We'll quote a real project from a real sample. Send a slice of your CRM and we'll have numbers back the same week.
See What We'll FindAbout the Author
Rome Thorndike is the founder of Verum. He built Dynamics CRM integrations at Microsoft, sold the same kind of system at Salesforce, then watched two later-stage startups drown in the data those systems collect. Verum is his answer to that loop.