About Data Import
Get a unified view of your data
Data Import lets you upload data from external sources and combine it with data you collect via Google Analytics. You can then use Google Analytics to organize and analyze all of your data in ways that better reflect your business.In this article:
Why use Data Import?
If you use a variety of systems and tools to run your business, you can use Google Analytics to join and analyze that data in one place. For example, you can turn separate CRM data, ecommerce data, and Analytics data into a single data set that provides a comprehensive view of your business.
Each business system you use generates its own data store. Your CRM might contain information like customer-loyalty rating, lifetime value and product preferences. If you are a web publisher, your content management tool probably stores data dimensions such as author and article category. If you are an ecommerce business, you might create catalogs that describe your products according to prices, style, size, etc. And (since you're reading this), you most likely use Google Analytics to track traffic and performance for your websites, mobile apps or appliances. Typically, this data exists in its own "information silo," unaffected and uninformed by the data in other silos.
Data Import lets you join the data generated by your offline business systems with the online data collected by Google Analytics. This can help you organize, analyze and act upon this unified data view in ways that are better aligned with your specific and unique business needs. For example, as a web publisher, you could join hits collected by Google Analytics with data dimensions exported from your CMS and CRM systems to analyze the relative contributions of authors to your site.
Types of data you can import
Data Import lets you upload and integrate information with your Analytics account at 3 different points in the data collection and processing chain.
Hit data import
Hit Data import lets you sending hit data directly into Google Analytics. This provides an alternative to using the tracking code, mobile SDKs, or Measurement Protocol. Imported hits are added to your Google Analytics account prior to any processing; therefore, your imported data may be affected by processing-time actions, such as filters.
This type of import supports uploading the following types of data:
- Refund Data—align your internal ecommerce reporting with Google Analytics by importing ecommerce refund data.
Extended data import
Extended data import adds to (extends) the data already collected and processed, or being processed, by Google Analytics. Typically, this extended data is stored in a custom dimension or metric, though in some cases you might want to overwrite the default information already gathered (for example, importing a campaign's Source or Medium dimension).
You can upload the following data types:
- User Data—create segments and remarketing lists that incorporate imported user metadata, such as a loyalty rating or lifetime customer value.
- Campaign Data—expand and reuse your existing non-Google campaign codes by importing ad campaign-related dimensions, such as source.
- Geographical Data—create custom geographical regions, allowing you to report on and analyze Google Analytics data in ways that are better aligned with your business' organization.
- Content Data—group content using imported content metadata, such as author, date published, and article category.
- Product Data—gain better merchandising insights by importing product metadata, such as size, color, style, or other product-related dimensions.
- Custom Data—provides support for importing custom data sets.
Summary data import
Summary data lets you sum uploaded metrics. Imported summary data is applied after all processing and aggregation of collected data. This can be useful when you receive data in batches some time following hit collection, as summary data import lets you add to or update your information as it becomes available.
Currently, summary data import supports the following import type:
- Cost Data—include 3rd party (non-Google) ad network clicks, cost and impression data to gain a more complete picture of your ad spend.
Access Data Import
To access Data Import, sign in to your Google Analytics account, then:
- Click Admin in the menu bar at the top of any page.
- In the ACCOUNT column, select the Analytics account that contains the property to which you want to upload the data.
- In the PROPERTY column, select the property that contains the Data Set that will hold your data.
- Click Data Import. This displays the Data Sets page.
How Data Import works
Data Import works by uploading text files containing external data to a Google Analytics Property. This information is typically exported from an offline business tool (for example, your CRM or CMS system). For smaller amounts of data, you might create the upload file manually, using a text editor or spreadsheet.
Data Import joins the offline data you've uploaded with the default hit data being collected by Google Analytics from your websites, mobile apps or other devices. Imported data can be used to enhance your reports, segments and remarketing audiences in ways that reflect your own business needs and organization. The result is a much fuller, more complete picture of your users' on- and offline activity.
How you upload data
You can upload data by one of two methods:
- From the Google Analytics user interface, using the Admin > (Property) > Data Import option
- Using the Google Analytics Management API
How Data Import joins on- and offline data
When you configure Data Import, you create a Data Set, which defines one or more dimensions to use as a key. Data Import uses this key to match values in the uploaded data to values in your collected hit data. The rest of your imported data you upload is stored in the dimensions or metrics you define in the Data Set. Imported data can use either default or custom dimensions and metrics. Imported data can be used in reports, remarketing audiences and other Google Analytics tools alongside standard data collected by the website tracking code, mobile SDK or Measurement Protocol.