Google Analytics Custom Reports for Ecommerce

ECOMMERCE PURCHASES

Summarizing your most important money-makers (some code required)

Google Analytics custom reports offer us an advanced view of our marketing data. But limitations in the system means that custom reports are not always easy or intuitive to create.

Because of the way the data structure works in Google Analytics, the system has a habit of limiting our reporting options. It's not an “if you can dream it, you can do it” type of reporting system.

It's more of a “sometimes; you can get the system do work how you intend it” type of reporting system.

Creating a custom e-commerce report

In the post and video below we'll walk through how to build a custom report. Specifically, we'll look at custom Google Analytics e-commerce reports.

I'll explain how dimensions and metrics factor into custom reports, and we'll also look at how to work around some of the limitations of custom reports.

Then, we will use the Google Analytics Dimension and Metrics Explorer to help us solve a common e-commerce reporting problem.

Google Analytics custom reports for e-commerce

One of our Google Analytics Course students sent us a question about custom reports. He asked us to help him figure out how to put all his most important e-commerce data into one report.

Analytics Course Custom Report Question

What's the challenge we are facing? We need to develop a Google Analytics custom report that includes the following metrics and dimensions:

revenue, quantity of product, the product purchased, and ecommerce conversion rate.

Let's see if we can put together a report that includes all this information.

Google Analytics Custom Reports

To solve our problem, we need to start by looking at how Google Analytics custom reports work.

Custom reports exist to help you tie together two or more metrics and dimensions from the stock reports.

For example, let's say you want to merge traffic data, landing page info, and conversion rates. It's difficult to see all this data together in a standard Google Analytics report.

But, you can use a custom report to compare all this data in one report.

Here's my warning to you: Not everything you can dream is something you can do in custom reports.

Custom reports sound great, but they have many limitations. The limitations are the result of how Google Analytics collects data.

Data collection can happen at the hit level, the session level, or the user level.

Because each of these data points is tracked differently, they don't all work together.  This means that not every metric and dimension can be compared to each other.

But before we get ahead of ourselves, let's explain metrics and dimensions.

What are metrics and dimensions?

Dimensions

A dimension is a row of data in Google Analytics. The dimension is the label that you see on the left-hand side of your screen in your Google Analytics reports.

Dimensions = rows of data

Metrics

The metric is the column in your Google Analytics reports. Basically, metrics are the numbers that go into your reports.

Metrics = columns of data (aka the numbers)

Not all dimensions and metrics work together

Like we started to discuss earlier, not all metrics and dimensions work together.

Google states that you can only compare “Valid Combinations” of data. Valid Combinations: Not all dimensions and metrics can be queried together. Only certain dimensions and metrics can be used together to create valid combinations.

It’s easy to have problems finding “valid” combinations.  Our Analytics Course student Helgi ran into this very problem while trying to create his custom e-commerce report.

Customizing Google Analytics E-commerce Reports

Now that we understand the roadblocks we face let's get back to building our e-commerce report.

We'll use the Google Analytics Store Demo account to try to build our report.

As I add metrics to my custom report, my options become limited.

I can add product quantity and product revenue. But I can't add in the e-commerce conversion rate.

Google analytics custom reports for ecommerce

If  I remove the product dimension, I can add the e-commerce conversion rate to my report. But I can't put the product name and e-commerce conversion rate together in the same report.

Google Analytics custom reports for ecommerce

There is a reason these metrics and dimensions won't work together. A product is not a dimension that has an associated conversion rate.

Google Analytics measures conversion rates from a user perspective. So, the conversion is assigned to the user's session, not to a product they purchased.

Our limitation is that Google Analytics is not set up to view conversion rates from a product perspective.

What we need to know is how many users who viewed a specific product went on to buy that product.

Google Analytics Product performance report

Another solution we could try is the product performance report.

In the product performance report, we can see the shopping behavior of our visitors.

We can see revenue, price, and product quantity. We can also see how many people added a product to their cart. But we still don't have conversion rates in our report.

Google Analytics shopping performance report

Even If I try to add a secondary dimension, Google will not let me add in the e-commerce conversion rate.

Google Analytics landing page report

If I switch into the landing page report, I can see the conversions associated with my pages.

I can access the conversions and revenue at a page level. But, I still can't view the conversion rate.

Google Analytics landing page report

Advanced Segments

We can also try to solve our reporting problem using advanced segments.

Google Analytics will let me create a segment of users at a product level. Unfortunately, when I create a segment in the demo account, I get a false positive. Google gives me an over-inflated segment of users for the product I am analyzing.

