Analytics Query Tool

The ShufflePoint Analytics Query Tool is based on the Analytics Query Language (GAQL), and is used to create refreshable Excel® and PowerPoint® documents. It is also used to generate Google™ Gadget data source URLs. See the Quick Start Guides below for details.

Related Quick Start Guides

• GA with Excel using IQY Files - Mac® and Windows®
• GA with Excel using Web Queries - Windows Only
• GA with iGoogle
• GA with Google Gadgets
• GA with PowerPoint

The Analytics Query Tool has four main work areas or panels, which are briefly described below.

Sources

The panel on the left contains the drag-and-drop “Sources”. The possible sources are categorized as “Metrics”, “Dimensions”, and “Profiles”. The sources are drag-and-dropped onto the target lists described below. See Sources for more details.

Targets

The panel at the top right contains the drag-and-drop “Targets”. The possible targets are “Columns”, “Rows”, “Cells”, and “Profiles”. This panel also contains settings for the query “Timeframe” and “Row” limit. See Targets for more details.

Query Tab

The panel in the middle right contains brief instructions and the GAQL query being constructed. Click on the “Query” tab to view or modify the query. See Query for more details.

Excel IQY Files Tab

The panel in the middle right also contains an Excel tab used for generating IQY files. See Excel IQY Files for more details.

Google Gadgets Tab

The panel in the middle right also contains a Google Gadgets tab used for generating gadget data source URLs. See Google Gadgets for more details.

Results

The panel at the bottom contains a grid with the query results. The options available depend on how the query tool is being used. See Results for more details.