Google Analytics 500 Limit Override
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!
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
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)