By Taylor Mcgrath

Google Analytics to BigQuery

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

Parameterization

For BigQuery this Kit has one variable that is used to make for dynamic use of target configuration. One variable for Email Notifications.
{ga_dataset_id} is used in all Target configurations and queries as the target Dataset id.
{Mail_Alert_Group_GA} for Schedule Email Notifications.

Time to Ride the River

Rivery is free to try - no credit card required.