* Analytics Edge Basic Add-in

Welcome to the Analytics Edge Basic Add-in! Get ready for some simple Excel report automation. Just register the add-in, add an account, and start making your queries! More

* Analytics Edge Core Add-in

Welcome to the Analytics Edge Core Add-in! Get ready for some simple Excel report automation. Just register the add-in, add an account, and start making your queries! More

* Analytics Edge Standard Add-in

Welcome to the Analytics Edge Standard Add-in! Get ready for some simple Excel report automation. Just register the add-in, add an account, and start making your queries!  More

* Bing Ads Help

The Bing Ads Connector for Analytics Edge makes it possible to download data directly from the Bing Ads API into Microsoft Excel. More

* Bing Webmaster Help

bingThe Bing Webmaster Tools Connector for Analytics Edge makes it possible to download data directly from the Bing Webmaster Tools API into Microsoft Excel. More

* Constant Contact Help

The Constant Contact Connector for Analytics Edge makes it possible to interact directly with the Constant Contact API, automating your downloads and updates. More

* Core Add-in Orientation

The Analytics Edge Core Add-in is simply different — it is designed to make it easier (and a lot faster) to refresh an Excel report, so it is worth taking a few minutes to see how it works before you dive in.  More

* Facebook Ads Help

The Facebook Ads Connector for Analytics Edge makes it possible to automate your Facebook Ads Insights downloads into Microsoft Excel. Get just the metrics you want, formatted for use in Excel. More

* Facebook Help

The Facebook Connector for Analytics Edge makes it possible to automate your Facebook Insights downloads into Microsoft Excel. Get just the metrics you want, formatted for use in Excel. More

* GA Management Help

This release of the Google Analytics Management connector is early in the product development lifecycle. It does not have all of the planned features implemented, nor has it been extensively tested. USE WITH CAUTION. More

* Google AdWords Help

The AdWords Connector for Analytics Edge makes it easy to download Google AdWords data directly into Microsoft Excel. More

* Google Analytics Help

google-analytics-pro-menuThe 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

* Google Search Help

The Google Search Connector for Analytics Edge makes it easy to download Google Search Console data directly into Microsoft Excel. More

* MailChimp Help

menuThe MailChimp Connector for Analytics Edge makes it easy to download your MailChimp campaign and list information into Microsoft Excel. More

* Moz Connector Help

moz-menuThe Moz Connector for Analytics Edge makes it easy to automate downloads from Moz directly into Microsoft Excel. More

* Salesforce Help

salesforce-menuThe Salesforce Connector for Analytics Edge makes it easy to download Salesforce data directly into Microsoft Excel. More

* Shopify Help

shopify-menuThe Shopify Connector for Analytics Edge makes it easy to download your Shopify data directly into Microsoft Excel. More

* Your First Macro (video)

Most people use Analytics Edge to download data from one of the connectors into Excel. This video shows how to create a macro that can contain multiple queries. More

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

Active table in memory?

read-worksheet-resultsWhat is this green worksheet with the message “ANALYTICS EDGE – active table in memory…”? When you are editing a query or stepping through an Analytics Edge macro, a green worksheet will appear (AE Step Results). This temporary worksheet shows you what it is currently in memory — the results of the last function step — before you formally write it out to a worksheet. More

Activity for the Latest MailChimp Campaign

With the MailChimp Connector, Analytics Edge lets you automate more than just a data download – it lets you create a finished report that you can refresh with just a click. In this article, we’ll show how one click can get you a subscriber activity report for the most recent MailChimp campaign. More

Build an Email Cohort Analysis

This article explains how to build a cohort analysis report in Excel using the Analytics Edge Core Add-in with the Constant Contact connector. Cohort Analysis lets you see how one group of subscribers behaves differently from another. 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

Building a Multi-Site Report

With the Analytics Edge Core Add-in for Excel, you can easily build a multi-website report, quickly and without programming. This article and the attached sample workbook show how easy it can be. More

Constant Contact Report Automation

branded-report-example (1)With Analytics Edge, your reporting gets a whole lot easier with single-click refreshes, and you don’t lose any of the flexibility that makes Microsoft Excel so popular for Constant Contact reporting. Here’s an example of one engagement that went from idea to “This is AMAZING!!” in 24 hours. More

