View: Intermediary UMS Table(s): ums_staging.mktg_spend_source

Source Database Table

ums_staging.mktg_spend_source

Script that Populates Database Table

1580_UMS_BAS_mktg_spend_source.sql

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

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.