Function Wizards (filter at right)

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

More →

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.

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

Customers

ad-customersThis 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

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.

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

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.

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

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

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.

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. When the Edit Mode is On, the add-in places Excel comments on all the referenced worksheet cells. Click the button to toggle the Edit Mode On or Off. More →

Enter Data Source Schema

ga-enter-schemaEntering 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 inserts a column with an Excel formula, giving you full access to Excel’s advanced functions. It must be the last transformation before writing to a worksheet. More →

Functions Wizard

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.

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 →

Get Children Url Info

Get index details for a directory; equivalent to the Bing Webmaster Tools Index Explorer.

Get Feeds

GetFeedsReturn all top-level feeds for the site.

Get Keyword

GetKeywordGet keyword impressions for selected period.

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.