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

joinTypical 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

License wizard

licenseWhen you first start Excel with the Webmaster Tools connector installed, Analytics Edge will open the license wizard. Click the big Activate Free Trial License button to start your trial. 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.

Lists

listsUse this wizard to get the Constant Contact lists in the account. More

Lists

listsUse this Analytics Edge wizard to get information about all MailChimp contact lists, or about an individual list. More

Lookup

lookupThis Analytics Edge wizard lets you quickly lookup values from another Table or Worksheet that share an index value with the current table. More

Management Lists

ga-management-listsThe 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

Match

matchThis Analytics Edge wizard is used to keep or remove rows based on whether matching row values exist in another table or worksheet. More

MCF Reporting – Accounts

ga-mcf-accountsUse this Analytics Edge wizard to select the Login you want to use for the query, plus the Account, Property and View.

MCF Reporting – Fields

ga-mcf-fieldsUse this Analytics Edge wizard to select the dimensions and metrics to be retrieved in the query.

MCF Reporting – Sort

ga-mcf-sortUse 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.

Moving a Query

To move an Analytics Edge query, first make sure the Edit Mode is ON — that places Excel comments (little red triangles) in the cells with queries and cell references. Then simply move the comment to another location in the same worksheet, or another worksheet in the same workbook. Click on a worksheet cell to synchronize the queries with the new comment locations. More

Moving a Query

To move an Analytics Edge query, first make sure the Edit Mode is ON — that places Excel comments (little red triangles) in the cells with queries and cell references. Then simply move the comment to another location in the same worksheet, or another worksheet in the same workbook. Click on a worksheet cell to synchronize the queries with the new comment locations. More

Number Format

Analytics Edge supports Microsoft .NET Framework format codes which are slightly different from Excel format codes. The common variants are listed below, but see the references at the end for a full listing. More

Options

This wizard lets you configure Excel Pivot Tables refresh options and Email server settings. More

Page Posts – Pages

posts-pagesThis Analytics Edge wizard allows you to select a Facebook account and page, and get back details about the posts on that page. More

Pivot

pivot-bynameThis Analytics Edge wizard is used to pivot a column of data similar to Excel’s pivot table. If you are pivoting by date, you can select the date range and automatically fill in any missing values. More

Post Insights – Dates

fb-post-instghts-datesThis Analytics Edge wizard lets you pick the date range for your Facebook Post Insights query. All posts created in this date range will be included in the results. More

Post Insights – Pages

fb-post-insights-pagesUse this Analytics Edge wizard to select one of your saved logins, and the Facebook Page you want to use for this query. More

Query

Enter the SalesForce Query you want to run.

Rank

rank order data in ExcelThis Analytics Edge wizard is used to convert the selected column into a number representing either the rank order or it’s percentile, decile or quartile position. More

Read Text File

readtextfileThis Analytics Edge wizard allows you to import a text file into a table. It accepts both delimited files as well as fixed-width fields. More

Read Worksheet

readworksheetThis Analytics Edge wizard allows you to read an Excel worksheet into a table. The worksheet can be in any open workbook, and it is possible to read part of a worksheet if desired. More

Refreshing Queries

In Excel, on the Analytics Edge ribbon bar, click the Refresh All button to refresh all of your queries in the workbook.

refresh-all-queries More

Refreshing Queries

In Excel, on the Analytics Edge ribbon bar, click the Refresh All button to refresh all of your queries in the workbook. More

Repeat Macro

repeatmacroThis wizard converts the current macro into a Repeating Macro. Repeating macros allow you to load a tables of values from a worksheet to be used as Analytics Edge named ranges while running the rest of the macro. More

Replace

replaceThis Analytics Edge wizard lets you replace text in selected columns. It supports the usual * and ? wildcard matching. More

Reports

The Analytics Edge Google AdWords Connector provides access to all the reports available from the AdWords API. When you open the Reports wizard, you will see a number of tabs: Reports, Fields, Filters, Dates and Sort. More

Reports

The Analytics Edge Bing Ads Connector provides access to all the reports available from the Bing Ads API. More

Run Macro Function

run-macro-functionAnalytics Edge macros that start with an underscore (e.g. “_setup”) will NOT run when you click the Refresh All button, nor during a Scheduled Refresh. More

Salesforce Objects

Use this Analytics Edge wizard tab to select the Salesforce object (table) of interest.

Save Filter

ga-save-filter[Pro connector] Use this Analytics Edge wizard to save one or more view filters to one or more Google Analytics views. More

Save/Email PDF

