How To Get More Than 500 Rows From Google Analytics Reports

February 24, 2013 by · 10 Comments

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

Filed Under: Analytics · Tagged With:
  • 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.