MY_DB
Tables (50)
ad_group
- id — bigint — NOT NULL
- platform_account_id — character — NOT NULL
- platform_channel_id — integer — NOT NULL
- platform_campaign_id — character
- platform_ad_group_id — character — NOT NULL
- status — character
- platform_update_ts — timestamp
- update_ts — timestamp — NOT NULL
- start_ts — timestamp
- end_ts — timestamp
- budget_type — character
- budget_amount — double
amm_channel_confidence
- id — integer — NOT NULL
- category_id — bigint — NOT NULL
- platform_channel_id — bigint — NOT NULL
- order_channel — text — NOT NULL
- segment_nm — text — NOT NULL
- stability — text
- signal — text
- confidence — text
- update_ts — timestamp — NOT NULL
amm_channel_confidence_v2
- id — integer — NOT NULL
- category_id — bigint — NOT NULL
- platform_channel_id — bigint — NOT NULL
- target_variable_id — bigint — NOT NULL
- stability_pct_chng — double
- signal_pct_chng — double
- revenue — double
- update_ts — timestamp — NOT NULL
amm_curve_fact
- id — bigint — NOT NULL
- category_id — bigint
- start_date — date
- end_date — date
- platform_channel — text
- tactic_nm — text
- spend — double
- order_channel — text
- irevenue — double
- iroas — double
- icpo — double
- iadcost — double
- contr_profit — double
- mroas — double
- mprofit — double
- update_ts — timestamp
amm_guard_railed_experiment
- id — integer — NOT NULL
- category_id — bigint — NOT NULL
- platform_channel_id — bigint — NOT NULL
- experiment_nm — text — NOT NULL
- expt_start_date — date
- expt_end_date — date
- active_flg — boolean
- update_ts — timestamp — NOT NULL
analysis_group
- id — bigint — NOT NULL
- analysis_group_nm — text — NOT NULL
- platform_channel_id — integer
- segment_id — bigint
- tactic_id — bigint
- display_flg — boolean
- update_ts — timestamp — NOT NULL
- hierarchy_id — bigint
- legacy_expt_id — bigint
- platform_id — integer
analysis_group_category
- id — bigint — NOT NULL
- analysis_group_id — bigint — NOT NULL
- category_id — bigint
- primary_flg — boolean
- analysis_group_method_id — bigint
- parameter_set_id — bigint
- parameter_set_created_by_user — text
- parameter_set_created_date — timestamp
- parameter_set_status — text
- ref_parameter_set_id — bigint
analysis_group_family
- parent_id — bigint
- analysis_group_id — bigint
- active_flg — boolean
- id — bigint — NOT NULL
analysis_group_method
- id — bigint — NOT NULL
- analysis_group_id — bigint — NOT NULL
- analysis_method — text — NOT NULL
- cell_count — integer
- control_group_flg — boolean
- create_user_nm — text
- last_modified_by_user_nm — text
- display_flg — boolean
- analysis_group_status — text — NOT NULL
- creation_ts — timestamp — NOT NULL
- audience_id — text
- update_ts — timestamp — NOT NULL
- budget_duration — smallint
- budget — double
- profit_margin — double
- norm_factor — double
- cell_mapping_type — text — NOT NULL
- experiment_design_confidence — double
- analysis_group_method_nm — text
- marketing_event_variable_nm — character
- legacy_expt_id — bigint
- custom_expt_flg — boolean
- template_id — integer
- geo_target_set_id — bigint
- proposed_start_dt — timestamp
- budget_pacing_flg — boolean
- geo_supressons_flg — boolean
- aa_window_start_days — integer
- aa_window_end_days — integer
- updated_ts — timestamp
- is_new_designer — boolean
- initial_max_duration — integer
- suggested_max_duration — integer
- initial_max_avg_daily_spend — double
- suggested_max_avg_daily_spend — double
- initial_max_base_pacing_template_id — bigint
- suggested_max_base_pacing_template_id — integer
- iroas — double
- experiment_state — text
- visible_flag — boolean
analysis_group_method_ad_entity
- id — bigint — NOT NULL
- analysis_group_method_id — bigint — NOT NULL
- geo_target_set_id — bigint
- cell_num — smallint — NOT NULL
- campaign_id — bigint
- ad_group_id — bigint
- parent_campaign_id — bigint — NOT NULL
- similar_campaign_id — bigint
- initial_budget — double
- initial_bid_modifier — double
- update_ts — timestamp — NOT NULL
- initial_troas — double
- initial_tcpa — double
- estimate_cpc_cpm — double
- geo_applied_flg — boolean
- budget_applied_flg — boolean
- expt_status — text
- expt_error_notes — text
- adset_budget_details — json
- suggested_budget — double
analysis_group_method_amm_curve_result
- id — bigint — NOT NULL
- analysis_group_method_id — bigint
- target_variable_id — bigint
- pc_id — bigint
- pc_name — character
- tc_id — bigint
- tactic_name — character
- spend — double
- events — double
- m_roas — double
- i_revenue — double
- p_conversions — double
- p_revenue — double
- lt_revenue — double
- lt_mroas — double
- lt_factor — double
- category_id — bigint
- aggregation_level — character
- curve_type — character
- created_at — timestamp
analysis_group_method_automation_expanding_model_job
- id — bigint — NOT NULL
- model_set_id — bigint
- modeling_start_date — date
- modeling_end_date — date
- status — text
- created_on — timestamp
- created_by — text
- creation_mode — text
analysis_group_method_automation_expanding_model_set
- id — bigint — NOT NULL
- expanding_model_job_id — bigint
- expanding_model_start_date — date
- expanding_model_end_date — date
- no_of_days — integer
- status — text
- created_on — timestamp
- created_by — text
analysis_group_method_automation_expanding_model_stage_two
- id — bigint — NOT NULL
- expanding_model_set_id — bigint
- aov — numeric
- min_event — bigint
- number_of_days — bigint
- normalization_value — numeric
- media_coefficient_magnitude — numeric
- media_coefficient_p_value — numeric
- media_coefficient_std_error — numeric
- media_coefficient_vif — numeric
- k_coefficient_magnitude — numeric
- k_coefficient_p_value — numeric
- k_coefficient_std_error — numeric
- k_coefficient_vif — numeric
- intercept_magnitude — numeric
- intercept_p_value — numeric
- intercept_std_error — numeric
- i_roas_magnitude — numeric
- i_roas_std_error — numeric
- lift — numeric
- residual_variance — numeric
- adjusted_r_square — numeric
- dw — numeric
- r_square — numeric
analysis_group_method_automation_hot_geo_analysis_job
- id — bigint — NOT NULL
- model_set_id — bigint
- modeling_start_date — date
- modeling_end_date — date
- geo_location_exclusions — json
- status — text
- created_on — timestamp
- created_by — text
- creation_mode — text
analysis_group_method_automation_hot_geo_analysis_model_set
- id — bigint — NOT NULL
- hot_geo_analysis_job_id — bigint
- model_set_geo_location_exclusion — json
- geo_location_exclusions — json
- aa_start_date — date
- aa_end_date — date
- ab_start_date — date
- ab_end_date — date
- aa_factor — numeric
- ab_factor — numeric
- lift_in_orders — numeric
- event_type — text
- avg_cost_per_event — numeric
- status — text
- created_on — timestamp
- created_by — text
analysis_group_method_automation_hot_geo_analysis_stage_two
- id — bigint — NOT NULL
- hot_geo_analysis_model_set_id — bigint
- aov — numeric
- min_event — bigint
- number_of_days — bigint
- normalization_value — numeric
- media_coefficient_magnitude — numeric
- media_coefficient_p_value — numeric
- media_coefficient_std_error — numeric
- media_coefficient_vif — numeric
- k_coefficient_magnitude — numeric
- k_coefficient_p_value — numeric
- k_coefficient_std_error — numeric
- k_coefficient_vif — numeric
- intercept_magnitude — numeric
- intercept_p_value — numeric
- intercept_std_error — numeric
- i_roas_magnitude — numeric
- i_roas_std_error — numeric
- lift — numeric
- residual_variance — numeric
- adjusted_r_square — numeric
- dw — numeric
- r_square — numeric
analysis_group_method_automation_job
- id — bigint — NOT NULL
- job_name — text
- analysis_group_method_id — bigint
- is_pre_window_included — boolean
- modeling_start_date — date
- modeling_end_date — date
- day_of_week_flags — json
- promo_flags — json
- custom_flags — json
- notes — text
- job_status — text
- model_count — bigint
- creation_mode — text
- created_by — text
- created_on — timestamp
- geo_location_exclusions — json
analysis_group_method_automation_job_model_type
- id — bigint — NOT NULL
- job_id — bigint
- model_type — text
analysis_group_method_automation_job_model_type_prior
- id — bigint — NOT NULL
- job_id — bigint
- category_id — bigint
- target_variable_id — bigint
- prior_intercept_mean — numeric
- prior_intercept_standard_deviation — numeric
- prior_control_coefficient_mean — numeric
- prior_control_coefficient_standard_deviation — numeric
- prior_control_coefficient_standard_deviation_computed — numeric
- prior_media_mean — numeric
- prior_media_standard_deviation — numeric
- prior_media_standard_deviation_computed — numeric
- prior_amm_saturation_constant — numeric
- prior_amm_saturation_constant_calculation_type — text
analysis_group_method_automation_job_normalization
- id — bigint — NOT NULL
- job_id — bigint
- normalization_type — text
analysis_group_method_automation_job_outcome
- id — bigint — NOT NULL
- job_id — bigint
- outcome_type — text
analysis_group_method_automation_job_product_category
- id — bigint — NOT NULL
- job_id — bigint
- product_category_id — bigint
analysis_group_method_automation_job_regression_type
- id — bigint — NOT NULL
- job_id — bigint
- regression_type — text
analysis_group_method_automation_job_saturation_constant
- id — bigint — NOT NULL
- job_id — bigint
- saturation_constant — numeric
- saturation_constant_type — text — NOT NULL
analysis_group_method_automation_job_target_variable
- id — bigint — NOT NULL
- job_id — bigint
- target_variable_id — bigint
analysis_group_method_automation_model_distribution
- id — integer — NOT NULL
- media_coefficient_posterior_distribution — jsonb
- intercept_posterior_distribution — jsonb
- k_coefficient_posterior_distribution — jsonb
- model_set_id — bigint — NOT NULL
analysis_group_method_automation_model_guardralling
- id — bigint — NOT NULL
- model_set_id — bigint
- experiment_prior_lift — numeric
- experiment_posterior_lift — numeric
- percentage_change_lift — numeric
- channel_portion_included — numeric
- channel_lift — numeric
- new_channel_lift — numeric
- percent_change_in_saturation_constant — numeric
- saturation_constant_portion_included — numeric
- new_channel_saturation_constant — numeric
- new_channel_elasticity — numeric
analysis_group_method_automation_model_set
- id — bigint — NOT NULL
- name — text
- job_id — bigint
- product_category_id — bigint
- target_variable_id — bigint
- outcome_type — text
- normalization_type — text
- saturation_constant — numeric
- model_type — text
- regression_type — text
- status — text
- created_on — timestamp
- model_set — json
- expanding_model_eligible_flag — boolean
- hot_geo_analysis_eligible_flag — boolean
- saturation_constant_type — text — NOT NULL
analysis_group_method_automation_model_set_history
- id — bigint — NOT NULL
- model_set_name — text
- job_name — text
- model_set_id — bigint
- analysis_group_method_name — text
- user_name — text
- publish_status — text
- updated_on — timestamp
analysis_group_method_automation_model_set_pin
- id — bigint — NOT NULL
- model_set_id — bigint — NOT NULL
- is_pin — boolean
analysis_group_method_automation_model_stage_one
- id — bigint — NOT NULL
- job_id — bigint
- number_of_days — bigint
- regression_type — text
- min_ad_spend — numeric
- max_ad_spend — numeric
- avg_ad_spend — numeric
- intercept — numeric
- coefficient — numeric
- p_value — numeric
- std_error — numeric
analysis_group_method_automation_model_stage_two
- id — bigint — NOT NULL
- model_set_id — bigint
- aov — numeric
- min_event — bigint
- number_of_days — bigint
- normalization_value — numeric
- media_coefficient_magnitude — numeric
- media_coefficient_p_value — numeric
- media_coefficient_std_error — numeric
- media_coefficient_vif — numeric
- k_coefficient_magnitude — numeric
- k_coefficient_p_value — numeric
- k_coefficient_std_error — numeric
- k_coefficient_vif — numeric
- intercept_magnitude — numeric
- intercept_p_value — numeric
- intercept_std_error — numeric
- i_roas_magnitude — numeric
- i_roas_std_error — numeric
- lift — numeric
- residual_variance — numeric
- adjusted_r_square — numeric
- dw — numeric
- r_square — numeric
- saturation_constant_type — text — NOT NULL
- saturation_constant — numeric
- amm_i_roas — numeric
analysis_group_method_automation_model_stage_two_flags
- id — bigint — NOT NULL
- model_set_id — bigint
- flag_id — text
- magnitude — numeric
- p_value — numeric
- std_error — numeric
- vif — numeric
analysis_group_method_base_budget_adj
- id — bigint — NOT NULL
- analysis_group_method_id — bigint — NOT NULL
- day — integer — NOT NULL
- base_adj_pct — double — NOT NULL
- base_adj_pct_tcpa — double
- base_adj_pct_troas — double
analysis_group_method_budget_adj
- id — bigint — NOT NULL
- analysis_group_method_id — bigint — NOT NULL
- day — integer — NOT NULL
- adj_pct — double — NOT NULL
- adj_pct_tcpa — double
- adj_pct_troas — double
analysis_group_method_cell
- id — bigint — NOT NULL
- analysis_group_method_id — bigint — NOT NULL
- cell_num — integer — NOT NULL
- cell_type — text — NOT NULL
- budget_adj_pct — smallint
- cell_display_nm — text
- suppress_flg — boolean
- update_ts — timestamp — NOT NULL
analysis_group_method_cell_actuals
- id — bigint — NOT NULL
- analysis_group_method_id — bigint — NOT NULL
- analysis_group_method_target_variable_id — bigint — NOT NULL
- cell_num — smallint — NOT NULL
- day — date — NOT NULL
- update_ts — timestamp — NOT NULL
- revenue — double
- orders — bigint
- category_id — bigint
analysis_group_method_cell_location_actuals
- id — bigint — NOT NULL
- analysis_group_method_id — bigint — NOT NULL
- location_id — bigint — NOT NULL
- cell_num — integer — NOT NULL
- category_id — integer — NOT NULL
- target_variable_id — integer — NOT NULL
- event_ts — date — NOT NULL
- orders — double
- revenue — double
- update_ts — timestamp
analysis_group_method_cell_location_platform_performance
- id — bigint — NOT NULL
- analysis_group_method_id — bigint — NOT NULL
- cell_num — integer
- location_id — bigint — NOT NULL
- event_ts — date — NOT NULL
- ad_spend — double
- impressions — double
- clicks — double
- reach — double
- conversions — double
- revenue — double
- impression_share — double
- update_ts — timestamp
analysis_group_method_cell_platform_performance
- id — bigint — NOT NULL
- analysis_group_method_id — bigint — NOT NULL
- cell_num — smallint — NOT NULL
- day — date — NOT NULL
- ad_spend — double
- impressions — double
- clicks — double
- reach — double
- conversions — double
- revenue — double
- impression_share — double
- update_ts — timestamp — NOT NULL
analysis_group_method_curve_stability
- analysis_group_method_id — bigint
- platform_channel_id — bigint
- tactic_id — bigint
- campaign_id — bigint
- window_type — character
- window_size — smallint
- hierarchy_level — character
- hierarchy_nm — character
- start_dt — timestamp — NOT NULL
- end_dt — timestamp — NOT NULL
- i1 — double
- e1 — double
- p1 — double
- i2 — double
- e2 — double
- p2 — double
- min_events — double
- e20 — double
- window_count — smallint
- rms_error — double
- window_count_gt_5 — boolean
- e2_lt_15_flg — boolean
- p2_lt_15_flg — boolean
- err_lt_15_flg — boolean
- stable_flg — boolean
analysis_group_method_dry_run
- id — bigint — NOT NULL
- analysis_group_method_id — bigint — NOT NULL
- dry_run_id — character — NOT NULL
- platform_campaign_id — character — NOT NULL
- campaign_name — text — NOT NULL
- status — character — NOT NULL
- code — bigint — NOT NULL
- message — text
analysis_group_method_event
- id — bigint — NOT NULL
- analysis_group_method_id — bigint — NOT NULL
- modification_ts — timestamp — NOT NULL
- modification_type — text — NOT NULL
- create_user_nm — text
- last_modified_by_user_nm — text
- modification_json — text
- modification_summary — text
- user_nm — character
- update_ts — timestamp — NOT NULL
analysis_group_method_model_set_promote
- id — bigint — NOT NULL
- analysis_group_method_id — bigint — NOT NULL
- product_category_id — bigint — NOT NULL
- target_variable_id — bigint — NOT NULL
- model_set_id — bigint — NOT NULL
- is_promoted — boolean
- promoted_date — timestamp
analysis_group_method_publish_lift_curve
- id — bigint — NOT NULL
- analysis_group_method_id — bigint — NOT NULL
- product_category_id — bigint — NOT NULL
- target_variable_id — bigint — NOT NULL
- model_set_id — bigint — NOT NULL
- is_publish — boolean
analysis_group_method_target_variable
- id — bigint — NOT NULL
- analysis_group_method_id — bigint — NOT NULL
- target_variable_id — integer — NOT NULL
- primary_flg — integer
category
- id — bigint — NOT NULL
- category_type — character
- category_nm — text — NOT NULL
- product_level_a — text
- product_level_b — text
- product_level_c — text
- parent_id — bigint
- level — character
- profit_margin — double
- expt_set_up_flg — boolean
- model_flg — boolean
- is_eligible_for_media_plan — boolean
platform_channel
- id — integer — NOT NULL
- platform_channel — character — NOT NULL
- platform_channel_lambda_id — integer
- display_name — character — NOT NULL
- camp_setup_flg — boolean — NOT NULL
- measurement_flg — boolean — NOT NULL
- aud_sync_flg — boolean — NOT NULL
- ad_group_sync_flg — boolean — NOT NULL
- camp_sync_flg — boolean — NOT NULL
- update_ts — timestamp — NOT NULL
- channel_settings — text
- platform — text — NOT NULL
- tapclick_channel_name — text
- event_type — character
- perf_sync_lambda_flg — boolean
- loc_perf_sync_days — integer
- camp_perf_sync_days — integer
- group_nm — character
- min_budget — double
- model_exclude_flag — boolean
- default_elasticity — double
- lift_factor — integer
- data_source_id — bigint
- paid_channel — boolean
- evaluation_order — integer
- lambda — double
- system_platform_channel_flg — boolean
- platform_id — bigint
- dataset_id — bigint
- funnel_id — bigint
- tactic_evaluation_required_flag — boolean
- active — boolean
target_variable
- id — integer — NOT NULL
- target_variable_nm — text
- display_nm — text
- active_flg — boolean
- src — text
- order_channel — character
- segment_id — bigint
- expt_set_up_flg — boolean
- model_flg — boolean
- roll_up_flg — boolean
- order_channel_id — bigint
- optimization_flg — boolean