Date range comparisons and multi-segment queries in Supermetrics for Google Docs

We’ve released a new version of our Google Docs add-on with some nice new features:

Automatic comparisons to previous values

Supermetrics for Google Docs can now automatically calculate year-over-year changes and other comparisons. Just go to the Select dates tab and use the Compare to dropdown menu. You can choose to compare to the same date range a year earlier, to the previous date range of the same length, or to a custom period. You can also select the comparison type: change from the comparison period in percent, change in absolute terms, or the value from the comparison period.

Screen Shot 2014-05-12 at 16.16.24 

With this feature, you can easily get data like “top 10 rising traffic sources”. Just set a “Compare to” period, and under Options, set sort by the comparison values. You can use the “# of rows to fetch” setting in the Split by tab to get the top 10 rows, and additionally you can set a filter, for example to get only traffic sources sending at least 50 visits.

Screen Shot 2014-05-13 at 9.02.44

When you run the query you’ll get something like this:

Screen Shot 2014-05-13 at 9.14.07 

Dynamic custom date ranges

Custom date ranges are now much more flexible. Instead of just using the calendar to pick a fixed date range, you can type any date reference accepted by PHP’s strtotime function. Some possible values include:

  • “today”, “yesterday”
  • “first day of this month”, “last day of last month”, “first day of -2 month”
  • “first day of this year”, “first day of last year”
  • “last monday”
  • “-30 days”

When you use relative date reference like the above, the date range is updated every time you refresh the query. You can use these relative date references for both the query date range and the comparison date range. 

Screen Shot 2014-05-13 at 9.21.17

 

Multiple Google Analytics segments in one query

You can now run queries with more than one GA segment. Simply use the Segment tab to pick several segments and run the query. If you want to see the results separately for each segment, use the Split by tab to split the results by segment name or ID; otherwise the add-on will return the sum of all included segments.

Screen Shot 2014-05-13 at 9.42.37

And you’ll get something like this:

Screen Shot 2014-05-13 at 9.45.10

Automatic refresh and PDF emailing – still waiting for Google to let us do it

Everyone’s asking when it will be possible to schedule automatic query refreshing and emailing of results. We would love to add this functionality and have everything ready on our side, but we need Google to allow add-ons to add time-based triggers. This should be coming at some point soon. If you want to push Google to do this, please add a star to this Google Apps Script feature request.

Get the new version

To get the lastest version of the add-on with the above-mentioned improvements, simply reload the document or spreadsheet and launch Supermetrics from the Add-ons menu. If you don’t see Supermetrics there, you can install the add-on using either of these links:

One Response to “Date range comparisons and multi-segment queries in Supermetrics for Google Docs”

  1. Michael Davis

    Is there any way to change the default legend item to a custom name instead of “Comparison Value” when using this feature? Thanks!

    Reply

Leave a Comment to Michael Davis

  • (will not be published)