How To Get More Than 500 Rows From Google Analytics Reports

hack jock

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!

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.

Google Analytics show rows drop-down menu

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.

export-google-analytics-reports

 

Image by Alan Cheek

  • http://www.eBizROI.com Rick Noel, eBiz ROI, Inc.

    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.

    • http://www.annielytics.com/ Annie Cushing

      You’re very welcome! Glad it helped.

      • http://twitter.com/AllSearch52 AllSearch52

        Great trick, just used it. Hopefully I can kill some of the 5k 404 errors.

        • http://www.annielytics.com/ Annie Cushing

          Good luck w/ that! And good for you for staying on top of those!

  • Anne Haynes

    I love this tip! It’s amazing what can be done when you fiddle with the URL structure.

    • http://www.annielytics.com/ Annie Cushing

      Yes, it is! Kind of takes all the mystery out of how these different tools work.

  • George Phillip

    Hey Annie, awesome tip, thanks. GA has been killing me when trying to export large datasets.

  • http://www.facebook.com/profile.php?id=584308533 James Hart

    Have you seen that GA now allows you to look at 5,000 rows now. I think it was a recent change. Great post

    • http://www.annielytics.com/ Annie Cushing

      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.

      • Nick

        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.

  • mustafaalmsry

    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/

    • http://www.annielytics.com/ Annie Cushing

      They must have set this limit when they increased the number of rows you could choose from. It wasn’t always capped at 20k.

  • Peter Kirwan

    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

    • http://www.annielytics.com/ Annie Cushing

      I’d use the API. There are no limits on the API – at least none that I’ve run into.

      • Peter Kirwan

        Thanks for the suggestions. Teaching myself how to do things with the API is high on my list!

Powered by WishList Member - Membership Software