Save time generating Excel reports
Create one spreadsheet template report for use with multiple Google Analytics profiles and timeframes.
Use IQY files
Import Google Analytics data into an Excel cell range using a datasource file.
These cell ranges can then be bound to charts and formatted tables.
The advantages of IQY files are:
- Excel IQY files are supported on both Mac and Windows
- Queries can be place in Excel cells for clarity and manageability
- Flexible control over access
View IQY QuickStart
Compare Google Analytics Profiles
Define a single query for multiple profiles, making it easy to compare the performance of all your profiles.
Use Web Queries
Web Queries created within Excel are only supported on Windows.
The advantages of IQY files are:
- Data refresh requires login
- No datasource file necessary
View Web Query QuickStart