Google Analytics to Snowflake
The Google Analytics template uses the Standard Google Analytics Report and breaks this out into 4 reports for data by Users, Pages, Events, and Sessions. This enables the user to have easy access to digestible information within Google Analytics. 2 Targets currently exist for this report (Snowflake, Google BigQuery).
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
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.
