Your revenue team does not trust the data in HubSpot. You already know this. You have seen the sidelong glances in pipeline reviews when a number does not add up. You have heard the "let me double-check that offline" caveat from your VP of Sales. You have watched your CS team Slack each other for context that should be sitting in the deal record.

What you do not know—and what is costing you real money every quarter—is exactly how bad it is. Not a vague "the data is messy" understanding. A quantified, specific, dashboard-level picture of your bad CRM data that you can act on immediately.

Most teams never run that audit because they assume it requires a week-long project, an outside consultant, or a RevOps team they do not have. It does not. You can get a clear baseline of your HubSpot data health in under 60 minutes—if you know exactly what to measure and where to look.

This is the tactical, step-by-step walkthrough. Block the hour. Open HubSpot. Let's go.

Before You Start: Set Up Your Audit Workspace

Time: 5 minutes

Before you touch a single report, create a dedicated dashboard in HubSpot called "Data Health Audit." This is where every report you build in the next 55 minutes will live—and it becomes the recurring measurement tool your team uses going forward. Do not scatter these reports across existing dashboards. Isolation matters. This dashboard has one job: telling you the truth about your data.

Open a separate document—Google Doc, Notion page, whatever your team uses—and title it "Data Audit Findings." You will use this to capture the specific numbers, flag the worst offenders, and document the action items that come out of each step. Raw numbers without context are useless. Write down what you find and what it means as you go.

Step 1: Measure Record Completeness on Active Deals (Minutes 5–20)

This is the single most important metric in your entire HubSpot data audit because it directly impacts forecast accuracy—the number your board sees every quarter.

What to Build

Create a custom report that filters for all open deals and measures the fill rate on these six critical fields: close date, deal amount, deal stage, associated contact, associated company, and deal owner. These are not optional enrichment fields. These are the minimum viable data points required for a deal record to be useful for forecasting, routing, and reporting.

How to Read It

Pull the percentage of active deals that have all six fields populated. This is your Record Completeness Rate. Write it down.

Then pull a separate list of deals where the close date has already passed but the deal status is still "open." These are your zombie deals—records that are actively inflating your pipeline number with revenue that is never coming in. Count them. Calculate what percentage of your total pipeline dollar value they represent.

What Good Looks Like

Record Completeness Rate above 85% is functional. Above 90% is strong. Below 75% means your forecast is fundamentally unreliable and every downstream decision built on pipeline data—headcount planning, territory design, board reporting—is compromised. If you want to understand exactly how that forecast variance translates into real dollars, we break down the hidden costs of bad CRM data in a separate deep-dive.

If you are below 75%, do not panic. You now have the baseline. That is the entire point. The five-step remediation framework in our CRM data hygiene blueprint is built specifically for this situation—starting with the standards and enforcement structures that prevent the number from getting worse while you fix what is already broken.

Step 2: Quantify Your Duplicate Problem (Minutes 20–30)

Duplicates are the most visible symptom of a data hygiene problem and the easiest to quantify. They also distort every report you run—inflating contact counts, splitting activity history across multiple records, and creating confusion for reps who do not know which record is the "real" one.

What to Build

Navigate to HubSpot's built-in duplicate management tool (Settings > Data Management > Duplicates). Pull the current count of suspected HubSpot duplicate contacts and duplicate companies. Write both numbers down.

Then calculate your duplicate rate: divide the number of suspected duplicates by your total contact count. Do the same for companies.

How to Read It

A duplicate rate under 3% is manageable with routine weekly maintenance. Between 3–8% means duplicates are actively degrading your reporting accuracy and rep experience. Above 8% means you have a systemic creation problem—your forms, integrations, or team workflows are generating duplicates faster than anyone could manually clean them.

The Quick Win

While you are in the duplicate tool, merge the top 20 duplicate pairs right now. Prioritize duplicates that have associated open deals—these are the ones most actively distorting your pipeline data. This takes 10 minutes and delivers an immediate, tangible improvement to data quality. It also gives you a feel for the types of duplicates being created, which tells you where the root cause lives: sloppy form submissions, integration misconfigurations, or reps who create instead of search.

Step 3: Identify Your Stale Records (Minutes 30–40)

Stale records are the silent bloat in your database. They take up space, skew engagement metrics, inflate your marketing contact tier (which you are paying for), and give everyone a false sense of database size. HubSpot's Database Decay research shows that marketing databases naturally degrade by roughly 22.5% every year—which means every month you skip this check, the problem is compounding.

What to Build

Create two lists:

Stale contacts: Contacts with no logged activity (email, call, meeting, form submission, page view) in the past 90 days. Filter out contacts in lifecycle stages that would not be expected to have recent activity—subscribers or unqualified leads, for example. You want to isolate contacts who should be active but are not.

Stale deals: Deals that have been in the same pipeline stage for more than 60 days with no activity update. These are the opportunities your reps have either lost and not updated, or are "nurturing" without any documented engagement—which in practice means they are sitting in the pipeline to make the coverage number look better.

How to Read It

Calculate your Stale Record Rate: divide stale contacts by total active contacts, and stale deals by total open deals. Write both percentages down.

