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.
– Live HTTP header (http://livehttpheaders.mozdev.org/)
We’ll make possible for the analyst in you to download more than 5 columns from Google Analytics’ Pivot Table reports.
The URL that exports Google Analytics reports in CSV for Excel (&fmt=5) is:
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:
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!