* Add-in Orientation

When you install the Analytics Edge Add-in for Excel, a new ribbon bar will appear in Excel. License status is visible on the License button (‘License ok’). Starting with version 11, all connectors are pre-installed but they are still licensed separately.

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

* 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.

More

* Desktop 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.

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

* Licenses

The License wizard for the Analytics Edge Add-in for Excel [and the Analytics Edge Desktop App] provide a single location to manage product configuration and licensing. More

* MailChimp Help

menuThe 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

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 Webmaster Tools

The Accounts wizard is used to manage saved Bing Webmaster Tools accounts for use by the connector. For security reasons, Analytics Edge stores your account information in an encrypted file on your computer, not in the workbook. Accounts are stored using Reference names, and the queries in your workbooks use a Reference name to identify which account to use. More

Accounts – Facebook Ads

The Accounts wizard is used to manage saved Google Business Profile accounts for use by the connector. For security reasons, Analytics Edge stores your account information in an encrypted file on your computer, not in the workbook. Accounts are stored using Reference names, and the queries in your workbooks use a Reference name to identify which account to use.
More

Accounts – Google Ads

The Accounts wizard is used to manage saved Google Ads accounts for use by the connector. For security reasons, Analytics Edge stores your account information in an encrypted file on your computer, not in the workbook. Accounts are stored using Reference names, and the queries in your workbooks use a Reference name to identify which account to use.
More

Accounts – Google Analytics

The Accounts wizard is used to manage saved Google Analytics accounts for use by the connector. For security reasons, Analytics Edge stores your account information in an encrypted file on your computer, not in the workbook. Accounts are stored using Reference names, and the queries in your workbooks use a Reference name to identify which account to use. More

Accounts – Google BigQuery

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 Business Profile

The Accounts wizard is used to manage saved Google Business Profile accounts for use by the connector. For security reasons, Analytics Edge stores your account information in an encrypted file on your computer, not in the workbook. Accounts are stored using Reference names, and the queries in your workbooks use a Reference name to identify which account to use. More

Accounts – Google Search Console

The Accounts wizard is used to manage saved Google Search Console accounts for use by the connector. For security reasons, Analytics Edge stores your account information in an encrypted file on your computer, not in the workbook. Accounts are stored using Reference names, and the queries in your workbooks use a Reference name to identify which account to use.

More

Accounts – LinkedIn Ads

The Accounts wizard is used to manage saved LinkedIn Ads accounts for use by the connector. For security reasons, Analytics Edge stores your account information in an encrypted file on your computer, not in the workbook. Accounts are stored using Reference names, and the queries in your workbooks 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 – Microsoft Ads

The Accounts wizard is used to manage saved Microsoft Ads accounts for use by the connector. For security reasons, Analytics Edge stores your account information in an encrypted file on your computer, not in the workbook. Accounts are stored using Reference names, and the queries in your workbooks use a Reference name to identify which account to use. More

Append

Append a previously saved table, or the contents of a worksheet in the same workbook, to the current table in memory. More

Automations

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

Big Query SQL Query

Use this Analytics Edge connector wizard to download the results of a GoogleSQL query from Google Big Query. More

Bulk Export

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

Calculate

This Analytics Edge wizard lets you perform typical math calculations without using 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

Combine

Combine two sets of data, merging the values from a worksheet or previously named table. This is generally used with two similar data sets, totalling the numbers, retaining the most recent date, and/or preserving a list of category values. 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

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

Customers – Google Ads

The Customers wizard of the Google Ads connector is used to list customers for a selected login accounts. With regular Ads accounts, it will list your account, but for MCC accounts, it will list all customer accounts associated with the MCC account. More

Customers – Microsoft Ads

The Customers wizard of the Microssoft Ads connector allows you to get a listing of the customers available to a selected login account. More

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

Duplicate

This Analytics Edge widget recognizes duplicate rows in your data and lets you choose whether to keep them, remove them or combine them. More

Filter

This Analytics Edge wizard lets you construct one or more filters to be applied to the current table. Filters can be combined using And / Or logic, and you can choose to remove or keep the matching rows. More

Formula

This Analytics Edge wizard inserts a column with an Excel formula, giving you full access to the spreadsheet application’s advanced functions. It is evaluated in the spreadsheet AFTER you write it to a worksheet, so it should be followed by a Write to Worksheet function. More

GA4 Realtime Report

Download your data for a GA4 Realtime report. This wizard lets you select an account and GA4 property. select the fields, filters and sort criteria for the report.

GA4 Realtime reports show traffic in the last 30 minutes.

More

Group

This Analytics Edge wizard lets you add a category or group column based on the value in one of the other data columns. More

Insights – Pages

pagesUse this Analytics Edge wizard to select one of your saved logins, and the Facebook Page you want to use for this query. More

Join

Typical uses include combining name or address components into a single column for uploading into a database. More

License

licenseTrial licenses are issued automatically by Analytics Edge. When you make a purchase, enter your registration/license key into the box provided and click Submit.

List Details

listUse this wizard to get details about a specific Constant Contact list in the account given the list id number. More

List Reports

list-reportsUse this Analytics Edge wizard to get reports on your MailChimp contact lists. More

Lists

listsUse this wizard to get the Constant Contact lists in the account. More

Lists

listsUse this Analytics Edge wizard to get information about all MailChimp contact lists, or about an individual list. More

Lookup

This Analytics Edge wizard lets you quickly lookup values from another Table or Worksheet that share an index column with the current table. More

Match

This Analytics Edge wizard is used to keep or remove rows based on whether matching row values exist in another table or worksheet. More

Number Format

Analytics Edge supports Microsoft .NET Framework format codes which are slightly different from Excel format codes. The common variants are listed below, but see the references at the end for a full listing. More

Page Posts – Pages

posts-pagesThis Analytics Edge wizard allows you to select a Facebook account and page, and get back details about the posts on that page. More

Performance Report

The Performance Report wizard of the Google Business Profile connector allows you to get a trend report for a several metrics. More

Pivot

This Analytics Edge wizard is used to pivot a column of data similar to Excel’s PivotTable. If you are pivoting by date, you can also select the date range and automatically fill in any missing values. More

Post Insights – Dates

fb-post-instghts-datesThis Analytics Edge wizard lets you pick the date range for your Facebook Post Insights query. All posts created in this date range will be included in the results. More

Post Insights – Pages

fb-post-insights-pagesUse this Analytics Edge wizard to select one of your saved logins, and the Facebook Page you want to use for this query. More

Quick Functions

Following a Quick Query, the Quick Functions wizard allows you to PivotArrangeSort or Filter your data as well as provides options to Write the results. More

Rank

This Analytics Edge wizard is used to convert the selected column into a number representing either the rank order or it’s percentile, decile or quartile position. More

Read Google Sheet

This Analytics Edge wizard is used to read the data from a Google Sheets worksheet. It always reads the entire sheet. More