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!

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

Trackbacks/Pingbacks


Leave a Reply

Follow Us on Twitter

Authors