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

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 Mode Help

The Core Add-in has an ‘Edit Mode’ that shows you where your Quick Queries are located as well as any cell references. 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

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. These “Quick Functions” are available only to Premium license users. 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.

Google Account Login

This wizard is not seen in normal use. During a normal login sequence, a new browser window will open in front of it requesting you to login to your Google account. After you login, this wizard will close automatically. 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.

License

The Google Analytics Connector for Analytics Edge should automatically activate a 30 day free trial period. If you purchase a license, enter the purchased licensed code in the Google AdWords > License wizard and Submit to activate the new license. More

Link Metrics

This Analytics Edge wizard returns information about links between a target URL and other pages and domains. Parameters let you receive a wide array or a narrow subset of results, with multiple options for how results are sorted.  More

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

Listing

Use this wizard to list all ad accounts, campaigns, ad sets or ads in your accounts.

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

Management Lists

ga-management-listsThe Management Lists wizard allows you to download information about your account(s), web properties and views. Select the Login to use for the query, then pick the Account, 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

MCF Reporting – Accounts

ga-mcf-accountsUse this Analytics Edge wizard to select the Login you want to use for the query, plus the Account, Property and View.