Audit and clean data quarterly

Setting up a clean CRM is one thing. Keeping it clean is another. Data decays constantly: people change jobs, companies rebrand, email addresses bounce, contacts go inactive, and properties that made sense six months ago are now irrelevant.

A quarterly data audit is how you prevent the slow rot that turns a useful CRM into a cluttered mess. Every quarter, you systematically review your data quality, clean up what's degraded, and tighten the rules to prevent the same problems from recurring.

I run these for every client I work with, and the teams that do them consistently have dramatically better CRM adoption and reporting accuracy than the ones that don't. It's the difference between a tool people trust and a tool people avoid.

The four areas of a quarterly audit

A thorough audit covers four areas: records, properties, workflows, and integrations.

Records. Start with duplicates. Go to CRM > Contacts > Actions > Manage Duplicates. HubSpot identifies potential duplicate pairs based on email, name, phone, and company. Review each pair and either merge or reject. Do the same for companies (matched by domain and company name).

Then look at stale records. Use your CRM health dashboard (or create a saved view) to find contacts with no activity in the past 90-180 days. Decide what to do with them: re-engage, archive, or suppress from marketing.

Properties. Go to Settings > Data Management > Properties and export the full list. Sort by fill rate. Properties with less than 10% fill rate are candidates for removal or consolidation. Check for duplicate properties (different names, same purpose) and consolidate them.

Workflows. Review all active workflows. Are any broken (showing errors)? Are any unused (no enrolments in the past quarter)? Broken workflows are creating bad data or failing silently. Unused workflows are clutter that makes your automation harder to manage.

Integrations. Check Settings > Integrations > Connected Apps. Are all integrations still syncing? Has any app been disconnected or deprecated? Are there sync errors that need attention?

Handling duplicates

HubSpot's Manage Duplicates tool compares contacts by first name, last name, email, phone, and company name. For companies, it uses domain name, company name, and phone.

When merging, you choose which record to keep as the primary. HubSpot preserves both records' property values, but the primary record's values take precedence where there's a conflict. Review the merge preview carefully before confirming.

For high-volume duplicate situations (thousands of pairs), consider a third-party tool like Insycle or Dedupely that can handle bulk operations with more sophisticated matching logic.

Cleaning stale contacts

Stale contacts are records that haven't engaged with your business in 6-18 months: no email opens, no website visits, no form submissions, no calls, no deals. These contacts drag down your email deliverability (senders reputation suffers when you email people who never open), inflate your database costs, and skew your reporting.

The process:

Build a list of contacts with no activity in the past 12-18 months. Run a short re-engagement campaign (2-3 emails over 2-4 weeks with a clear offer or question). Contacts who engage stay. Contacts who don't get suppressed from marketing or marked as non-marketing contacts.

Don't delete them outright. Suppression is safer because it preserves history and is reversible. Deletion is permanent.

Property hygiene

If you have Operations Hub Professional, the Data Quality Command Centre shows you properties with no data, unused properties (not used in any workflow, list, or report), and duplicate properties. This gives you a clear cleanup list.

Without Operations Hub, export your properties and manually review. Focus on:

Custom properties with less than 10% fill rate. Are they new (give them time) or abandoned (archive them)? Properties with unclear names. If your team can't tell what "Status V2" means, rename it or add a help text description. Properties that overlap. If "Lead source" and "Original source" both capture the same concept, consolidate into one.

Building the habit

The audit itself takes 2-4 hours per quarter. Schedule it. Put it on the calendar. Assign it to a specific person. Without a recurring commitment, it doesn't happen.

Some teams run a lighter monthly check (30 minutes: duplicates, stale deals, sync errors) and a deeper quarterly audit (full property and workflow review). Find the cadence that works for your team size and data volume.

Data quality is not a project with a finish line. It's a recurring practice. The quarterly audit is how you keep your CRM trustworthy, your reports accurate, and your team confident that the data they're looking at reflects reality.