Transformation Configuration Setup

This pages provides instructions on what transform code should be added to a script manifest file to transform Amazon Ads into the Unified Marketing Schema (UMS)

Overview

The Amazon Ads extractor provides data on marketing spend and performance across a number of different marketing methods that are available on Amazon. The Daasity transformation code maps data from the Amazon Ads schema into the Unified Marketing Schema (UMS) for the following marketing channels:

• Sponsored Products

• Sponsored Display

• Sponsored Brands

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 will not complete successfully unless the Initialization Code that creates the UMS tables which is outlined in our Initialization Block is executed prior to this Amazon Ads UMS code in this workflow

Transformation Code Requirements

To enable the data transformation from the Amazon Ads schema into UMS, Daasity recommends the following code be added to any Script Manifest File and Workflow:

  ums_amazon_ads:
    integrations:
      - amazon_ads
    scripts:
      - "github://platform-sql-shared/scripts/pro/1500_ums/1535_UMS_BAS_amazon_ads_sponsored_products_spend.sql"
      - "github://platform-sql-shared/scripts/pro/1500_ums/1536_UMS_BAS_amazon_ads_sponsored_display_spend.sql"
      - "github://platform-sql-shared/scripts/pro/1500_ums/1537_UMS_BAS_amazon_ads_sponsored_brands_spend.sql"
      - "github://platform-sql-shared/scripts/base/1500_ums/vendor_kpi/2535_UMS_BAS_amazon_ads_sponsored_products.sql"
      - "github://platform-sql-shared/scripts/base/1500_ums/vendor_kpi/2536_UMS_BAS_amazon_ads_sponsored_display.sql"
      - "github://platform-sql-shared/scripts/base/1500_ums/vendor_kpi/2537_UMS_BAS_amazon_ads_sponsored_brands.sql"

We recommend this code be added within a UMS block that transforms all your marketing integrations into the appropriate UMS tables

If you do not add the above code to a Script Manifest File and create a Workflow with the Script Manifest File added to the workflow, the data extracted from Amazon Ads will not be transformed into the downstream tables

UMS Master Spend

The following code will transform the specific Amazon Ads spend into the [ums.master_spend] table:

• github://platform-sql-shared/scripts/pro/1500_ums/1535_UMS_BAS_amazon_ads_sponsored_products_spend.sql

• github://platform-sql-shared/scripts/pro/1500_ums/1536_UMS_BAS_amazon_ads_sponsored_display_spend.sql

• github://platform-sql-shared/scripts/pro/1500_ums/1537_UMS_BAS_amazon_ads_sponsored_brands_spend.sql

UMS Vendor Performance

The following code will transform the specific Amazon Ads data into the [ums.vendor_performance] table:

• github://platform-sql-shared/scripts/base/1500_ums/vendor_kpi/2535_UMS_BAS_amazon_ads_sponsored_products.sql

• github://platform-sql-shared/scripts/base/1500_ums/vendor_kpi/2536_UMS_BAS_amazon_ads_sponsored_display.sql

• github://platform-sql-shared/scripts/base/1500_ums/vendor_kpi/2537_UMS_BAS_amazon_ads_sponsored_brands.sql