Google Analytics Tips & Tricks - Exporting More Than 500 Results
March 19, 2009 – 2:46 pm by Dan CristoOne of the frustrating limitation of Google Analytics is the inability to export more then 500 results for any given report. Here is a quick little work around:
1) Within Google Analytics, create a report that has more than 500 results.
2) Add a parameter at the end of the URL: The parameter is “&limit=<number you want to export>”. So an example would be: &limit=1000 or &limit=1500
Let me break down the parameter…
- ” &” indicates that a new parameter is being added to the URL
- “limit” is the name of the parameter
- “=1000″ is the quantity of results you want to export
3) Hit “enter” or “go” in your browser to activate the parameter (the page may not look like it changed, because it loads so quickly).
4) Export your results as you normally would.
When you open up your results, you should see the entire set of results, not just 500.
Leave a quick comment below if you found this tip useful!
Dan Cristo is a search engine optimization specialist at Zeta Interactive - follow me on Twitter
23 Responses to “Google Analytics Tips & Tricks - Exporting More Than 500 Results”
Nice! What a quick and useful trick. Thanks for sharing.
By MikeTek on Mar 19, 2009
Thanks Mike! It’s made the rounds before, but Dan did a great job of presenting it in a visual format.
By Hugo Guzman on Mar 19, 2009
Thanks a lot Dan, for saving our time to get more than 500 keywords within a min.
(moderator edit: Had to give Dan his props for making this tutorial)
By bhagawat on Mar 20, 2009
@MikeTek - Glad you found the tip useful. Thanks for commenting.
@bhagawat - You’re welcome. Sure beats exporting the data multiple times into Excel!
By Dan Cristo on Mar 20, 2009
Great and Simple quick Tip. Thums up to you
By krishna on Apr 6, 2009
Brilliant!
By Juan on Apr 24, 2009
Thank you! I was about to throw this laptop out the window!
By Ruben on May 6, 2009
Very helpful. It looks like the limit is 50,000.
Nathan
By Nathan Decker on Jul 23, 2009
@Nathan - Thanks for the insight regarding the max number of results that can be exported.
By Dan Cristo on Jul 23, 2009
Hi folks,
When i append &limit=1000 nothing changes in my GA
Help me!!
By Human on Aug 26, 2009
Sorry to hear that, Human! Make sure to follow the steps in exact order. It’s a bit tricky, but if you keep at it, you’ll figure out how to complete the export (it took us quite a few tries to get the hang of it internally).
By Hugo Guzman on Aug 27, 2009
I found this tip months ago and forgot to bookmark it. Then tonight I needed to export over 500 and did a search and you were the first result.
Excellent tip, it works every time and is awesome!
@Human - the results in GA don’t change beyond 500, BUT when you export you get the full amount you set in your limit.
Again, thanks for the tip!
By newmediaMike on Sep 22, 2009
Can’t get it to work for me. I’m viewing the Top Content report and following instructions as written.
By EddieO on Oct 9, 2009
aha! you need to click ‘CSV’ (not the option that says ‘CSV for Excel’), as explained here: http://google.com/support/analytics/bin/answer.py?hl=en&answer=159501
By EddieO on Oct 9, 2009