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.
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.
When you run the query you’ll get something like this:
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.
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.
And you’ll get something like this:
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: