I switched to the new Google Analytics interface and almost immediately ran into that old problem of wanting to export more than 500 rows of data without having to resort to using API calls. The old “limit=50000″ trick doesn’t work with the new format, but thankfully there is a work around which I came across on the Convonix blog.
If you choose to show more than the standard 10 rows using the drop down at the bottom of the page, a new “rowcount” variable is added to your URL. For example, I changed a page to display 25 rows and the variable looks like this:
By changing the 25 you can change how many rows get displayed and then export them, up to a 50,000 row limit apparently. I’d caution against relying on this as a long term solution though. The previous 50,000 row limit trick got reduced to 20,000 after so many people started using it, and I imagine the same will happen with this trick once its use catches on. In the meantime though, enjoy!
Hey there Philip,
It’s not working for me in the NEW Google Analytics, I change the field, even to something like 1,000 just to test, and it won’t populate for me, just gives me a resource error, any thoughts on this?
I just tried it again myself and it worked fine for me. When you change the number of rows on the page with the drop down does the rowcount%3D variable get added to your URL? And if you change the number after it and hit return does the page reload with that number of rows? When does the resource error occur?
it works just fine, thanks!