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
Function Wizards (filter at right)
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
Select the fields for your report.
Filters
Select the Filters for your SalesForce query.
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 Blocked Urls
Get list of blocked pages/directories.
Get Children Url Info
Get index details for a directory; equivalent to the Bing Webmaster Tools Index Explorer.
Get Children Url Traffic Info
Get index traffic details for directory.
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
Insights – Dates
This Analytics Edge wizard lets you pick the date range for your Facebook Insights query. More
Insights – Fields
This Analytics Edge wizard lets you select the Facebook Insights metrics you want. More
Insights – Pages
Use this Analytics Edge wizard to select one of your saved logins, and the Facebook Page you want to use for this query. 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
Use this wizard to get details about a specific Constant Contact list in the account given the list id number. More
List Members
Use this wizard to get the contacts in a specified list. More
List Reports
Use this Analytics Edge wizard to get reports on your MailChimp contact lists. More