MDW Hero Metrics Table Spec: tbl_cp_doe_hero_metrics_v4
tbl_cp_doe_hero_metrics_v4
Term | Definition | Datatype |
study_id | Study ID from study config table | int8 |
study_name | Name of study | varchar(200) |
cell_id | Cell ID from cell config table | int8 |
cell_name | Name of cell | varchar(200) |
cell_type | type of cell | varchar(200) |
model_id | Model ID | int8 |
model_name | Model Name | varchar(200) |
treatment | Control Holdout | varchar(200) |
predicted_conversions | Total conversions predicted by the model | float8 |
contribution | % sot contribution | float8 |
incrementality | % vendor incrementality | float8 |
sot_pre_exp_conversions_cell | total number of sot conversions for test markets during pre-exp period | float8 |
sot_pre_exp_conversions_top_bau | total number of sot conversions for top bau during pre-exp period | float8 |
sot_pre_exp_conversions_all_bau | total number of sot conversions for all bau during pre-exp period | float8 |
sot_pre_exp_conversions_cell_avg | average sot conversions for test cell during pre-exp period | float8 |
sot_pre_exp_conversions_top_bau | average sot conversions for top bau during pre-exp period | float8 |
sot_pre_exp_conversions_all_bau_ | average sot conversions for all bau during pre-exp period | float8 |
sot_pre_exp_conversions_cell_avg | marginal sot conversions | float8 |
sot_pre_exp_conversions_top_bau_avg | total incremental conversions for test markets | float8 |
sot_pre_exp_conversions_all_bau_avg | total incremental conversions for top bau | float8 |
sot_marginal_conversions | marginal sot conversions | float8 |
sot_inc_conversions_cell | total incremental conversions for test markets | float8 |
sot_inc_conversions_top_bau | total incremental conversions for top bau | float8 |
sot_inc_conversions_all_bau | total incremental conversions for all bau | float8 |
sot_pre_exp_revenue_cell | sot revenue for test cell during pre-exp | float8 |
sot_pre_exp_revenue_top_bau | sot revenue for top bau during pre-exp | float8 |
sot_pre_exp_revenue_all_bau | sot revenue for all bau during pre-exp | float8 |
sot_exp_revenue_cell | sot revenue for test cell during experiment | float8 |
