Live Sessions Data Source - HubSpot API calls

[MSerra6]

Hi All,

I am trying to build an API to pull session information out of HubSpot into a google sheet to create a live sessions data source for a looker dashbaord. As of now, I am only able to create an API that pulls one dimension, either Session Source or Session geolocation. When I messaged HubSpot support for suggestions on getting these two dimensions in one data source through an API, I was advised to create custom analytics views. I was going to create custom analytics views for each type of session source and then pull a geolocation sessions call with a filterId for each of the custom analytics view. This solution would have worked for me, but then I ran into the issue that custom analytics views only show data from the creation date of the view forward. I need this solution to work for pulling historical data, at least back to 2022. 

Does anyone have a solution for this, using APIs or otherwise? I am willing to explore other options. 

Thank you!

[kennedyp]

Hi @MSerra6! Welcome to the Community-- happy to have you here 😊

Thanks for utilizing support -- let's tag in some of our community members to see if we can get some more advice. 

Hey @zach_threadint, @Phil_Vallender, @cameroncollecti do y'all have any suggestions or experience to share here? 

Best,

Kennedy