How can I help? Email: support@analyticsedge.com
Function Wizards (filter at right)
* Analytics Edge Desktop App
How can I help? Email: support@analyticsedge.com
The Analytics Edge Desktop App is a standalone application that provides spreadsheet report automation to both Google Sheets and Excel files on Windows or MacOS computers.
* App Changelog
Most recent release listed first. Install latest release over previous release should update existing installation saved credentials and settings.
1.0.0.0 – 20231124 – initial production release
0.9.33.0 and earlier – these early release versions are not considered suitable for daily use.
* App Orientation
When you open a file, the App interface mimics a typical spreadsheet application, with a menu bar, a strip to display or edit cell contents, a worksheet display area, and a task pane area.
* 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 Orientation
The Analytics Edge Add-in for Excel 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
* 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
* LinkedIn Ads Help
To get started with the LinkedIn Ads connector, add an account, then create a new Reports query. On the Analytics Edge ribbon bar, click the LinkedIn Ads 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
* Mode: AE Macro
With this option, you can record a sequence of functions that can easily be edited and refreshed. Macros are created and edited using the Task Pane located to the right of the sheet. More
* Mode: Interactive
Choosing the Mode on the Analytics Edge ribbon lets you decide if you want a macro function or connector function to start an Analytics Edge Macro, a Quick Query, or simply run the function once (Interactive). More
* Mode: Quick Query
Available only for connector queries, selecting this option targets a new, refreshable query to be written to the selected worksheet/cell. After the query runs you will be presented with optional Quick Functions wizard. Intermediate results are visible in the ‘ᴁ Step Results’ worksheet behind the wizard. When you are ready, click the Write to Worksheet button to write the results to the originally selected worksheet/cell location. 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.
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
2 Your First Google Analytics Query
Make your first Google Analytics query (be sure to create an Account entry first). 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 – 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
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
AdWords-to-Ads Conversion Help
The Google AdWords API will stop working April 27, 2022. All queries using that API must be converted to use the new Google Ads API. In Analytics Edge, there is a new Ads Report (vs the legacy AdWords Report) wizard. 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
Append To Worksheet
Append to the existing data in a worksheet, aligning columns to match. 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
The Bulk Query wizard in the GA Pro connector was created before Quick Queries were added to the Core Add-in. The purpose was to expose a user-editable query configuration worksheet so more-advanced users could edit individual query parameters manually. That functionality is now possible by using Quick Queries. The Bulk Query remains in the connector for backward compatibility. 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
Chrome UX Report
Get one or more Chrome UX Report results from the Chrome UX API [may be quota limited]. More
Columns Tab
This Analytics Edge wizard lets you select the Facebook Ads Insights metrics you want. More
Compare (old)
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
Convert
This Analytics Edge wizard is used to convert columns from one data type (text, number, or date) into another. It can also convert to a variant of the same type, like converting dates to first of the month. Typically used to force imported data into the correct type (such as dates with odd formats), it can also be used to convert dates and numbers into specific formats for reporting purposes. More
Convert (old)
This Analytics Edge wizard is used to convert columns from one data type (text, number, or date) into another. It can also convert to a variant of the same type, like converting dates to first of the month. 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
Date Format (old)
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