Google Analytics 500 Limit Override

override-google-analytics-500-limit

All reports in Google Analytics are subject to a 500 limit of listed records, may it be keywords,search terms, referrals or any other report. In other words, if you are trying to view or download the full list of your paid keywords, you will be limited to the top 500 of them.

Let’s bypass it!

Google Analytics drop down limiting the reports to 500 rows of data

As you can see above, there are 875 “rows” of data you want to analyze. But when you download the file you will not get more than 500 records.

There’s a secret to fix this issues. Add the “&limit=” parameter to your report URL.

Let’s say you are looking at your keywords report

1. Go to the report page you want to see.

The URL may look like: https://www.google.com/analytics/reporting/keywords?id=1234567&pdr=20081006-20081105& cmp=average#lts=1234567890

2. Add “&limit=5000” at the end of the URL

https://www.google.com/analytics/reporting/keywords?id=1234567&pdr=20081006-20081105& cmp=average#lts=1234567890&limit=5000

3. Hit refresh(F5) in your browser then click on a different report link

4. Paste the URL from step 2 in the address bar and load that page

5. Export your report.

This time you will have 5000 records in the downloaded file

 

Note: Downloading is the only way to get unlimited records. They won’t be visible in the Google Analytics interface

Later Update (August 31st 2009): Google has released the official version of this trick (http://analytics.blogspot.com/2009/08/back-to-basics-tip-for-exporting-rows.html)

VN:F [1.9.22_1171]
Rating: 10.0/10 (5 votes cast)
VN:F [1.9.22_1171]
Rating: +6 (from 8 votes)
Google Analytics 500 Limit Override, 10.0 out of 10 based on 5 ratings

About 

Traian is Founder and Director of Search Marketing at Pitstop Media Inc. He has more than 11 years experience in helping small and medium businesses generate and convert organic traffic from search engines. Connect with Traian on Google+

 

17 Responses to “Google Analytics 500 Limit Override”

  1. valve said:

    Nov 07, 08 at 3:04 pm

    Thanks. This will help me review my Adwords data using Google Analytics much faster.

    VA:F [1.9.22_1171]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  2. TraiaN said:

    Nov 11, 08 at 7:28 pm

    I’m glad it’s helpful

    VA:F [1.9.22_1171]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  3. Jeff said:

    Nov 19, 08 at 9:03 pm

    Good job – you saved my time.

    VA:F [1.9.22_1171]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.22_1171]
    Rating: +1 (from 1 vote)
  4. Roman said:

    Nov 23, 08 at 12:31 pm

    It doesn’t work for me!

    VA:F [1.9.22_1171]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  5. traiann said:

    Nov 24, 08 at 5:38 pm

    @Roman,

    Make sure you are downloading the report. They won’t directly show up in the interface.

    VN:F [1.9.22_1171]
    Rating: 0.0/5 (0 votes cast)
    VN:F [1.9.22_1171]
    Rating: -1 (from 1 vote)
  6. Matthew Hunt said:

    Dec 28, 08 at 9:32 pm

    Awesome tip! Will make things go way faster!

    VA:F [1.9.22_1171]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.22_1171]
    Rating: -1 (from 1 vote)
  7. Allen Howard said:

    Feb 06, 09 at 10:09 pm

    Thank you TraiaN. Its really very helpful.Keep on writing such good stuff.

    VA:F [1.9.22_1171]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.22_1171]
    Rating: -1 (from 1 vote)
  8. Ejaz said:

    Feb 25, 09 at 1:16 am

    Thank you friend. I am new to internet marketing so i hope this will help me.

    VA:F [1.9.22_1171]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  9. ra6000 said:

    Jun 04, 09 at 5:25 am

    This is a great tip, but does anyone know how to get more data than 50,000? Any number over 50,000 produces an error. I have about 400,000 events that I need to extract.

    VA:F [1.9.22_1171]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  10. TraiaN said:

    Jun 04, 09 at 11:30 am

    When this is the case, you should break the dates (i.e. from Jan-March and then from April-June) so there won’t be more than 49999 rows to generate. Then, you can concatenate them in Excel. I hope it helps.

    VN:F [1.9.22_1171]
    Rating: 0.0/5 (0 votes cast)
    VN:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  11. Tony said:

    Aug 03, 09 at 7:10 am

    I have using this method for nearly a year now but when I tried today it didn’t work – only gave me the fist 500 records. Have Google closed the door?

    VA:F [1.9.22_1171]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  12. TraiaN said:

    Aug 03, 09 at 5:16 pm

    @tony:starting august 1st this method doesn’t seem to work :( . Probably Google is trying to force us using their bloody API.

    VN:F [1.9.22_1171]
    Rating: 0.0/5 (0 votes cast)
    VN:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  13. Adam Tudor said:

    Dec 07, 09 at 10:18 am

    Don’t worry, it’s still working – only with csv and tsv file formats however.

    VA:F [1.9.22_1171]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  14. Anand said:

    Jan 07, 10 at 11:59 pm

    yes its working now in all supported format

    VA:F [1.9.22_1171]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  15. gamedevelopment said:

    Jan 19, 10 at 1:47 am

    Great tips…thanks

    VA:F [1.9.22_1171]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  16. Dejan said:

    Jun 13, 10 at 9:51 am

    Good article!
    Thank you!

    VA:F [1.9.22_1171]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  17. ashly said:

    Jul 04, 10 at 7:48 pm

    Absolutely true, this is very easy way to increase PR in Google and other search engine. Thanks for sharing the whole information.

    VA:F [1.9.22_1171]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)