Google Analytics Column Hack-Pivot Tables

March 15th, 2010 by Daniel Laws

One of our clients requested a method to export more data from the Google Analytics pivot tables. The purpose of the export was to tie together Google Analytics with specific URL variables; however, Google Analytics displays a limited number of items on the pivot table. We did some research and we came across this Google Analytics Hack.

What You Will Need:

– Firefox
– Live HTTP header (http://livehttpheaders.mozdev.org/)

What are we hacking?

We’ll make possible for the analyst in you to download more than 5 columns from Google Analytics’ Pivot Table reports.

Below are the steps to the hack:

1. Go to any report that has the pivot table option and segment the data the way you want to analyze it (for testing purposes you can use the example above: go on Traffic Sources report à then Referring Sites and then pivot by Landing Page and choose Showing Visits)
2. Start Live HTTP header (in Firefox, under Tools) – do not load any other pages between step 2 and 3
3. Make sure you checked the Capture box on live HTTP header
4. Go back to your Google Analytics window and select a new number of page rows on, under Show rows (the footer of the pivot table). At this moment, the table should reload.
5. Open the Live HTTP header window
6. The first line there should be the request sent to Google Analytics in order to reload the pivot table. You should see something similar to Live HTTP Header
7. Copy the link (should be the first if you didn’t load any other page or made other HTTP request – music or video streams) and load it in another tab. You should have something similar to: Pure html table
8. Now look for the &tcols=5 parameter. Change it to &tcols=50 and load the new URL

Here’s a bonus hack for Google Analytics

The URL that exports Google Analytics reports in CSV for Excel (&fmt=5) is:
https://www.google.com/analytics/reporting/export?fmt=5 and some parameters after.
You will have to copy everything starting and including &id=…. from the URL you previously modified (the one with &tcols=50) and append it to Google’s export URL. The export URL will look like:
https://www.google.com/analytics/reporting/export?fmt=5&id=1234567&esig=4&seg0=-8&pdr=20091016-20091115&cmp=visit_segments&trows=25&rpt=ReferringSourcesReport&seg=1&view=4&tchcol=0&tst=0

We have used this several times to export additional pivot table information. A word of caution when using a hack, do it at your own risk. We highly recommend that you use this on a duplicate profile and on a secure network.

Source: You Should Test That!

Danny founded DMG in 2008 and continues to lead in developing an industry-leading digital agency while emphasizing online measurement best practices. Under Danny’s direction and leadership, DaBrian Marketing Group has become Reading, PA’s leading digital agency focused on demonstrating value through measurement of marketing campaigns.

One Response to “Google Analytics Column Hack-Pivot Tables”

  1. June 19, 2014 at 12:15 pm, Steve Groller said:

    Hiya Brian,

    Thanks for the update! It’s hard to believe that this post is now over 4 years old, but we’ll definitely work to amend it to account for recent updates to Google Analytics. We’ll be sure to do that as soon as possible.

    Sorry for any inconvenience in trying to get the pivot table hack to work!

    Reply

Leave a Reply

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

RSS
Facebook
Facebook
Google+
Google+
https://dabrianmarketing.com/blog/google-analytics-column-hack-pivot-tables">
YOUTUBE
LinkedIn