Export More Than 500 Rows of Reports

By default Google Analytics shows and exports only 500 rows of report. It would be nice to have it export more than 500 rows or all of the data for comparison.

To export more than 500 reports:

analytics tip export 50000 rows
  1. Display the report in Analytics
  2. Append &limit=50000 at the end of the URL in your location bar BEFORE any hash (#) sign. You may not have a hash sign in your URL.
  3. It would seem nothing happens because Analytics continues to show 500 rows. But when you Export CSV, Analytics will export more than 500 rows (upto 50000). Note that I've only tested it on CSV option, not other XML, PDF, CSV for Excel or TSV.




Enjoy your big reports!