How to Run a Quarterly HubSpot CRM Audit

Annual CRM cleanups are better than nothing, but a lot of damage happens in twelve months. Stale deals distort your pipeline for three quarters before anyone catches them. Inconsistent data formatting compounds with every new import and form submission. Workflows break silently and run that way for months.

A quarterly audit is the minimum cadence for keeping a HubSpot portal healthy. It is frequent enough to catch problems before they compound, but not so frequent that it becomes burdensome. Here is a repeatable audit process you can run every 90 days.

Before you start: define your audit scope

Not every quarter needs a full-depth audit. Alternate between comprehensive and focused audits:

• Q1 (January): Comprehensive -- full cleanup after the year-end push. This is your deepest audit.
• Q2 (April): Focused -- check data quality metrics and deal pipeline hygiene. Fix anything that degraded since Q1.
• Q3 (July): Moderate -- mid-year check. Review automations, audit new properties created in the first half, clean stale records.
• Q4 (October): Focused -- pre-year-end pipeline accuracy. Make sure reporting data is solid before the annual review.

The quarterly audit checklist

1. Data quality scorecard

Start every audit by measuring your data quality. Track these metrics quarter over quarter to see if things are improving or degrading.

Contact completeness rate. What percentage of contacts have all required fields filled? Define "required" for your business -- typically email, first name, last name, company, and lifecycle stage at minimum.

To check this in HubSpot, create a list with "any of" criteria where each required field "is unknown." The count of contacts in this list divided by your total contact count gives you the incompleteness rate.

Email deliverability indicators. What is your hard bounce rate? How many contacts have invalid email addresses? HubSpot's email health dashboard shows this for marketing emails, but you should also check the raw count of contacts with a "bounced" email status.

Duplicate rate. Go to Contacts > Actions > Manage Duplicates and note how many potential duplicates HubSpot has identified. Track this number quarterly. If it is growing, your deduplication processes are not keeping up with new data entry.

Formatting consistency. This is harder to quantify, but you can spot-check specific properties. Pull a sample of 100 records and check fields like phone number, country, and state for formatting consistency. If more than 10% have non-standard formatting, you have a standardization problem.

2. Contact hygiene

Unengaged contacts. Create or refresh your list of contacts with no engagement in the last 90 days. Compare this to last quarter's list. If the unengaged segment is growing as a percentage of total contacts, your engagement strategies need attention -- but the data action is to either re-engage or downgrade/remove these contacts.

Invalid email addresses. Filter for contacts with a hard bounce status. These should be removed from marketing contact status immediately and evaluated for deletion.

Contacts with no owner. Unowned contacts fall through the cracks. Filter for contacts where "Contact owner" is unknown and assign them or evaluate whether they should be in the CRM at all.

Lifecycle stage accuracy. Spot-check contacts in each lifecycle stage to make sure they belong there. Common issues:

• "Leads" who are actually customers (lifecycle stage was not updated when they converted)
• "Marketing Qualified Leads" who have been sitting in that stage for six months with no sales activity
• "Customers" whose subscriptions have actually lapsed

3. Deal pipeline audit

Stale deals. Filter for deals where:

• The deal stage is open (not closed won or closed lost)
• The last activity was more than 45-60 days ago (adjust based on your typical sales cycle)

These deals are likely dead but have not been formally closed. Work with sales managers to either re-activate them with a next step or close them as lost.

Close date accuracy. Filter for deals with a close date in the past that are still in an open stage. These deals have blown past their expected close date and need updated dates or a stage change.

Amount accuracy. For deals in late stages (negotiation, contract sent), verify that the deal amount reflects the current proposal. Outdated amounts distort your weighted pipeline forecast.

Pipeline coverage. Calculate your pipeline coverage ratio (total open pipeline value divided by quarterly target). If it has dropped significantly since last quarter, that is a signal -- not just a data quality issue, but a business one.

4. Company data review

