mmm-modeler_app / src /utils /constants.js
aashish-bindal's picture
Initial commit: Dabur MMM Modeler React app
425a907
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'];