The Quarterly CRM Audit Checklist Every HubSpot Team Needs

CRM data doesn't stay clean on its own. Contacts go stale, formats drift, domains get reused by different companies, and nobody deletes the test records from that one import six months ago. If you're not running regular audits, the quality of your data is quietly getting worse every week.

The good news: a quarterly audit doesn't have to take a full day. With the right process, you can get through it in a few hours. Here's the checklist.

Why Quarterly (Not Monthly, Not Yearly)

Monthly is overkill for most teams. The work-to-value ratio drops fast when your team is small and your database isn't huge. Yearly is too slow. Data quality problems compound. A small inconsistency in January becomes a broken automation by December.

Quarterly hits the right balance. It's often enough to catch problems before they spread, and infrequent enough that the audit doesn't become a burden that gets skipped.

Schedule it. Put it in the calendar. Assign it to a specific person. Audits that live on a "someday" list don't happen.

Part 1: Duplicate Records

Duplicates are the most common CRM problem. They make reporting inaccurate, cause contacts to receive emails twice, and generally make your CRM harder to trust.

Find duplicates:

• Run HubSpot's built-in duplicate management tool (Contacts > Actions > Manage Duplicates)
• Filter contacts by email domain to spot near-duplicates with different email variants ([email protected] and [email protected] that are the same person)
• Search for contacts with identical first name + last name combinations
• Check company records for the same company entered multiple times with slight variations ("Acme Corp" and "Acme Corporation")

Address what you find:

• Merge obvious duplicates using HubSpot's merge tool
• Flag unclear cases for human review before merging
• Document your merge criteria so the team handles future cases consistently
• After merging, check if associated deals and tickets transferred correctly

Count your duplicates before and after so you can track whether your data entry process is improving over time.

Part 2: Standardize Contact Formats

Inconsistent formats break reporting and look unprofessional in any communication that pulls from CRM fields.

Phone numbers:

• Search for contacts where phone is stored in multiple formats ((512) 555-1234, 512-555-1234, 5125551234, +15125551234)
• Decide on one standard format and apply it consistently
• Use find-and-replace with regex to normalize formats in bulk rather than editing manually

Common regex patterns for phone cleanup:

• Strip all non-digits, then reformat: \D matches any non-digit character
• Parentheses format: \((\d{3})\)\s*(\d{3})-(\d{4}) matches (512) 555-1234
• Replace with: $1-$2-$3 to get 512-555-1234

Company names:

• Search for common abbreviation inconsistencies ("Inc" vs "Inc." vs "Incorporated", "LLC" vs "L.L.C.")
• Check for all-caps company names from imports
• Look for leading/trailing spaces that make otherwise identical entries look different

Country and state fields:

• Check for "US", "USA", "United States", "United States of America" used interchangeably
• Verify state fields use consistent abbreviations or full names (not mixed)
• Flag records with invalid or placeholder values ("N/A", "Unknown", "test")

Title and role fields:

• Search for test values ("asdf", "xxxxxx", "test contact")
• Look for titles that are clearly job descriptions rather than titles
• Check for placeholder emails ("[email protected]", "[email protected]")

Part 3: Clean Old Domains

Email domains go stale as companies get acquired, rebrand, or shut down. Old domains in your database can cause deliverability problems.

• Export a list of unique email domains from your contact database
• Identify domains that are no longer active (spot-check the highest-volume domains)
• Check for domains that redirected to a new parent company after acquisition
• Flag contacts with emails at defunct domains for re-engagement or removal
• Look for common typos in major domains ("gamil.com", "yahooo.com", "outlok.com")

For company records:

• Check company domain name fields for outdated or incorrect domains
• Verify that company website URLs still resolve (don't link to 404 pages)
• Update records for companies that rebranded since you last cleaned this

Part 4: Validate Data Completeness

Missing data is often a sign that your forms, integrations, or import processes have a gap.

• Identify the percentage of contacts with empty email addresses
• Check how many contacts are missing company association
• Find contacts with no activity in the last 12 months and no lifecycle stage set
• Verify that high-value properties (lifecycle stage, lead source, deal stage) are populated on the records that matter most

This step isn't about filling in every gap manually. It's about identifying systemic problems. If 40% of contacts imported through a specific form are missing phone numbers, the form probably doesn't have a phone field. That's worth fixing at the source.

Part 5: Audit Active Automations

Workflows break when the data they depend on changes. A quarterly check keeps automations running.

• List all active workflows and the enrollment triggers they use
• Verify that property values referenced in enrollment criteria still exist and are populated
• Check list-based enrollments to confirm the lists are still accurate
• Review workflows that use contact properties you've been cleaning (a format change can break a filter)
• Look for workflows with zero enrollments in 90 days (they may be broken or just unused)

Part 6: Review Imported Records

Most junk data enters through imports. Review what came in since the last audit.

• Pull a list of contacts imported in the last 90 days
• Spot-check 20-30 records for format, completeness, and obvious errors
• Check for test records from the import process that shouldn't be in production
• Verify that import mappings haven't drifted (fields mapped to the wrong properties)

The Full Checklist at a Glance

Duplicates:

• Run HubSpot duplicate management tool
• Search for near-duplicates by name
• Merge or flag all duplicate contacts and companies

Formatting:

• Standardize phone number format
• Clean up company name variations
• Fix country/state field inconsistencies
• Remove test/placeholder values

Domains:

• Audit unique email domains for stale or invalid entries
• Update company domain name fields
• Check company website URLs still resolve

Completeness:

• Check key property fill rates
• Identify systemic gaps in data entry

Automations:

• Verify active workflow enrollment criteria
• Check for zero-enrollment workflows
• Test key automations after any data cleanup

Imports:

• Spot-check recent imports
• Remove test records
• Verify field mappings are still correct

How Long This Should Take

A thorough quarterly audit for a mid-size HubSpot portal (10,000 to 50,000 contacts) should take two to four hours with the right tools. If it's taking full days, you're either finding more problems than expected (common on a first audit) or doing the cleanup manually when you should be using bulk operations.

Use HubSpot's built-in tools for deduplication. Use a find-and-replace tool for format standardization and bulk cleanup. Manual editing is only for edge cases that need human judgment.

The first audit is always the hardest. Once you've done it, the next one is mostly maintenance.