chakkra said:
1) That doesnt make much sense, if three skus appear on the chart that means that all three skus are selling. Therefore all skus must be counted. 2) That was not a false spike. The spike came in the last week when there was the $100 discount and the tool reflected that. Without that promotion sales for the X1 would have been much lower. |
There was a spike, but the tool wasn't accurate because it just added the points to the total of the multiple skus appearing, thus also affecting the monthly average in favor of the XB1 which wasn't the case in the end. The tool was more accurate in the months before because this situation didn't really happened.
If we want the tool to be accurate in a ration of 1-0, which the 1 is the leader and the two others are in the decimal under it, we need to lower the error margin, especially in Q3 and Q4 when all the bundle and offers are more prevalent. Since we don't have real numbers with the rankings, we can only speculate on the number of units sold. When I'm suggesting to do an average by numbers of skus on the charts, it's to prevent the massive fluctuation we saw. Skus moving up the charts is more indicative of sales growth than a new sku appearing on the list.
I'll give some examples:
Let's say we make a chart from 1 to 10 as 1 is worth 10 points and 10 is worth 1.
Console 1 has two skus at 1 and 3, which is worth 18 points for an average of 9, while console 2 is holding spots 5 and 6 which is worth 11 point for an average of 5.5. The ratio of console1 would be 1 and and console 2 would be 0.61, which would show that one console is topping the charts while the other is selling at a steady pace, but still at a lower rate than the other.
Now let's say console 2 have a 3rd sku appearing on the chart and grabbing the fourth spot, while the other console is still a the same spots. Console 2 new average will now be of 6 and at a ratio of 0.66 to the leader. The gap is lowering just because we have an other option and selling at the same steady pace as the other before.
Now let's say that the new sku is actually moving up in the chart and even moving to the 3rd spot. Console 2 is now holding spots 3, 5 and 6 for a new average 6.3 and console 1 is holding spots 1 and 4 for a new average of 8.5. Console 2 is now at a ratio 0.75, thus showing a spike in sales.
Is this method perfect ? No, it's still speculations.
But I believe it could help in predicting not only the ranks, but also the ratios between them which is exactly the idea behind the tool.