topic Re: HubSpot-Snowflake Data Share in Dashboards & Reporting

HubSpot-Snowflake Data Share

AbyJacob — Wed, 18 Oct 2023 12:59:44 GMT

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,

Re: HubSpot-Snowflake Data Share

Shadab_Khan — Tue, 17 Oct 2023 05:12:10 GMT

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 🔥

Re: HubSpot-Snowflake Data Share

AbyJacob — Tue, 17 Oct 2023 13:01:50 GMT

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-tool

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

Re: HubSpot-Snowflake Data Share

Shadab_Khan — Tue, 17 Oct 2023 13:10:01 GMT

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.

Re: HubSpot-Snowflake Data Share

AbyJacob — Tue, 17 Oct 2023 14:26:49 GMT

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.