Analytics Edge provide 2 connectors for Google Analytics: Free and Pro. For many people, the Free Google Analytics connector is all they need. The Pro connector provides many extra features, including full support for GA 360 customers. This article describes the differences in more detail.
Function Wizards (filter at right)
* Analytics Edge Basic Add-in
2020-01-25 The Analytics Edge Basic Add-in has been merged into the Analytics Edge Core Add-in (Free license option). The Basic Add-in itself has been discontinued and is no longer available.
Existing users should install the latest release of the Core Add-in and select the Free license option
* Analytics Edge Standard Add-in
2020-01-25 The Analytics Edge Standard Add-in has been merged into the Analytics Edge Core Add-in (Standard license option) for existing licensed users only. The Standard Add-in itself has been discontinued and is no longer available.
Existing users should install the latest release of the Core Add-in and select the Free license option
* 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
The 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 Operation: Queries vs Macros
The Analytics Edge Core Add-in supports both Quick Queries and Macro. Quick Queries are available with the Free license option, but Macros are only available with the Premium license.
* Facebook Ads Help
To 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
* 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
To 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
The MailChimp Connector for Analytics Edge makes it easy to download your MailChimp campaign and list information into Microsoft Excel. More
* Moz Connector Help
The Moz Connector for Analytics Edge makes it easy to automate downloads from Moz directly into Microsoft Excel. 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 License button.
* Salesforce Help
The Salesforce Connector for Analytics Edge makes it easy to download Salesforce data directly into Microsoft Excel. More
* Shopify Help
The Shopify Connector for Analytics Edge makes it easy to download your Shopify data directly into Microsoft Excel. More
* Social Shares Free
This Analytics Edge wizard lets you collect social share counts from various services. More
1 Add a Google Analytics 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
1 Core Add-in Orientation
The Analytics Edge Core Add-in is designed to make it easier and a lot faster to create, edit, and refresh a custom Excel report. Like Excel, you can quickly get good value out of it, but the more you learn, the more value you can obtain. More
2 Your First Google Analytics Query
Make your first Google Analytics query (be sure to create an Account entry first). More
2 Your First Quick Query (video)
Most people use Analytics Edge to download data from one of the connectors into Excel. This video shows how to create a Quick Query to do just that. More
3 Example of Macro Capabilities (video)
This video shows the entire process to create a custom report with Google Search Console data using the Analytics Edge Core Add-in. See how easy it is to work step-by-step using simple wizards to produce a report combining multiple queries and unique calculations. 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 – Bing Ads
For security reasons, Analytics Edge stores your account information on your computer, not in the workbooks. More
Accounts – Constant Contact
This wizard is used to authorize Constant Contact login accounts to be used by the various queries. More
Accounts – Facebook Ads
Use this wizard to log in to your Facebook Ads account and authorize Analytics Edge to access your data. More
Accounts – Facebook Insights
Use this wizard to log in to your Facebook account and authorize Analytics Edge to access your data. More
Accounts – Google AdWords
For 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 – Google Analytics
Use this wizard to log in to your Google Analytics account and authorize Analytics Edge to access your data. [Updated for the latest release of the connector 2019-10-18] More
Accounts – Google Search Console
For 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.
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
Use 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 – Salesforce
Enter your Salesforce Account here.
Accounts – Shopify
Enter 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 premium connectors are automatically licensed for 30 days, no payment required. More
Analytics Reporting – Dates
Use this Analytics Edge wizard to establish the date range for the report. More
Analytics Reporting – Dynamic Segments
Analytics Edge makes it possible to create dynamic segments using a a wizard interface similar to that in the web version of Google Analytics. More
Analytics Reporting – Fields
Use this Analytics Edge wizard to select the dimensions and metrics to be retrieved in the query. More
Analytics Reporting – Filters
Use this Analytics Edge wizard to define filters to use with the query. More
Analytics Reporting – Options
The Options tab provides access to several options that affect how the Google Analytics data is presented in Excel. More
Analytics Reporting – Output
The 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 – Reports
The Reports tab lets you quickly select common dimension and metric combinations that you can use as-is or use a starting point for a custom report. More
Analytics Reporting – Segments
This 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
Use 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
Analytics Reporting – Views
Use this Analytics Edge wizard to select the Login account and the reporting View to use for the query. More
Anchor Text
This Analytics Edge wizard returns information about anchor text for inbound links. [Paid Moz API access required] More
Append To Worksheet
This Analytics Edge wizard is used to append the current table of data to an existing worksheet. More
Attributions
This Analytics Edge wizard lets you pick different attribution windows for your Facebook Ads Insights query. More
Automations
Use 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 Export Contacts
Use this wizard to export large numbers of contacts from a specific Constant Contact list. More
Bulk Export Download
Use this wizard to download the results of a delayed bulk export operation. More
Bulk Export Status
Use this wizard to check the status of a bulk export request. More
Bulk Queries – Dates
[Pro connector] Use this Analytics Edge wizard to establish the date range for the report. More
Bulk Queries – Fields
Use this Analytics Edge wizard to select the dimensions and metrics to be retrieved in the query. More
Bulk Queries – Filters
Use this Analytics Edge wizard to define filters to use with the query. More
Bulk Queries – Options
The Options tab provides access to several options that affect how the Google Analytics data is presented in Excel. More
Bulk Queries – Queries
Use this Analytics Edge wizard to select the Query Configuration Worksheet for Bulk (multiple) Google Analytics queries. More
Bulk Queries – Segments
This 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 – Sort
Use this Analytics Edge wizard to select the sort order to use for the query. More
Bulk Queries – Views
Use this Analytics Edge wizard to select the Login account to use for the query, plus the Account, Property, and View. More
Campaign Details
Use this Analytics Edge wizard to get details about a specific Constant Contact campaign. The campaign is identified by the campaign ID number. More
Campaign Reports
Use this Analytics Edge wizard to get reports for a selected MailChimp campaign. More
Campaign Reports – Bounces
Use this wizard to get details about bounced messages for the selected Constant Contact campaign. More
Campaign Reports – Clicks
Use this wizard to get details about clicks for the selected Constant Contact campaign. More
Campaign Reports – Clicks on Link
Use this wizard to get details about specific link clicks for the selected Constant Contact campaign. More
Campaign Reports – Forwards
Use this wizard to get details about forwarded messages for the selected Constant Contact campaign. More
Campaign Reports – Opens
Use this wizard to get details about opened messages for the selected Constant Contact campaign. More
Campaign Reports – Sends
Use this wizard to get details about sent messages for the selected Constant Contact campaign. More
Campaign Reports – Summary
Use this wizard to get summary statistics about the selected Constant Contact campaign. More
Campaign Reports – Unsubscribes
Use this wizard to get details about unsubscribes (opt-outs) for the selected Constant Contact 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
Choose Run Once, Quick Query or Macro
[New in version 10] When you first select a function or connector query, a dialog will pop up allowing you to choose whether you want to start an Analytics Edge Macro, a Quick Query, or simply run the command once without saving it. More
Columns Tab
This Analytics Edge wizard lets you select the Facebook Ads Insights metrics you want. More
Compare
This Analytics Edge wizard is used to compare the current table with another, computing the difference between matching rows.
Also: Using the Compare Function More
Contact – Add Contacts
Use this wizard to add contacts to your Constant Contact account. More
Contact Details
Use this wizard to get details about a specific contact in your Constant Contact account. More
Contact Listing
Use this wizard to get the contacts for a specific Constant Contact account. More
Contact Report – Bounces
Use this wizard to get details about the bounces of a selected contact (email address) in Constant Contact. More
Contact Report – Clicks
Use this wizard to get details about the clicks of a selected contact (email address) in Constant Contact. More
Contact Report – Contact Activities
Use this wizard to get details about the activity of a selected contact (email address) in Constant Contact. More
Contact Report – Forwards
Use this wizard to get details about the forwards of a selected contact (email address) in Constant Contact. More
Contact Report – Opens
Use this wizard to get details about the opens of a selected contact (email address) in Constant Contact. More
Contact Report – Sends
Use this wizard to get details about the sent campaigns for a selected contact (email address) in Constant Contact. More
Contact Report – Summary
Use this wizard to get details about the summary actions of a selected contact (email address) in Constant Contact. More
Contact Report – Summary by Campaign
Use this wizard to get details about the summary by campaign id of a selected contact (email address) in Constant Contact. More
Contact Report – Unsubscribes
Use this wizard to get details about the unsubscribes of a selected contact (email address) in Constant Contact. More
This Analytics Edge wizard lets you download the list of customer ids for your account.