How to export more than 500 Multi-Channel Funnels in Google Analytics

Due to the suceess on our post on How to export more than 500 rows in Google Analytics we’ve been posed an interesting question which highlights a limitation of that method. It DOES NOT work for exporting Multi-Channel Funnels (Top Conversion Paths) and only returns the first ten line items, but we think we’ve found a solution.

Please let us know how you get on and what bugs you find.

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 bear in mind that if you’re using the free version of Google Analytics, reports are limited to 50K rows: https://www.google.com/analytics/premium/features.html

 

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_andre(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_andre({'_.date00':date0, '_.date01':date1, 'explorer_dataSet_ALL-table.rowStart':'0', 'explorer_dataSet_ALL-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: 4

  • Debbie Mahler
    August 22, 2012 11:37 pm

    This isn’t working! Did Google change something? I can’t get any more than 2007 rows of data out of them. When I use your code, I get “service not available”

  • Edward
    September 13, 2012 2:35 pm

    it doesn’t work for me, I tried to get the assisted conversions and it does’t do the job… any alternatives??

Post a Comment

Sumobaby