Connect Google Analytics Warehoused

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 our existing Google Analytics integration. It will allow for better analysis due to having the Google Analytics data in your Data Warehouse, which is different than the live feed of the existing Google Analytics integration. Analyzing these metrics in MBI, alongside other pieces of data, will improve 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.

Let us 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, we can create a new 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 MBI 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 a Add Integration, located on the right side of the screen.
  3. Click the Google Analytics Warehoused icon. This will open the Google Analytics credentials page.
  4. Enter your Google Analytics credentials. Upon completion of the authorization process, you will be redirected back to MBI.
  5. A list of profile IDs will display. Check the profiles you want to connect to MBI. 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 will have the option of including all your profile IDs in MBI. Just 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 8 numbers following p at the end of the line

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

Disconnecting Google Analytics Warehoused from MBI

  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 MBI.

On this page