Skip to main content

Peliqan

Try for free
Request a demo

HubSpot Analytics

Top Traffic Sources

SQL query for HubSpot Analytics

Identify the top traffic sources based on the number of visitors.

SELECT traffic_source, COUNT(DISTINCT visitor_id) AS total_visitors FROM traffic_daily GROUP BY traffic_source ORDER BY total_visitors DESC LIMIT 5

Try this query now in HubSpot Analytics

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.

  • 14-day free trial
  • No credit card needed