View Source

The new features created at this stage are presented in this table:

GBU Name Type in Dataiku Grouping level Recipe in Dataiku Description Functions in the code Used in the model

CS SpP

n_customers_per_product

Product Feature

material_code

compute_Price_drivers_features

Number of customer per material

create_n_customers_per_product

Yes

CS SpP

n_products_per_customer

Customer Feature

shipto_code

compute_Price_drivers_features

Number of product per shipto

create_n_products_per_customer

Yes

CS SpP cpc_revenue_log CPC Level soldto_code, soldto_group, material_code & gbu_product_family compute_Price_drivers_features Revenue per CPC in log scale create_cpc_features No

CS SpP cpc_volume_log CPC Level soldto_code, soldto_group, material_code & gbu_product_family compute_Price_drivers_features Volume per CPCin log scale create_cpc_features Yes

CS SpP cpc_price_log CPC Level soldto_code, soldto_group, material_code & gbu_product_family compute_Price_drivers_features Price per CPC in log scale create_cpc_features Yes

CS rev_within_soldto_grp_but_cpc CPC Level soldto_code compute_Price_drivers_features Sold-to revenue but CPC create_cpc_features No

SpP rev_within_shipto_grp_but_cpc CPC Level shipto_code compute_Price_drivers_features Ship-to revenue but CPC create_cpc_features No

CS SpP

rev_within_family_but_cpc

CPC Level

gbu_product_family

compute_Price_drivers_features

Family revenue but CPC

create_cpc_features

No

CS group_revenue_within_family_but_cpc CPC Level soldto_group & gbu_product_family compute_Price_drivers_features Sold-to group revenue within Family but CPC create_cpc_features No

SpP group_revenue_within_family_but_cpc CPC Level shipto_group & gbu_product_family compute_Price_drivers_features Ship-to group revenue within Family but CPC create_cpc_features No

CS rev_outside_family Group Feature soldto_code & gbu_product_family compute_Price_drivers_features Sold-to revenue outside Family create_cpc_features Yes

SpP rev_outside_family Group Feature shipto_code & gbu_product_family compute_Price_drivers_features Ship-to revenue outside Family create_cpc_features Yes

CS SpP cpc_revenue_share_wrt_grp_family_revenue CPC Level soldto_group & gbu_product_family compute_Price_drivers_features CPC ratio with respect to group revenue within the family create_cpc_features Yes

CS cpc_revenue_share_wrt_grp_soldto_revenue CPC Level soldto_group compute_Price_drivers_features CPC ratio with respect to group revenue across all families create_cpc_features No

SpP cpc_revenue_share_wrt_grp_shipto_revenue CPC Level shipto_group compute_Price_drivers_features CPC ratio with respect to group revenue across all families create_cpc_features No

CS group_volume_within_family_but_cpc CPC Level soldto_group & gbu_product_family compute_Price_drivers_features Sold-to group volume within Family but CPC create_cpc_features No

SpP group_volume_within_family_but_cpc CPC Level shipto_group & gbu_product_family compute_Price_drivers_features Ship-to group volume within Family but CPC create_cpc_features No

CS group_volume_but_cpc_label CPC Level soldto_group & gbu_product_family compute_Price_drivers_features Split group_volume_within_family_but_cpc into categories using quartiles create_group_volume_feature Yes

SpP group_volume_but_cpc_label CPC Level shipto_group & gbu_product_family compute_Price_drivers_features Split group_volume_within_family_but_cpc into categories using quartiles create_group_volume_feature Yes

CS SpP historical_unit_price_coalesce_ratio_on_12 CPC Level CPC compute_Sales_evolution_features Price evolution ratio between the last 1, 3 or 6 months and the last 12 months for a CPC compute_coalesce_evolution_ratio Yes

CS SpP historical_sales_coalesce_ratio_on_12 CPC Level CPC compute_Sales_evolution_features Sales evolution ratio between the last 1, 3 or 6 months and the last 12 months for a CPC compute_coalesce_evolution_ratio Yes

CS COMPONENT_ratio Product Feature material_code compute_product_characteristics_features the ratio contained by product for Component substance product_composition_ratios Yes

CS IMPURITY_ratio Product Feature material_code compute_product_characteristics_features the ratio contained by product for Impurity substance product_composition_ratios Yes

CS SOLVENT_ratio Product Feature material_code compute_product_characteristics_features the ratio contained by product for Solvent substance product_composition_ratios Yes

CS n_components Product Feature material_code compute_product_characteristics_features the total count of substances by product product_composition_counts_by_product Yes

CS

Unit ICM/Price ratios

CPC Level

CPC & historical_month

compute_Sales_evolution_features

The ratio between Unit ICM and Unit Price for one or average of several month.

The activation of these features is managed by the "ICM_features" dictionary, in which the size of the interval of historical months can also be modified.

"ICM_features": {
"use_ICM_features": false,
"interval_sizes": [1, 3, 6, 9, 12]
}

A coalesce ratio ("ratio_icm_sales_coalesce_ratio") is then created to obtain the first available value by ranking the intervals in descending order.

get_ICM_price_ratio

No