Four hours. That is all it takes to run a meaningful audit of your HubSpot CRM and find the problems that are quietly wrecking your pipeline. You do not need a HubSpot partner agency. You do not need a six-week project. You need a laptop, admin access, and this guide.
Most HubSpot instances start clean. Then 18 months pass, three people leave, two integrations get added, and suddenly nobody trusts the data. The lifecycle stages do not match reality. There are 47 custom properties that nobody uses. Duplicates are everywhere. This audit finds exactly where things went wrong.
Before You Start: What You Need
- HubSpot Super Admin access (Settings > Users & Teams to check)
- A spreadsheet to log findings
- Access to your connected tools (marketing automation, forms, integrations)
- Four uninterrupted hours
Set a timer. Work through each section in order. Log every issue you find with a severity rating: critical (breaking workflows), moderate (causing inefficiency), or low (cosmetic or minor).
Hour 1: Contact Properties Audit
Go to Settings > Properties. This is where most HubSpot CRMs fall apart first.
Check for Property Bloat
Sort by "Created by" and look at properties created by former employees. Then sort by "Used in" to find properties that appear in zero forms, zero workflows, and zero lists. These are dead weight.
A healthy HubSpot instance has 50 to 80 active contact properties. If you have more than 150, you almost certainly have redundancy. Look for duplicates: "Company Size" and "company_size" and "Number of Employees" all storing the same information in different places.
Check Property Types
Single-line text fields used for data that should be dropdowns are a consistency killer. If "Industry" is a free-text field, you will have "SaaS", "saas", "Software", and "Tech" all meaning the same thing. Convert these to dropdown properties with standardised options.
Check Required Fields
Go to your contact creation settings. Which fields are required when a rep manually creates a contact? At minimum, you need: email, first name, last name, company name, and lifecycle stage. If reps can create contacts with just an email address, your completeness rates will be abysmal.
Log Your Findings
Note: total properties vs. active properties, any duplicate properties, text fields that should be dropdowns, and missing required field rules.
Hour 2: Lifecycle Stages and Deal Pipeline
Lifecycle Stage Audit
Go to Settings > Properties > Lifecycle Stage. Check how contacts are distributed across each stage. If 80% of your contacts are stuck on "Lead" or "Subscriber", your lifecycle stages are not doing their job.
Common problems:
- No automation moving contacts between stages (everything is manual, so nothing moves)
- Custom lifecycle stages that overlap with default ones ("Warm Lead" alongside "Marketing Qualified Lead")
- Contacts in "Customer" stage who are not actually customers (they were never moved back after a deal was lost)
- No stage for churned or former customers
Pull the numbers. How many contacts are in each stage right now? What percentage moved stages in the last 90 days? If fewer than 10% of contacts changed lifecycle stage in three months, your CRM is static - a filing cabinet, not a sales tool.
Deal Pipeline Audit
Go to Sales > Deals and check your pipeline stages. Look for:
- Deals stuck in the same stage for more than 60 days (these are dead but nobody closed them)
- Deal stages with no exit criteria defined
- Multiple pipelines created for what should be one pipeline with conditional properties
- Deals with no associated contacts (orphaned deals that nobody owns)
A clean pipeline has deals moving or dying. A dirty pipeline has deals sitting in "Negotiation" for six months because closing them as lost feels like admitting failure.
Hour 3: Duplicate Management
HubSpot has a built-in duplicate management tool under Contacts > Actions > Manage Duplicates. Run it. But do not stop there - it only catches obvious matches.
What HubSpot's Tool Misses
HubSpot's deduplication catches identical email addresses and very close name matches. It does not catch:
- Same person, different email (personal vs. work email)
- Same company with slight name variations ("ClientWise Ltd" vs. "ClientWise" vs. "Contact Wise")
- Records merged from different sources where names are formatted differently ("JOHN SMITH" from one import, "John Smith" from another)
Export your contacts to CSV and check for duplicates on first name + last name + company name combination. This catches a significant number of duplicates that HubSpot's tool misses.
Quantify the Problem
How many duplicate pairs did HubSpot flag? How many additional ones did the CSV check find? Multiply the total by the average time to review and merge a duplicate (roughly 3 minutes for a straightforward merge). That gives you the cleanup effort in hours.
If the number exceeds what your team can handle in a week, that is a sign you need a professional CRM health check rather than a DIY cleanup. Some of the most common HubSpot setup mistakes create duplicates at a systemic level that manual merging cannot keep up with.
Hour 4: Integration Health
Go to Settings > Integrations > Connected Apps. This is where silent data corruption lives.
Audit Each Active Integration
For every connected app, check:
- Sync direction: Is it one-way or two-way? Two-way syncs are the leading cause of data overwrites.
- Field mapping: Are the right HubSpot properties mapped to the right fields in the other tool? Mismatched mappings silently corrupt data with every sync.
- Last sync date: If the last sync was weeks ago, the integration may be broken without anyone noticing.
- Error log: Check for sync errors. A handful of errors is normal. Hundreds of errors means the integration is actively damaging your data.
Check for Zombie Integrations
Integrations installed by people who left the company. Tools you no longer use but never disconnected. Test accounts that are still syncing dummy data into production. Disconnect anything that is not actively needed.
Check Form and Workflow Integrations
Go to Marketing > Forms and check each form's connected lists and workflows. Then go to Automation > Workflows and look for workflows with zero enrolments in the last 90 days (dead workflows) or workflows with high error rates.
Dead workflows are harmless. Broken workflows are not - they silently drop contacts from sequences, skip lifecycle stage updates, or fail to notify reps of new leads.
After the Audit: Prioritising Fixes
You should now have a list of issues rated by severity. Here is the order to fix them:
- Critical integration issues - broken syncs or mismatched field mappings are actively corrupting data right now. Fix or disconnect these today.
- Lifecycle stage automation - without this, contacts do not move and your pipeline metrics are meaningless.
- Duplicate merging - start with the highest-value duplicates (contacts with deal associations) and work down.
- Property cleanup - archive unused properties, convert text fields to dropdowns, set required fields.
- Deal pipeline hygiene - close or archive stuck deals, define exit criteria for each stage.
If your audit uncovered more than 20 critical or moderate issues, the CRM needs more than an afternoon of fixes. Consider whether the cost of your team's time to fix everything exceeds the cost of bringing in outside help.
For a detailed comparison of the two approaches, see our analysis of HubSpot vs. Salesforce data management differences, which covers platform-specific quirks that affect how you prioritise fixes.
Keeping It Clean
An audit is a snapshot. Without a recurring process, the CRM will drift back to its current state within six months. Set a calendar reminder to re-run this audit quarterly. Better yet, assign a CRM owner - someone whose job includes data quality, not just someone who happens to have admin access.
The teams that stay on top of their HubSpot data are the ones whose forecasts are believable and whose reps trust the system enough to actually use it. Everyone else runs this audit once, fixes half the issues, and ends up back here in a year.
