Update: Task completed. Took only about 30 mins using Excel functions. I thought it would have taken me hours!
Ranking by CTR would give a slightly different ranking simply because of inventory size influence.
6L does pretty well everyone knows that and some not all blindly buys it without considering other factors.
User submits loads of 6L and brandbucket accepts them thereby increasing its stock by a large percent compared to others and at same time decreasing it's STR simply because only selected few will ever sale.
In the other hand not everyone can afford to buy 4L at lightning speed so less inventory stock which leads to higher STR.
STR stands for Sell-Through-Rate.
Character length rank should be dependent on sales volume and not STR which varies from marketplace to marketplace.
@Nat Hunt @Recons.Com
The highest STR was 100%
=> length 18 ; domain=> successfuldelivery.com but obviously removed it as was only 1 in stock.
But wait, maybe we should buy more 18L since it has the highest STR?