Integrating google analytics to snowflake


(Nir Yalin) #1

I would like to create a standard dashboard of data from Google analytics on my company’s Website and Blog. In order to create the dashboard i need to extract the data from GA to our Snowflake DB. Does anyone a schema of GA that will help me figuring out what data to extract and how to model it?

Thanks,
Nir


(Izzy) #2

My 2 cents: We’ve got a pre-built google analytics block by Firebase, and a GA360 one made by Google.

https://looker.com/platform/blocks/source/google-analytics-for-firebase-by-google and https://looker.com/platform/blocks/source/google-analytics-premium-360-by-google respectively.

Those should at the very least give you an idea of the right direction, and might be almost plug and play!