If stale contacts exceed 25% of your database, you are paying for marketing contacts that provide zero commercial value. If stale deals exceed 15% of your open pipeline, your pipeline coverage ratio is a fiction—and your forecast is built on deals that are effectively dead.

What to Do With This Number

Do not mass-delete stale records during the audit. That is a governance decision that requires standards and a defined archival process. For now, document the number and flag the worst offenders—the deals with the largest dollar amounts that have had zero activity for the longest time. These are the first conversations your sales managers should be having in their next round of one-on-ones.

Step 4: Audit Property Usage and Clutter (Minutes 40–50)

Every HubSpot instance accumulates property clutter over time. Custom properties get created for a specific campaign, a one-off report, or a data migration—and then they sit there forever, unfilled and unmaintained, adding noise to every record view and confusing reps who do not know which fields actually matter. This is where the absence of a HubSpot data dictionary becomes painfully obvious—nobody knows what half the properties mean, who created them, or whether they are still in use.

What to Build

Export your full property list (Settings > Properties) and sort by fill rate. HubSpot shows you the percentage of records that have data in each property. Pull every custom property with a fill rate below 10%.

Then count your total custom properties versus your actively used custom properties (fill rate above 50%). The ratio tells you how much clutter is in your system.

How to Read It

If more than 40% of your custom properties have a fill rate below 10%, your CRM has a clutter problem that is actively making data entry harder. Every unused property is a field that a rep has to scroll past, a dropdown they have to ignore, and a potential source of confusion about what actually needs to be filled out.

The Quick Win

Flag every sub-10% property for review. Do not delete them during the audit—some may be used in workflows or reports you are not aware of. Instead, create a "Properties to Review" list in your audit document. During your next quarterly hygiene review, verify each one against active workflows and reports, then archive or delete anything that is truly orphaned.

Step 5: Validate Lifecycle Stage Accuracy (Minutes 50–60)

Lifecycle stages are the foundation of your funnel reporting. If contacts are in the wrong stage, your conversion rates are fiction, your marketing attribution is broken, and your lead-to-opportunity handoffs are happening at the wrong time—or not at all.

What to Build

Pull a random sample of 10 contacts from each lifecycle stage in your system. Open each record and manually verify: does this contact actually belong in this stage based on their activity history, deal associations, and engagement level?

How to Read It

Score each sample on a pass/fail basis. If a contact is a "Marketing Qualified Lead" but has never engaged with a marketing asset, that is a fail. If a contact is an "Opportunity" but has no associated open deal, that is a fail. If a contact is a "Customer" but their deal was closed-lost, that is a fail.

Calculate your Lifecycle Stage Accuracy Rate: the percentage of sampled contacts that are correctly staged. If you are below 80%, your funnel reporting is unreliable. Below 60% means lifecycle stages are effectively meaningless in your instance—they exist in name only and provide no analytical value.

This is the metric that tells you whether your definitions are clear enough. If reps are consistently misstaging contacts, the problem is almost never laziness. It is ambiguity. Your lifecycle stage definitions either do not exist, are too vague to act on, or have not been communicated in a way that eliminates guesswork. Establishing clear HubSpot naming conventions for every stage—documented in a living data dictionary your team can reference—is how you close the gap.

Your Audit Scorecard: What You Should Have Now

At the end of 60 minutes, your "Data Audit Findings" document should contain five specific metrics:

Record Completeness Rate — percentage of active deals with all six critical fields populated. Duplicate Rate — suspected duplicates as a percentage of total contacts and companies. Stale Record Rate — percentage of contacts and deals with no recent activity. Property Clutter Ratio — percentage of custom properties with sub-10% fill rate. Lifecycle Stage Accuracy Rate — percentage of sampled contacts correctly staged.

These five numbers are your Data Health Baseline. Every improvement you make from here forward gets measured against them. Run this same HubSpot data audit monthly—it gets faster after the first time because the reports already exist—and track the trend lines. The goal is not perfection on day one. The goal is visible, measurable progress every month.

What Comes After the Audit

The audit tells you how bad it is. It does not fix it.

Fixing it requires the operational framework—data standards, deduplication protocols, a recurring hygiene calendar, and an accountability structure—that turns a one-time audit into a permanent discipline. That is exactly what we break down in our CRM data hygiene blueprint. The blueprint picks up where this audit ends and gives you the step-by-step system to build data hygiene that actually sticks.

But if your audit scorecard reveals problems across three or more of these five metrics—and for most B2B teams that have never run a structured audit, it will—you are likely looking at a remediation effort that is hard to execute while simultaneously running day-to-day revenue operations.

That is where Squad4 comes in.

Our GTM & HubSpot Audit goes deeper than what you can accomplish in 60 minutes—mapping data quality issues to their revenue impact, identifying root causes in your integrations and workflows, and delivering a prioritized remediation roadmap your team can execute immediately. For organizations that need ongoing governance, our Fractional GTM/RevOps services embed the operational discipline that keeps your data clean permanently—not just until the next fire drill pulls everyone's attention away.

You just spent 60 minutes learning the truth about your data. Now do something about it.

👉 Book a HubSpot Data Health Audit with Squad4 and turn your baseline into a remediation plan with real revenue impact.