CRM

LChen5
Member

Export contacts with information about non-Primary associated companies

SOLVE

I need to export all contacts who are associated with more than 1 company in Hubspot, and also be able to export company-level information (in this case, Company ID) for all of the non-primary companies associated with that contact.

 

Is there a way to build a report to do this? I know that I can build a report that shows all Contacts with a count of how many companies they're associated with, but I can't figure out a way to also pull in data from the company-level into the report when it's multiple companies. 

0 Upvotes
1 Accepted solution
LouiseHare
Solution
Top Contributor | Partner
Top Contributor | Partner

Export contacts with information about non-Primary associated companies

SOLVE

Hey @LChen5 ,

 

If you just need the Company ID then you should be able to do this with a simple export from the Contact record screen. 

 

First go to 'Edit Columns' on the Contacts screen

Screenshot 2024-04-23 at 12.52.27.png

 

Under Associations, you will see the option to add a column for Companies, and also a column for Companies by each association label that you have in HubSpot (the only association label in this particular account is Primary)

 

Screenshot 2024-04-23 at 12.53.43.png

 

When you've added the columns (presumably all the Company associations besides Primary), you then just want to export the view

 

Screenshot 2024-04-23 at 12.56.40.png

 

The export will contain the Company names and Record ID for each column/association label.

 

Hope this helps,

Untitled design (5).png

Louise Hare she/her

Freelance HubSpot Expert

Book a Consultation

 

If my reply helped to answer your question please mark it as a solution to make it

easier for others to find! 

View solution in original post

3 Replies 3
LouiseHare
Solution
Top Contributor | Partner
Top Contributor | Partner

Export contacts with information about non-Primary associated companies

SOLVE

Hey @LChen5 ,

 

If you just need the Company ID then you should be able to do this with a simple export from the Contact record screen. 

 

First go to 'Edit Columns' on the Contacts screen

Screenshot 2024-04-23 at 12.52.27.png

 

Under Associations, you will see the option to add a column for Companies, and also a column for Companies by each association label that you have in HubSpot (the only association label in this particular account is Primary)

 

Screenshot 2024-04-23 at 12.53.43.png

 

When you've added the columns (presumably all the Company associations besides Primary), you then just want to export the view

 

Screenshot 2024-04-23 at 12.56.40.png

 

The export will contain the Company names and Record ID for each column/association label.

 

Hope this helps,

Untitled design (5).png

Louise Hare she/her

Freelance HubSpot Expert

Book a Consultation

 

If my reply helped to answer your question please mark it as a solution to make it

easier for others to find! 

DianaGomez
Community Manager
Community Manager

Export contacts with information about non-Primary associated companies

SOLVE

Hi @LChen5

 

Thanks for reaching out to the Community!

 

We currently do not have a 'number of associated companies' property for contacts to create a list or a report to display this information, and this has been requested by users here. To contribute, upvote the existing idea and share more details about your specific use case in the comments. I've given it an upvote as well for it to gain more traction so that our Product Team is made aware!

 

However, I did come across a user who worked around this using her own method: Pulling a report that shows all contacts with primary and secondary company associated.

 

Hope this helps,

Diana


¿Sabías que la Comunidad está disponible en Español?
¡Participa hoy en conversaciones en el idioma de tu preferencia,cambiando el idioma en tus configuraciones!

Did you know that the Community is available in other languages?
Join regional conversations by changing your language settings !


0 Upvotes
MHolzer
Contributor

Export contacts with information about non-Primary associated companies

SOLVE

If you have the right sub you can just create a calculation property: "number of associated companies" and then filter for this.
@LChen5 

0 Upvotes