ShufflePoint integrates Excel with Google Analytics using Excel's “Web Query” feature. Web queries associate a web based data feed with an Excel cell range, which can be bound to charts and formatted tables. No more copy and paste! All queries can be refreshed at once. No add-ins or macros required.
Download the ShufflePoint IQY file for Windows or Mac and immediately begin defining your queries. Create a single spreadsheet template and reuse it for multiple profiles and timeframes. Once created, the entire spreadsheet can be refreshed at once. Safely distribute non-refreshable copies of your reports with ease.
Queries are defined using our language AQL (see our Analytics Query Language listing). AQL, which is similar to SQL, provides many features that simplify reporting web analytics data such as:
- Named timeframes and timeframe comparisons
- Page name mapping to present renamed pages consistently
- Filtering that exposes the full API capabilities
- Named and dynamic segments
- Multiple profiles in one query for easy comparisons
- Common web analytics calculations
- Many more ...
Combine the power of AQL, Excel, and Google Analytics to create web analytics dashboards and reports.
This app accesses data securely using
AuthSub, OAuth or Open ID.
(2)
Comments (1)
Analytics
The best excel integration for GA
- Larry - Dec. 20, 2010
Test-driven several excel solutions and this one wins hands-down. This is the only solution I found with all of the following: - No add-ons: Uses the existing functionality in Excel, so I can easily share reports without the need to install anything. - Rolling date ranges: If I want a data block that always returns the last 30 days, I can specify that and never have to manually enter dates again. - SAMPLED DATA BEGONE! SP queries isolated dates. No mucked up sampled data!
Best Excel Solution
- Ophir Prusak - May 18, 2010
I needed a simple solution that did *not* require any add-ins or macros so I could sen an excel file to my client which they could update themselves. ShufflePoint was the only solution I found that did this, as it's really a service, not a product. Because of this they're constantly upgrading the feature set and the support is phenomenal.