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. More →

Copy a Query

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.

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.

Copy a Query

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.

Copy to Google Sheets

A new option for Analytics Edge is to copy the results to a Google Sheets sheet. This option comes with some limitations, identified below. The option is available in the Write to Worksheet macro wizard. Click the Select/Modify button to launch the Google Sheets wizard. More →

Customers

This Analytics Edge wizard lets you download the list of customer ids for your account. With regular AdWords accounts, it will list your account, but for MCC accounts, it will list all customer accounts associated with the MCC account. More →

Customers

This Analytics Edge wizard lets you download the list of customer ids for your 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 →

Dates

You can select from preset date ranges similar to what is available in the AdWords web interface, or you can pick a combination of start and end, start and duration, or end and duration. More →

Dates

You can select from preset date ranges similar to what is available in the Bing Ads web interface, or you can pick a combination of start and end, start and duration, or end and duration. More →

Dates Tab

This Analytics Edge wizard lets you pick the date range for your Facebook Ads Insights query. More →

Delete a Query

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.

To delete an Analytics Edge query from your worksheet, first make sure the Edit Mode is ON — that places Excel comments (little red triangles) in the cells with the queries. Then select the cell where the query is located, then select the Edit Query > Cut menu item from the Analytics Edge ribbon bar, or click on the Cut icon beside the Edit Query button.

Delete a Query

To delete an Analytics Edge query from your worksheet, first make sure the Edit Mode is ON — that places Excel comments (little red triangles) in the cells with the queries. Then select the cell where the query is located, then select the Edit Query > Cut menu item from the Analytics Edge ribbon bar.

remove-a-query

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 →

Edit a Query

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.

To edit a specific query, select the cell where the query is located (if Edit Mode is ON, an Excel comment will appear in the cell). Click on the Edit Query button on the Analytics Edge ribbon bar. The original query wizard will open with all of your previous settings.

edit-a-query More →

Edit a Query

Edit Mode Help

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.

The Basic Add-in has an ‘Edit Mode’ that places Excel comments (little red triangles) where your queries or cell references are located. These comments are used to keep the queries in sync with changes you make to the workbook, like renaming worksheet tabs or inserting rows. More →

Edit Mode Help

The Standard Add-in has an ‘Edit Mode’ that shows you where your queries and any cell references have been placed (for start and end dates, for example). When Edit Mode is ON, the add-in places Excel comments on all the referenced cells. More →

Edit Mode Help

The Core Add-in has an ‘Edit Mode’ that shows you where your Quick Queries and any cell references have been placed (for start and end dates, for example). When Edit Mode is ON, the add-in places Excel comments on all the referenced cells. More →

Enter Data Source Schema

Entering the Google Analytics data source schema into Analytics Edge makes it easier to upload data by automatically populating the target column names to match the schema. More →

Fields

The fields available for each report are listed in three groupings: Segments (used to group metrics), Attributes (settings or other fixed data) and Metrics (numerical performance data). More →

Fields

Select the fields for your report.

Fields

The fields available for each report are listed in two groupings: Attributes and Metrics (numerical performance data). 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 →

Filter

Use this Analytics Edge wizard to set filter options for the Facebook Ads query. More →

Filters

To add filters to your report, select a combination of the column, criteria and value, and then click the Add button. Multiple filters will be AND-ed, meaning the report will contains rows that pass all the filters. More →

Filters

Select the Filters for your SalesForce query.

Filters

To add filters to your report, select an attribute to filter, then select values desired and add them to the filter by clicking the [ >> ] button. More →

Formula

This Analytics Edge wizard, used at the end of a macro, allows you to populate a column with an Excel formula, giving you full access to Excel’s advanced functions. It must be the last transformation in the sequence. More →

Functions Wizard

The Analytics Edge Standard Add-in allows you to make several transformations to your data before you write it into your worksheet. More →

Functions Wizard

Quick Queries in the Analytics Edge Core Add-in allow you to make several transformations to your data before you write it into your worksheet. More →