How can I pull analytics data into a custom HubSpot report?

[GRice1]

Hi,

I want to pull some traffic analytics data from the Traffic Sources, specifically, I want to extract the New Visitor Sessions column total. I do not see an object that I can easily pull this data from. Ideally I want to be able to pull the circled value and I want to do a calculation using this number to calculate a marketing analytics metric/ This analytic lives in another report which contains data from the Deal objects, so I don't want the joining of these two objects to cause data to be lost. Any advice would be appreciated,  thanks.

[karstenkoehler · Accepted solution]

Hi @GRice1,

This exact data point, as highlighted in your screenshot, can, as far as I know, not be included in the custom report builder. It's not available there, unfortunately.

Best regards!

[GRice1]

I see, thank you.

[mabubilal · Accepted solution]

You're right; HubSpot’s custom report builder doesn’t directly include certain traffic analytics metrics like New Visitor Sessions. One workaround is to export this data from the Traffic Analytics tool into a CSV, then use that data to perform your calculations in an external tool, like Excel or Google Sheets. From there, you can blend it with your Deal object data manually.

[karstenkoehler · Accepted solution]

Hi @GRice1,

This exact data point, as highlighted in your screenshot, can, as far as I know, not be included in the custom report builder. It's not available there, unfortunately.

Best regards!