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.
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.
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.
