* 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

To get started with the Bing Ads connector, just add an account, then make your queries! On the Analytics Edge ribbon bar, click the Bing Ads button and select the Accounts menu item.
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

* Facebook Ads Help

ribbonTo get started with the Facebook Ads connector, just add an account, then make your queries! On the Analytics Edge ribbon bar, click the Facebook Ads button and select the Accounts menu item. More

* Facebook Insights Help

To get started with the Facebook Insights connector, just add an account, then make your queries! On the Analytics Edge ribbon bar, click the Facebook Insights button and select the Accounts menu item. 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

To get started with the Google AdWords connector, just add an account, then make your queries! On the Analytics Edge ribbon bar, click the Google AdWords button and select the Accounts menu item. More

* Google Analytics Help

google-analytics-pro-menuTo get started with the Google Analytics connector, just add an account, then make your queries! On the Analytics Edge ribbon bar, click the Google Analytics button (Free or Pro) and select the Accounts menu item. More

* Google Search Help

To get started with the Google Search Console connector, just add an account, then make your queries! On the Analytics Edge ribbon bar, click the Google Search button and select the Accounts menu item. 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

* Register the Basic Add-in

Before you can use an Analytics Edge add-in, it needs to be registered. In Excel, on the Analytics Edge ribbon bar, click the Register button. Note: the button will change to “License” if the add-in is already registered. More

* Register the Core Add-in

Before you can use an Analytics Edge add-in, it needs to be registered. In Excel, on the Analytics Edge ribbon bar, click the Register button. Note: the button will change to “License” if the add-in is already registered. More

* Register the Standard Add-in

Before you can use an Analytics Edge add-in, it needs to be registered. In Excel, on the Analytics Edge ribbon bar, click the Register button. Note: the button will change to “License” if the add-in is already registered. 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

Account Information

This wizard (actually the bottom of the Constant Contact Accounts wizard) is used to get information about a Constant Contact account you have authorized. More

Accounts – Google AdWords

ad-accountsFor security reasons, Analytics Edge stores your account information on your computer, not in the workbooks. Accounts are stored using Reference names, and the queries use a Reference name to identify which account to use. More

Accounts – MailChimp

Use this Analytics Edge wizard to log into your MailChimp account. This authorizes the Analytics Edge MailChimp connector for access to your account data. More

Accounts – Moz

accountUse this Analytics Edge wizard to enter your Moz account credentials. Using the Mozscape API requires that you get an Access ID and Secret Key associated with your Moz community login. More

Accounts – Shopify

accounts-shEnter a name for your Shopify account, and the web address for your shop, then click the Add Account button. More

Adding Connectors

Connectors are installed from inside the Add-in itself — in Excel, on the Analytics Edge ribbon bar, click the License button. All paid connectors are available free for 30 days, no payment required. More

Adding Connectors

Connectors are installed from inside the Add-in itself — in Excel, on the Analytics Edge ribbon bar, click the License button. All paid connectors are available free for 30 days, no payment required. More

Adding Connectors

Connectors are installed from inside the Add-in itself — in Excel, on the Analytics Edge ribbon bar, click the License button. All paid connectors are available free for 30 days, no payment required. More

Adding Queries

The Analytics Edge Basic Add-in makes it easy to download data to your workbook. Just select the cell where you want the results put, then open a connector query wizard. When you click Finish, the results are written into Excel. More

Adding Queries

The Analytics Edge Standard Add-in makes it easy to download data to your workbook. Just select the cell where you want the results put, then open a connector query wizard. When you click Finish and Write to Worksheet, the results are written into Excel. More

Analytics Reporting – Output

outputThe Output tab (available only in the Google Analytics Pro Connector) offers the ability to download direct to a CSV (comma-separated) file instead of returning the results to Excel. More

Analytics Reporting – Segments

segmentsThis Analytics Edge wizard is used to select a predefined Google Analytics segment from your account, or to define a dynamic one to be used solely for this query. More

Analytics Reporting – Sort

sortUse this Analytics Edge wizard to select the sort order to use for the query. Additionally, you can restrict the query to download a limited number of rows i.e. the top 10. More

Anchor Text

anchor-text-1This Analytics Edge wizard returns information about anchor text for inbound links.  [Paid Moz API access required] More

Append

appendThis Analytics Edge wizard makes it easy to merge two tables together, keeping all of the rows and columns of the original tables. More

Append To Worksheet

This Analytics Edge wizard is used to append the current table of data to the end of an existing worksheet. More

Arrange

This Analytics Edge wizard is used to rearrange and/or rename columns in a table. More

Attributions

This Analytics Edge wizard lets you pick different attribution windows for your Facebook Ads Insights query. More

Automations

automationsUse this Analytics Edge wizard to get a listing of the MailChimp Automations running in your account. More

Bulk Export

Use this Analytics Edge wizard to get a bulk export of the subscriber activity for a selected MailChimp campaign. More

Bulk Queries – Segments

ga-bulk-segmentsThis Analytics Edge wizard is used to select a predefined Google Analytics segment from your account, or to define a dynamic one to be used solely for this query. More

Bulk Queries – Views

ga-bulk-viewsUse this Analytics Edge wizard to select the Login account to use for the query, plus the Account, Property, and View. More

Calculate

calculate1This Analytics Edge wizard lets you perform typical math calculations without formulas, including a number of series calculations across rows or down columns. More

Campaign Details

get-a-campaignUse this Analytics Edge wizard to get details about a specific Constant Contact campaign. The campaign is identified by the campaign ID number. More

Campaigns

get-campaignsUse this wizard to get a list of the Constant Contact campaigns in the account. More

Campaigns

campaignsUse this Analytics Edge wizard to get information about all MailChimp campaigns, or about an individual campaign. More

Campaigns/Ads Tab

Use this Analytics Edge wizard to select one of your saved logins, and the Facebook Ad Account, Campaign, Ad Set, or Ad you want to use for this query. More

Columns Tab

This Analytics Edge wizard lets you select the Facebook Ads Insights metrics you want. More

Combine

combineThis Analytics Edge wizard is used to combine two sets of data, merging the values from a worksheet or previously named table. More

Compare

This Analytics Edge wizard is used to compare the current table with another, computing the difference between matching rows. More

Contact Details

get-contactUse this wizard to get details about a specific contact in your Constant Contact account. More

Convert

convertThis Analytics Edge wizard is used to convert columns from one data type (text, number, or date) into another. More

Convert Excellent Analytics

[Only available in the Free Google Analytics connector] Use this wizard to convert existing queries built with Excellent Analytics into Analytics Edge queries. Select the cell below the Excellent Analytics query cell and open the wizard. More

Copy a Query

To make a copy of an Analytics Edge query, make sure the Edit Mode is ON — that places Excel comments (little red triangles) in the cells with queries and cell references.  Then simply copy the comment to another location in the same worksheet, or another worksheet in the same workbook. Click on a worksheet cell to trigger a synchronization of the queries with the new comment locations.

More