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 Core Add-in
How can I help? Email: support@analyticsedge.com
First Steps: Installation Activation Add Connectors
New ‘Mode’ options on the ribbon:
- interactive – execute a query or function just once (not refreshable)
- Quick Query – execute a single (refreshable) query that writes to the selected cell
- AE Macro – automate multiple query and analysis steps without formulas or coding
Quick Start: 1. Add Your Accounts
Each connector is a little different, but most require that you add an account before you can make a query.
See the connector help documents for details.
Google Analytics | Google Search | Google AdWords | Bing Ads | Facebook Ads | Facebook Insights
Quick Start: 2. Quick Query
- Select the cell where you want your query results
- On the Analytics Edge ribbon, select the Mode ‘Quick Query’
- Select Free Google Analytics > Analytics Report or pick another connector function
- Select a standard report or pick the desired options in the connector wizard.
- Click Finish to run the query.
- [Premium License] In the popup Quick Functions wizard, click the Write to Workbook button.
Repeat the operations above to place other queries in your workbook.
Build a report of your own, here’s some general guidance and a free sample to get you started fast:
Video Example: Using the Google Analytics Connector
- Add an Account with the Account Wizard.
- Select the target worksheet cell.
- Make your query.
Follow a similar process for other connectors: Google Search, Facebook Page Insights, Bing Webmaster Connector, Moz Connector
The More You Know, The Easier It Gets
Welcome to Analytics Edge
Analytics Edge makes it easy to get your data into Microsoft Excel. You can place multiple queries anywhere in your workbook as this video explains.
Help Resources Available
The Analytics Edge help site has plenty of resources available for learning and assistance with reporting. This video explains what is available and highlights the ‘account not found’ problem people experience when sharing workbooks.
Reproducing Standard Reports
This video reviews the common problems that people have when trying to reproduce standard web reports in Microsoft Excel using Analytics Edge.
Creating Custom Reports
Analytics Edge was designed to create the customized reports people need for their website or campaign tracking needs. This video explains the common errors you may run across and what you can do about them.
Licenses and Updates
This video explains how Analytics Edge products are licensed and updated. It demonstrates how to identify updates available and how to install them.
* 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 Ads Help
To get started with the Google Ads connector, just add an account, then make your queries! On the Analytics Edge ribbon bar, click the Google Ads 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
The Google Ads Accounts wizard is used to add, refresh or delete saved accounts for use by the Google Ads connector. Click the Add Account button to start a new login sequence. An Account Login wizard will open, as well as a browser window should for you to log in to Google Ads. If the browser windows does not open, follow the instructions in section 1 of the Account Login wizard to start the login process.
More
Accounts
The LinkedIn Ads Accounts wizard is used to add, refresh or delete saved accounts for use by the LinkedIn Ads connector. Click the Add Account button to start a new login sequence. An Account Login wizard will open, as well as a browser window should for you to log in to LinkedIn. If the browser windows does not open, follow the instructions in section 1 of the Account Login wizard to start the login process. 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 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
Ads Reports (New)
This wizard for the Google Ads connector lets you make a query to the Google Ads API to download your data. [available in v3.0+] 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
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. Date Format
Analytics Edge supports Microsoft .NET Framework date format codes which are slightly different from Excel date format codes. The common variants are listed below, but see the references at the end for a full listing. More