Hello,
In a data with categories and products, I want to score the products within themselves, but I could not formulate it.
How can I score according to the performance of the products in each category? How can I normalize the scoring because the number of products in each category is different. At the end of the process, the score in the pants category and the score in the t-shirt category should not be outliers.
For example;
There are 9 products in the pants category, 8 in socks, 7 in jackets and 16 in t-shirts.
In the 9 products in the pants category;
-The product with a high conversion rate should score the same proportion in this metric.
-Margin % again in the category to which the products are connected, the products should receive points for this metric in the same proportion according to the margin height.
etc. etc.
At the end of the day there should be a total score.
But since I am new to excel, I could not formulate it. How can we formulate this in a simple way within the framework of logic? The sample file is attached
Can you help me?
Thanks in advance
Bookmarks