Google Analytics: Meet The Pivot Table
April 19, 2016
Google Analytics can be intimidating and often times used for the most monotonous tasks. Don’t get me wrong, even the simplest data can be insightful and allow for great optimizations within any account. However, are you leveraging Google Analytics to its fullest potential? Are you diving deep enough into the data to find hidden treasures?
Below are a few steps that will allow you to take Google Analytics one-step further. These simple, yet effective steps will allow you to unlock information and key insights that have fallen by the wayside in this fast-paced world of PPC.
When looking at any given report or view in analytics, the option to add a secondary dimension is available. Often times a quick glance happens and it’s back to the interface to pull the report. Don’t limit yourself to only viewing the data in Analytics, but rather take the data and throw it into a pivot table, which will allow you to condense the data into a readable format.
First, take a minute to figure out what you really want to know. Let’s say you want to look at product performance by device, first you need to go to the Product Performance report in Google Analytics. In Analytics go to Conversions > Ecommerce > Product Performance, as shown below.
Next add in your secondary dimension, or the additional filter you would like to see. In this case I am going to choose device, however, the following can be extremely beneficial as well:
Day of Week
Hour of Day
Once you have selected your secondary dimension, ensure the date range is accurate for your reporting purposes and download the report.
Side Note: Don’t forget to show all rows, or else your report will contain only the top 10 rows.
After downloading the report, create a pivot table of the data, which will allow you to shift through the data and get to bed at a reasonable time! If you want to brush up on your pivot table skills, here is a great article that will walk you through the steps in creating a seamless pivot table.
After getting your pivot table set-up, there are countless ways to segment the data. The first you see here is a top-level view of performance data that shows performance by device. This shows us that the majority of revenue is generated from desktop devices.
The next table you will see is by product and device. Here you will see how individual products perform on each device and which device is most likely going to bring in the more revenue.
The above example is just one route that can be taken. Below are additional routes to get you thinking about your next Analytics pivot table.
|Analytics Report||Secondary Dimension||Explanation|
|Convs. > eCommerce > Product Performance||Device||Shows product performance by device|
|Convs. > Multi – Channel Funnels > Assisted Conv.||Campaign||Shows which campaigns assisted revenue can be attributed to.|
|Acquisition > Adwords >
Hour of Day
|Device||Shows device performance broken out by hour of day.|
|Audience > Technology > Browser & OS||City||Shows browser performance by city.|
There will never be a shortage of data that can be pulled when it comes to PPC. Where clicks are happening, there will always be endless ways to segment data. Rather than pulling the same reports over and over that tell the same story, switch it up and really dive into Google Analytics.
Browse By Category
How To Build Custom Affinity Audiences In Old & New AdWords
PPC Hero Emma Franks breaks down the step-by-step process to create Custom Affinity Audiences in the AdWords interface, whichever version you use.
Why Online Polls Are Critical To Understanding Your Users
You may believe polls are just distracting or annoying. Challenge yourself today to learn how polls can be critical in understanding your users.
A bi-weekly newsletter packed full of resources and strategies that will help make you a better PPC expert.
Hanapin Marketing | The PPC Agency of Experts Behind PPC Hero
Faster, Easier Mobile Lead Generation with Social Lead Ads
Explore how lead ads work, what effects they can have on mobile conversion rates and next steps for rolling out campaigns across social channels.
What the State of PPC Report Reveals for 2018
This year we had a great turnout of responses and some mind-blowing insights to share with you. Join Hanapin's President Jeff Allen as he walks through what we found in our State of PPC Report for 2017-2018 and where the industry is going.
Bing Ads Content Data To Be Deleted
Bing Ads is Deleting Content Data. What you should know and do before-hand.