The Analytics Edge connector for Google Analytics comes in 2 variants: Free and Pro. They share the same account and configuration files, so it is possible to switch between them or to start with the Free version and upgrade to the Pro without having to rebuild your reports. More
How To Guides (filter at right)
02 Add an Account
Once you have installed and activated the trial for the Google Analytics connector, you need to log in to your Google Analytics account. More
03 Your First Query
Make your first Google Analytics query (be sure to create an Account entry first). More
1 Basic Add-in Orientation (video)
See how easy it is to get your Google Analytics data in Excel! More
Advanced Techniques: the Monthly PDF Report
This article describes some of the more advanced techniques used to create the free Excel workbook Google Analytics Monthly PDF Report. More
Building a Cohort Analysis
This article explains how to build a cohort analysis report in Excel using the Analytics Edge free Google Analytics connector. Cohort Analysis lets you see how one group of people behaved differently from another. More
How the Blog Cohort Analysis Macro Works
If you’re trying to use the free report Cohort Analysis for Blog Articles, but don’t have the same blog path, here’s a behind the scenes look at how the macro was made so you can adapt it to your own article path. More
Multi-Source Waterfall Report
The wizard-based automation provided by the Analytics Edge Core Add-in for Excel makes it easy to combine data from multiple sources. This article explores how you can build a Waterfall Report that includes data from Google Webmaster Tools (now Google Search), Bing Webmaster Tools, Google Analytics and an external database. More
Multi-View Queries [Core Add-in]
The Pro version of the Analytics Edge connector for Google Analytics can be used to query multiple profiles/views at once. To do this, you need the Analytics Edge Core Add-in. More
Spam-Free Reporting With Dynamic Segments
Google Analytics has had a bit of a referral spam problem over the past year, and although you can install filters in your account to prevent most of it (see the Definitive Guide to Removing GA Spam), you can’t apply them retroactively. More
Tracking Multiple Websites
If you have multiple websites that you manage, and struggle to keep an eye on all of them at once, here’s how to create a quick report to compare their day-to-day traffic at a glance. More
Using the Save Filter Function
The Google Analytics Pro connector contains a Save Filter function that lets you copy view filters from one account to a number of others with ease. More
Year-Over-Year Comparison in One Query
Here’s a neat little technique you can use to get year-over-year comparisons in one query with the Google Analytics Pro connector from Analytics Edge. More
Year-Over-Year Reporting
If you are trying to build a Google Analytics report comparing one year to the previous one, you can use the Pivot operation to make charting easier. The trick is to choose your dimensions wisely. More