Analytics Query Language

ShufflePoint integrates Google™ Analytics using our powerful Analytics Query Language (AQL) and an intuitive drag-and-drop Analytics Query Tool. AQL, which is similar to SQL, provides many features that resolve issues related to consistently reporting web analytics data.

The query tool is used to create and run AQL queries, generate IQY files for Excel®, and create URLs for iGoogle, Google Earth, Google Maps and Google Gadgets. ShufflePoint supports all of the features of the GA V2 API.

Going beyond the raw GA API

Generic timeframe and comparison

AQL supports generic timeframes such as “Last30Days”, making query reuse possible. Two timeframes can also be specified to generate a comparison result set in one step.

Formatting and sorting

AQL syntax includes a format function that allows you to build strings with embedded results for use within PowerPoint or Excel. It also supports sorting and limiting results to a specified number of rows.

Sophisticated filtering

AQL supports filter expressions to limit the data returned, either by metric value thresholds or by dimension member values. AQL passes these filter expressions directly to Google, so AQL will always be up-to-date in this regard.

Compare multiple profiles

When more than one profile is specified in a AQL query, the results are autmoatically correlated and presented in a single result set, making it easy to compare your sites.

Built in calculations

AQL makes it easy to obtain standard results such as metric percentages and dimension counts. Common calculations are also presented as selectable metrics, greatly simplifying the creation of usable statistics.

Data consistency

All web sites change over time as pages are added, renamed, or moved. AQL makes it possible to combine these results into a consistent result set through a built in mapping feature, improving data quality.

sign up for a free 7 day trial