HubSpot Ideas

SLoo

Contact List filter for Number of associated companies

Hi team, 

It'll be great if we could filter a contact list by the number of associated companies. There isn't a direct filter for this in a list or workflow at the moment and it'll definitely benefit customers distilling these records. 

Thanks for your consideration!

36 Comentários
karenkaz
Participante

@JJimenez29 Here is how I built the report. I can't limit it to contacts with more than one associated company but sorting by count of companies in descending order gets me mostly there. I download it and use Excel to exclude the records with only one company. When building the report, Contacts is the primary data source and Companies is secondary. (Ignore APA Contact ID, that's just a custom property we use.)

 

Now, if only it were easy to turn a report into a list without having to download it and reupload, but that's another feature request. 😄 

 

 contactswithcompanies.png

MInglis
Participante

+1 - this would do a lot of good for our data integrity 

BSong
HubSpot Employee

Agreed, we already have "Number of .... records" for other objects to Contacts, Number of Companies should be the next natural step

RWass
Membro

We are in need of such filtering option also. As many have said here before. There is options for this when it comes to associated contacts for a company, but not the other way around.

KSwift
Participante

Hey, I couldn't get @karenkaz's solution to work. For sone reason, when I exported the contacts, they all had either 0 or 1 in the companies count. In case that happens to anyone else, my workaround has been to export contacts with the contacts - companies column, and then filter for any with a semicolon, indicating more than one ID populates the field. 


CMedrano
Participante

Need this greatly! This would be an amazing report to keep database hygiene, especially since you can't delete or merge duplicate companies in HubSpot when you have the Salesforce integration active.

MDELAIGUE
Membro

A basic filter that we don't have ... please add it, we need this feature on contacts

MPackard
Participante

Still very much in need of this property to identify contacts that have multiple / duplicate companies associated! (The Hubspot feature that automatically associates contacts to companies based on domain OR creates a new company, while useful, is the culprit of generating many a duplicate company which are very hard to identify in bulk. As of now, team has to flag when these occur for admin to merge)

MDUPRAT
Participante

This is a feature very needed! I would like to automate the life cycle of my clients. This would be possible if a contact could only be associated with one company but this is not the case. I need to identify customers with multiple accounts open because otherwise I risk "closing" a contact who has an account closed but has other accounts still open!

JannieEngen
Colaborador(a)

Yes, this is needed!

MCarnes7
Membro

This is a very needed filter!!

ema_negrisan
Participante

We need this too.

jpeluso
Participante

This would be extremely helpful for data cleanup. You can kind of accomplish this by adding a contact > companies column in a contacts view, but you can't do anything further within Hubspot. Hope this gets added soon!

ReeaVainikainen
Participante | Parceiro Elite

Definitely an important feature for data management and quality monitoring!

CSteiling
Membro

Definitely a needed feature for data quality!

jtwen
HubSpot Employee

hey, sharing a propsoed workaround where we can create a calculated property to achieve our goal here: https://community.hubspot.com/t5/CRM/Contacts-with-multiple-companies/td-p/904247