save-email-pdfThis wizard lets you save an Adobe PDF copy of the Excel workbook and optionally email it to someone. More

Schedule Manager

This Analytics Edge utility is part of the Core Add-in, and is used to manage all of the Analytics Edge scheduled refreshes. More

Schedule Refresh

schedule-refresh-2This Analytics Edge wizard helps you to schedule unattended refreshes for the workbook you have open. More

Schedule Refresh

The Analytics Edge Standard Add-in allows you to schedule a refresh of your workbook. Open the workbook to be scheduled and from the Analytics Edge ribbon bar, click the Schedule button.

More

Scheduler Manager

The Analytics Edge Standard Add-in includes the ability to schedule workbook refreshes, and the Schedule Manager is used to manage all of the Analytics Edge scheduled refreshes. It will open automatically following any scheduled refresh, and it can be opened manually from the Schedule button on the Analytics Edge ribbon. More

Scope

The Scope tab allows you to restrict the report to specific accounts, campaigns or ad groups. Selecting an Ad Account will cause a Campaigns tab to appear with the campaigns in that ad account. More

Search Analytics

This Analytics Edge wizard makes it easy to get your Google Search Analytics data into Excel. More

Site selector popup

select-websiteThis dialog list all websites that your Webmaster Tools account has access to. Select the site you want to report on and click OK, or double-click the entry to select and close the dialog.

Sort

Set the Sorting options for your SalesForce query.

Sort

sort3This Analytics Edge wizard lets you create one or more sorting rules which will be applied in sequence to order your data. More

Sort

The Sort tab lets you determine the sort order of the results of your query. Select the column and click the Ascending or Descending button to add a sorting rule. Sorting rules are applied in order, where matching values in the first sorted column are ordered by the next rule. More

Sort

Use this Analytics Edge wizard to select sorting options for your Facebook Ads query. More

Sort

The Sort tab lets you determine the sort order of the results of your query. Select the column and click the Ascending or Descending button to add a sorting rule. More

Split

splitThis Analytics Edge wizard lets you split a text column into several columns. You can split on a delimiter or a fixed-width sequence. More

Subtotal

subtotalThis Analytics Edge wizard allows you to subtotal a table based on unique values in selected columns. More

Table Name

table nameThis Analytics Edge wizard lets you save the current table for reference later in the macro, such as with appending or comparing tables. More

Task Pane

taskpaneThe “heart” of the Analytics Edge Core Add-in is the Task Pane, which opens automatically to let you create, run and edit Analytics Edge macros. More

Top / Bottom

topThis Analytics Edge wizard lets you keep or remove a specific number of the top or bottom rows. More

Top Pages

This Analytics Edge wizard returns metrics for many URLs on a subdomain you specify. [Paid Moz API access required] More

Total

totalThis Analytics Edge wizard is used to create an aggregate row or column, like Total or Average. More

Unpivot

unpivotThis Analytics Edge wizard is used to perform a reverse pivot operation, converting multiple columns of data into two; one with the original column name and the other with the value. More

Update

update a table from another tableThis Analytics Edge wizard lets you update the current table from entries with matching rows in another table or worksheet. More

Upload Data into Google Analytics

ga-upload-dataTo upload data into Google Analytics, select the Property and Custom Data Source (see Google Analytics help for details about custom data sources and uploading data). More

Url Metrics

This Analytics Edge wizard returns metrics for a URL or set of URLs you specify. Specify which metrics to return (e.g. moz.com/blog) and select the metrics from the list. More

URL Shares

urlsharesThis Analytics Edge wizard is used to get the Facebook share metrics for any URL or list of URLs. More

User Activity – User ID

Experimental Release – Subject to Change

User ID – Enter the User ID or Client ID for the report to use.

Client ID – if the ID entered is a Client ID, check this box.

Activity Types – select all activity types to include in the report.

 

User Activity – Views

Experimental Release – Subject to Change

ga-mcf-accountsUse this Analytics Edge wizard to select the Login you want to use for the query, plus the Account, Property and View.

Write to Current Cell

The Core Add-in includes this shortcut menu item that mimics the functionality of the Basic Add-in. At any time during macro development, the current active table in memory can be quickly written to a specific cell on a specific worksheet. More

WriteToTextFile

write a table to a text fileThis Analytics Edge wizard lets you write the current table to a delimited text file, specifying the format to be used for dates. More

WriteToWorksheet

This Analytics Edge wizard is used to write the results of an analysis to a worksheet. It can either overwrite an entire sheet, or be written to a specific location. It can also optionally copy the results to a Google Sheets file as well. More