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

Entering 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