CRM Data Quality Scorecard: Benchmarking Health
Your CRM data is either an asset or a liability. Most teams don't know which because they've never measured it. A data quality scorecard gives you a monthly score that tracks data health over time, identifies the worst problems, and proves whether your hygiene efforts are working. Without measurement, data quality is just a feeling.
A scoring framework for measuring CRM data quality. Field completeness benchmarks, accuracy testing methods, and a monthly scorecard template for RevOps teams.
The Four Pillars of CRM Data Quality
CRM data quality breaks down into four measurable dimensions.
Completeness: what percentage of records have all required fields filled? A contact without an email is incomplete. An account without a revenue estimate is incomplete. Completeness is the easiest dimension to measure and the most common problem.
Accuracy: are the filled fields correct? A contact with an email that bounces has a filled field but inaccurate data. Accuracy is harder to measure than completeness because it requires validation against external sources.
Consistency: does the same data look the same across records? If one account has the industry set to 'Software' and another has 'SaaS' and a third has 'Technology,' your segmentation breaks. Consistency problems come from free-text fields, inconsistent imports, and lack of picklist enforcement.
Timeliness: how current is the data? A contact record that was accurate 18 months ago may have a wrong title, wrong company, and wrong phone number today. Timeliness degrades automatically at roughly 30% per year in B2B. Without active maintenance, your CRM ages like milk.
Each pillar needs its own metrics, benchmarks, and improvement actions. Trying to fix 'data quality' as one big problem leads to unfocused effort. Fixing completeness for email fields is a specific, measurable project.
Completeness Metrics and Benchmarks
Measure completeness for each field that matters to your sales process. Not every field matters equally.
Tier 1 fields (must be 95%+ complete): Email address, company name, lead source, lifecycle stage. These are the minimum viable record. If these fields are empty, the record is essentially useless.
Tier 2 fields (must be 80%+ complete): Job title, phone number, company size, industry. These fields drive segmentation, routing, and prioritization. Gaps here reduce but don't eliminate the record's utility.
Tier 3 fields (target 60%+ complete): Technology stack, annual revenue, funding stage, LinkedIn URL. These fields enable personalization and advanced scoring. Nice to have, not essential for basic operations.
Calculate completeness score per field: (records with field filled / total records) x 100. Then calculate an overall completeness score by weighting tiers: Tier 1 fields at 3x, Tier 2 at 2x, Tier 3 at 1x.
Example: if email completeness is 92% (Tier 1, weight 3), title completeness is 75% (Tier 2, weight 2), and LinkedIn completeness is 50% (Tier 3, weight 1), the weighted score is (92x3 + 75x2 + 50x1) / (3+2+1) = (276 + 150 + 50) / 6 = 79.3.
Track this score monthly. A declining score means data is decaying faster than you're maintaining it. An improving score means your hygiene processes are working.
Accuracy Testing Protocol
You can't check every record for accuracy. Instead, use statistical sampling.
Monthly accuracy audit: randomly select 100 contact records. For each record, verify the email (send a test or use a verification service), check the job title against LinkedIn, and verify the company (is the person still there?). Record the accuracy rate for each field.
Email accuracy benchmark: 90%+ is healthy. 80-90% needs attention. Below 80% indicates a serious data quality problem that's likely damaging your sender reputation.
Title accuracy benchmark: 85%+ is healthy. Below 75% means your data is stale and your personalization is referencing wrong roles.
Company accuracy benchmark: 90%+ is healthy. Below 85% means you have significant job-change churn that isn't being caught.
For automated ongoing accuracy monitoring, set up these alerts:
Email bounce rate above 3% on any outbound campaign triggers a data review.
Phone connect rate below 15% for a rep over a week triggers a data quality check on their assigned contacts.
Failed enrichment rate above 20% on a batch operation indicates incoming data quality problems.
The cost of these audits is minimal compared to the cost of operating on bad data. A 100-record audit takes one person 2-3 hours per month. The problems it catches save dozens of hours of wasted sales effort.
Consistency Rules and Enforcement
Consistency problems are preventable. They come from three sources, and each has a fix.
Source 1: Free-text fields where picklists should exist. If reps type industry, title, or lead source as free text, you'll get hundreds of variations. Fix: convert free-text fields to picklists. If a field has more than 20 unique values and should have fewer than 10, it needs a picklist.
Source 2: Inconsistent imports. Every CSV import introduces formatting differences. 'United States' vs 'US' vs 'USA' vs 'United States of America.' Fix: create an import validation template that maps incoming data to your picklist values before import. Never import raw CSVs directly.
Source 3: Multiple data sources with different formats. ZoomInfo formats phone numbers as (555) 123-4567. Apollo formats them as +15551234567. Your reps type 555-123-4567. Fix: implement a formatting standard and enforce it through CRM validation rules or a data quality tool like Insycle or Openprise.
Measure consistency by counting unique values for fields that should be standardized. If your industry field has 200 unique values when it should have 25, your consistency score for that field is 25/200 = 12.5%. The closer to 100%, the more consistent your data.
Prioritize fixing consistency for fields used in segmentation, routing, and reporting. An inconsistent industry field breaks your segment-based analytics. An inconsistent phone format is annoying but doesn't break workflows.
Timeliness and Decay Tracking
B2B data decays at a predictable rate. The question isn't whether your data is decaying but how fast and which records are most affected.
Track last-verified date for every contact. This is the date when the record was last confirmed accurate, either through successful engagement (email reply, phone connection) or through re-enrichment. Records without a last-verified date should be treated as stale.
Age brackets for action:
0-90 days since verification: active data. No action needed.
91-180 days since verification: aging data. Queue for re-enrichment.
181-365 days since verification: stale data. High probability of inaccuracies. Re-enrich before using in outbound.
365+ days since verification: expired data. Treat as unreliable. Re-enrich or remove from active outbound lists.
Measure the distribution of your CRM across these brackets. A healthy CRM has 60%+ of records in the 0-180 day bracket. If 40%+ of your records are over 365 days stale, you need a bulk re-enrichment project.
Decay rates vary by field. Email addresses decay at 20-25% per year (job changes, company email migrations). Phone numbers decay at 15-20% per year. Job titles decay at 25-30% per year (promotions, lateral moves). Company information decays at 10-15% per year. Prioritize re-enrichment for the fields that decay fastest.
The Monthly Scorecard
Build a scorecard that you review on the first Monday of every month. It should fit on one page.
Section 1: Overall data quality score. A weighted composite of completeness, accuracy, consistency, and timeliness. Track month-over-month trend.
Section 2: Completeness by field. Show the top 10 fields ranked by importance, with current fill rate and trend.
Section 3: Accuracy spot-check results. Show the results of your 100-record monthly audit. Highlight any field that dropped below its benchmark.
Section 4: Age distribution. Show what percentage of records are in each age bracket (0-90 days, 91-180, 181-365, 365+). Show the trend.
Section 5: Action items. Based on the scorecard data, list the top 3 actions for the coming month. Examples: 'Re-enrich 5,000 records over 180 days stale,' 'Convert industry field to picklist,' 'Fix 2,000 records with missing phone numbers.'
Share this scorecard with sales leadership. When reps complain about data quality, you have numbers to validate or challenge their complaints. When you need budget for data tools, you have documented quality trends to justify the spend. When your enrichment vendor claims 95% accuracy, you have your own measurements to compare against.
The scorecard itself takes 2-3 hours per month to produce if you've automated the queries. Most CRMs support the reporting needed. For advanced tracking, export to a Google Sheet or BI tool where you can build longitudinal charts.
Tools Mentioned in This Guide
Related Categories
Frequently Asked Questions
What's a good overall CRM data quality score?
Target 80+ on a 100-point scale using weighted completeness, accuracy, consistency, and timeliness metrics. Most companies score 50-65 when they first measure. Getting to 80 takes 3-6 months of focused effort.
How often should I audit CRM data quality?
Monthly for the scorecard review. Weekly for automated alert-based checks (bounce rates, enrichment failures). Quarterly for a deep audit that includes manual verification of 200+ records.
What's the fastest way to improve CRM data quality?
Fix completeness first. It's the easiest to measure and improve. Run a batch enrichment on all records with missing email or title fields. This alone can improve your overall score by 10-15 points in a single month.
Who should own the CRM data quality scorecard?
RevOps or Sales Ops. They have the technical skills to build the reports, the cross-functional visibility to identify problems, and the authority to enforce data standards across sales, marketing, and CS.
How much does poor CRM data quality cost?
Industry research estimates that bad data costs companies $15-25 per dirty record per year in wasted time, missed opportunities, and operational inefficiency. A CRM with 50,000 records at 70% data quality has roughly 15,000 dirty records costing $225,000-$375,000 annually.