Email
RSS
8
Export More Than 500 Rows In Google Analytics
23 Comments | Posted by Mike Poserina in Google AdWords, Google Analytics
For many people using Google Analytics, a major drawback when analyzing data is the max 500 rows constraint in their reports. For a person who wants to look at all keywords & search phrases over the last year, it could take hours to export and compile.
The easiest way to get this data without running numerous reports is to add “&limit=50000” to the end of your URL. Although you will still see 500 lines in the browser being displayed, when you export you will be exporting all rows up to the 50,000 line mark.
23 Comments for Export More Than 500 Rows In Google Analytics
donat | Tuesday, January 27, 2009 at 11:51 am
Nectar | Tuesday, February 3, 2009 at 8:03 am
Thank for this! saved me a lot of trouble
Mike | Thursday, February 12, 2009 at 10:09 am
you’re a genius!
M Schenkel | Saturday, February 21, 2009 at 11:35 am
I have a report scheduled each week to be sent in XML format. Anyway this can be configured to include all rows?
Nathan Decker | Thursday, July 23, 2009 at 8:51 am
Word! Thanks for the help, quite useful. I’d love to know what additional parameters exist.
Nathan
Shop Wakeboards
directory | Thursday, December 24, 2009 at 12:44 am
It’s ok and works, but how can I export the following list, for example from 50,001 to 100,000? I need to export a 313k keyword list
DiscoStu | Monday, January 11, 2010 at 1:49 pm
Not getting this to work in any browser…I append &limit=50000 at the end, then hit enter, then export and it still only exports what I sees.
DiscoStu | Monday, January 11, 2010 at 2:42 pm
OK figured it out. For me at least, it won’t show 50K results only 20K, and it won’t change anything visually, only if you export, and only if you export to csv – not cvs for excel. But then I could export 20k keywords at a time, then I’d go to keyword #20 000 and export the next 20k etc
Jean-Francois Monfette | Thursday, January 28, 2010 at 12:31 pm
Thank you very much ! This will save me a whole lot of work.
Manish | Thursday, April 8, 2010 at 3:35 am
Thanks for such a wonder full information, it will ease my lot of work.
g13 media | Wednesday, April 14, 2010 at 7:30 am
This same technoqie can be applied to google local business results. Nice post
A-frame signs | Wednesday, June 30, 2010 at 10:22 am
Thanks for the tip. It saved us from downloading 8 pages of 500 keywords lists and then having to combine them afterwards into one main list. Why can’t Google give powerusers these options from their control panel?
Export More Than 500 Rows In Google Analytics | Engine Ready « SEO and Internet marketing tools | Friday, July 2, 2010 at 7:13 am
[...] Export More Than 500 Rows In Google Analytics | Engine Ready. marketing tools How To Choose Domain Name for a Niche Site [...]
Neil Smith | Wednesday, August 18, 2010 at 11:29 am
Thanks !
Would the same be used for the api as well ?
eg
&limit=50000 ?
Thanks
Josiah Garber | Wednesday, September 22, 2010 at 5:06 am
This does not work if you choose CSV for Excel.
Make sure you choose CSV and it should work fine.
Thanks for the tip.
zoekertjes | Monday, December 6, 2010 at 1:56 am
I see a limit till 20.000, is there a work arround for that?
Nick | Monday, January 24, 2011 at 2:51 am
Brilliant – saved loads of time clicking through 500 by 500!
John Thyfault | Monday, March 7, 2011 at 11:36 am
Thanks, this is a great tip! Saved me lots of time.
The CSV only hint is vital.
Stephen | Friday, June 17, 2011 at 9:31 am
Yes, this was great. Does have a hard stop at 20K records though.
tjmreds | Thursday, September 8, 2011 at 3:53 am
Thanks, this worked a treat, although like DiscoStu I could only export in CSV (not CSV for excel) format.
Rodrigo | Wednesday, October 5, 2011 at 3:51 am
Hey! Is it possible to extract reports between 20.000 and 40.000 rows? When you add “&limit=20000″ you will only get reports up to 20000 line!
Many thanks, it works.