UPDATE: Google Analytics now gives you up to 5000 rows, so you don’t need to do this trick unless you have > 5,000 rows in a report. Thanks, Goog!
UPDATE TO THE UPDATE: Google shut this down, so this hack no longer works. Thanks, Goog … :/
When you create a report in Google Analytics (GA), the interface limits you to 500 rows. You can get around that limit though. Your browser will probably give out before you hit the limit of rows you can export from a GA report. Mine normally starts coughing up blood at about 30,000 rows.
But here’s what to do:
Step 1: Change the Show rows drop-down in the bottom-right corner of your report from 10 to 25.
Step 2: Take note of how many line items you need to export. In the example of the screenshot above, we would need at least 6001, although I usually include extra for good measure.
Step 3: Look at very end of the report URL. You’ll see table.rowCount%3D25/. Change that 25 to however many rows you need and press Enter (Mac: Return).
Step 4: Click Export > CSV from the top drop-down menu.
Image by Alan Cheek
Hi Annie, I love useful posts like this. I always was frustrated by this Google Analytics 500 row limit. Thanks for sharing your handy technique to get beyond this limit.
You’re very welcome! Glad it helped.
Great trick, just used it. Hopefully I can kill some of the 5k 404 errors.
Good luck w/ that! And good for you for staying on top of those!
I love this tip! It’s amazing what can be done when you fiddle with the URL structure.
Yes, it is! Kind of takes all the mystery out of how these different tools work.
Hey Annie, awesome tip, thanks. GA has been killing me when trying to export large datasets.
If you’re dealing with large datasets, you’re probably getting a lot of sampling. You might want to switch to using the API. I show how easy it is using a free tool in this post I wrote on Search Engine Land: http://searchengineland.com/how-to-use-the-google-analytics-api-in-plain-english-and-a-free-plugin-139867.
Have you seen that GA now allows you to look at 5,000 rows now. I think it was a recent change. Great post
Yeah, I just need to get around to updating it. Or people can figure out that they don’t have to use the hack unless they need > 5k.
I work with big data reports from Universal Analytics. Which I frequently export to excel for additional processing. Your fix for the rows works fine but only up to 20.000 rows this is really the upper limit.
If you’re doing enterprise-level analytics like that, you really shouldn’t be using the UI; you should be pulling the data daily or weekly using the API. There are a number of products that make that easy if you don’t have a developer who can set up a reporting dashboard for you. I wrote a post on Search Engine Land about one of the free ones: http://searchengineland.com/how-to-use-the-google-analytics-api-in-plain-english-and-a-free-plugin-139867
I work with big data reports from Universal Analytics. Which I frequently export to excel for additional processing. Your fix for the rows works fine but only up to 20.000 rows this is really the upper limit.
thank you
http://wwwmustafaalmsry.blogspot.com/
They must have set this limit when they increased the number of rows you could choose from. It wasn’t always capped at 20k.
I ran into the 100 row limit for the Trackback report. Tried the old hack and at first I thought it had worked as I could specify say 1 or 3 rows. Tried going over 100 and it seemed to stop at 100 though
I’d use the API. There are no limits on the API – at least none that I’ve run into.
Thanks for the suggestions. Teaching myself how to do things with the API is high on my list!
Hi,
There seems to be a new cap set at 5000 rows for export now. This method doesn’t seem to work. Any updates on this?
Yeah, Google shut this hack down. 🙁