1580_UMS_BAS_mktg_spend_source Transformation

Target Database Table

ums_staging.mktg_spend_source.

Script Description and Logic

Inserts daily channel vendor BSD marketing spend into the master marketing spend table.

Source Tables Used In Script

Schema Table (or Derived Table) Name Table Type Purpose
bsd influencers database Primary
bsd marketing_spend database Primary
drp calendar database Primary
N/A daily_mktg_spend derived Appending marketing channel and influencer spend from BSD sheets

SQL Flow

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

 1580_UMS_BAS_mktg_spend_source Transformation

Calculated and Derived Fields

Target Column Target Column Data Type Source schema.table Source Column Transformation/Logic
daily_mktg_spend DECIMAL(20,4) bsd.marketing_spend spend spend/num_days_in_period


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