Form Views/Submissions and Snowflake Data Share integration

Marketing & Content Hub Reporting & Analytics
1

Hi,

I am trying to access form views and submission data in Snowflake, using Hubspot’s Snowflake Data Share integration. I am able to get the count of form submissions by month from the form_submission table, but am unable to figure out how to get form views by month. I see that form views are available in total for each form on the forms table, but how do you get the counts by month?

In the Hubspot User Interface reporting module, it is very easy to build a report that shows views and submissions together by month.

Thanks for any help!

2

Hello @ACarr4 thank you for posting in our Community!

I want to share this knowledge base here with more details and invite our top experts to share their thoughts @himanshurauthan @LMeert @thesnappingdog any recommendations to @ACarr4 matter?

Thank you,

Pam

3

Thank you @PamCotton , and I welcome any help, as I am still stuck on this. I cannot seem to find any time-series data that allow me to get form views by month in the snowflake schema that Hubspot builds.