Clean Your Data Before CRM Migration: What to Purge
Eighty thousand contacts. A new CRM quote priced per record. Migrating dirty data does not fix the problem. It doubles licence cost, poisons reporting from day one, and turns cutover into a cleanup project you never budgeted for.
We run the pre-migration purge so only clean, keepable records cross the line.
Sound Familiar?
These are the exact fears marketing and sales ops leads bring us before a CRM cutover:
- You are staring at 80,000 contacts and know half of them will poison the new CRM on day one
- Duplicates quietly double your marketing licence tier while inflated contact counts look like growth
- Dead leads from 2019 still sit in active lists, dragging bounce rates and sender reputation
- Nobody can agree what to purge, so the plan defaults to "migrate everything and clean later"
- Finance already priced the new CRM on the dirty record count, locking you into paying for junk
Licence renewal and per-record pricing create a hard deadline. B2B contact data decays 22–30% a year. If the new CRM quote or marketing hub tier is locked to your current contact count, every duplicate and dead lead you migrate is money you will keep paying after go-live.
What Pre-Migration Data Cleaning Actually Does
Audit → purge criteria → dedupe & archive → migrate only what deserves a seat.
Profile the Database
Duplicate rate, inactive contacts, bounce list, competitor domains, missing required fields
Set Purge Rules
Inactive >24 months, hard bounces, competitor domains, test junk, and keep-clean-archive decisions
Dedupe & Archive
Merge golden records, soft-archive dormant history, standardise formats for the new schema
Cut Over Clean
Only kept records migrate. Reporting and automations work on day one without a post-go-live cleanup
Everything You Need for CRM Data Quality at Cutover
Pre-Migration Data Audit
We measure duplicate rate, inactive contacts, bounced emails, competitor domains, and incomplete required fields so you know exactly what to purge before cutover.
Purge Criteria & Playbooks
Clear rules for what goes: inactive over 24 months, hard-bounced emails, competitor domains, test accounts, and records that fail minimum field standards.
Deduplication Strategy
Fuzzy match on email, company, phone, and name. Survivorship rules pick the golden record so activity history survives and ghosts disappear.
Archive vs Migrate Decisions
Keep active accounts, clean fixable records, archive dormant junk offline. Not every contact deserves a seat in the new CRM.
Licence & Volume Modelling
We show how purging dead and duplicate records drops your contact count, marketing tiers, and per-record migration fees before renewal locks in.
Cutover-Ready Validation
Target under 2% duplicates, 80%+ completeness on required fields, and verified active contacts so reporting and automations work from day one.
CRMs We've Cleaned Before Migration
From 82,000 Contacts to 51,400 Worth Migrating
How a Johannesburg B2B services firm cut contact volume by 37% before HubSpot cutover and avoided a marketing-tier jump tied to dirty records.
Migrate Everything Plan
- 82,000 contacts quoted into the new HubSpot Marketing Hub tier
- 14% duplicate rate across contacts and companies (about 11,500 ghosts)
- 28,000+ contacts with no activity in 24 months still marked active
- Hard-bounce list ignored; competitor domains still in nurture sequences
- Ops planned to "clean after go-live" while dual licences ran
Purge-First Cutover
- Purge rules signed off: inactive >24 months, hard bounces, competitor domains
- Duplicates merged with email + company survivorship; activity history preserved
- Dormant history soft-archived offline, recoverable for audits
- 51,400 clean contacts migrated; duplicate rate under 2% at go-live
- Marketing licence stayed one tier lower than the dirty quote
Before vs After Pre-Migration Data Cleaning
How It Works
From first export to clean cutover in 2–6 weeks, sized to your database.
Audit the Mess
Profile duplicates, dead leads, bounce rates, and licence exposure across your current CRM export.
Agree Purge Rules
Marketing and sales ops sign off on inactive thresholds, archive vs migrate, and survivorship logic.
Clean & Deduplicate
Purge, merge, and standardise on a staging set. Your team reviews edge cases before anything moves.
Migrate Clean
Only kept records land in the new CRM. Validation gates confirm counts, quality, and reporting before dual-licence cutover.
Frequently Asked Questions
Why clean CRM data before migration instead of after?
Cleaning before migration typically costs about one-third of cleaning after. Every rand spent on pre-migration data quality saves R3–R10 in post-migration remediation, broken automations, and corrupted reporting. Dirty records that land in the new CRM spawn duplicate tasks, poison sender reputation, and inflate licence tiers from day one.
What should we purge before a CRM migration?
Typical purge criteria include contacts inactive for more than 24 months with no open deals, hard-bounced or invalid emails, competitor and personal domains that should never have been imported, obvious test accounts, and records that fail your minimum required fields. Soft-archive historical deals separately if you need them for audits, but do not migrate them as active contacts.
How long does pre-migration data cleaning take?
Most mid-market databases of 50,000–200,000 records need 2–6 weeks: one week to audit, two to four weeks to purge and deduplicate, then a short validation pass before cutover. An 80,000-contact CRM with a typical 10–15% duplicate rate usually lands in the 3–4 week range.
How do you decide archive vs migrate?
We use a keep-clean-archive framework. Keep active, complete, recently verified records. Clean fixable issues (formatting, enrichable gaps, mergeable duplicates). Archive dormant records with no activity in 18–24 months, unfixable junk, and anything that would only inflate licence cost. Archived data stays recoverable offline without polluting the new CRM.
Will this reduce our CRM licence cost?
Often yes. Marketing hubs and several CRMs price by contact or record count. Migrating duplicates and dead leads locks you into a higher tier. Purging before cutover, especially ahead of a renewal or a new CRM quote based on record volume, is usually the cheapest licence negotiation you will ever do.
How much does a pre-migration data cleanse cost?
Pre-migration cleansing typically sits at 5–15% of the overall CRM implementation budget. For mid-size databases we usually quote R35,000–R95,000 depending on volume and mess. Against the 1-10-100 rule (roughly R18.50 to prevent, R185 to fix later, R1,850 once it fails in production), most clients see payback inside the first quarter on the new platform.
Do Not Migrate the Mess
If your new CRM quote is based on today's contact count, every duplicate and dead lead you leave in place is a licence you will keep paying.
Tell us which CRM you are leaving, which you are moving to, and roughly how many contacts you are staring at. We will map purge criteria, archive vs migrate decisions, and a fixed-scope cleanse before cutover.