Export Parent Company Name

Rachel_KL

I created a report showing a list of companies that have an associated parent company.  The report shows exactly what I want.  The issue is when I export that report data.  Rather than getting the parent company name, I get the parent company ID.  A random numeric value is totally useless.  I want/need the actual parent company name.  There must be some way on the back end to do a lookup and pass through the company name after looking up the company ID.  Please fix this!!

4 Replies
romi
Contributor | Elite Partner

We use this HubSpot Google Sheets integration to automatically sync the company data to a Google Sheet.

We then use the Google Sheet Import Range function to import this data into another sheet which we can add functions to.

We then do a lookup on this sheet using the Parent ID against the Company ID to add the Parent Company Name as a Column which can then be used in other reports, etc. 

Hamo77
Member

I concur with this! It must be a very simply enhancement to allow for the export of the parent organisation name next to the parent company ID. Please can this be added to the functionality Hubspot?

DTack
Participant

Agree - facing the same issue!!

 

I'm trying to report on the number of deals each of my child companies has within a parent. In an ideal world I would like to see:

Parent company/Child company names/number of deals under parent umbrella

 

I'm on the free version of Hubspot (for the short term) so I can't build custom reports. In the interim I have created a list which shows the child company/parent company/number of deals under child company. I now want to export the list and sort by parent company so that I have the original view I need (how many deals under a parent with the child orgs listed). My issue now is that when I export the list, the parent company names dissapear and are replaced with unique idenitifier numbers?? Anyone know how to fix this??

 
 
 
 
 

For us, we have a complex market as we sell to the NHS landscape. In this matrix you have an Integrated Care System (this would be the 'parent' company although that isn't strictly true) and then horizontally you will have several hospital trusts and local authorities ('child' organisations). Each of the parents are assigned to a senior member of the team but the children could be assigned to any other member of the team. On a weekly basis I need to pull a list of all of the deals we have in the pipeline to include the parent and the child. This allows me to see where we are really engaging with a parent and also where we may be engaging with a parent but no children. I present this to the senior leadership team and sort by Parent.

Currently, I am pulling the list of opportunities (I can see the parent on my screen but can't sort by parent) but when I export I can only see the unique identifier number for the parent. This means I have to go back and manually note the Parent.

If Hubspot wants to be a CRM of choice for organsiations such as consultancies (not just transactional businesses) we need this functionality!

Thanks

  •  
UrbanPoint
Contributor

This actually used to work until a few weeks ago, where the PARENT company name, was showing in the Associated Companies column in the export. This dissapeared recently and when I contacted HS, they say apparently it was a bug (where PARENT company was showing in the Associated Company) so now is fixed. This does now seem like a bug to me; and now I ahve to play around with sheets and formulas, when the information is already there.

 

HS IT team, please fix this so we can actually make use of the exported data without having to resort to other programmes.