How to export more than 500 rows in Google Analytics

It has been a long standing issue that it is not altogether apparent how you export more than 500 rows of data from Google Analytics.

The common method that people including ourselves was to alter the query parameters in the URL to visually display a greater number of results before clicking to export. The trouble here is if your browser has a number of tabs open and you try to display 10,000 results the you risk crashing the browser. This method is outlined in Google’s help page titled ‘Exporting and Emailing Reports’.

Please note that if you apply any advanced segments or alter the standard report past date this will still just export the original report.

 

Step 1 – Create Bookmark

Step 1 - Export more than 500 rows from Google Analytics

 

  1. Create a new bookmark in your Browser;
    • If you have your Bookmarks bar visible then you can probably right-click whilst hovering your mouse over the bar to bring up a menu allowing you to create a new bookmark.
  2. Name your bookmark something you’ll remember;
  3. Copy the code below in place of the URL;
javascript:function post_Smby(params){var form = document.createElement("form"); form.setAttribute("method","post"); form.setAttribute("action","exportReport"); for(var key in params){var hiddenField = document.createElement("input"); hiddenField.setAttribute("type","hidden"); hiddenField.setAttribute("name",key); hiddenField.setAttribute("value",params[key]); form.appendChild(hiddenField);} document.body.appendChild(form);form.submit();}var rowcount=prompt("Amount of rows (10-50000):","1000"); hashes=unescape(location.hash).split("/"); date0=hashes[3].substr(hashes[3].indexOf(".date00")+8,8); date1=hashes[3].substr(hashes[3].indexOf(".date01")+8,8); post_Smby({'_.date00':date0, '_.date01':date1, 'explorer-table.rowStart':'0', 'explorer-table.rowCount':rowcount+'', 'id':hashes[1], 'ds':hashes[2], 'ef':'CSV', 'exportUrl':location.href});

 

Step 2 – Export 500+ from Google Analytics

Step 2 - Export more than 500 rows from Google Analytics

 

  1. Navigate to the report you wish to export and select the appropriate date range;
  2. Click on your bookmark, a window will appear;
  3. Type how many rows you wish exported;
  4. Click OK and in a few moments you will have a CSV exported.

Notes:

This has been tested on a PC using IE9, Chrome 19 & Firefox 10 – No guarantees

Comments: 15

  • David
    June 28, 2012 9:50 am

    Hi

    This is excellent works like a dream. One question. Do you know how I would alter it to get the ecommerce stats?

    sectionId%3Decommerce

    Thanks

    David

  • Parthipan
    July 30, 2012 10:47 am

    This code allows us to download only the top 50,000 records.

    My site has more than 2 lakhs rows how to download all those records.

    Thanks,
    Parthipan

  • Nick
    August 16, 2012 3:02 pm

    Hi,

    Great tip, very useful! Do you know if there is a way to edit the code to allow Multi-Channel Funnel path data to be downloaded? The current code returns the first 10 paths only :-(.

    Thanks,
    Nick

  • Vincent
    October 12, 2012 6:55 am

    This is not working for me. I got to Standard Reporting>>Traffic>>Search>>Overview

    Then I clicked on the bookmark.

    An excel file downloaded but it only contained dates and corresponding visits on that day. The file did not contain the search terms

  • PRF
    December 21, 2012 12:17 pm
  • kelltrill
    February 21, 2013 11:54 am

    Hi Sumobaby

    Thanks so much for posting this solution. It’s by far the most effective one I’ve come across so far.

    1 question though: At the moment when I export the resulting CSV only shows the primary dimension metric. If I’m also using a secondary dimension in GA (example: product category and product SKU in product performance report) then only the product category metric exports.

  • kelltrill
    February 21, 2013 11:56 am

    Hmm, scratch that. It seems to only export the immediate view without any alterations. In other words, only the Product metric, not any of the others.

  • Saquib
    May 16, 2014 9:09 am

    I am unable to download 23000 rows. Please assist

Post a Comment

Sumobaby