Login Try for free
CRM Data Guide

How to Clean Stale CRM Contact Records: A Step-by-Step Guide

A cleanup you can run this week on any CRM: find the outdated records, map your fields, validate emails and phones, merge duplicates and re-import without overwriting good data.

Works in HubSpot, Salesforce, Pipedrive or a spreadsheet Field map template included Safe re-import in 5 steps

Nothing in a CRM breaks when records go stale. The contacts are still there and the dashboards still count them, but a growing share of the emails are dead and a growing share of the job titles describe a role the person left a year ago.

This guide is the cleanup itself, in the order that avoids the classic mistake of a cleanup: overwriting good data with worse data. It works the same way in HubSpot, Salesforce, Pipedrive, Zoho, Airtable or a plain spreadsheet, because every step runs on an export.

Before you start: back up and pick a scope

Two things to do before you touch a single record.

  • Take a full export and keep it untouched. Name it with the date, store it somewhere your import tool cannot reach. If an import goes wrong, this file is how you put things back.
  • Pick the scope. Cleaning the whole database at once is how cleanups stall. Start with the segment that costs you money when it is wrong: contacts in active sequences, open opportunities, or the list behind your next campaign. A few thousand rows is a good first batch.

Also note who owns the CRM's import settings. Most of the damage in a cleanup comes from one import with the wrong "overwrite" option, so whoever runs step 8 should be the person who can undo it.

1

Export the fields you will actually use

Export more than the contact details. The activity fields are what tell you a record is stale; the IDs are what let you write the result back to the right record.

  • Record ID (HubSpot "Record ID", Salesforce "Contact ID"). Without it, a re-import creates duplicates instead of updates.
  • Identity: first name, last name, email, phone, LinkedIn profile URL.
  • Company: company name, company domain or website.
  • Role: job title, seniority or department if you store them.
  • Activity: create date, last modified date, last activity or last contacted date, last email open or reply.
  • Status: email bounce status, unsubscribed / opted out, lifecycle stage, owner.

Export as CSV with UTF-8 encoding, so accents in names survive the round trip.

2

Find the outdated records

Add a column called stale_reason and fill it with the first rule each row matches. In a spreadsheet each rule is one filter; in the CRM each is one saved view.

RuleHow to spot itWhat it usually means
Hard bounceBounce status is "hard" or "invalid"The mailbox is gone, most often because the person left
No activityLast activity and last modified both older than 180 daysNobody has checked this record since it was created
Title never updatedJob title unchanged and record older than 12 monthsA promotion or a move you have not seen
Missing key fieldNo email, or no company domain, or no titleIncomplete from day one: routing and scoring fail silently
Personal email on a B2B recordDomain is gmail.com, outlook.com, yahoo.com and so onFine for some teams, a deliverability and compliance risk for cold outreach
Role addressLocal part is info, sales, contact, hello, adminA shared inbox, not a person

Leave alone any record that has a reply or a meeting in the last 90 days, whatever its age. Recent engagement beats every rule above.

Count the rows per reason before going further. That count is your before picture, and it tells you which of the next steps will carry the most weight.

3

Map every field before you change one

A field map is a small table that says, for each column, where it goes back in the CRM and whether new data may replace old data. Writing it takes ten minutes. Skipping it is how a cleanup wipes out the notes your reps typed by hand.

Column in your fileCRM property (internal name)Update rule
Record IDhs_object_id / IdMatch key. Never edit.
EmailemailReplace only when the old one hard-bounced and the new one verifies
Job titlejobtitle / TitleOverwrite: a fresh source beats an old entry
Company / domaincompany, websiteOverwrite when the person changed employer, and log the old value
Phonephone, mobilephoneFill if empty
LinkedIn URLCustom propertyFill if empty
Lead source, owner, notesVariousNever touch

Use the internal names, not the labels: two properties can share the label "Phone", and the import screen matches on internal names. In HubSpot they are under Settings → Properties; in Salesforce, Object Manager → Fields & Relationships.

Add two properties if you do not have them yet: previous_company, to keep the old employer when someone moves, and last_cleaned_at, the date this record was last checked. Step 9 runs on that second one.

4

Normalise the formats

Duplicates and failed validations mostly come from format, not from wrong data. Fix the format first so steps 5 and 6 compare like with like.

  • Emails: lowercase, trim spaces, remove trailing dots and "mailto:".
  • Names: trim, fix ALL CAPS to normal case, split a full-name column into first and last.
  • Company domains: strip https://, www. and anything after the first slash, so https://www.acme.com/about becomes acme.com.
  • Phones: convert to international E.164 format (+14155550123), so the same number written three ways becomes one value.
  • LinkedIn URLs: keep linkedin.com/in/handle only, without tracking parameters or a trailing slash.
  • Countries: one convention, either full names or ISO codes, not both.
5

Merge duplicates

Look for duplicates in three passes, from the most certain key to the least:

  1. Same email. Almost always the same person.
  2. Same LinkedIn URL with different emails: the same person with an old and a new address.
  3. Same first name, last name and company domain. Check these by eye before merging: two Michael Smiths can work at the same company.