Google Analytics advanced segments

Although I am not satisfied with this result, there is another problem with this approach. If we build a segment at the product level, we would have to do that for every product where we want to view a conversion rate.

For many e-commerce stores, this could be 100's to 1000's of products. So my conclusion is that creating our segment this way isn't a perfect solution.

The Google Analytics Dimensions and Metrics Explorer

What if we try to build our custom e-commerce report in the Google Analytics API?

We can use the Dimension and Metrics Explorer to tell us if we can build the custom report want to create.

The first step is to search the metrics and dimension we want to use in the Explorer.

As we ad metrics and dimensions to our list, the Explorer will gray out invalid combinations.

Google Analytics advanced segments

The Explorer shows us that we can create our custom report in the Google Analytics API.

All the metrics and dimensions we need, product, revenue, quantity, and e-commerce conversion are available in the API.

Conclusion: This is only available in the Google Analytics API

Building Google Analytics custom reports in the API

We've seen how the Goole Analytics interface limits our custom reporting options. We won't face many of those limitations using the Google Analytics API.

Creating a report in the API seems intimidating.

But doing an API call isn't all that difficult. And, once you get comfortable working with the API, it's a much quicker process than building reports in the Google Analytics interface.

There are even tools we can use, like Supermetrics and the Google Sheets add-on, to help us build reports in the API. While Supermetrics comes up more often when we talk about PPC reporting and dashboards is has a huge number of applications!

Here's my question to you. Do you want to see me create this report in the Google Analytics API? If you do, leave a comment below.

If there's enough interest in learning to use the API, we'll devote an entire video and post to this topic.

Want to stay up to date with our hottest tips?

To stay up to date with our latest posts, sign up for our email list. We'll notify you as soon as our Google Analytics API tutorial goes live. You'll also get access to loads more Google Analytics knowledge and resources.

But, be careful! Before you know it, you'll be working deep in the analytics API. And you'll be creating answers to all your Google Analytics custom reporting problems. 🙂

Leave a Comment

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

Cp 31

Custom Reports in Google Analytics allow you to create a view of the data in your account that goes beyond the default reports you see in the Google Analytics interface. This is important, because the columns that you see in default reports are confined to a pre-set number of metrics that can be viewed at a time. As you get more advanced in learning Google Analytics, you will find that sometimes the default views are not enough in order for you to do proper analysis. This is where custom reports come in, allowing you to combine metrics from several reports into a single location that can be used for analysis today or in the future.

Google Analytics Custom Reports are used by analysts in a variety of fashions. For example, you can use them to link together PPC cost data with product performance for your e-commerce store. Another example would be looking at search query data by geography. There really is no limit to the possibility to how you can use custom reports in Google Analytics, so use your imagination to start coming up with killer analysis!

How to set up a custom report

You can currently access your custom reports through the Customization tab in the Google Analytics interface

Google Analytics Customization Tab

Custom reports come in three formats: Explorer, Flat Tables and Map Overlay.

Google Analytics Custom Report Types

Explorer Reports

The Explorer table mimics the familiar reporting interface of Google Analytics, where you have the ability to start with a dimension and then “drill down” into more dimensions. These reports are best consumed electronically, on your computer screen, due to the way drill downs are presented.

Explorer Table in Google Analytics

Flat Table Reports

Flat table custom reports do exactly that – flatten the dimensions that you are viewing into a streamlined tabular format. These reports are particularly useful for when you have data that you need to view without drilling down. Flat table reports are often used for exporting data a spreadsheet tool like Excel for analysis, or for printing a report for consumption outside of Google Analytics.

Google Analytics Flat Table Reports

Map Overlay Reports

Somewhat new to Google Analytics is the ability to view metrics in a map overlay format. This is particularly useful if you would like to view where in the world you are seeing traction for your key metrics. What cities in the world are the most socially engaged with your content? Use the Map Overlay report to find this and many answers.

Google Analytics Map Overlay Custom Report

Map overlay reports can be very useful in discovering areas where you are most successful.

Google Analytics Map Overlay Report

Organizing Your Custom Reports

You can organize your custom reports into categories in order to make your most common reports easily accessible.

Add New Custom Report Category Create Custom Report Categories

Your report organization categories will be visible on the left hand side of your screen:

Google Analytics Custom Reports Categories

Custom Reports Gallery

Do you have a great custom report that you would like to have featured on this page? Please contact Jeffalytics to share the details!

Price Lock Alert: Save $1000 on Lifetime Access To Academy Insiders

00
Months
00
Days
00
Hours
00
Minutes
00
Seconds
Scroll to Top