Inquiry CRM Data Quality: Dedupe, Enrich, Archive, and Manage the Lifecycle
1. Why CRM Data Goes Bad
Inquiries from your own site come in through several channels: website forms, forwarded email, WhatsApp, LinkedIn, trade show business cards. Each channel writes a record into the CRM, nobody dedupes, and after three months the same buyer has five or six records in the database.
Sales rep A follows up once, sales rep B follows up again, both email the same person, and the buyer thinks your company is a mess. This isn’t unprofessional salespeople, it’s data that never got merged at the door.
For how to consolidate multiple channels, see Multi-Channel Inquiry Integration. This article focuses on data governance after the merge: how to dedupe, how to enrich, and when to archive. How to design fields is a separate topic, see Inquiry CRM Field Design, not covered here.
| Data Problem | What it looks like | Consequence | Governance Action |
|---|---|---|---|
| Duplicate leads | Multiple records for the same company and contact | Buyers contacted twice, reps competing for the same deal | Three-key dedupe and merge at intake |
| Missing fields | Company name and country left blank | Can’t tier leads, can’t run reports | Auto-enrich via domain lookup |
| Dormant pileup | Leads from three years ago still in the active pool | Dashboard numbers inflated, reps can’t find new leads | Archive after 180 days with no contact |
| Wrong tags | Source channel tagged incorrectly | Attribution skewed, budget misallocated | Sample and correct 10% weekly |
Counterintuitive take: more leads in the CRM doesn’t mean a healthier pipeline. A database of 5,000 leads where 80% are dormant or duplicates is far harder to work than a clean database of 1,000.
2. Intake Dedupe: Three Keys
Dedupe at the moment data is written into the CRM, don’t wait three months and run a batch job. Checking at write time is cheapest; merging later wipes out follow-up notes sales has already logged.
Three matching keys: the email local part (the bit before the @), the email domain, and the company name. Hit two of the three and it counts as the same lead: merge into the existing record, append the new timestamp and inquiry content, and don’t create a new one.
| Matching rules | Condition | Action | Handling false matches |
|---|---|---|---|
| Same email | Exact email match | Merge into existing record | None, merge directly |
| Same domain, same company | Domain match + similar company name | Assign to the same company | If the contact differs, create a new contact |
| Same company name, different email | Company name matches but email domain differs | Manual review | Possible competitor using a fake identity |
| Repeat submission within 24 hours | Multiple submissions from the same email in a short time | Merge into one | Don’t assign to a sales rep twice |
Example: A buyer submits an inquiry on your website on Monday, then sends the same thing again via WhatsApp on Wednesday. On inbound, the system sees the matching email and automatically appends the WhatsApp message to the same lead instead of creating a new one. Both channels sit in one record, so the sales rep opens it and sees the full context.
What if duplicates have already piled up? Run a batch merge script and consolidate duplicate records using the three keys above. The rule: keep the earliest record and attach all follow-up logs, attachments, and statuses from the later records to it. For batch deduplication methods, see Handling duplicate inquiries.
3. Auto-fill: reverse lookup from the email domain
Buyers can’t be bothered to fill in company name and country on the form, so those two fields are often left blank. Sales reps then have to search for it themselves, which wastes time. The good news: a business email domain is the company’s website address, so a reverse lookup can fill in most of it.
How it works: extract the email domain (excluding free domains like gmail and outlook), check the Whois record and homepage for that domain, and auto-fill company name, country, and industry. Leave fields blank if you can’t find them. Don’t guess.
| Field | Source | Fill rate reference | What if it can’t be filled |
|---|---|---|---|
| Company name | Reverse lookup of the website title from the email domain | About 70% of business domains can be filled | Leave blank; the sales rep asks on the first call |
| Country | Domain registration location + website language | About 60% can be filled | Rough fill based on IP geolocation |
| Industry | Business description on the homepage | About 50% can be filled | Leave blank; not required |
| Headcount | Public company information databases | About 40% can be filled | Leave blank; don’t make things up |
The red line for fill rate: if the company name field is blank more than 20% of the time, the inbound form itself has a problem. Go back and check whether company name was set as optional. For form field design, see Inquiry Form Field Design and Conversion Rate.
Auto-fill is a nice bonus, not a replacement for manual work. If a sales rep finds the auto-filled country or industry is wrong during follow-up, fix it right away. Data quality is maintained on an ongoing basis, not fixed once and forgotten.
4. Lifecycle: active, dormant, archived
Leads can’t sit in “following up” forever. After 90 days with no interaction (no email reply, no answered call, no attachment opened), a lead automatically moves to the dormant pool; after 180 days, it’s archived.
Archiving isn’t deleting. Archived leads disappear from the active board, so sales reps don’t see them day to day, but the data is still there for attribution and reviews. Run a re-engagement email once a quarter; any archived lead that replies is automatically pulled back into the active pool. For re-engagement messaging for dormant leads, see Dormant Lead Reactivation.
| Stage | Condition | Board view | Action |
|---|---|---|---|
| Active | Engaged within 90 days | Counts toward sales pipeline | Normal follow-up |
| Dormant | No engagement for 90-180 days | Shown in gray | Send a reactivation email |
| Archive | No engagement for 180+ days | Remove from the board | Quarterly reactivation batch |
| Revived | Replied after archiving | Move back to Active | Notify the original owner or reassign |
Example: A German buyer requested a quote in January 2025 and never replied. By July, the lead hits 180 days and the system archives it automatically. In October, the quarterly reactivation batch sends him an email: “We’ve updated our product line, want to take a look?” He replies, and the system automatically moves the lead back into the active pool and assigns it to the rep who currently covers the German-speaking region.
Red line: never physically delete any historical lead. Historical data is the basis for attribution analysis, win-rate statistics, and channel quality comparisons, and once deleted it’s gone for good. For how to analyze channel quality, see Inquiry Source Channel Analysis.
Spot-check data quality every week: pull 10 leads at random and check whether the company name, country, and source channel fields are filled in correctly. If the error rate tops 10%, something is wrong with your inbound process or how reps fill in fields, and you need to fix it specifically.
FAQ
When should deduplication happen?
What if the company name and country fields are empty?
How long without follow-up before a lead should be archived?
Can archived leads be deleted?
How do you know whether your CRM data quality is good?
How do you merge duplicate inquiries from the same company across different channels?
Final thoughts
With CRM data quality, the hard part isn’t the technology — it’s restraint. Don’t pile junk into the database, don’t hoard leads you should archive, don’t physically delete history. A clean, deduplicated CRM with complete fields is worth more than any fancy sales tool.
Three steps to put it in place: dedupe inbound leads on three keys — email, domain, and company name — and merge anything with the same email within 24 hours. Use reverse domain lookup to auto-fill company name and country; if you can’t fill a field, leave it blank rather than guessing. After 90 days with no interaction, mark the lead dormant; archive at 180 days; re-engage every quarter. Never physically delete archived leads.
One line worth remembering: a CRM isn’t a warehouse, it’s a workshop — duplicate parts get merged, missing screws get replaced, broken ones get archived and frozen, so sales can actually find what they need.