How To Export More Than 5000 Rows in Google Analytics

Blog subscribers

Export 5000 rows in Google Analytics dashboard - Screen Shot 2013-04-10 at 16.38.16

You CAN NO LONGER display and export more than 5000 rows in Google Analytics. You used to be able to, using the hack I list below:

When you select 5000 rows you will have a URL like this

…once you could just change that last number from 5000 at the end of that URL to 50000 (add an extra zero) and hey presto – you saw much more in the dashboard, too.

The MAXIMUM amount of rows you can see in the Dashboard is 5000 rows, whichever number you specify at the end of that URL.


Google Sheet add-on to download data in multiple blocks of 10K:

Free add-in for Excel which will download up to a million rows: