Short answer
If your CRM is full of duplicate contacts and leads that never respond, your reports can mislead you and your emails may miss the mark. The fix is a regular cleanup using clear rules for what makes a lead 'dead', careful merging of duplicates, and consistent housekeeping. This article offers a direct checklist you can follow, with no jargon or sales fluff.
Define Your 'Dead Lead' Criteria
Start by deciding what a dead lead means for your business. A common rule is no engagement for 90 days, but your sales cycle matters. If you sell high-ticket items with long consideration times, 180 days might be smarter. Look at your own data: which leads actually closed, and how long did they take? That gives you a baseline.
Also check lead quality. A lead that never fits your ideal customer profile may be dead even if they opened an email. Add criteria like budget, authority, need, and timeline to filter out poor fits. Write your rules down so everyone applies them the same way.
- Track last activity: email opens, clicks, calls, or website visits.
- Set a threshold, e.g., no meaningful engagement for 90 days.
- Consider lead score: below a certain score for 60 days may be dead.
- Review lead source: if a source produces zero conversions, flag those leads.
Find Duplicates Across Your CRM
Duplicates are not just in contacts; they can appear across companies and deals. For example, 'Acme Inc.' and 'Acme Corporation' might be separate company records, and then contacts are tied to the wrong one. In HubSpot, you can use associations to link records correctly, but first you need to spot the duplicates. Use your CRM's built-in tools or export data to a spreadsheet and look for matches by email, phone, or company name.
Watch out for variations: 'Acme Inc.' vs. 'Acme Corporation'. Normalize data entry with dropdowns and validation rules to stop duplicates from forming later. Also check for duplicate deals: the same opportunity might be logged twice, inflating your pipeline numbers.
- Search by email, phone, and name variations.
- Use fuzzy matching tools if available.
- Involve your sales team: they may know which record is the 'real' one.
Merge Duplicates Carefully
When you merge duplicates, decide which data to keep. Typically, keep the record with the most complete and recent information, such as the one with an email and phone number, or the company with the most deals. In HubSpot, you can use the associations API to merge records and reassign links without losing related data, but this needs technical skill. If APIs are not your thing, use the CRM's merge interface.
Always export a backup before merging. Check for conflicts: if two records have different phone numbers, decide which to keep or combine them into custom fields. After merging, check the result to ensure no important data was lost.
- Backup your CRM data before a large merge.
- Define a hierarchy: which field wins if there's a conflict?
- Merge one pair at a time to avoid mistakes.
- Re-associate any records that were linked to the deleted duplicate.
Handle Dead Leads: Reactivate or Delete
Don't just delete dead leads. Consider a win-back campaign first. If they still don't respond and meet your criteria, delete in batches to keep your CRM under size limits and improve performance. Salesforce allows bulk deletion or archiving, and HubSpot lets you bulk delete contacts. But be careful: some data protection laws require deleting personal data when it's no longer needed, so review your legal obligations.
When you delete, also remove any tasks, notes, or communications tied only to that lead. That prevents clutter and keeps your CRM clean. Do it in phases and monitor the impact on your reports.
- Use your CRM's bulk delete features.
- Segment dead leads for a final win-back attempt.
- Delete in phases to see how it affects reports.
- Keep an audit log of deleted records for compliance.
Prevent Future Duplicates and Dead Leads
Cleaning once is not enough. Set up automation to avoid duplicates and flag dead leads automatically. Use forms with email verification and add validation rules to your CRM. For example, create a rule that blocks duplicate emails, but test it first. In Salesforce, you can use duplicate rules and matching rules; HubSpot has built-in deduplication on import or sync.
Create a quarterly cleanup rhythm. Assign a CRM owner responsible for data quality. Schedule a reminder to review duplicates, check engagement, and archive inactive records. Adjust your lead scoring regularly to match your sales cycle.
- Set up duplicate detection on forms.
- Automate lead scoring to drop leads after inactivity.
- Train your team on data entry standards.
- Run a monthly 'CRM health' report.
What to verify
- Data retention laws vary by jurisdiction; verify your obligations with a legal professional.
- Using HubSpot's associations API requires technical expertise; test in a sandbox first.
- Salesforce documentation was not fully retrieved, so confirm exact steps for duplicate rules and bulk deletion in your version.
Questions and answers
How often should I clean my CRM?
It depends on your sales volume and data entry rate. As a rule, do a deep clean quarterly. If you have high inbound volume, consider a monthly check for duplicates and dead leads. Automation can reduce how often you need to do it manually. [2]
What's the best way to find duplicates in HubSpot or Salesforce?
Both platforms have built-in duplicate detection features. In HubSpot, you can enable duplicate detection when logging or importing. In Salesforce, you can set up duplicate rules. For more advanced control, use their APIs or third-party tools. Start with email and phone fields because they are often unique. [1][2]
Is it safe to delete dead leads automatically?
Automatic deletion is risky unless you have strict criteria and legal clearance. Better to archive them automatically or move to a separate list. Then, a human can review and delete in batches. This prevents you from losing a lead with a long buying cycle. [2]
Sources and verification date
- Official source: developers.hubspot.comdevelopers.hubspot.com · Checked
- Official source: help.salesforce.comhelp.salesforce.com · Checked