1900_UMS_BAS_master_spend Transformation

Target Database Table

ums.master_spend.

Script Description and Logic

Inserts unified daily channel vendor marketing spend metrics from the staging table to the master marketing spend DRP table.

Source Tables Used In Script

Schema Table (or Derived Table) Name Table Type Purpose
drp_staging master_spend database Primary
drp_staging mkt_spend_soource database Primary
N/A mktmin derived Pulls marketing spend source ID's from the lowest ranked spend source

SQL Flow

To View Larger Image, Right Click and Choose Open Image In New Tab.

1900_UMS_BAS_master_spend Transformation

Calculated and Derived Fields

 None.

All content © Daasity 2021. Do not copy, share or distribute.