How to Import External Data into Google AnalyticsPosted on 11 Mar by

How to Import External Data into Google Analytics

Data import is a feature in Google Analytics that helps us combine Google Analytics data with the externally uploaded data to help organize and analyze our data in a better way. If you use a variety of systems and tools to run and manage your business and would like to combine your external data such as CRM, e-commerce or content publishing data with your Google Analytics data, then data import is your best bet. Google analytics data import feature will help you import all sought of external data into Google Analytics Platform.

Importing External Data into Google Analytics Tutorial:

Create Custom Dimension in Google Analytics

As we are adding data to Google Analytics, we need to find a place where we can store this external data. Creating custom dimension helps us solve this issue (we can also use custom metrics for this purpose).So before importing data, we need to create a custom dimension in Google Analytics.

For creating custom dimension, first go to admin settings and click custom definitions at the bottom and select custom dimensions

 

 importing external data to google analytics - google analytics custom dimension
 

After clicking the +New Custom Dimension button, you need to give a name to the custom dimension and specify its scope.The Scope defines to which data your dimension will be applicable. The dimension scope can be for hit, user, session or product.

 

google analytics data import - custom dimension name in google analytics
  After creating custom dimension, you can start creating your data set in google analytics 

Creating Data Set in Google Analytics

A Data Set is a container that holds the data you upload to Google Analytics. For creating a data set, go to admin section in Google Analytics, select data import at the bottom of Google Analytics and click + New Data Set.

 

How to import external data into google analytics - data set in google analytics
 

 

How to import external data into google analytics - data set types in google analytics
 

 

google analytics data import - data set details into google analytics
 

  Define Data Set Schema

 In the next step, you need to set the data set schema. Through schema, you define the data you want to join on key and the data you will import to google analytics. In this step, you need to select your key, which is usually the data i.e. common to both Google Analytics and in the uploaded data. The key can be any of the standard dimension according to your chosen data type or any custom dimension. In this step, along with key, you need to select the dimension or metrics that you are going to include in your importing CSV file. It can be any of your created custom dimension or any of existing standard dimension.

 

how to import external data to google analytics - data set schema
 

For example, if you are uploading content publishing information, then you might define your schema as shown in the below given screenshot:

 

importing external data to google analytics - key and imported data

You also have the option to overwrite your uploaded data over Google Analytics hit data. If you choose the yes option, your imported data will overwrite Google analytics data and if you select No, hit data will overwrite your Google analytics data when both Google analytics and hit data are available and then click save

 

google analytics data import - overwrite data in google analytics

Create your CSV file

After defining schema, click the get schema button, here you can either copy and paste the dimensions as column headings in your external CSV file or directly download the schema template which will provide the CSV with the dimensions as column headings. After downloading the CSV, you just need to fill your external data and upload it into Google Analytics

 

how to import external data into google analytics - schema download

Upload the Data to Google Analytics

 There are two options to upload data to Google Analytics, you can either use Google Analytics Management API to upload data, or you can upload it manually. To simplify the process, let’s choose manual upload.

 

google analytics data import - manage uploads in google analytics

For uploading, you need to click manage uploads in the action section of your created data set and upload your CSV file containing external data. After uploading your CSV file, you view file upload details such as uploaded date of the CSV file, uploaded file name and its uploaded status.

 

Importing external data into google analytics - file upload in google analytics

View your Imported External Data in Google Analytics

After uploading, Google analytics will take few hours for updating your data with Google Analytics data. After this data update duration, you can view your uploaded data in your custom reports or custom dashboard since custom dimensions were used to store your data.

Though you will be able to import most of your external data into Google analytics, you need to know few of the conditions or limitations of this google analytics feature before importing your data:

  • Your data won’t be applied to historical analytics data. It will only be updated with your data moving forward.
  • You need to have edit permission at web property level to create and configure your custom dimensions and data import.
  • You cannot select the data type after creating a data set, so before creating a data set define your data measurement goals and create data set accordingly
  • If you would like to use custom dimension instead of standard dimensions, you need to have universal analytics instead of classical analytics since custom dimension only exists in universal analytics
If you want to know more about Google Analytics data optimization features or services, then please visit performance optimization Hope the above guide proved helpful in your data management process. Feel free to drop your comments or opinions in our comment section below.

This resource was published by
11 March 2016
  • Ranjit is a Digital Marketing Specialist at Webdura Technologies . He is Google Analytics, Google Adwords, and Hubspot Certified . He loves digital space and helps businesses increase their returns through digital strategies.

POST YOUR COMMENT

Leave a Reply

Your email address will not be published. Required fields are marked *