As a base requirement it needs to be checked which Google Analytics Property is used in order to select the right data process setup on the side of Adtriba.

At the moment Adtriba supports the following GA Properties and export schemas:

Based on the used GA Property a daily data dump with the following specification needs to be placed in a S3 bucket which Adtriba will provide.

Integration of Universal Analytics data

  • Export the latest and full ga_sessions_YYYYMMDD table once per day
  • Data format must be JSON
  • Data files must be compressed as GZIP
  • Data can be split into multiple files for optimal performance on both sides
  • Upload it to the Adtriba S3 bucket

Destination

s3://{BUCKET}/tracking/ga360_ua/ga_sessions_{YYYYMMDD}/ 
  • The variables {BUCKET} and {YYYYMMDD} must be replaced
  • Adtriba will define the {BUCKET}
  • The customer/data uploader must replace {YYYYMMDD} with the date which is used in the name of the export table

Option 1: JSON & one file

s3://{BUCKET}/tracking/ga360_ua/ga_sessions_20210201/data.json.gz

Option 2: JSON & multiple files

s3://{BUCKET}/tracking/ga360_ua/ga_sessions_20210201/data_000.json.gz
s3://{BUCKET}/tracking/ga360_ua/ga_sessions_20210201/data_001.json.gz
s3://{BUCKET}/tracking/ga360_ua/ga_sessions_20210201/data_002.json.gz
...

Implementation of Google Analytics 4 data

  • Export the latest and full ga_sessions_YYYYMMDD table once per day
  • Data format must be JSON
  • Data files must be compressed as GZIP
  • Data can be split into multiple files for optimal performance on both sides
  • Upload it to the Adtriba S3 bucket

Destination

s3://{BUCKET}/tracking/ga360_ga4/events_{YYYYMMDD}/ 
  • The variables {BUCKET} and {YYYYMMDD} must be replaced
  • Adtriba will define the {BUCKET}
  • The customer/data uploader must replace {YYYYMMDD} with the date which is used in the name of the export table

Option 1: JSON & one file

s3://{BUCKET}/tracking/ga360_ga4/events_20210201/data.json.gz

Option 2: JSON & multiple files

s3://{BUCKET}/tracking/ga360_ga4/events_20210201/data_000.json.gz
s3://{BUCKET}/tracking/ga360_ga4/events_20210201/data_001.json.gz
s3://{BUCKET}/tracking/ga360_ga4/events_20210201/data_002.json.gz
...

Did this answer your question?