Target Database Table
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|
To View Larger Image, Right Click and Choose Open Image In New Tab.
Calculated and Derived Fields
All content © Daasity 2021. Do not copy, share or distribute.