Expected Google Analytics Warehoused Data

Last update: 2023-07-25
  • Created for:
  • Beginner
    Intermediate
    Admin
    Developer
    User
NOTE

Requires Admin permissions.

NOTE

Some information was used with permission from your friends at Stitch.

Google Analytics Warehoused integration in Commerce Intelligence uses the Google Analytics Core Reporting API.

NOTE

To avoid unexpected or nonsensical results, confirm that any dimensions you use are compatible with one or more metrics you use in the Report Builder.

A single table - called report - is created in your Data Warehouse.

The schema of this table is composed of the Metrics and Dimensions that you selected during the setup process and two other columns: start-date and end-date.

If for example, you selected the following Metrics and Dimensions during setup:

  • Metrics: ga:users
  • Dimensions: ga:month

The table would look like the example below.

Column Name Description
\_id This column is the primary key.
\_rjm\_record\_hash Commerce Intelligence unique identifier. This column is created by Commerce Intelligence.
\_updated\_at This column contains the last time that the data row was updated. This column is created by Commerce Intelligence.
start-date Identification of what day the row is for.
end-date Identification of what day the row is for.
month Selected dimension: Month of the session, a two-digit integer from 01 to 12.
users Selected metric: The total number of users for the requested time period.

What’s the difference between Google Analytics Warehoused and Live Integration

The main differentiator is that one integration is stored (Google Analytics Warehoused), and the other is not (Google Analytics Live). In cases of Google Analytics Warehoused, this allows for manipulation of your Google Analytics data and gives you the ability to combine Google Analytics and other data sources to create insightful reporting.

Look at Google Analytics ad campaigns for an example of what can be done from a manipulation standpoint. Suppose you had multiple ad campaigns for Q4 with different names. The campaigns were a result of a specific marketing initiative. With warehoused data, you can create a column that finds the campaign names in question and returns the Q4 initiative name of Operation Dumbo.

The combination aspect allows Google Analytics data to be joined to other data in order to conduct analyses. For example, take Total Time On Site By Ad Campaign data from Google Analytics and join it up against Total Spent Per Campaign data from Facebook Ads to get a complete picture of how much engagement is costing you.

With the Google Analytics Live integration on the other hand, every Google Analytics chart is like a little silo that is not stored in your Commerce Intelligence Data Warehouse.

Related:

On this page