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
Function Wizards (filter at right)
Accounts
Use this Analytics Edge wizard to enter your Google Analytics credentials.
Accounts
Enter your SalesForce Account here.
Accounts wizard
This 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 – Dates
Use this Analytics Edge wizard to establish the date range for the report. More
Analytics Reporting – Dynamic Segments
Analytics Edge makes it possible to create dynamic segments using a a wizard interface similar to that in the web version of Google Analytics. More
Analytics Reporting – Fields
Use this Analytics Edge wizard to select the dimensions and metrics to be retrieved in the query. More
Analytics Reporting – Filters
Use this Analytics Edge wizard to define filters to use with the query. More
Analytics Reporting – Options
The Options tab provides access to several options that affect how the Google Analytics data is presented in Excel. More
Analytics Reporting – Output
The 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 – Reports
The Reports tab lets you quickly select common dimension and metric combinations that you can use as-is or use a starting point for a custom report. More
Analytics Reporting – Segments
This 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
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
Analytics Reporting – Views
Use this Analytics Edge wizard to select the Login account and the reporting View to use for the query. More
Anchor Text
This Analytics Edge wizard returns information about anchor text for inbound links. [Paid Moz API access required] 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
Attributions
This Analytics Edge wizard lets you pick different attribution windows for your Facebook Ads Insights query. More
Automations
Use 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 Export Contacts
Use this wizard to export large numbers of contacts from a specific Constant Contact list. More
Bulk Export Download
Use this wizard to download the results of a delayed bulk export operation. More
Bulk Export Status
Use this wizard to check the status of a bulk export request. More
Bulk Queries – Dates
[Pro connector] Use this Analytics Edge wizard to establish the date range for the report. More
Bulk Queries – Fields
Use this Analytics Edge wizard to select the dimensions and metrics to be retrieved in the query. More
Bulk Queries – Filters
Use this Analytics Edge wizard to define filters to use with the query. More
Bulk Queries – Options
The Options tab provides access to several options that affect how the Google Analytics data is presented in Excel. More
Bulk Queries – 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
This 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 – Sort
Use this Analytics Edge wizard to select the sort order to use for the query. More
Bulk Queries – Views
Use this Analytics Edge wizard to select the Login account to use for the query, plus the Account, Property, and View. More
Campaign Details
Use this Analytics Edge wizard to get details about a specific Constant Contact campaign. The campaign is identified by the campaign ID number. More
Campaign Reports
Use this Analytics Edge wizard to get reports for a selected MailChimp campaign. More
Campaign Reports – Bounces
Use this wizard to get details about bounced messages for the selected Constant Contact campaign. More
Campaign Reports – Clicks
Use this wizard to get details about clicks for the selected Constant Contact campaign. More
Campaign Reports – Clicks on Link
Use this wizard to get details about specific link clicks for the selected Constant Contact campaign. More
Campaign Reports – Forwards
Use this wizard to get details about forwarded messages for the selected Constant Contact campaign. More
Campaign Reports – Opens
Use this wizard to get details about opened messages for the selected Constant Contact campaign. More
Campaign Reports – Sends
Use this wizard to get details about sent messages for the selected Constant Contact campaign. More
Campaign Reports – Summary
Use this wizard to get summary statistics about the selected Constant Contact campaign. More
Campaign Reports – Unsubscribes
Use this wizard to get details about unsubscribes (opt-outs) for the selected Constant Contact 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
Contact – Add Contacts
Use this wizard to add contacts to your Constant Contact account. More
Contact Details
Use this wizard to get details about a specific contact in your Constant Contact account. More
Contact Listing
Use this wizard to get the contacts for a specific Constant Contact account. More
Contact Report – Bounces
Use this wizard to get details about the bounces of a selected contact (email address) in Constant Contact. More
Contact Report – Clicks
Use this wizard to get details about the clicks of a selected contact (email address) in Constant Contact. More
Contact Report – Contact Activities
Use this wizard to get details about the activity of a selected contact (email address) in Constant Contact. More
Contact Report – Forwards
Use this wizard to get details about the forwards of a selected contact (email address) in Constant Contact. More
Contact Report – Opens
Use this wizard to get details about the opens of a selected contact (email address) in Constant Contact. More
Contact Report – Sends
Use this wizard to get details about the sent campaigns for a selected contact (email address) in Constant Contact. More
Contact Report – Summary
Use this wizard to get details about the summary actions of a selected contact (email address) in Constant Contact. More
Contact Report – Summary by Campaign
Use this wizard to get details about the summary by campaign id of a selected contact (email address) in Constant Contact. More
Contact Report – Unsubscribes
Use this wizard to get details about the unsubscribes of a selected contact (email address) in Constant Contact. 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
Use this Analytics Edge wizard to copy the selected filter between accounts and to assign it to other views in the same account. More
This Analytics Edge wizard lets you download the list of customer ids for your account. 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
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 Query – Cut 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 Query – Cut menu item from the Analytics Edge ribbon bar. 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
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.
