HubSpot-Snowflake Data Share

[AbyJacob]

Hi,

We are bringing the hubSpot data to SnowFlake using data share. Where do i find the Traffic Analytics data? I can see traffic analytics along with sessions analytics in HubSpot, but cannot find the same data in SnowFlake. Please help.

Thanks,

AB

[Shadab_Khan]

Hi @AbyJacob ,

Looks like you need to use SITE_PAGE &/OR Event Type: EVENTS_VISITED_PAGE

Full Details are shared on Knowledge Doc

Stay Awesome & Keep Doing it BIG 🔥 

[AbyJacob]

Hey @Shadab_Khan ,

Thanks for the reply. I'm actually trying to replicate the reports in this "Traffic Analytics" dashboard within HubSpot in Snowflake. 

https://knowledge.hubspot.com/reports/understand-hubspots-traffic-sources-in-the-traffic-analytics-t...

Do you think the same can be achieved using SITE_PAGE or EVENTS_VISITED_PAGE?

[Shadab_Khan]

I cannot say for sure(dont have active snowflake account on me), try doing it and then see if the data gets a tally or no.

[AbyJacob]

Thanks, @Shadab_Khan 

Looks like those tables provide info about the individual pages on the website. I'm trying to see if there's an easy way to replicate the analytics provided at the HubSpot side.  I'd think HubSpot has information like below stored in some tables, trying to identofy those tables.