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

Source Database Table


Script that Populates Database Table


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.