Connector Dialog for Google Analytics

IMPORTANT: The Google Analytics connector is compatible with Google Analytics version 4.0. If the site you wish to access has not been migrated from Universal Analytics, this site will be inaccessible to the connector.

Workspaces containing connections to an earlier version of Google Analytics can still be loaded into the application. However, some properties may have to be manually modified to successfully open data sources using the new connector. 

 

General Instructions

  1. Launch the Connect to Data dialog and then select Application > Google Analytics.

    The Google Analytics connector dialog displays.

  2. Provide the following information:

    • Key File Path

    • Property ID 

  3. Enter the date range to use to filter rows.

  4. Click Fetch Dimensions and Metrics.

    The Categories, Dimensions and Metrics list boxes are populated. Note that some date/time data imports from Google Analytics may display differently in Monarch Data Prep Studio. For example, average time values (under Metrics), such as Avg. Session Duration and Avg. Time on page, display in Google Analytics in HH:MM:SS format but display in Monarch Data Prep Studio in SS (seconds) format . You can use the date/time formatting options of Monarch Data Prep Studio to format the necessary fields after import these data into the application.

  5. Double-click on any field from these list boxes. They are selected and displayed in the Selected Columns list.

  6. Click X to delete a selected column in the list.

  7. Click OK to confirm the selection and retrieve the record set into Monarch Data Prep Studio.

 

The Google Analytics connector dialog includes the following fields and settings:

Field

Description

Key File Path

Location of the key file furnished by Google Analytics when you created the Service Account. You can also click Browse to select the path of the key file.

Notes:

The key file must be in the JSON format.

When opening an old workspace containing a Google Analytics connection that uses a keyfile in p12 format, you must generate a new keyfile in JSON format.
Property ID

The identifier associated with your account and used by Google Analytics to collect data.

This ID a numeric in value. If your property ID is alphanumeric, you must get a new one from the GA migrated site.

Date From/To

Select the date range that will be used to filter the Google Analytics rows.

Note that the start date selected must be later than August 13, 2015.

Fetch Dimension and Metrics

Click to select the Dimensions and  Metrics valid for the Google Account you have specified.

This populates the Categories, Dimensions and Metrics list boxes.

Categories

Click to navigate and select a Google Analytics Category.

Dimensions

Double click to select a Google Analytics Dimension.

Metrics

Double-click to select a Metric.

Selected Columns

Displays the columns that have been fetched.
Clear Fields Removes the selected columns.

Validate Selection

Validate the Dimensions and Metrics you have selected.

Preview Data

Click to fetch data using the credentials and criteria you have specified. 10 records are displayed to allow you to verify that you are selecting the correct data.

OK/CANCEL

Select OK to establish the connection and fetch data or Cancel to close the dialog. 

The state of the OK and PREVIEW buttons provide a handy status about the state of your connection:

  • The OK and PREVIEW DATA buttons are enabled as soon as the required fields have been entered and verified. This usually means a connection to the data source has been established and a table has been selected.

  • The OK button is disabled when an update is made that can lead to an invalid result (e.g. the User Name or Password is not valid, or the the SQL statement in the Query tab is invalid). In such cases, use  PREVIEW DATA to validate that data can be retrieved. If this fails verify your connection information or query until data can be retrieved.

 

Notes:

  • You cannot select more than 7 dimensions and 10 metrics per request.

  • Some dimension and metric combinations do not work together. At present, no list of compatible combinations is available. 

  • Selecting any dimension/metric will disable non-compatible dimensions/metrics.

  • If the metrics and dimensions seleted are deprecated, they must be removed and new fields must be selected from the appropriate lists.

  • BetaDataAnalyticsClient limits: Default = 10,000; Maximum = 250,000

 

 

 

 

© 2025 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support