How To Export More Than 5000 Rows in Google Analytics

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 in 2015 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:

Real Time Analytics

I highly recommend CLICKY Real Time Web Analytics for real time website visitor analysis. Easy to install, Clicky is also easier to use than Google Analytics. Disclosure: I am a customer and affiliate.

Find Out More

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, Yahoo & Bing
  • how to optimise your site to get more traffic from Google
  • how to target the most valuable keywords for your business
  • how to make your site rank better in free Google listings
  • how to rank high & avoid Google penalties in 2015

Trust Hobo with your SEO plan

SEO Audit