The Google Analytics interface can be pretty slow, especially when coughing up 500 records in a query with a filter and a couple of advanced segments applied. Luckily, there is a very simple tool to basically use the Analytics API to dump any batch of data into a flat file very quickly without having to bribe an overworked web developer or learn Python yourself. It’s called the “Google Analytics Query Explorer 2” and it’s simply fantastic.
The trick to using the tool is knowing a often ignored identifier called your “Profile ID” which is different from the Account ID you typically find in your Analytics tracking code. The Account ID starts with UA- that’s not what you want. The Profile ID is found in the Profile Settings tab of your account administration. Example below: 3657130
It is also in the page URL string on most any Analytics report, but you have to ferret it out of the other gibberish by looking for a letter “p” between two strings of URL characters. Again: 3657130
Once you have the Profile ID, the tool is a snap. You are limited to 7 dimensions and 10 metrics, which is plenty for almost any report. This tool is perfect for larger batches of data as well. There is an “Excel TSV” or “tab separated values” button that allows the direct download of up to 10000 rows of data– so no more paging through Analytics reports and exporting 500 rows at a time!
Also, the developers added a G+ button which makes it really easy to share the data with the one or two lonely colleagues you might know on Google+.