Analytics Query Tool - Excel IQY Files
Overview
Excel IQY files are supported on the Mac and Windows, and are used to dynamically import Google Analytics data through ShufflePoint into an Excel cell range. These cell ranges can then be bound to charts and formatted tables. Spreadsheets built with IQY files can be shared without sharing the IQY file. There are several ways to use IQY files, and the method you choose will be based on your needs.
NOTE: Use the “Key Generator” link on your My ShufflePoint page to generate keys for use with IQY files.
- for Excel on Windows (save to 'My Document/My Data Sources' *)
- for Excel on Macs (save to 'Microsoft Office X/Office/Queries' *)
* Or save in the directory that Excel defaults to when adding Web Queries. Within Excel click Data / Import External Data / Import Data and note the location.
For detailed instructions read Quick Start - Google Analytics with Excel using IQY Files.
“Place query in” setting
Spreadsheet
Each new Web Query in Excel will have a “query” Parameter. Use this approach to maintain queries within the spreadsheet. This approach has the advantage of having the queries visible in the spreadsheet.
To obtain a query which can be pasted into an Exce cell, use the “Copy to Clipboard” button on the Analytics Query Tool's “Query” tab.
IQY File
The query will be embedded within the IQY file. Use this approach if your query exceeds the 256 character limit of an IQY parameter.