By Alex Rolnik

Google Analytics - Databricks

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. 

This Kit includes…

  • 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

Configuring this Kit for use

Variables

In this Kit, there are two variables that are used to make for dynamic use of target configuration. 

  • {Database_GA} is used in all Target configurations and queries as the target database name.
  • {GA_Failure_Group} is used as the alert email address(es) for when a river fails (optional).

Go to the Variables menu on the left side navigation bar and create variables for Database_GA and GA_Failure_Group. Then fill in the values as the Databricks database where you would like the data to land and the email address(es) to which you would like the failure emails sent.

Connections

Kits are imported with ‘blank’ source and target connections. In order to use the kit, you have two options:

  • Swap out blank connections with existing connections
  • Add credentials to the blank connections that come with the imported Kit

Have questions about this Kit?

Set up a meeting with a Rivery solutions engineer.

Time to Ride the River

Rivery is free to try - no credit card required.