On occasion we need to review or download more than 500 rows of data from Google Analytics. In the old version of GA, you could select any view, and append “&limit=1000” to the URL and use the export to CSV option to view 1,000 rows. Simply by changing the number on the end of that string would provide you with the number of rows you needed.

To achieve the same result in the new Google Analytics, navigate to your report and select the drop down to show 25 rows, and notice how the URL changes:

https://www.google.com/analytics/web/#report/conversions-ecommerce-transaction/axxxxxxxw2082610p2108288/%3F_.date00%3D20110501%26_.date01%3D20110630/

to

https://www.google.com/analytics/web/#report/conversions-ecommerce-transaction/axxxxxxxw2082610p2108288/%3F_.date00%3D20110501%26_.date01%3D20110630%26explorer-table.rowStart%3D0%26explorer-table.rowCount%3D25/

Simply change the last number before the dash, in the above example “25” to the number of rows you want to see:

https://www.google.com/analytics/web/#report/conversions-ecommerce-transaction/a1196161w2082610p2108288/%3F_.date00%3D20110501%26_.date01%3D20110630%26explorer-table.rowStart%3D0%26explorer-table.rowCount%3D1000/

and now you will see 1,000 rows of data, as well as be able to export all of those rows in one export.