To get started with the Google Analytics connector, just add an account, then make your queries! On the Analytics Edge ribbon bar, click the Google Analytics button (Free or Pro) and select the Accounts menu item. More
Function Wizards (filter at right)
1 Add a Google Analytics Account
Once you have installed and activated the trial for the Google Analytics connector, you need to log in to your Google Analytics account. More
2 Your First Google Analytics Query
Make your first Google Analytics query (be sure to create an Account entry first). More
Accounts – Google Analytics
Use this wizard to log in to your Google Analytics account and authorize Analytics Edge to access your data. [Updated for the latest release of the connector 2019-10-18] 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
Bulk Queries
The Bulk Query wizard in the GA Pro connector was created before Quick Queries were added to the Core Add-in. The purpose was to expose a user-editable query configuration worksheet so more-advanced users could edit individual query parameters manually. That functionality is now possible by using Quick Queries. The Bulk Query remains in the connector for backward compatibility. 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
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
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
GA 4 Reporting – Fields
Use this Analytics Edge wizard to select the dimensions and metrics to be retrieved in the query. More
GA 4 Reporting – Filters
Use this Analytics Edge wizard to define filters to use with the query. More
GA 4 Reporting – Options
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
this tab is currently disabled
GA 4 Reporting – Reports
This tab contains preconfigured report options to help you get started and demonstrate the connector’s capability. Some changes may be necessary, including filtering and sorting, to get the data you want.
GA 4 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
GA 4 Reporting – Views
Use this Analytics Edge wizard to select the Login account and the reporting Property to use for the query. More
Google Analytics (Free) vs Google Analytics (Pro) Connector
Analytics Edge provide 2 connectors for Google Analytics: Free and Pro. For many people using the old Universal Analytics version of GA , the Google Analytics (Free) connector is all they need. The Pro connector provides many extra features, including full support for GA 360 customers as well as the new Google Analytics 4. This article describes the differences in more detail.
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
Save Filter
[Pro connector] Use this Analytics Edge wizard to save one or more view filters to one or more Google Analytics views. More
Upload Data into Google Analytics
To 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
User Activity – Dates
Experimental Release – Subject to Change
Use this Analytics Edge wizard to establish the date range for the report. More