Transformation Configuration Setup

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

Overview

The Facebook Ads extractor provides data on marketing spend and performance from impressions through vendor attributed revenue and orders. The Daasity transformation code maps data from the Facebook Marketing schema into the Unified Marketing Schema (UMS) for the following marketing channels

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:

• Facebook Ads

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

• Initialization

Transformation Code Requirements

To enable the data transformation from the Facebook Ads schema into UMS, the following code must be run in a workflow:

  ums_facebook_ads:
    integrations:
      - facebook_ads
    scripts:
      - "github://platform-sql-shared/scripts/pro/1500_ums/1520_UMS_BAS_facebook_spend.sql"
      - "github://platform-sql-shared/scripts/base/1500_ums/vendor_kpi/2520_UMS_BAS_facebook.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 Facebook Ads will not be transformed into the downstream tables

UMS Master Spend

The following code will transform the specific Facebook Ads spend into the [ums.master_spend] table and will limit data to a single attribution window:

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/pro/1500_ums/1520_UMS_BAS_facebook_spend.sql

If you have multiple attribution windows you can use this code which will transform all attribution windows

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/pro/1500_ums/1521_UMS_BAS_facebook_spend_all.sql

Facebook provides the same spend for every attribution window so if you use the all attribution window code make sure to filter your results on a single attribution window to report on the correct spend

UMS Vendor Performance

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

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1500_ums/vendor_kpi/2520_UMS_BAS_facebook.sql