Breaking the 500-Row Barrier in Google Analytics

Google Analytics has many strengths as an analytics tool, but it has its limitations. A major one has been the restriction of only being able to export 500 rows of a report at a time.  For example, the screenshot below shows that the report for Site Search Terms has over 22,000 rows, yet we can only select a maximum of 500 rows to display at once (number of rows displayed is the number that will be exported):

GA 500 row limit

GA 500 row limit

It may not be particularly useful to look at all 22,000 rows, but even if we want to get a report on the top 2,000 search terms, we would have to create 4 reports, selecting 500 rows each time, exporting, then moving on to next 500. Tedious – to put it mildly.

Accessing data via the Google API offers one way around this limitation.  However, the Google Analytic Blog has provided a more straightforward solution that anybody can use.  In this Tip for Exporting Rows, it is explained that the 500-row limit can be overcome using these easy steps:

1. Go to the report you want to export.

2. Append &limit=x to the end of the report URL (where x=number of rows you want to export)

3. Hit enter to refresh the page (double-check to make sure the &limit= is still there)

4. Export as CSV.

Voila! Easy and efficient!  Thanks to the folks at the Google Analytics Blog for sharing this trick.


One Response

  1. I needed that but in the e-mailing part.

    Limit is no recognized but theres other place with the mail row limit. You can find TROWS now with 5000 that I changed. You can still find the &limit but it does nothing.

    The best part is that TROWS is always present so you shoul change this instead of adding the &limit, i believe.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: