The Quotidian UserScript: Google Analytics Row Limit Link

I was reading a post made yesterday on the Google Analytics Blog by Christina Park (a Google employee), titled "Back to Basics: Tip for exporting rows" and a userscript came to mind to improve this process a great deal.

The Unpleasantry:

If you want to export a report from Google Analytics with every row displayed, then if you follow the instructions laid out for you by Christina you would:

  1. Go to the bottom of the report and find the pagination details.
  2. Append "&limit=x" to the url in the location bar, where x is the number of total number rows in the report which you obtained by reviewing the pagination details.
  3. Hit enter, to load the modified url.
  4. Export as normal.

But wait, there is a problem.. if you changed the date while you reviewed the report, or made some other change to the report after it loaded initally, then those changes won't be reflected in the url which you will append "&limit=x" to. This means that the page that loads after you have appended "&limit=x" will be without the changes you made.

One way to get around this currently is to use the navigation to change to another report, which will keep the same date range, comparison range, segments selected, and other changes you made, then flip back to the report you were just on, and then finally append "&limit=x" and do the export. But this is all very tedious.

The Alleviation:

Once you install the "Google Analytics Row Limit Link" UserScript the total row count in the pagination details at the bottom of each report will be a link, simply click it and the total number of rows will be displayed in the report (note: your start row is unchanged). This is not only much simpler then the help that the Google Analytics team provides, but it also saves their servers from tons of redundant page loads.

© Erik Vold 2007-2012. Contact Erik Vold. Top ^