How To Export More Than 500 Rows To CSV – Up To 50,000 Rows (Google Analytics Tip)
I saw this on Google forum: How To Export More Than 500 Rows To CSV – Up To 50,000 Rows in Google Analytics:
Is it possible to export more than 500 rows of data? I’ve got a site with over 40,000 pages and at least once a month I would like to be able to download the data for each page. As it is now, I have to page through the results, exporting each time and then copy and paste all the csv’s together.
The answer was pretty succinct:
Append the following to the end URL of the page you are looking at and press enter:
&limit=50000
Note the GA page will not display any differently (ie, it will still show 500), but when you export the data to a csv file, you will actually export 50,000 rows instead of 500.
Written by Shaun Anderson
That’s a really handy tip and certainly one I wasn’t aware of. Thanks for sharing