Google Analytics 4 as a source

You can create a data pipeline that loads Google Analytics 4 reports into destination tables.

Supported account types

To provide connection information, you can enter credentials in AutoSync, Designer, or Classic Manager. Designer and Classic Manager offer multiple account types for most endpoints and not all types are compatible with AutoSync. When you create or edit a data pipeline, the existing credentials list includes only compatible account assets. AutoSync supports the following Designer and Classic Manager account types:

  • Google Service Account

Connection configuration

Google Analytics properties include the following:

  • Account Properties:
    • Credential label: A unique, meaningful name such as Google-Analytics-Sales. If a configuration with the same name exists, AutoSync displays an Asset conflict error message.
    • JSON key: Upload the JSON key downloaded from the Google Console. Learn more about generating JSON keys.
    • Share: (Optional) Select a user group to share this configuration with. Org admins create user groups to share credentials. If you are a member of a user group, you can select it from the dropdown. You can also select the global shared folder, which shares the credentials with everyone in your Org.
  • Validate and Save: After saving and validating, AutoSync adds the configuration to the list of saved credentials.
  • Select account id: Select your account id. AutoSync populates the list from your Google Analytics account.
  • Select property id: Select the id of your Google Analytics Property. AutoSync populates the list from your Google Analytics account.
  • Enter report name: Enter the name of your report. This will also be used as your table name.
  • Select metrics: Select the metrics you want to include in your report from the dropdown.
  • Select dimensions: Select the dimensions you want to include in your report from the dropdown.
  • Select start date and end date: Select the date range for reporting event data.