DocumentationCommerceCommerce Intelligence User Guide

Connect Google Analytics Warehoused

Last update: Tue Jul 25 2023 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • Beginner
  • Intermediate
  • Admin
  • Developer
  • User
NOTE
Requires Admin permissions.

Google Analytics is the most widely used web analytics service on the internet. Implementing Google Analytics on your website allows you to track how visitors use your site, what content is attractive, where visitors exit, and more. Google Analytics Warehoused is a separate integration from your existing Google Analytics integration. It allows for better analysis due to having the Google Analytics data in your Data Warehouse, which is different from the live feed of the existing Google Analytics integration. Analyzing these metrics in Commerce Intelligence, alongside other pieces of data, improves your site’s overall health and usability.

Difference between GA 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 the case 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 fourth quarter 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 fourth quarter 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 Data Warehouse.

Connecting Google Analytics Warehoused

INFO
Google Analytics Warehoused is a Premium Integration. Contact support if you have an interest in adding this integration to your subscription.
  1. Go to the Connections page under Admin > Integrations.
  2. Click Add an Integration, located on the right side.
  3. Click the Google Analytics Warehoused icon. This opens the Google Analytics credentials page.
  4. Enter your Google Analytics credentials. Upon completion of the authorization process, you are redirected back to Commerce Intelligence.
  5. A list of profile IDs display. Check the profiles that you want to connect to Commerce Intelligence. If you have multiple profiles and need some help identifying which is which, refer to the Connecting Multiple Google Analytics profiles section below.

Connecting multiple Google Analytics profiles

You may have multiple websites connected to a single Google Analytics account, identified by their own Google Analytics profile ID. In this case, you have the option of including all your profile IDs in Commerce Intelligence. Check the profile IDs you would like to include during the profile selection step.

To identify a particular website’s Google Analytics Profile ID:

  1. Log into Google Analytics

  2. Go to the particular website’s Google Analytics dashboard

  3. Look at the URL - the Profile ID corresponds to the eight numbers following p at the end of the line

    www.google.com/analytics/web/#home/a11345062w43527078p**XXXXXXXX**/

Disconnecting Google Analytics Warehoused from Commerce Intelligence disconnect

  1. Visit your Google Analytics account settings page.
  2. Under the Security section, and click edit next to Authorizing applications and sites.
  3. Click revoke access next to Commerce Intelligence.
recommendation-more-help
e1f8a7e8-8cc7-4c99-9697-b1daa1d66dbc