" />

Quick Tip: How to Export More Rows from Google Analytics

Posted on Tuesday, July 17th, 2012 by Print This Post Print This Post

Categories - Analytics, Featured

With the new version of Google Analytics, there has been some confusion about how to export more rows than the maximum 500. We have had problems with this when trying to export keyword lists, URL page lists and more. In the previous version of GA, this trick would only work with exporting to CSV. But with the new version, you can export the additional data in any format.

If you have thousands of rows that need to be exported you can use the following workaround:

1. Go to the report that contains the data you want to export.

2. Go ahead and show 500 rows to start with (toggled at the bottom of the report):

 3. Then, once the report loads, go up to the url in your browser and scroll to the end of it. Find the part that says something like “rowCount%3D500/.” Then change the “500” to the number of rows you wish to have such as 10000. So the new end of your url will say something like “rowCount%3D10000/”. Then press enter


4. After pressing enter on the adjusted url, you should now see your report with more rows

5. Now you can export all these rows to any format you wish.

Never again be restricted to too little data!

About Richard Schneider

Richard has over 5 years experience in the web development and internet marketing industry with extensive experience in web analytics, SEO, SEM, and social media. He started his internet business career by launching a photography blog and social network that now attract close to 200,000 visits per month and serve over 1 million page views per month. Originally joining TSA as a search engine optimization analyst, Richard is now helping the company expand its web analytics services.

Tags | ,

5 Responses to “Quick Tip: How to Export More Rows from Google Analytics”

  1. Anal Sex says:

    Great post. I was checking continuously this weblog and I am inspired! Very helpful info specially the remaining phase :) I maintain such information much. I was seeking this particular info for a long time. Thanks and good luck.

  2. I personally want to book mark this particular posting, “Quick Tip: How to Export More Rows from Google
    Analytics | The Search Agents” on my site. Do you really mind
    in case I personallydo it? Thanks a lot -Anastasia

  3. tinyurl.com says:

    Your entire post, “Quick Tip: How to Export More Rows
    from Google Analytics | The Search Agents” trikisenmovimiento was truly worth commenting on!
    Just wished to say you did a good work. Many thanks ,Eileen

  4. thank but it does not work for over 20,000

  5. thanks heaps. just saved a lot of time


Leave a Reply

Follow Us on Twitter

Featured in Alltop

Big List - Search Marketing Blogs

2010 SEMMY Runner-Up

BoostCTR Best PPC Blogs