Spaces:
Sleeping
Sleeping
| 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']; | |