Google Analytics

Connect your data from Google Analytics to the Ascend platform.

The Google Analytics 4 connection utilizes a JDBC driver from CData. For more information, see CData's documentation.

Prerequisites

  • Google Analytics 4 account

Connection Properties

The following table describes the fields available when creating a new Google Analytics 4 connection. Create a connection using the information below and these step-by-step instructions.

FieldRequiredDescription
Access TypeRequiredThe type of connection is Read-Only for Google Analytics 4.
Connection NameRequiredInput your desired name.
Google Analytics View (Profile)OptionalEnter the ViewID you are connecting to. The ViewID can be found by in View Settings. If left empty, Ascend will automatically retrieve the first available View.
Requires CredentialsOptionalCheck this box to create a new credential or select an existing credential.

Credential Properties

The following table describes the fields available when creating a new Google Analytics 4 credential.

Field NameRequiredDescription
Credential NameRequiredThe name to identify this credential with. This credential will be available as a selection for future use.
Credential TypeRequiredThis field will automatically populate with Google Analytics 4 CData JDBC.
Google Cloud CredentialsRequiredProvide Google Cloud credentials in JSON format.

Read Connector Properties

The following table describes the fields available when creating a new Google Analytics 4 read connector.

Field NameRequiredDescription
NameRequiredProvide a name for your connector. We recommend using lowercase with underscores in place of spaces.
DescriptionOptionalDescribes the connector. We recommend providing a description if you are ingesting information from the same source multiple times for different reasons.
Table NameRequiredName of the table being ingested. Enter in the table name or select Browse and Select Data to locate the table.
Replication StrategyOptionalFull Resync, Filter by column range, or Incremental column name. See Database Reading Strategies for more information.
Filter ExpressionOptionalDefine a filter expression to be applied when querying the source table, utilized within the WHERE clause in SQL