Orphaned companies. Filter for companies with no associated contacts. These may be test records, import artifacts, or companies whose contacts have been deleted. Evaluate and clean up.

Stale company data. Spot-check your top 50-100 companies by deal value. Are the company names, domains, industries, and addresses still accurate? Companies get acquired, rebrand, and change industries more often than most teams realize.

Company name consistency. Run a quick review of company name formatting. Common issues:

• Inconsistent use of "Inc.", "LLC", "Ltd."
• Mixed casing
• Different abbreviations for the same company

If you spot a pattern of inconsistency, a bulk search-and-replace operation can fix hundreds of records at once.

5. Property audit

New properties created this quarter. Review any custom properties that were added in the last 90 days. For each one, confirm:

• Is it being used?
• Is it named according to your naming convention?
• Is the property type appropriate (dropdown vs. free text, etc.)?
• Is it assigned to the correct property group?

Low-usage properties. Identify properties with less than 5% data fill rate. If a property has been around for more than two quarters with low usage, it is probably not providing value. Consider archiving it.

Properties with high cardinality. Free-text properties that should be dropdowns (like "Industry" or "Job Department") tend to accumulate inconsistent values over time. Check whether any text properties should be converted to dropdowns with standardized options, and clean up the existing values before converting.

6. Automation health check

Workflow errors. Check each active workflow for errors in the last 90 days. HubSpot's workflow performance tab shows error rates and specific failed enrollments. Investigate and fix any workflows with error rates above 1%.

Workflow performance. For each active workflow, check:

• Is it still enrolling records? (If not, the trigger criteria may have become outdated.)
• Is the goal being achieved at a reasonable rate?
• Are there workflows that should have been turned off after a campaign ended?

Email send health. Check your marketing email dashboard for deliverability trends. If open rates are declining or bounce rates are increasing, your contact data quality may be the root cause.

Form conversion rates. Review form performance. If conversion rates dropped, check whether form fields or validation rules need updating.

7. Integration review

Active integrations. Review your connected integrations and apps. Are all of them still in use? Unused integrations that still have API access are a security risk and can create confusing data changes.

Sync conflicts. If you use data sync (via Data Hub, formerly Operations Hub, or third-party tools), check for sync errors or conflicts that have accumulated. Address any records that failed to sync.

After the audit: action items

Every audit should produce a short list of action items with owners and deadlines. Common items include:

• "Merge 150 duplicate contacts" -- Owner: [Name], Deadline: [Date]
• "Close 45 stale deals" -- Owner: [Sales Manager], Deadline: [Date]
• "Standardize country field values" -- Owner: [Ops], Deadline: [Date]
• "Fix workflow X error" -- Owner: [Ops], Deadline: [Date]
• "Archive 12 unused properties" -- Owner: [Ops], Deadline: [Date]

Keep a running document that tracks these action items and their completion status. Over time, this document becomes a record of your data governance efforts -- useful for compliance and for demonstrating progress to leadership.

Making it sustainable

The biggest risk with a quarterly audit is that it fades away after one or two cycles. Here are practical tips for making it stick:

Timebox it. A quarterly audit should take 2-4 hours, not two days. If it takes longer, you are going too deep for a quarterly cadence. Save the comprehensive audit for Q1 and keep the other quarters lighter.

Use the right tools. Manual data checks are slow and error-prone. For formatting consistency and bulk corrections, a search-and-replace tool cuts the time from hours to minutes. For duplicate management, use HubSpot's built-in tool. For list creation and filtering, use saved views that you can reuse each quarter.

Assign a single owner. One person should be responsible for running the audit and ensuring action items get completed. This is usually someone in RevOps or CRM administration.

Share results. Send a brief summary to stakeholders after each audit. Include the data quality scorecard, key findings, and action items. Visibility creates accountability.

---

A quarterly CRM audit is not glamorous work, but it is the single most effective practice for maintaining CRM data quality over time. The teams that do it consistently are the ones whose reports are trustworthy, whose automations work reliably, and whose sales reps actually trust the system they are working in.