This article describes some of the more advanced techniques used to create the free Excel workbook Google Analytics Monthly PDF Report. More
How To Guides (filter at right)
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
Unsampled Data From Google Analytics For Free
Wondering how to get unsampled data from Google Analytics into Microsoft Excel? The Free Google Analytics Connector included with all Analytics Edge Add-ins has the ability to minimize sampling problems with large sites and long time frame queries (up to a million rows!). 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