Quarterly data clean-up
Keep the CRM trustworthy
By the wpdailylive editorial team · Part of CRM for small business, the complete guide
Key takeaways
- Quarterly cadence: Data decays by about a quarter each year, so clean every quarter.
- Merge duplicates first: Duplicates distort reports and confuse the team.
- Fix the gaps: Fill missing owners and close dates; remove unused fields.
- Archive, don’t delete: Keep history by archiving dead contacts.
- Check unsubscribes: Confirm opt-outs synced correctly, and give someone ownership of the clean-up.
- 1.Merge duplicate contacts and companies
- 2.Close deals with no activity in 90 days
- 3.Fill missing lead sources
- 4.Archive unused fields and pipelines
- 5.Remove leavers and reassign their records
- 6.Check integrations are still syncing
Clean-up checklist with owners
| TASK | HOW | OWNER |
|---|---|---|
| Merge duplicates | Built-in duplicate tool | Ops or admin |
| Archive dead contacts | No activity 18+ months, no open deals | Ops |
| Fix missing owners | Filter: owner is empty | Sales manager |
| Update close dates | Filter: close date in the past | Each rep |
| Remove unused fields | Fields empty 90+ days | Admin |
| Check unsubscribes | Compare with email platform | Marketing |
CRM data cleanup checklist
Why data decays
People change jobs, companies rebrand, email addresses stop working and duplicates creep in from imports and forms. Industry estimates commonly put B2B contact data decay at around a fifth to a third a year. A quarterly hour keeps reports trustworthy.
Data retention and privacy
Under GDPR (UK and EU) you should only keep personal data as long as you need it. Set a rule, such as archiving prospects with no activity in two years, and delete data when someone asks.
Common mistakes to avoid
How do I clean up CRM data?
Merge duplicates, fix bounced emails, update job changes, archive inactive contacts, close stale deals, fill key fields and hide unused fields.
How often should CRM data be cleaned?
Every quarter, plus a duplicate check after every import.
How do I remove duplicates in my CRM?
Use the CRM’s duplicate management tool, matching on email for people and domain for companies, and merge records to keep history.
What is CRM data decay?
The gradual loss of accuracy as people change jobs, emails stop working and companies change; often estimated at a fifth to a third of B2B data a year.
How long can I keep contact data in my CRM?
Only as long as you need it under GDPR in the UK and EU; set a rule such as archiving prospects inactive for two years.















