Your HubSpot reports look great. Pipeline value is up. Lead volume is growing. The CEO nods approvingly in the weekly meeting.
Then the quarter closes.
Actual revenue is 40% below forecast. Marketing-sourced leads that sales says were garbage. VP of Sales blames the CRM. Marketing blames sales.
Nobody blames the data. But that's where the real problem lives.
1. Ghost Properties Inflating Your Schema
Properties with less than 5% fill rate that nobody uses — but everyone is afraid to delete.
Why it hurts: Every unused property adds noise to forms, views, and exports. Worse, similar-but-different properties like company_revenue and annual_revenue cause teams to record data in different places. Your reports show two conflicting numbers for the same thing.
The fix
Export all properties with fill rates. Archive anything below 5% that hasn't been updated in 90 days. Adopt snake_case with category prefixes going forward (e.g., sales_qualified_date).
2. Orphan Contacts Without Company Associations
In many portals, 20-40% of contacts have no associated company. Think about what that means for your account-based reporting.
Why it hurts: A contact at a target account fills out a form but isn't linked to the company record. Your ABM reports show zero engagement for that account. Your sales rep doesn't see the contact. That lead might never get worked.
The fix
Enable automatic association by company domain (Settings > Objects > Contacts > Auto-create and associate). Bulk-associate existing orphans using workflows or the batch API.
3. Lifecycle Stage Chaos
The journey should be: Subscriber → Lead → MQL → SQL → Opportunity → Customer.
In reality? Contacts are skipping stages, regressing, jumping from Subscriber straight to Customer. Your funnel metrics become fiction.
The fix
If more than 10% of contacts have skipped stages, build a workflow to enforce sequential progression. Use lifecycle stage automation or qualifying criteria to gate each transition.
4. Pipeline Pollution: Deals That Should Be Dead
Open your deal pipeline. Sort by "Last Activity Date." You'll find deals sitting in stages for 3x, 5x, even 10x the average stage duration.
These stuck deals inflate pipeline value and destroy forecast accuracy.
Your reported pipeline shows $2M, but $800K of that hasn't had any activity in 90 days. When leadership makes decisions based on a $2M pipeline that's really $1.2M... bad things happen.
The fix
Define "stuck" thresholds per stage (e.g., 2x average days). Create alert workflows. After 30 days of no response, auto-move to "Stalled." Review and close stalled deals monthly.
5. Inconsistent Data Formats
Phone numbers stored four different ways. Country names in three variations. Revenue values as $50,000, 50000, and 50K.
Why it hurts: A workflow filtering for "Country equals United States" misses every record that says "US." Your reports show four separate bars for the same country. Integrations expecting specific formats break silently.
The fix
Use dropdown properties instead of free text for critical fields like Country. Standardize with Operations Hub formatting actions. Use HubSpot's built-in phone formatting.
6. Duplicate Records You Don't Know About
HubSpot's built-in dedup catches exact email matches. That's it.
But what about the same person with personal vs work email? The same company as "Acme Inc" vs "Acme, Inc." vs "ACME"? Contacts entered by both marketing automation and manual sales entry?
Why it hurts: Split engagement history. Contact A has 5 email opens, Contact B (same person) has 3 website visits. Neither shows the full picture. Marketing scores them separately. Sales might outreach twice. You're paying for duplicates in your HubSpot tier.
The fix
Go beyond email matching. Compare by name + company, phone number, and domain patterns. Our Audit Tool runs a 4-pass dedup algorithm with confidence scoring to catch fuzzy matches the native tool misses.
7. Missing Deal-to-Contact Associations
Deals created via import, API, or manual entry often have no contact association. The deal exists in the pipeline but isn't linked to the person who generated it.
Why it hurts: Attribution breaks completely. Marketing can't prove which campaigns generated revenue. Sales managers can't see all deals for an account.
The fix
Require contact association when creating deals (required property or workflow validation). For existing orphan deals, use the batch association API to link them based on matching criteria.
The Compound Effect
Measure Before You Fix
Don't start fixing things randomly. First, measure the severity across all 7 dimensions so you can prioritize by business impact.
The HubSpot Audit Tool scores your data quality across all these areas and tells you exactly what to fix first. No guesswork, no spreadsheet analysis.