Sep 17, 2020 11:21 AM
I am having difficulty finding the page session duration for anyone other than prospects.
My end goal would be to have a report that could display the session count (y axis bar) and session durations (y axis line) by company (x axis) for a set time period. Is something like this currently possible? I'm very new to Hubspot and may be overlooking this or mis-understanding how the session durations are saved. Any help here would be fantastic.
Sep 17, 2020 11:47 AM
@WJordan you can use a free app called Ultimate Data Export for HubSpot to retrieve the information you are looking for. UDE exports all of your HubSpot CRM data into an Excel spreadsheet, including raw web events. You can use the functions of Excel to do the analysis.
Jul 8, 2022 11:22 AM
I recently tested out the Ultimate Data Export you recommended for this, but this does not seem to capture information on the web session duration. I can view number of sessions for each contact, but not the duration itself. I presume that this is because the data is not stored in the regular Hubspot tables but wanted to double check if I was missing something?
Sep 18, 2020 12:53 PM
Thanks John, I've attempted this and the site currently shows "out of stock" for the mentioned service.
Can the Power.Bi connector also provide the raw web event data?
Sep 18, 2020 3:20 PM
@WJordan Our apps undergo periodic maintenance. During that time, the store shows them as out of stock. Sorry for the inconvenience, but we don't want anyone to subscribe while we are applying updates. Just check back in a few hours or a day.
Yes, our Power BI connector also provides the raw web events data. So does our Tableau connector and our Excel connector. Those are paid services that automatically update on a scheduled basis. Ultimate Data Export for HubSpot is a free export to Excel.