By Taylor Mcgrath

Google Analytics - Snowflake

Integrates with:

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.

Time to Ride the River

Rivery is free to try - no credit card required.