By Taylor Mcgrath

Google Analytics to BigQuery

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.

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 Template has 1 variable that is used to make for dynamic use of target configuration. 1 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.

Minimize the firefighting.
Maximize ROI on pipelines.

icon icon