I need to rank our customers regarding product mix they are buying.
from total sale customer buy (by product-segments): 10% braking, 5% suspension, 3% filters …
We know, that ideal customer (mechanic) should buy from total sale : 15% braking, 10% suspension, 8% filters … all together I will monitor 6 most important segments.
If they don’t buy it, it buy it from our competition …
My goal is:
- rank customers regarding how good they are in product-mix (what is their sale percentage regarding to ideal sale by product segments)
- give top ranking customers better conditions (better product mix = higher loyalty)
- find customers who for example missing 2 of 8 important segment and give to sales team a task to try to sell them missing segment
- find customers who buy only small amount or nothing from important segments and rank them as not-important costumers
Please if you have an idea how to start I will be very grateful.
I watch some videos but I didn’t similar problem …
Thanks and best regards,