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