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 is evaluated in Excel AFTER you write it to a worksheet, so it should be followed by a Write to Worksheet function. 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

GA 4 Reporting – Fields

ALPHA PRODUCT WARNING – subject to change with no backward compatibility guarantee

Use this Analytics Edge wizard to select the dimensions and metrics to be retrieved in the query. More

GA 4 Reporting – Filters

ALPHA PRODUCT WARNING – subject to change with no backward compatibility guarantee

Use this Analytics Edge wizard to define filters to use with the query. More

GA 4 Reporting – Options

ALPHA PRODUCT WARNING – subject to change with no backward compatibility guarantee

this tab is currently disabled

The Options tab provides access to several options that affect how the Google Analytics data is presented in Excel. More

GA 4 Reporting – Output

ALPHA PRODUCT WARNING – subject to change with no backward compatibility guarantee

this tab is currently disabled

GA 4 Reporting – Reports

ALPHA PRODUCT WARNING – subject to change with no backward compatibility guarantee

This tab contains preconfigured report options to aid people familiar with the old Google Analytics reports. Some changes may be necessary, including filtering and sorting, to get the data you want.

GA 4 Reporting – Sort

ALPHA PRODUCT WARNING – subject to change with no backward compatibility guarantee

Use 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

GA 4 Reporting – Views

ALPHA PRODUCT WARNING – subject to change with no backward compatibility guarantee

Use this Analytics Edge wizard to select the Login account and the reporting View to use for the query. 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. More