Transformation Configuration Instructions

This pages provides instructions on what transform code should be added to a script manifest file to transform Google Analytics 4 (via BigQuery) data into the Unified Traffic Schema (UTS)

Overview

The Google Analytics (via BigQ) extractor provides data on site traffic, page performance, checkout performance and order attribution. The Daasity transformation code maps data from the GA4 schema into the Unified Traffic Schema (UTS)

Feature Dependencies

You must have enabled our Code Repository feature in order to both access the Daasity transformation code as well as modify a Script Manifest File enabling this code to execute

We recommend you review the Transformation Configuration section of our Help documentation to familiarize yourself with our workflow engine and script manifest files.

Script Manifest File (YML)

Upstream Transformation Dependencies

This code is dependent on the following integration being installed:

• Google Analytics 4 (via BigQuery)

This code block is dependent on the following upstream code blocks being implemented:

• Initialization

Transformation Code Requirements

To enable the data transformation from the GA4 schema into UTS, the following code must be run in a workflow:

    integrations:
      - google_analytics_v4_bq
    scripts:
      - "github://platform-sql-shared/scripts/base/2600_google_analytics/2635_GA4_BAS_base_multi_channel_funnel.sql"

  uts_ga4_bq:
    integrations:
      - google_analytics_v4_bq
    scripts:
      - "github://platform-sql-shared/scripts/base/2650_uts/2671_UTS_BAS_GA4_multi_channel_funnel.sql"

GA4 BQ

The following code will populate the final [ga4_bq.base_multi_channel_funnel] with data from the staging BigQuery tables

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/2600_google_analytics/2635_GA4_BAS_base_multi_channel_funnel.sql

Unified Traffic Schema

The following code will combine the multi-channel funnel data from GA3 and GA5

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/2650_uts/2671_UTS_BAS_GA4_multi_channel_funnel.sql