Note: Configure the OAuth 2.0 authentication parameters in the Connection tab before proceeding with adding tables.

To add Google Analytics 4 tables:

  1. Navigate to the Mapping tab.
  2. Click Configure Logical Schema.
  3. Select the Account ID from the dropdown. An Account ID is required for analytics admin APIs. There is no default.
  4. Select the Property ID from the dropdown. A Property ID is required for analytics data APIs. There is no default.
    You can also add the Account ID and Property ID values in the Default Query Options field in the Connection tab. For example, accountID=123456789;propertyID=987654321.
  5. Click Create Table.
  6. Type a name for the table, or select a table from the dropdown.
  7. Select from the options under the Dimensions and Metrics headings. If no primary key is defined in the table, set the primary key by selecting a column in the table.
  8. Click Save & Close. The JSON of the configured schema appears in the Add Tables field.