How to See Which HubSpot Lists Are Actually Doing Something and Which Are Dead Weight
HubSpot's Used in tab tells you a list is connected to a workflow. It does not tell you whether the list is doing anything. Stamp the source list onto the record and report on it.
Step 3: Build the Custom Report
Now that the data is living on the Contact or Deal record, you can actually see it in a chart.
- Navigate to Reporting > Reports > Create report > Custom report.
- Select Contacts (or your primary object) and Workflows as your data sources.
- For your X-axis, use your new Active Source List property.
- For your Y-axis, use Count of Contacts or Workflow Enrolment Date.
If the data sources part of this is new to you, our custom report builder guide to data sources and proving ROI walks through how the objects join up.
Step 4: Filter for accuracy
To keep the report clean, add a filter where Active Source List is known. This removes any records that entered workflows through manual enrolment or other triggers, leaving you with a clean view of your list-driven performance.
The same report doubles as an audit trail
Do you know which of your lists still do anything?
Most portals carry hundreds, and nobody remembers building them.
There is a second reason to know which lists are moving contact data around. Under the OAIC's Notifiable Data Breaches scheme, a suspected eligible breach has to be assessed within 30 days, and where serious harm is likely, reported to the OAIC and to the people affected.
That assessment asks what data was where. Answering it is a different job when you can point at a stamped property on the record and say which segments and workflows a contact was actively moving through, rather than working backwards through a list library nobody has audited in years. The report you just built is that answer, ready in advance.
Wrapping Up
You’ve effectively turned a manual check into a dynamic dashboard. You can now see which lists are feeding your workflows and which ones are just taking up space. It’s cleaner data, better visibility, and significantly less clicking around.
Dead lists usually point at something bigger. If you want the wider picture, we have written up 12 HubSpot metrics that show automation is being underused, and the same list-and-workflow pattern powers flagging at-risk accounts when contacts unsubscribe.
Need a hand sorting out the lists and workflows underneath? That is what NBH's RevOps and HubSpot service does all day, so message us.
Want to join the conversation? Be a member of our HubSpot User Group and get access to exclusive events.
For more HubSpot hacks and technical deep-dives, come join us over on our Facebook page and YouTube channel.
Wondering what breaks if you clear the old lists out?
Half the cleanup is working out what a list is still feeding.
Happy HubSpotting.