3520_PFT_BAS_performance_trend_benchmarks Transformation

Target Database Table

drp.performance_trend_benchmarks.

Script Description and Logic

Builds out daily store level performance trend benchmarks based on the last 14 days of performance trend data in order to compare to performance trend actuals. Daily store level metrics are used to construct benchmark revenue per session, conversion rate, AOV, and units per order. Daily level moving averages and standard deviations are then calculated from these constructed metrics based on the last 14 days of data, reported out for the last 3 months to be used as benchmarks for comparison against actuals.

Source Tables Used In Script

Schema Table (or Derived Table) Name Table Type Purpose
drp integration_mapping database Primary
drp performance_trends database Primary
N/A CTE derived Lookup
N/A PB_CTE derived Lookup

SQL Flow

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

3520_PFT_BAS_performance_trend_benchmarks Transformation

Calculated and Derived Fields

Coming soon.


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