topic Re: How can I create create an Active List that shows Companies with no Contacts assigned? in Tips, Tricks & Best Practices

How can I create create an Active List that shows Companies with no Contacts assigned?

AaronBoatin — Sun, 12 Mar 2023 19:22:15 GMT

We're trying to clean up the unused companies in our database and delete ones not associated with any contacts.

I'm runnning into a dead end when trying to create an active list.

Any help would be greatlty appreciated!

Re: How can I create create an Active List that shows Companies with no Contacts assigned?

karstenkoehler — Sun, 12 Mar 2023 20:34:05 GMT

Hi @AaronBoatin,

There is a company property 'Number of associated contacts' which you can filter for on the company index page (Menu > Contacts > Companies) it in lists. When this number is 0, the contact wouldn't have any associated contacts.

Best regards!

Re: How can I create create an Active List that shows Companies with no Contacts assigned?

BukunmiOdetayo — Tue, 21 Mar 2023 17:43:31 GMT

Hey @AaronBoatin,

I too just deleted some unused companies from my CRM a couple of hours ago. To do this, navigate to contacts -> lists -> create a list (active) and choose "company based".

Then, give your list a name and edit filter -> choose company properties and add the following filters:

1. Company name is known and

2. Number of associated contact is equal to "0"

This will give you the list of companies with no associated contacts in your hubspot.

I added this demonstration video for you.

Let me know if this helps.

Re: How can I create create an Active List that shows Companies with no Contacts assigned?

AaronBoatin — Mon, 13 Mar 2023 09:25:24 GMT

Thank you, Bukunmi!

Re: How can I create create an Active List that shows Companies with no Contacts assigned?

AaronBoatin — Mon, 13 Mar 2023 09:28:32 GMT

Danke, Karsten!

Re: How can I create create an Active List that shows Companies with no Contacts assigned?

GRajput — Mon, 20 Mar 2023 14:13:25 GMT

Hi @AaronBoatin - Yes, we can create an active list that shows Companies with no Contacts assigned.You can create an active list using Number od associated contacts.Here is the screenshot below:

Please mark it as SOLUTION ACCEPTED if you like the solution.

Thank you!

Re: How can I create create an Active List that shows Companies with no Contacts assigned?

RevOpsNinjaaaaa — Tue, 14 Jan 2025 11:18:51 GMT

I don't see any property called "Number of associated contact". I do see it for deals but not contacts. Any idea why?

Re: How can I create create an Active List that shows Companies with no Contacts assigned?

HSasking59 — Tue, 29 Apr 2025 11:44:37 GMT

Similarly, how can I create an active list for deals who have no companies associated? I can create a list view on the deals management page but can't seem to use the same property to filter the list with "Associated Company" is unknown like I could in the list view. Any ideas?