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.