I'm looking to use excel to help me find the optimal order of products displayed on a eccommerce page.
Different revenue is generated from a click for each product dependent on the position on the page, so in the example below, Product 1 makes £33 for a click in position 1, £10 in position 2 etc. (Numbers are all made up here). The volume by position is ofcourse different (ie 40% will click P1 vs
20% click P2, however I have accounted for that in the £s to keep this simpler, so assume it is evenly spread)
Can I use excel to try every possible order to show what the optimal order is.
In this example there is on 5 products and therefore 5 positions, however in reality there may be 30-40 products
Capture.PNG
Many Thanks
Bookmarks