I had some fun twisting the formula yesterday.
To get numbers matching more or less NPD march results, I did three main changes :
- Getting rid of Walmart and Target numbers ; those are neither hourly nor daily best selling lists meaning there are kind of useless for our future "tool".
- Twisting the point system to award more point to high ranking items (#100 = 1 point, #51 = 50 points, #49 = 52 points, #21 = 110 points, #20 = 115 points, #1 = 210 points)
- Formula used was : Gamestop*1 + Best Buy*0.3 + Amazon*0.5
I don't have my excel sheet in front of me but I am pretty sure this is what I did (will double check later).
What do you think of those changes ? We have to keep in mind that we only have one week of data for March though...
I will finish April with all 5 lists and will calculate month average with both old and new system...
