Checklist Data Hygiene
Data Enrichment Audit Template
Audit your CRM data quality with this enrichment template. Identify gaps in contact, company, and technographic data across your sales database.
Data Enrichment Audit Template
Poor data quality silently kills your outbound performance. This audit template helps you evaluate the completeness and accuracy of your prospect database, then build a plan to fix the gaps.
Step 1: Field Completeness Audit
Export a sample of 500-1000 records from your CRM and measure fill rates for each critical field.
Contact Fields
| Field | Target Fill Rate | Your Fill Rate | Gap |
|---|---|---|---|
| First name | 100% | ___% | ___% |
| Last name | 100% | ___% | ___% |
| Email address | 95%+ | ___% | ___% |
| Phone number | 70%+ | ___% | ___% |
| Job title | 90%+ | ___% | ___% |
| LinkedIn URL | 80%+ | ___% | ___% |
Company Fields
| Field | Target Fill Rate | Your Fill Rate | Gap |
|---|---|---|---|
| Company name | 100% | ___% | ___% |
| Industry | 90%+ | ___% | ___% |
| Employee count | 85%+ | ___% | ___% |
| Revenue range | 70%+ | ___% | ___% |
| Website URL | 95%+ | ___% | ___% |
| Tech stack | 60%+ | ___% | ___% |
Step 2: Data Accuracy Check
Pull 100 random records and manually verify accuracy.
- Email addresses are still deliverable (run verification)
- Job titles match current LinkedIn profiles
- Company names are spelled correctly and current
- Phone numbers connect to the right person
- Industry classifications are accurate
Step 3: Duplicate Analysis
- Count total duplicate contacts (same email)
- Count total duplicate companies (same domain)
- Identify merge strategy for duplicate records
- Set up deduplication rules for future imports
Step 4: Decay Assessment
- How many contacts have bounced emails in the past 90 days?
- How many contacts changed jobs in the past 6 months?
- What percentage of records have not been updated in 12+ months?
Step 5: Enrichment Plan
Based on your audit results, prioritize enrichment actions:
- Verify and fix all email addresses first (highest ROI)
- Fill missing job titles and seniority levels
- Enrich company data (size, industry, tech stack)
- Add missing phone numbers for high-priority accounts
- Schedule recurring enrichment to prevent future decay
Scrapine continuously enriches your CRM data, filling gaps automatically and flagging records that have gone stale so your database stays accurate over time.