Skip to main content

Peliqan

HubSpot Analytics

Sessions by date

SQL query for HubSpot Analytics

Get the total number of visitor sessions per day.

SELECT date, SUM(sessions) as total_sessions FROM visitor_sessions_daily GROUP BY date

HubSpot Analytics data model

HubSpot Analytics
Pages Daily

HubSpot Analytics
Sources Daily

HubSpot Analytics
Sessions Daily

Ready to get instant access to all your company data ?​

Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.