Export More Than 500 Rows In Google Analytics – update 2016 – more analytics tricks

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.

When asked what can be expected from Google search in 2009, Google’s Matt Cutts said it will be “The big year for the mobile phone.”  Matt Cutts Interview

I can definitely see this happening. Everywhere I look people are playing with their iPhones. I can name 4 people in our office alone that have purchased one in the last month.  Apple and AT&T are making record sales and I have no doubt that these mobile phones are going to be big in 2009.

So what does all of this mean for the future online marketing?  We have been told time and time again that mobile phones are going to be the new marketing media of the future. If 2007 wasn’t the “The big year for the mobile phone” then it was 2008. Or was it?

However, a big change did happen on December 8, 2008 when the Google team announced a new campaign-level option that allows AdWords advertisers to show desktop text and image ads on the iPhone, the T-Mobile G1, and other mobile devices with full (HTML) Internet browsers. These ads point to desktop landing pages so that it is unnecessary to create mobile landing pages or ads in mobile formats. This allows advertisers to display ads exclusively on these mobile devices, create campaigns for them, and get separate performance reporting. Google Mobile Article

 I see this change as Google’s first step in progressing mobile advertising. Now that advertisers can target mobile devices with HTML internet browsers the next step logical step would be to integrate the click to call function into full length Adwords ads. I also believe Google has big plans for the T-Mobile G1 to compete with the iPhone. Then what about Application advertising? My favorite iPhone feature is the applications function; but how would Google advertise on applications?  Maybe Google will create a type of application network similar to the content network. This would allow ads to be easily managed within the Google Adwords account. These are some of the changes that I hope Matt Cutts is talking about when he says that 2009 is going to be “The year of the mobile phone”.



  • donat · Tuesday, January 27, 2009 at 11:51 am

    Many thanks, it works.

  • 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.

    Shop Wakeboards

  • Dean Cruddace · Monday, December 7, 2009 at 9:12 am

    Exactly what i needed cheers

  • 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 ?
    &limit=50000 ?

  • 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!

  • Dan Sullivan · Monday, February 21, 2011 at 8:58 am

    Seems to cut off at 20000 no matter what I do.

  • 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.

  • justin · Thursday, September 15, 2011 at 3:31 pm

  • 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!

  • Valon Canhasi (@Redjakova) · Monday, March 12, 2012 at 7:40 pm

    Thanks it worked perfectly !

  • ian kenny · Thursday, April 12, 2012 at 11:04 am

    Does not work for me, cant seem to delineate between csv and csv for excel…

  • Chris · Tuesday, May 1, 2012 at 5:52 pm

    This can be done in the new Google Analytics, just using slightly different text. Instead of pasting “&limit=5000” to the end of the URL, modify the last section of the URL from “explorer-table.rowCount%3D25/” to “explorer-table.rowCount%3D20000/”. You’re just changing the number at the end (after the “D”).

    Beware this will have a noticeable performance impact on your browser, and it will display all the rows on the page. I used 50,000 rows initially, and my browser was slow to the point of un-useable. However, it did export all 50,000 rows to CSV pretty quickly.

  • Mike · Wednesday, June 20, 2012 at 11:07 am

  • Carter · Wednesday, July 18, 2012 at 1:20 pm

    This should be standard for reports – they should always export all data…….why we need to jump through hoops (and crash our browsers) to export data is beyond me.

  • Zach · Thursday, November 29, 2012 at 9:54 am

    Thanks a ton Chris and Mike. I’m creating a report/case study for a client and this is just what I needed.

    I agree with Carter. Not sure why this functionality isn’t built into the interface, maybe one of those notorious things Google does to limit data visibility.

  • AJM · Tuesday, January 15, 2013 at 7:25 am

    I was looking for this solution. Thanks!



Copyright © 1999 - 2016 Engine Ready, Inc. All Rights Reserved.