Skip to main content

Finding: HubSpot Hygiene Issues

Severity: 🟡 HighMultiple data quality issues in HubSpot are affecting GTM effectiveness.

Summary of Issues

1. Old Job Titles

The Problem

Contacts have job titles from when they were first imported, not current titles.

Impact

  • Wrong persona targeting
  • Irrelevant messaging
  • Sequences to wrong people

Example

Fix

  • Re-enrich contacts older than 6 months
  • Set up recurring enrichment refresh
  • Flag “last enriched date” property

2. Phone Number Formatting

The Problem

Phone numbers have inconsistent formats:
  • +1 555 123 4567
  • 555-123-4567
  • 5551234567
  • +1 (555) 123-4567

Impact

  • Dialers may fail to parse
  • Duplicate numbers not caught
  • Reporting inaccuracies

Fix

  • Standardize to E.164 format: +15551234567
  • Create HubSpot workflow to auto-format
  • Clean existing records

3. Duplicate Records

The Problem

Same person/company exists multiple times with slight variations.

Examples

Impact

  • Multiple team members contact same person
  • Activity history split
  • Inaccurate pipeline reporting

Fix

  • Run HubSpot duplicate detection
  • Merge duplicates
  • Set up ongoing deduplication rules

4. Missing Company Associations

The Problem

Contacts exist without associated companies.

Impact

  • Can’t segment by company size
  • Can’t tier properly
  • Account view is incomplete

Fix

  • Match contacts to companies by email domain
  • Use Baseloop to enrich company data
  • Create workflow to flag unassociated contacts

5. Stale Contacts

The Problem

Contacts with no activity for 12+ months are still in active lists.

Impact

  • Sequences sent to people who left companies
  • Higher bounce rates
  • Wasted enrichment on old data

Fix

  • Create “Stale Contact” property (no activity 12mo)
  • Suppress from sequences
  • Re-verify before re-engaging

6. Inconsistent Properties

The Problem

Same data stored in multiple properties, or different values for same meaning.

Examples

Impact

  • Reports are inaccurate
  • Segmentation is unreliable
  • Workflows fire incorrectly

Fix

  • Audit all properties
  • Standardize naming convention
  • Create dropdowns where possible
  • Document property usage

Data Hygiene Metrics

Hygiene Workflow Proposal

Recommendations

Immediate (Week 1)

  1. Run duplicate report — Identify volume
  2. Audit core properties — List what’s used
  3. Identify stale contacts — Count 12mo inactive

Short-term (30 Days)

  1. Merge duplicates — Start with companies
  2. Standardize phone format — Create workflow
  3. Create hygiene dashboard — Track metrics

Ongoing

  1. Quarterly re-enrichment — Top accounts
  2. Monthly duplicate check — Merge new dupes
  3. Stale contact review — Suppress or refresh
See Proposed HubSpot Setup for the target state.

Next

Audit Overview

Back to main audit findings