ShufflePoint Release History and Notes

New features

weeksToDate timeframe Creates start and end date on calendar week boundaries. Use with ga:week dimension. See AQL doc.

New features

Keyword Envy integration Get your keyword ranking data into reports using AQL queries.

WeeksToDate timeframe Creates a query timeframe for all full calendar weeks for year to date.

Query Shortener Allows all but the longest queries to reside in Excel. Use the "Shorten AQL Query" link on MyShufflepoint.

Bug fixes

You can now run two-timeframe queries in query tool

You can add filter extensions to metrics in a where clause

New features

Query Tool Upgrade Most AQL features now supported by query tool.

Row and Column Totals Add totals in AQL for pivot queries. See AQL doc.

New features

New AdWords dimensions

• ga:adwordsAdGroupId
• ga:adwordsCampaignId
• ga:adwordsCreativeId
• ga:adwordsCriteriaId
• ga:adwordsCustomerId

New GeoRSS and KML feeds for Google Maps and Earth.

Bug fixes

Fixes to two-timeframe outputs

New features

New timeframes have been added

• lastCalendarWeek - last calendar week (Sun-Sat)
• lastCalendarWeek2 - two weeks ago (Sun-Sat)
• thisMediaWeek - current media week (Mon-Sun)
• lastMediaWeek - last media week
• lastMediaWeek2 - two media weeks ago

Dynamic segments now supported

Bug fixes

NoColumnHeaders flag works again

dimension and metric combinations

ga:nextPagePath and ga:previousPagePath are now part of the Content group.

In the query tool, these dimensions will now be found under the Content group.

IQY file change

Access keys are now parameter in a generic IQY, which has several advantages:

• Eliminates complexity of generating your own IQY files
• Key can exist in a single cell instead of being embedded in each query
• Time-limited keys now easy to manage (previously required a macro to update)
• Key can be scoped to GA credential, account, web property, or profile
• “Freeze” report by clearing key cell

Custom variables now supported

The ten Google custom variable dimensions can be used in queries. In addition we have added 5 dimensions sp:customVar[1-5] which report results as <variable>=<value>

Two timeframes now supported

A query timeframe clause may now specify two timeframes. For example:

TIMEFRAME lastMonth, lastMonth2
TIMEFRAME yearToDate, lastCalendarYear

When such a query is used with an Excel IQY file, the result will be that all colums are split into “current”, “previous”, and “change”, where the change column show the percent change between the two periods.

Note: only in Excel IQY results will you observe this new result shaping for two timeframes. In the query tool you will only see the values for the first time period.