How to Change the Default Row Limit in Exporting Google Analytics Data

When you use the “Export” functionality in Google Analytics, you are able to export the data that from the report that is currently showing on your screen. Since most of the reports have a 500 row limit you can only export up to 500 rows by default. However there is a workaround for that.

Changing the Number of Rows Exported

As explained in article “How to Change the 500 Row Limit in Google Analytic Reports”  you can change the view on your screen to show more than 500 rows.  If you use this hack to change the data displayed on your screen and then use “Export” functionality then you will be able export more than 500 rows.  For example, if you want to export 2500 rows then

  1. Change the number of rows in the URL of the report see belowhttps://www.google.com/analytics/web/#report/content-pages/a26989140w6400164p6618633/%3Fexplorer-table.rowStart%3D0%26explorer-table.rowCount%3D500%26_.advseg%3Duser2093821913/

    to

    https://www.google.com/analytics/web/#report/content-pages/a26989140w6400164p6618633/%3Fexplorer-table.rowStart%3D0%26explorer-table.rowCount%3D2500%26_.advseg%3Duser2093821913/

  2. Now you should see 2500 rows in your report
  3. Click on Export Button
  4. Your export with 2500 rows should be ready in few seconds

Speak Your Mind

*