* Google Analytics Help

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

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 – Output

outputThe 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 – Segments

segmentsThis 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

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. 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 – Segments

ga-bulk-segmentsThis 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 – Views

ga-bulk-viewsUse 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

ga-enter-schemaEntering 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 – 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 – 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

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.

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

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.

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

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

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.