When you merge, keep the oldest record (it holds the history: deals, emails, meetings) and bring the newest values into it. Do the merge inside the CRM rather than by deleting rows in the file, so activity history follows the surviving record.

6

Validate emails and phone numbers

Run every email through a verifier and keep its verdict in a column, not just a pass/fail. The categories matter:

ResultWhat it meansWhat to do
ValidThe mail server accepted the addressKeep
InvalidBad syntax, no mail server, or mailbox refusedMark for refresh in step 7; stop sending now
Catch-all / unknownThe domain accepts every address, so nothing can be confirmedKeep, but send at lower volume and watch bounces
DisposableTemporary inbox serviceRemove from outreach
Roleinfo@, sales@ and similarReplace with a named contact if you can

For phones, check that the number parses as a valid number for its country and tag it mobile or landline. A landline switchboard stored in a "mobile" field is the most common phone error in B2B CRMs.

Validation tells you an address works. It does not tell you the person is still there: an old colleague's mailbox can stay open for months after they leave. That is what the next step is for.

7

Refresh what changed

Take the rows flagged in step 2 and the invalid ones from step 6, and check where each person works today. The LinkedIn profile is the most current public source: compare its current employer with the company in your CRM.

  • Same employer: update the title if it changed, then find the email again if the old one failed.
  • New employer: move the old company to previous_company, write the new company, title and work email. Then tag the record: someone who knew your product and just arrived in a new job is one of the warmest contacts you have.
  • Cannot confirm: leave the record unchanged and tag it unverified. Do not guess an email from a pattern.

For a handful of records, do it by hand. For hundreds, an enrichment tool does the lookup per row: LinkFinder AI, for example, takes the CSV and returns current employer, title and a verified email per row. Whatever tool you use, bring the results back as new columns and apply them with the rules from step 3.

8

Re-import without breaking anything

  1. Import 50 rows first. Open five of them in the CRM and check every mapped field landed where step 3 said it would.
  2. Match on Record ID, never on email: you just changed some emails, so matching on email would create new contacts.
  3. Leave out the columns marked never-touch. Remove them from the file rather than relying on an import option.
  4. Set last_cleaned_at to today on every row you checked, including the ones that did not change.
  5. Run the full import, then compare the counts per stale_reason with your before picture.

Records that ended up unverified and inactive go to an archive list or a suppression list, depending on your CRM. Removing them from outreach protects your sending domain; deleting them is a separate decision, guided by your data retention policy.

Keep it clean

A one-off cleanup starts decaying the day it ends. Three habits stop the same project coming back in eighteen months:

  • A 90-day sweep: a saved view of contacts whose last_cleaned_at is older than 90 days, run through steps 4 to 8 each quarter. It is a small batch every time.
  • Check before every campaign: verify the segment you are about to email, not the whole database.
  • Complete records at creation: required fields on forms and imports, so nothing enters the CRM without an email, a company domain and a title.

If you want the sweep to run on its own, see how to set up a scheduled CRM enrichment pipeline in n8n, Make or Zapier.

The checklist

  • Full backup export saved and untouched
  • Scope chosen: one segment, a few thousand rows
  • Record ID, activity dates and bounce status exported
  • Every row tagged with a stale reason, counts written down
  • Field map written: overwrite, fill if empty, never touch
  • Emails, domains, phones and LinkedIn URLs normalised
  • Duplicates merged in the CRM, oldest record kept
  • Emails verified, result kept per row; phones parsed and typed
  • Job changes checked, previous company kept
  • 50-row test import checked by eye, full import matched on Record ID
  • last_cleaned_at set, 90-day sweep scheduled

Frequently Asked Questions

Run a full cleanup once, then a smaller sweep every 90 days on records that have not been touched since. B2B contact data goes stale at roughly two to three percent a month, so a quarterly sweep keeps the stale share in single digits.
A record whose email hard-bounced, whose person changed employer, or that has had no activity and no update in 180 days or more. Age alone is not the test: a two-year-old record that still opens your emails is fine.
Update first, delete last. A record of someone who changed jobs is worth more updated (it tells you where they went) than deleted. Delete or archive only what you cannot verify and have no lawful reason to keep.
Only for fields you mapped as overwrite, such as job title or company size. Fields your team types by hand, like notes, deal owner or lead source, should be fill-if-empty or never-touch. Test the import on 50 rows first and keep the backup export.
No. A catch-all domain accepts every address, so verification can only flag it as unknown, and a spam trap is a working mailbox that verifies as valid. Treat catch-all results as medium confidence and send to them at lower volume.

Check how much of your CRM is still current

Upload a CRM export and get current employer, job title and a verified work email back for each contact, with job changes flagged. Free credits to test it on a sample first.

Start Free Trial

No credit card required · HubSpot and Salesforce exports accepted · CSV back in minutes

Explore more in Email Finding & Enrichment

See the full topic → Email Finding & Enrichment hub