Google Analytics - Snowflake
The Google Analytics Kit uses the Standard Google Analytics Report and breaks this out into four reports for data by Users, Pages, Events, and Sessions. This enables the user to have easy access to digestible information within Google Analytics.
Contents:
- Data ingestion rivers for Users (additional Rivers for weekly and monthly views), Pages, Events, and Sessions
- Master orchestration River
You can find the full contents, data model documentation, and source fields used here. Output Table Names:
- GA_USERS
- GA_PAGES
- GA_EVENTS
- GA_SESSIONS
Minimum RPU Consumption: 7
Parameterization
For Snowflake this Template has 2 variables that are used to make for dynamic use of target configurations. 1 variable for Email Notifications. {ga_db} is used in all Target configurations and queries as the target database. {ga_schema} is used in all Target configurations and queries as the target schema. {Mail_Alert_Group_GA} for Schedule Email Notifications.


Easily Solve Your Most Complex Data Challenges
No Credit Card Required.