Google Analytics #1 – How to Export More Than 500 Rows from the New System
Hi analytics lovers! My name is Mike and I'll be running through some cool Google Analytics tips that can make your analysis of the world of search that bit more useful.
First off, I thought I'd talk a little bit about exporting data.
By default Google Analytics gives you access to data in a variety of ways – you can download PDFs for graphs and excel sheets for table data. This is hugely useful in giving us plenty of opportunity to analyse information out of Google Analytics using spreadsheet programs like Microsoft Excel.
The only problem is that sometimes table data is limited to the number of rows shown/set as part of your table.
The maximum number of rows you can set is 500 – this means you can get a maximum of 500 rows of data using this method of export. This is absolutely fine if you only want to look at the top 500 rows of data – for example looking the top content pages and the keywords that are driving traffic to those pages would happily sit in an excel/csv export that is limited to this method. However! What if we were looking at 10,000 traffic driving keywords to see if there are any keywords with low ranking or longer tails (long query traffic driving keywords) that are converting well? The row export just won't cut it… especially if you are going to use Excel filters and the like.
So how do you increase the export size? In the traditional Google Analytics it was pretty simple to change the maximum row export by appending the analytics URL with "&limit=10000" to the end of the URL where 10,000 is the maximum number of rows for export.
This is really easy and whilst the data might not appear changed in Google Analytics, rest assured when you export via CSV it should display up to 10,000 rows - or however many rows you have set. However, this method isn't possible in the NEW Google Analytics - so how do export these extra rows?
Firstly scroll right down and change the default "Show rows:" drop down to anything other than the default, in the example above we'd change the 25 to another number.
Hopefully the results should change to show the number of rows set – the URL should also change to include the following very near the end of the URL:
In the NEW Google Analytics, the "rowCount%3D" is essentially the way the URL tells the system how many rows to show at a time. If you change the end number (e.g. 25) to something like 10,000, Google Analytics will display this information. The page should refresh to show a maximum of 10,000 rows and will allow you to export this number via the export tool.
The only gripe we have with this system is the fact that it takes a bit of time for Google Analytics to return over 500 rows of data which might slow the system down. Another option might be to use the Google Analytics API.