Why unused properties are a problem

Cluttered forms and filters slow your team down β€” they scroll past 50 irrelevant fields to find the one they actually need. Property dropdowns become unnavigable. Reports pull from stale fields and produce numbers nobody trusts. New team members can't tell which properties matter and which are graveyards from a 2022 integration.

And there's a hard ceiling: HubSpot enforces a 1,000 custom property limit per object type. If you're approaching that on contacts or companies, cleanup isn't optional β€” you'll get blocked from creating the next field you need.

Method 1 β€” The manual Excel export

This is the technique most admins try first. It works, but it's tedious.

  1. Go to Settings β†’ Properties in HubSpot.
  2. Click "Export all properties" in the top right of the property list.
  3. Open the CSV. You'll see property names, types, groups, and creation dates β€” but not fill rate. HubSpot's export does not tell you how many records actually have a value.
  4. For each property, go back to HubSpot and create a filter or list with the condition "property is known". The list count tells you how many records have a value. Compare that to total records to get the fill rate.
  5. Repeat for every property across every object type (contacts, companies, deals, tickets…).
  6. Time estimate: 3–5 hours for a portal with 100 custom properties. Longer if you also audit deals, tickets, and custom objects.

This works, but it's brutal. You'll do it once and never want to do it again. It's also frozen in time β€” six months later you're back at zero.

Method 2 β€” HubSpot's Data Quality Command Center

HubSpot ships a native data quality tool. It's worth knowing what it does and doesn't do before you decide it's the answer.

  • Available only with Operations Hub Professional or higher (from $800/mo).
  • Covers contacts and companies only β€” not deals, tickets, leads, line items, quotes, or custom objects.
  • Defines "unused" as "not referenced in any HubSpot tool" (no workflow, list, or report uses the property). This is a fundamentally different question from "does any record have data in this field?"
  • A property could have 10,000 filled records and still show as "unused" if no workflow references it.
  • Conversely, a property with 0% fill but mentioned in one old, disabled list won't show as "unused".
  • It's good if you already pay for Ops Hub Pro and primarily care about automation dependencies. It's not worth upgrading just for this.
The Command Center answers "is this property wired into anything?" β€” not "does anyone actually have data in this field?" Both questions are useful, but they're different.

Method 3 β€” Automated scanning with PropSweep

PropSweep is built around the fill-rate question specifically. It scans every custom property in your portal and calculates the actual percentage of records with a value β€” across contacts, companies, deals, tickets, leads, line items, quotes, calls, emails, meetings, notes, and custom objects.

  • Works on all HubSpot plans, including Free.
  • A portal with 100 custom properties scans in about 30 seconds.
  • Free tier: one scan every 7 days, contacts/companies/deals, top 5 results.
  • Pro Pass: $19 for 6 months, unlimited scans, all object types, weekly auto-scan, CSV export.
  • Read-only OAuth β€” your CRM data never leaves HubSpot. See data transparency.

Install from the HubSpot Marketplace and run your first scan in 30 seconds. Full setup guide here. For a side-by-side with the native Data Quality Command Center, see the comparison page.

What to do after you find unused properties

Finding the dead weight is the easy part. Cleaning it up safely takes a little discipline:

  • Archive rather than delete. HubSpot keeps archived properties for 90 days, so you can restore if you find out something downstream still depended on the field.
  • Check for active references first. HubSpot's property settings panel shows whether a property is used in any workflow, list, or report. If it shows up there, talk to whoever built that automation before archiving.
  • Export a snapshot before cleanup β€” either the Excel export or a PropSweep CSV β€” so you have a record of what existed pre-cleanup.
  • Communicate changes to your team. Someone might be using a property you think is dead, especially if their workflow lives in a personal saved view rather than a shared list.
  • Adopt a property naming convention going forward β€” prefix by team, campaign, or integration (e.g. marketing_q4_2026_source) β€” so future cleanups are easier and sprawl is easier to spot.

How often should you audit properties?

  • Quarterly is ideal for active portals β€” fast enough to catch sprawl before it gets painful, infrequent enough to not be a chore.
  • After any major integration change, migration, or team restructure. These events tend to leave behind orphaned properties from old systems and old owners.
  • After campaign seasons (Q4, events, product launches) that tend to spawn one-off properties nobody cleans up afterward.

Run your first scan in 30 seconds

You can install PropSweep free from the HubSpot Marketplace and run your first scan in 30 seconds β€” no credit card needed.

Install Free on HubSpot