Google Analytics Data Import: 17 Ways To Revolutionize Your Reports

January 13, 2015 | Dorcas Alexander

blog-data-import

Have you ever looked at the available dimensions and metrics in your Google Analytics reports and wished you could make up your own? You may have data about products, content, or users that isn’t part of any tracked session, which could bring new insight to your reporting and analysis of those sessions.

With Google Analytics Data Import, you can unify your online and offline data and revolutionize your reports.

For a while, data import was used only for uploading cost data — for costs associated with non-Google advertising — but now you can use it for much more. Data import is for you whether you track transactions, or prospects, or readers, or campaigns, or just about anything you can name.

There are two important considerations, before you begin. First, you must use Universal Analytics, which gives you 20 slots for custom dimensions and another 20 for custom metrics (200 each if you have Premium).

The other main consideration, as you start to create your wish list of custom dimensions and metrics, is what existing dimension will be used to join each imported dimension. Think of the existing dimension as the key.

For example, the key for a product-scoped custom dimension could be the product SKU or other unique identifier. The key for a hit-scoped custom dimension could be the page URL. And the key for a user-scoped custom dimension would most likely be that user’s ID number (not personally identifiable except in your own database, of course).

Do you track transactions?

warehouse-small

Your product database has all kinds of information you can add to session data for deeper analysis of your user’s online transactions. You only get a few slots in the transaction hit such as product category, brand, and variation, along with the name, SKU, unit price, and quantity. With data import you can add product-scoped custom dimensions like these, among others:

1. Product cost, margin, or profit
2. Product weight, or other physical information about a product
3. Marketing information like the product’s intended audience or specific promotions

What can you learn about customer behavior? Add user-scoped dimensions with customer information, for example:

4. Customer lifetime value, number of purchases
5. Cohort information, e.g. first purchase, most recent purchase
6. Types of preferred products

In extreme circumstances, hits too large may be rejected by Google, such as transactions with many different products. In those cases, Google recommends that you send only the minimum transaction data and instead use the product SKU to unify the descriptive product information via Data Import.

Remember that data import does not unify data retroactively, but only from the point of upload and going forward. You need to upload product data regularly, possibly daily, in order to associate the most up-to-date product info as each transaction is tracked and processed.

Do you track prospects?

After users submit your online lead forms, the sales team follows up to describe and qualify each prospect. If a prospect logs in again, you could attach user-scoped custom dimensions with data import of:

7. Prospect qualification codes, e.g. what stage of follow-up
8. Areas of interest, e.g. products or services desired
9. Demographic information
10. Potential value of the lead

This type of data can be invaluable if the sales cycle occurs online over an extended period of time, and involves more than one interaction with your digital presence. How well does your site or app work to close the sale?

Any type of user-scoped data import requires a way to identify the same user, typically by requiring them to log in, but you can also identify unique users with a method similar to email tracking by my colleague Jim Gianoglio.

Do you track readers?

Digital content offers many ways to reimagine your reporting and analysis. You probably have some data already available on the page, such as the author or publication date, which can be fed to custom dimensions with Universal tracking code.

comments-small

On the other hand, data import lets you mine your CMS for a wealth of information for page-scoped dimensions like:

11. Topics or taxonomy used to tag content
12. Metadata such as number of words, number of images or videos, number of comments
13. Other internal content classifications, e.g. style or intended audience

And if your readers need to log in, then consider user-scoped dimensions, including:

14. Cohort info based on subscription or registration date
15. Activity level, e.g. most recent session, number of articles viewed, number of comments
16. Favorite topics either from expressed interest or inferred from browsing behavior

Want to see how the length of an article affects its popularity? Want to compare articles written for a given audience? What brings daily readers back time and again? Use data import to add the dimensions you need.

Do you track campaigns?

You can also use data import to add session-scoped custom dimensions to your reports. Suppose you have unique campaign codes instead of utm parameters on your campaign URLs, and each code maps to data that may or may not resemble GA’s medium, source, and campaign name.

Now you can skip trying to align your campaign tracking with Google’s, and go straight to data import instead. For each campaign code, upload as many custom dimensions as you need for:

17. All the descriptive labels in your existing campaign tracking system

You can use the new custom dimensions as secondary dimensions in GA’s standard reports, alongside medium or source or campaign, etc. You can also view custom dimensions and metrics by creating custom reports, including flat tables with up to four dimensions side by side.

What custom dimensions and metrics would revolutionize the way you report and analyze data? Have you tried this feature and, if so, did you import something not mentioned here? If you haven’t tried it yet, why not? Please share in the comments.