Download All Your Page And Query Data

Downloading your Google Search Console data into Excel is easy with Analytics Edge. The Google Search Connector uses the API to pull down all of the query and page metrics — without the 1000 row limit imposed by the web interface. More

Downloading Constant Contact Click-Through Data

Downloading Constant Contact click-through data for multiple clients has never been easier than with Analytics Edge and the Constant Contact connector. This article describes the process in detail, so you can get the job done fast! More

Get Queries for All Top Pages

Here’s a short video showing how easy it is to download the Google Search queries for each of your top pages using the Analytics Edge Core Add-in and Google Search connector: less than 5 minutes of work, and no programming! More

Get Top Queries for Selected Pages

Similar to the Queries for Top Pages report, this article details the steps to create a custom report grabbing the top 5 queries for a selected set of pages [Requires the Analytics Edge Core Add-in and the Google Search Connector]. More

Get Top Sources for Top Landing Pages

This video shows how easily multiple queries can be created and the results combined to produce a detailed report, in this case, grabbing the top sources for each of the top landing pages on your site. More

Google Search Trends Reporting

With the release of v4 of the Analytics Edge Google Search connector, you can now easily get week-to-week or month-to-month reporting in a single command. More

Hacking the Query Worksheet

The current release of the Analytics Edge Basic Add-in and Standard Add-in allows you to directly edit a worksheet containing all of the query details. This is an advanced topic with limited support. More

ISO Week Reporting

When a connector (API) does not offer the ability to make weekly reports based on international or ISO weeks (Monday to Sunday), you can use the Analytics Edge Core Add-in‘s Repeat Macro functionality to fill in the gap. More

Long-Tail Keyword Analysis (Advanced Example)

Long-tail keyword phrases are often made up of many different combinations of similar words, making it difficult to tell when there is a common topic of interest. This article walks through the creation of a keyword analysis report, based on weekly snippets of data from Google Search Console. More

Manually Scheduling a Refresh

If you want to refresh a workbook more than once a day, or if you simply want to control the refreshes yourself, this article shows how the Analytics Edge Core Add-in and Standard Add-in interacts with the Windows Task Scheduler app. 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

Optional Connectors

Analytics Edge has a variety of connectors available. They can be installed, updated and uninstalled using the License wizard. When you add a paid connector, it automatically starts a 30-day free trial period. More

Running Macros from Buttons

With v2.6.0 of the Analytics Edge Core Add-in, it is now possible to run a specific Analytics Edge macro from a button on your worksheet (the Analytics Edge Core Add-in must be installed). More

Running Macros from VBA

With Analytics Edge Core Add-in v2.7.2 and higher, you can run an Analytics Edge macro (e.g. “MyMacro”) from Visual Basic for Applications (VBA), using code More

Running Queries from Buttons

With v2.0.0 of the Analytics Edge Standard Add-in, it is now possible to run a specific Analytics Edge query from a button on your worksheet (the Analytics Edge Standard Add-in must be installed). More

Terminology

The Analytics Edge Core Add-in uses some common Microsoft Excel terminology, but the meanings are slightly different. 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 Functions in Macros

The real power of the Analytics Edge Core Add-in are the other functions that let you sort, filter or pivot your data. You can convert text to dates, and dates to first-of-the-month. More

Using the Append Function

append4-300x230The Analytics Edge add-in lets you easily append data from one table to another, aligning the common columns but appending the new rows to the bottom. More

Using the Combine Function

combineThe Analytics Edge add-in lets you easily combine data from two tables, aligning the common rows in key columns, and aggregating the cell values in other columns. More

Using the Compare Function

compareThe Analytics Edge add-in lets you easily compare data from one table to another, calculating growth or change in numbers as well as time differences in dates. More

Using the Repeat Macro Function

repeatmacroThe Analytics Edge Core Add-in v2.20 included an enhancement to the Repeat Macro function, making it easier to reports that combine a series of queries with one refresh. 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

Write the Results into Excel

The Analytics Edge Core Add-in is holding your query results in memory, where you can easily manipulate it with other Analytics Edge functions. When you are ready, you will want to write the results into an Excel worksheet. More