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!
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!
Danke, Karsten!
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?
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.
Thank you, Bukunmi!
I don’t see any property called “Number of associated contact”. I do see it for deals but not contacts. Any idea why?
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!