How To Export More Than 5000 Rows in Google Analytics

Subscribe.

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

https://www.google.com/analytics/web/?hl=en-GB&pli=1#report/trafficsources-organic/a12346448w43910105p43958149/%3F_u.date00%3D20110101%26_u.date01%3D20130410%26explorer-table.plotKeys%3D%5B%5D%26explorer-table.rowStart%3D0%26explorer-table.rowCount%3D5000/

…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.

Alternatives

Google Sheet add-on to download data in multiple blocks of 10K: https://ga-dev-tools.appspot.com/spreadsheet-add-on/

Free add-in for Excel which will download up to a million rows: http://www.analyticsedge.com/simply-free/




Learn how you can get more sales from your website

Subscribe for free and let us share with you:

  • how to submit your site to Google and other search engines.
  • how to optimise your site to get more traffic from Google.
  • how to target the most valuable keywords for your business.



Free SEO course

Join 70K+ subscribers and get free SEO training.