The Analytics Edge Core Add-in has a Free license option, and it includes a Free Google Analytics Connector. There are no account restrictions, no query restrictions, and the product is updated, maintained and supported. To keep it that way, I need your help to SPREAD THE WORD! Twitter, Facebook, Reddit, at conferences, in meetups, or just mention it over a beer with colleagues. More
Helpful Articles (filter at right)
Analytics Without Programming
Avoid complex Excel formulas; Analytics Edge lets you build reports in Excel without complicated formulas or programming. Using a simple wizard interface, this small Excel add-in lets you combine, calculate, split, pivot, sort, filter and much more. Try it yourself and see how easy it is! More
Automated Email Campaign Reporting
Several Constant Contact Solution Providers use the Analytics Edge Core Add-in for Microsoft Excel to automate their clients’ campaign reports. More
Challenges with Annual Reporting
It’s that time of year again, time to summarize the performance of your website, search engine optimization efforts, and campaign spending. As you start your marathon of data manipulation, there are a few things you should keep in mind to avoid disaster. More
Combine Google Analytics, Webmaster Tools and Moz Data
Analytics Edge makes it easy to combine data from different sources in the same report. This article describes one of our free workbooks that combines data from Google Analytics with Google Webmaster Tools and Moz. More
Custom MailChimp Multi-Campaign Reports
A flurry of interest in the Analytics Edge MailChimp connector over the past few weeks has made me realize that most of the email marketing automation examples I have posted have focused on the Constant Contact connector. More
Data Sampling Problems In Annual Reports
Google Analytics uses statistical sampling to improve responsiveness for large queries. There is nothing wrong with statistical sampling — it will usually produce numbers close to the actual, but not always. More
Error: Workbook may contain Analytics Edge macros
if you get the popup error:
Workbook may contain Analytics Edge macros that your license can’t access
or
Workbook contains Analytics Edge macros you cannot run without a Premium license More
How To: Email Campaign Domain Analysis
Find out how your email campaigns are performing with particular domains, so you can see which ISPs your subscribers use most often, and detect if you’re having delivery or compatibility problems. More
Misunderstood Metrics: Average Position
Google Search Console makes it easy to track the position of your website pages in Google’s search results, but the numbers are averages, and averages don’t tell the whole story. When it comes to search engine ranking, they can be really misleading. More
Sending Excel Reports To Clients
Many analysts, consultants and agencies use Excel to create reports for their clients because it allows them to deliver a unique solution, tailored to the client’s needs. By using Analytics Edge to generate and automate the report refresh, the monthly process becomes a lot easier and doesn’t require any changes to the client’s environment. More