MDW Medium Analysis Table Spec: tbl_cp_doe_source_medium_analysis_v4
tbl_cp_doe_source_medium_analysis_v4
Why is it important? This is a Measured Geo table which is the backend for the source medium tab of the Geo reporting dashboard. The table stores the source medium conversion data for all client studies.
Term | Definition | Datatype |
study_id | Study ID | int8 |
study_name | Study name | varchar(200) |
cell_id | Cell ID | int8 |
cell_type | Cell Name | varchar(200) |
model_id | Model Name | varchar(200) |
model_name | Model Name | int8 |
source_medium | Source/Medium name | varchar(200) |
sot_exp_conversions_top_bau_avg | % change in top bau sot conversions | float8 |
sot_conversions_change_cell_avg | % change in cell sot conversions | float8 |
exp_days | Total number of experiment days | int8 |
pre_exp_days | Total number of pre-experiment days | int8 |
report_start_date | Reporting start date | date |
report_end_date | Reporting end date | date |
pre_expt_start_time | Pre-experiment start time | date |
pre_expt_end_time | Pre-experiment end time | date |
expt_ref_start_time | Experiment start time | date |
expt_ref_end_time | Experiment end time | date |
