topic Re: Reports exported only have IDs in Dashboards & Reporting

Reports exported only have IDs

peterfilias — Thu, 20 Dec 2018 17:56:21 GMT

I am trying to export some reports I've made but when they get exported, they are only showing company ID and deal ID, not the Company Name or Deal Name.

What am I missing here?

Re: Reports exported only have IDs

jennysowyrda — Fri, 04 Jan 2019 21:38:12 GMT

Hi @peterfilias,

Are you still experiencing this issue? If so can you please include screenshots of what you are seeing and outline how you are getting to the export screen?

The more information, screenshots and details you can provide, the better the Community can assist!

Thank you,
Jenny

Re: Reports exported only have IDs

peterfilias — Mon, 07 Jan 2019 15:20:43 GMT

It appears that this issue didn't occur for me again. We can mark it as solved. I'm just curious as to why I had that behavior in the first place. Was it just a temporary glitch/outage on the company name lookup?

Re: Reports exported only have IDs

peterfilias — Mon, 07 Jan 2019 16:21:48 GMT

As a matter of fact, I am still experiencing this issue!

The solution I thought was acceptable actually wasn't. From the Companies list, I figured out to just select with my mouse and paste into a spreadsheet.

For the actual reports I'm trying to make, not a Company List, they come out with only IDs.

While the visualizer shows the company name, it only exports out IDs.

In a report I'm trying to work with for deals closed in 2018, the visualizer shows the deal name and the company name. When I export to CSV, it shows up like this.

Re: Reports exported only have IDs

jennysowyrda — Tue, 08 Jan 2019 21:13:44 GMT

Hi @peterfilias,

It looks like you have a subscription that includes HubSpot Technical Support. The best next step in regards to getting this sorted as quickly as possible will be to connect with Support so that they can assist you directly.

Thank you,
Jenny

Re: Reports exported only have IDs

Tommy2856 — Thu, 14 Oct 2021 10:59:39 GMT

Hi @peterfilias,

Did you eventually find a solution? Experiencing the same issue as we speak!

Thanks a bunch,

Re: Reports exported only have IDs

MiaSrebrnjak — Thu, 14 Oct 2021 15:04:26 GMT

Hi @Tommy2856,

This is Mia from the Community team! Are you exporting a Deal view via the option Board actions? Please try changing the type of your export file to CSV, the name of the Deal should be inlcuded. I hope this helps!

Cheers
Mia, Community Team

Re: Reports exported only have IDs

Tommy2856 — Thu, 14 Oct 2021 15:43:03 GMT

Hi Mia,

I’ve opened a ticket with Support, so all good from here 😊 Thanks for your quick assistance though!

Kind regards,

Thomas

Re: Reports exported only have IDs

MiaSrebrnjak — Fri, 15 Oct 2021 09:08:53 GMT

Oh, got it! Thank you for the udpate @Tommy2856!

Kind regards,

Mia

Re: Reports exported only have IDs

JMulchrone7 — Tue, 10 Jan 2023 11:05:55 GMT

Nope not a temp issue. It is now 2023 and I am having the same thing. Trying to pull a list of contacts to cross reference against salesforce and just getting ID's which is of no use whatsoever. Also had this pulling anything that is a time or date property, you just get a load of random numbers that are useless.

Re: Reports exported only have IDs

SimonDEBRITO — Thu, 06 Apr 2023 08:49:23 GMT

Hello,

In custom reports, you need to drag the property you want to see in your report into the "Fields" section. Simply drag & drop your "customer name" and "deal name" property here and it should work:

Re: Reports exported only have IDs

kvlschaefer — Mon, 10 Apr 2023 09:26:27 GMT

Hi @SimonDEBRITO,

Thanks for sharing!

Best,

Kristen

Re: Reports exported only have IDs

jphilbrook — Fri, 12 May 2023 13:28:04 GMT

I have the exact same issue in the custom report builder. I tried exporting as .csv and .xls - the deal name shows as the deal id. Really annoying.

Re: Reports exported only have IDs

hubhuman70 — Sat, 09 Sep 2023 01:26:17 GMT

Me too. Hubspot please fix this. It's been five years now.