Function Wizards (filter at right)

Convert

convertThis Analytics Edge wizard is used to convert columns from one data type (text, number, or date) into another. More →

Copy a Query

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

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 Filter

gm-copyUse this Analytics Edge wizard to copy the selected filter between accounts and to assign it to other views in the same account. More →

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 both the quick query Functions wizard, as well as in the Write to Worksheet macro wizard. Functionality is identical; click the Select/Modify button to launch the Google Sheets wizard. 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

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

duplicatesThis 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

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

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

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

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

filterThis 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

add a calculated column to ExcelThis 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 →

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.

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

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