Top Pages by Views
SQL query for HubSpot Analytics
Get the top 10 pages by total views.
SELECT page_url, SUM(views) AS total_views FROM pages_daily GROUP BY page_url ORDER BY total_views DESC LIMIT 10
HubSpot Analytics data model
Pages Daily
Sources Daily
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.
- 14-day free trial
- No credit card needed