By Taylor Mcgrath

Google Analytics to Snowflake

Integrates with:

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.

Experience Rivery In Action

Control Your Data. Free Your Business.