export const DICT_COLS = ['VARIABLE','SN_MANUFACTURER','SN_BRAND_GROUP','SN_ACTIVITY_TYPE','SN_ACTIVITY_LEVEL_1','SN_KPI','PRIMARY_METRICS']; export const DISP_COLS = DICT_COLS.filter(c => c !== 'PRIMARY_METRICS'); export const TOOLTIP_COLS = ['VARIABLE','SN_MANUFACTURER','SN_BRAND_GROUP','SN_ACTIVITY_TYPE','SN_ACTIVITY_LEVEL_1','SN_KPI']; export const TOOLTIP_LABELS = { VARIABLE:'Variable', SN_MANUFACTURER:'Manufacturer', SN_BRAND_GROUP:'Brand Group', SN_ACTIVITY_TYPE:'Activity Type', SN_ACTIVITY_LEVEL_1:'Activity L1', SN_KPI:'KPI' }; export const P6_FIELDS = [ {group:'Adstock', key:'min_Adstock', label:'Min'}, {group:'Adstock', key:'max_Adstock', label:'Max'}, {group:'Adstock', key:'jump_Adstock', label:'Jump'}, {group:'Power', key:'min_Power', label:'Min'}, {group:'Power', key:'max_Power', label:'Max'}, {group:'Power', key:'jump_Power', label:'Jump'}, {group:'Lag', key:'min_Lag', label:'Min'}, {group:'Lag', key:'max_Lag', label:'Max'}, ]; export const P6_FIELD_KEYS = P6_FIELDS.map(f => f.key); export const DEFAULT_CONFIG = { "base_path":"abfss://ecd849c9-b6e1-4904-9575-b07fd0ac20e7@onelake.dfs.fabric.microsoft.com/f8db9ca0-ae62-460c-b007-a4071f1f8977/Files/Modelling", "DEFAULT_PRIMARY_METRICS":"Y", "ADS_DICT_TBL":"Dictionary_MT_COCONUT_WATER_ASHIN", "VAR_DIC_TBL":"Dictionary_MT_COCONUT_WATER_ASHIN", "brand_folder":"MT_COCONUT_WATER_ASHIN", "RETAIL_CHANNEL":"MODERN_TRADE", "brand_list":["ODONIL_TOTAL","RED_TOOTH_PASTE","REAL","HONEY","SANIFRESH","REAL_ACTIV_COCONUT_WATER","DABUR_HERBL_TOOTHPASTE","GLUCOSE","DABUR_ALMOND_HAIR_OIL","MESWAK_TOOTH_PASTE","DABUR_RED_GEL","ANMOL_COCONUT_OIL","VATIKA_AYURVEDIC_HAIR_WASH"], "ads_name":"INSCOPE_BRANDS", "raw_ads":"ADS_MT_TOTAL.csv", "Global_Params":{ "brand":["ODONIL_TOTAL","RED_TOOTH_PASTE","REAL","HONEY","SANIFRESH","REAL_ACTIV_COCONUT_WATER","DABUR_HERBL_TOOTHPASTE","GLUCOSE","DABUR_ALMOND_HAIR_OIL","MESWAK_TOOTH_PASTE","DABUR_RED_GEL","ANMOL_COCONUT_OIL","VATIKA_AYURVEDIC_HAIR_WASH"], "variable_dic":"Dictionary_MT_COCONUT_WATER_ASHIN.csv", "spark_app_name":"MT_TOTAL_ADS_Modeling", "market":"IND", "manufacturer":"DBR", "date_frequency":"M", "model_start_date":"10/01/2022", "model_end_date":"09/01/2025", "contrib_start_date":"01/01/2025", "contrib_end_date":"09/01/2025", "dependent_metric":"VOS", "subbrand":"TOTAL", "ads_file":"Combined_ADS.csv", "subbrand_ads_file":"National_level_ADS.csv", "spend_summary_file":"spend_summary_panel.csv", "prices_file":"Prices.csv", "marketing_types_abb":{"PRO":[0,30,5,60,80,5,0,1],"CPO":[0,30,5,60,80,5,0,1],"SAL":[0,30,3,80,100,2,0,1],"PRY":[0,30,3,60,80,5,0,2],"DIS":[0,10,1,90,100,1,0,1],"INY":[0,10,1,90,100,1,0,1],"MTL":[5,40,5,30,85,10,0,1],"SXE":[0,10,1,90,100,1,0,1],"MDG":[5,20,5,40,85,10,0,1],"VIS":[0,20,5,60,80,5,0,1],"HHP":[0,20,2,80,100,5,0,1],"EXT":[0,10,1,90,100,1,0,1],"FLG":[0,0,1,100,100,1,0,0],"DST":[0,10,1,90,100,1,0,1],"NPD":[0,10,1,90,100,1,0,1],"CRD":[0,30,5,60,80,5,0,1]}, "control_var_identifier":["TMP","RFL","PRC","CNG","CND"], "comp_var_identifier":["CTL","RPI","BPR"], "var_len":43, "base_comp_lst":["CTL"], "hier_cols":["BRAND_GROUP","CUSTOMER_ACCOUNT","DESIGN_BRAND","DESIGN_CODE","REGION","STATE","CITY"], "panel_columns":["BRAND_GROUP","CUSTOMER_ACCOUNT","DESIGN_BRAND","REGION","STATE","CITY"] }, "account_map":{"D_MART":"DMT","RELIANCE_RETAIL_LTD":"RIL"}, "design_brand_ctl_map":{"RED TOOTH PASTE":[]}, "paxcom_comp_map":{"RTP":[]}, "UCM_Params":{"ucm_vars_file":"ucm_vars.csv","ucm_variance_file":"ucm_variances.csv","cycle_period_lb":12,"cycle_period_ub":24,"ucm_seed":2456,"no_iter":500,"spend_cutoff_min":0.3,"spend_cutoff_max":1.0,"missing_panel_vars_variance_file":"missing_panels_vars_variances.csv","top_perc_inv_control":100,"num_noninv_control":10,"level_variance_p":"level_variance.csv","top_n_apl":0.4,"spend_prop_threshold":0.1,"top_n_var":20,"p_value_threshold":0.5,"num_vars_list":[4,5,6,7,8],"top_eq_percent":0.7,"top_x_percent":0.5,"spend_weight":0.30,"p_value_weight":0.10,"p_value_vars_weight":0.10,"baseline_weight":0.50,"min_baseline":60,"max_baseline":90,"top_apl_fin":2,"spend_wt":0.45,"corr_wt":0.25,"vif_wt":0.05,"partial_corr_wt":0.25,"vif_threshold":100,"vif_allowance":100,"spend_threshold_cutoff":25,"hier_corr_threshold":0.3}, "APL_Params":{"top_n_apl":0.1,"top_apl_fin":2,"spend_wt":0.45,"corr_wt":0.25,"vif_wt":0.05,"partial_corr_wt":0.25,"vif_threshold":100,"vif_allowance":100}, "Regression_Params":{"ADS_filename":{"Stage_1":"raw_ads_with_base_final.csv","Stage_2":"Stage 2 ADS.csv","Stage_3":"Stage_3_ADS.csv"},"dependent":"IND_MTD_DBR_TOT_TOT_SAL_OTK_TOT_TOT_TOT_VOS","log_dependent":"LOG_IND_MTD_DBR_TOT_TOT_SAL_OTK_TOT_TOT_TOT_VOS","reg_vars_file":"ucm_vars.csv","min_spend_prop":0.0002,"top_n_model":1,"fix_reg_vars":[],"remove_reg_vars":[],"random_to_fixed_vars":[],"hold_out":"False","hold_out_perc":0.1,"sampling_split":"Out of time"}, "FP_Params":{"dependent_metric":"VOS","rf_wt":0.15,"br_wt":0.15,"sp_wt":0.70,"rfws_wt":0.5,"brws_wt":0.5}, "imputation_params":{"key_cols":["DATE","STATE","CUSTOMER_ACCOUNT","CITY"],"Param_1":{"source_month":"2025-09-01","target_month":"2025-10-01","variable_identifiers":["MTL","MDG"]},"Param_2":{"source_month":"2024-10-01","target_month":"2025-10-01","variable_identifiers":["TMP"]},"Param_3":{"source_month":"2024-10-01","target_month":"2025-10-01","variable_identifiers":["TMP"]}} }; export const STEP_LABELS = ['Setup','Variables','Contributions','Mapping','Fixed Vars','Params','Config'];