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
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
Listing
Use this wizard to list all ad accounts, campaigns, ad sets or ads in your accounts.
Management Lists
The 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
MCF Reporting – Dates
Use this Analytics Edge wizard to establish the date range for the report. More