Retail Price Optimization
“The moment you make a mistake in pricing, you’re eating into your reputation”
@kaggle.suddharshan_retail_price_optimization
“The moment you make a mistake in pricing, you’re eating into your reputation”
@kaggle.suddharshan_retail_price_optimization
Price optimization is using historical data to identify the most appropriate price of a product or a service that maximizes the company’s profitability. There are numerous factors like demography, operating costs, survey data, etc that play a role in efficient pricing, it also depends on the nature of businesses and the product that is served. The business regularly adds/upgrades features to bring more value to the product and this obviously has a cost associated with it in terms of effort, time, and most importantly companies reputation.
As a result, it is important to understand the correct pricing, a little too high, you lose your customers and slight underpricing will result in loss of revenue. Price optimization helps businesses strike the right balance of efficient pricing, achieving profit objectives, and also serve their customers.
The data contains the demand and corresponding average unit price at a product - month_year level
CREATE TABLE retail_price (
"product_id" VARCHAR,
"product_category_name" VARCHAR,
"month_year" VARCHAR,
"qty" BIGINT,
"total_price" DOUBLE,
"freight_price" DOUBLE,
"unit_price" DOUBLE,
"product_name_lenght" BIGINT,
"product_description_lenght" BIGINT,
"product_photos_qty" BIGINT,
"product_weight_g" BIGINT,
"product_score" DOUBLE,
"customers" BIGINT,
"weekday" BIGINT,
"weekend" BIGINT,
"holiday" BIGINT,
"month" BIGINT,
"year" BIGINT,
"s" DOUBLE,
"volume" BIGINT,
"comp_1" DOUBLE,
"ps1" DOUBLE,
"fp1" DOUBLE,
"comp_2" DOUBLE,
"ps2" DOUBLE,
"fp2" DOUBLE,
"comp_3" DOUBLE,
"ps3" DOUBLE,
"fp3" DOUBLE,
"lag_price" DOUBLE
);Anyone who has the link will be able to view this.