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

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

Use this wizard to log in to your Facebook Ads account and authorize Analytics Edge to access your data. More

Accounts

accountsThis wizard is used to authorize Constant Contact login accounts to be used by the various queries. More

Accounts

gm-accountsUse this Analytics Edge wizard to enter your Google Analytics credentials.

 

Accounts

accounts Enter a reference name for your account and enter the API key found in your Bing Webmaster Tools interface. More

Accounts

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

accounts-shEnter a name for your Shopify account, and the web address for your shop, then click the Add Account button. More

Accounts

Enter your SalesForce Account here.

Accounts

accountsUse this wizard to log in to your Facebook account and authorize Analytics Edge to access your data. More

Accounts

For security reasons, Analytics Edge stores your account information on your computer, not in the workbooks. More

Accounts wizard

accountsThis Analytics Edge wizard is used to establish Google login accounts that can be used by the various queries. More

Adding Queries

With the Analytics Edge Basic Add-in and optional Connectors, you can automate the download of data from a number of sources directly into Microsoft Excel worksheets. You can mix queries from multiple sources, and use different accounts for each query if you want; Analytics Edge makes it easy to refresh them all with a single click. More

Adding Queries

With the Analytics Edge Standard Add-in and optional Connectors, you can automate the download of data from a number of sources directly into Microsoft Excel worksheets. More

Analytics Reporting – Output

outputThe Output tab (available only in the Google Analytics Pro Connector) offers the ability to download direct to a CSV (comma-separated) file instead of returning the results to Excel. More

Analytics Reporting – Segments

segmentsThis Analytics Edge wizard is used to select a predefined Google Analytics segment from your account, or to define a dynamic one to be used solely for this query. More

Analytics Reporting – Sort

sortUse this Analytics Edge wizard to select the sort order to use for the query. Additionally, you can restrict the query to download a limited number of rows i.e. the top 10. More

Anchor Text

anchor-text-1This Analytics Edge wizard returns information about anchor text for inbound links.  [Paid Moz API access required] More

Append

appendThis Analytics Edge wizard makes it easy to merge two tables together, keeping all of the rows and columns of the original tables. More

Append To Worksheet

This Analytics Edge wizard is used to append the current table of data to the end of an existing worksheet. More

Arrange

This Analytics Edge wizard is used to rearrange and/or rename columns in a table. More

Attributions

This Analytics Edge wizard lets you pick different attribution windows for your Facebook Ads Insights query. More

Automations

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

Bulk Export

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

Bulk Queries – Queries

ga-bulk-queries

Click image to enlarge

Use this Analytics Edge wizard to select the Query Configuration Worksheet for Bulk (multiple) Google Analytics queries. More

Bulk Queries – Segments

ga-bulk-segmentsThis Analytics Edge wizard is used to select a predefined Google Analytics segment from your account, or to define a dynamic one to be used solely for this query. More

Bulk Queries – Views

ga-bulk-viewsUse this Analytics Edge wizard to select the Login account to use for the query, plus the Account, Property, and View. More

Calculate

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

Campaigns/Ads Tab

Use this Analytics Edge wizard to select one of your saved logins, and the Facebook Ad Account, Campaign, Ad Set, or Ad you want to use for this query. More

Columns Tab

This Analytics Edge wizard lets you select the Facebook Ads Insights metrics you want. More

Combine

combineThis Analytics Edge wizard is used to combine two sets of data, merging the values from a worksheet or previously named table. 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

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

Convert Excellent Analytics

[Only available in the Free Google Analytics connector]

Use this wizard to convert existing queries built with Excellent Analytics into Analytics Edge queries. Select the cell below the Excellent Analytics query cell and open the wizard. More

Copy a Query

Copy in the Same Workbook

To make a copy of an Analytics Edge query, simply copy the comment to another location in the same worksheet, or another worksheet in the same workbook. More

Copy a Query

Copy in the Same Workbook

To make a copy of an Analytics Edge query, simply copy the comment to another location in the same worksheet, or another worksheet in the same workbook. 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

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, you must select the cell where the query is located, then select the Edit QueryCut menu item from the Analytics Edge ribbon bar. More

Delete a Query

To delete an Analytics Edge query from your worksheet, you must select the cell where the query is located, then either delete the comment or select the Edit QueryCut menu item from the Analytics Edge ribbon bar. More

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, click on the cell where the query is located (remember a comment was placed in that cell so you could find it easily). Click on the Edit button on the Analytics Edge ribbon bar. The original query wizard will open with all of your previous settings. More

Edit a Query

To edit a specific query, click on the cell where the query is located (remember a comment was placed in that cell so you could find it easily). More

Edit Mode Help

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

Editing the Worksheet (Edit Mode On)

If you are going to move things around on your worksheet, rename a worksheet, or insert rows or columns, turn the Edit Mode ON first. After any worksheet change, be sure to select a worksheet cell after the change, and check the comments to make sure that the add-in has re-synchronized them to point to the new cell locations. The comment should contain the new cell location. Do NOT change the comments yourself — the add-in needs to do that to keep things aligned.

Turning Edit Mode Off

While Edit Mode is on, the add-in will intercept and process every click you make into the worksheet, looking for changes. This will slow things down in larger workbooks. Turn Edit Mode OFF when you are finished moving things around. It is not necessary to have Edit Mode on to Refresh a workbook, only if you want to move a query or cell reference to a different location or change worksheet names.

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