A HubSpot data quality panel you can click straight through
A B2B SaaS business with marketing, sales and customer success teams all working in HubSpot.
Plenty of HubSpot data problems, and no single place to see them
The business had tens of thousands of contacts in HubSpot, arriving from website forms, event lists, imports, integrations and sales reps typing them in by hand. Over the years that mix had left contacts with no name at all, names typed entirely in capitals, and personal email addresses where a work address should be. The same company was often held twice under slightly different names. There were deals with no company attached, records owned by deactivated users, and tasks long overdue.
Each of those problems could be found, one at a time. Someone would build a filter, export a list, fix what they could and move on. A month later the same questions came back and the same filters had to be built again. Leadership wanted to know, continuously, how much of the database they could trust and where the gaps were, without anyone spending a day working it out.
Some of the most damaging problems are about how a value is written, rather than whether it is there. A name in capitals, a stray space, "test" in a company name or a phone number in a name property all count as filled in. Duplicates are about how records relate to each other, so no single property shows them. Those questions needed a different approach.
A growing SaaS business with data coming in from every direction
Marketing ran campaigns and events, sales worked leads and deals, and customer success managed onboarding and renewals through tickets and tasks. Every team relied on the same records, and every team added to them. The business did not want a one-off clean-up that would be out of date within weeks. It wanted the state of its data in front of it every day, and a fast route from a number to the records that needed fixing.
Plenty of data problems, and no single place to see them
A rules table in HubSpot HubDB and a small code action that never needs editing
HubSpot data quality in front of the team every morning
Every figure opens the records behind it, with a link to each one in HubSpot.
The panel rebuilds and republishes itself with nobody touching it.
A read-only audit. Fixes are made by the team, in HubSpot, from the lists the panel gives them.
From seeing HubSpot data problems to preventing them
With the problems measured, the next step is to stop them arriving. That means tightening the forms and imports that create the most faults, and adding automation in HubSpot to tidy values as they come in. Tracking the figures over time will then show whether the database is getting cleaner, and how quickly.
← Back to all work