Data quality

HubSpot data quality: 7 hidden problems and how to measure them in Chile and Latin America

HubSpot data quality problems rarely throw an error: they quietly split reports, inflate the pipeline and make the forecast hard to defend. The seven most common ones are unused or duplicated properties, contacts without a company, inconsistent lifecycle stages, overdue close dates, inconsistent formats, placeholder values and late-stage deals without an amount. This guide shows how to measure each one and fix it without adding friction for your sales team, in B2B companies in Chile and Latin America.

  • By Roberto Guerra
  • 4 min read
  • Updated October 4, 2026
Contact property fill rates, from empty properties to ones filled in most records.
In short
Problems
Seven, from properties to amounts
First
Whatever affects the forecast
Never
Required fields at record creation
Rule
Measure before you fix
Every problem comes with how to fix it.
Property fill rates in HubSpot Audit, with sample data.

What are ghost properties and what should you do with them?

They are custom properties nobody fills in, or two properties that store the same thing, such as “annual revenue” and “company revenue”. Each one adds noise to forms and views.

Why do contacts without a company break your account view?

A contact from a target account fills in a form but is not associated with the company. The account looks inactive, the rep does not see the new contact and the attribution is lost.

What happens when lifecycle stages contradict the deals?

Contacts marked as subscribers with open deals, customers that regress to lead, stages skipped without a trace. Funnel metrics stop meaning anything.

Why are overdue close dates a forecast problem?

An open deal whose close date already passed is still counted in the forecast for a period that is over. Add deals with no next activity and the pipeline looks bigger than it is.

Forecast integrity: deals with overdue close dates, no next activity or no recent progress, and the first pipeline findings with their open amount.
Forecast integrity in HubSpot Audit, with sample data.

How do inconsistent formats break workflows?

“Chile”, “CL” and “chile” in the same field. A workflow filtering by one value misses the others and a report shows three bars for the same country.

Where do placeholder values like “test” or “N/A” come from?

Almost always from a field that was made required when the record is created. The rep does not know the value yet, needs to save and types anything.

Why should the amount be required by stage and not at creation?

Deals past the proposal stage with no amount, or with no contact, make pipeline value unreliable. Forcing those fields at creation does not work either: early deals rarely know the amount.

Two people review a report on a blurred screen.

How do you measure all seven before fixing anything?

Fixing at random wastes weeks. Measure first, rank by business impact and start with what affects the forecast.

Data quality checks with the share of records affected by each one, such as companies without a domain or contacts without an owner.
Data quality in HubSpot Audit, with sample data.

HubSpot Audit from Revenue Hub Latam measures these signals in the data model and process pillars, and labels the inferred ones as signals to confirm.

If you also suspect duplicate records, the duplicates guide explains how to decide what to merge in HubSpot.

FAQ

What else do people ask?

What is data quality in HubSpot?

It is how complete, consistent and trustworthy the records in your portal are: contacts, companies, deals and tickets. Good data quality means a report gives the same answer no matter who builds it.

Should I archive properties with low fill rates?

Not on usage alone. A rarely used property can be critical for one product line or integration. Check dependencies, phase it out first and archive only after confirming nothing uses it.

Should the deal amount be required when the deal is created?

No. Make it required at the stage where it becomes known, usually proposal. Required fields at creation produce placeholder values that look like data.

How do I find contacts without a company?

Filter contacts with no associated company, and check companies without a domain, because HubSpot cannot associate contacts to a company without one.

Should I auto-close stale deals?

No. Show them as exceptions to their owner and the manager. Closing or moving deals automatically replaces a business judgment with a rule and hides the real problem.

Does HubSpot Audit fix the data on its own?

No. The audit only reads your portal. Paid actions do change HubSpot: the ones that turn on, turn off, archive, delete or remove users ask for confirmation in a dialog, and assigning an owner applies as soon as you pick the person. The improvement plan does not recommend deleting: it proposes keep, improve, consolidate, redesign, phase out or review for archive.

Next steps

What should you do after reading this guide?

More HubSpot Audit guides
  • Data quality

    Duplicate contacts in HubSpot

    Why they appear, how to find them with the native tool and how to decide what to merge.

    3 min readRead the guide
  • Before you audit

    HubSpot portal audit checklist

    What to review in each of the six pillars and which decision to make with each finding.

    5 min readRead the guide
From Revenue Hub Latam
A Revenue Hub Latam product

Who is behind HubSpot Audit?

HubSpot Audit is a Revenue Hub Latam product. It grew out of the reviews we did by hand in every HubSpot diagnostic with B2B companies in Chile and Latin America.

  • Tools born from real problems we solved with clients in HubSpot.
  • HubSpot Audit diagnoses the portal; HubCoach, Teamwork and PortalSync support the day to day.
  • If you want to review the result with our team, we do it in a HubSpot diagnostic.
HubSpot Solutions Partner Platinum
HubSpot Platinum Partner in Santiago, ChileWe implement, rescue and run HubSpot for B2B companies.
HubSpot Partner Summit LATAM 2026From the Revenue Hub Latam team that created PortalSync: most-voted pitch, Pitch Contest · HubSpot Partner Summit LATAM 2026, Bogotá.
Start on your own, for free

Want to see this in your portal?

Connect HubSpot with OAuth and see your findings in minutes, with the free HubSpot Audit. For now, connecting requires a portal with an Enterprise product, Service Hub Professional or higher, and Marketing Hub or Content Hub Professional or higher.

  1. Create your account with your work email.
  2. Connect your HubSpot portal with OAuth.
  3. Read the summary and decide the next step.
HubSpot data quality: 7 hidden problems | Revenue Hub Latam