Last updated: March 13, 2015
Unfortunately the original row number hack in Google Analytics doesn’t work anymore.
For a free solution, I recommend to use the Google Analytics API (in combination with Google Analytics Spreadsheet add-on) to export up to 10.000 rows at a time.
Recommended reading: automate your Google Analytics data export.
In the past, Google Analytics allowed you to view and export 500 rows of data from most of your reports in your Google Analytics account. They changed this number to 5000 in April 2013. For a lot of people, especially those with smaller websites, this is more than enough.
Tip 2: Row number hack in Google Analytics.
If you know how it works, it’s quite an easy fix.
Here we go:
- Just head over to one of your reports where you like to display more than 5.000 rows.
- On the lower right corner change the default number from 10 to 25.
- After you make this change, the URL of your report will change and some extra variables are displayed at the end.
- At the end of the URL you can see: explorer-table.rowCount%3D25/.
- Change the last number into 20000 and you are done! (explorer-table.rowCount%3D20000/).
Keep in mind that if you change the row setting to more than 10000 rows, it might slow down your computer. In my experience, this hack works the best in Google Chrome.
Why does Google limit you to 5000 rows? I expect it to be very much resource intensive if everybody is playing around with higher number of rows.
This hack is a very good option if you need to export larger number of rows just once in a while.
However, make sure to learn about the Google Analytics API if you have large data volume requests on a daily basis. You will make yourself and Google happy! :-)
If anything is on your mind, please bring it up and add some extra value to this post.One last thing... Make sure to get my extensive checklist for your Google Analytics setup. It contains 50+ crucial things to take into account when setting up Google Analytics.