算法找到最畅销的价格
I have sales data from some our online listings. I randomly priced the same item to find the optimum price in an attempt to yield the most profit. Below is some of our sample data:
6 units @ 296.9/ea
225 units @ 331.69/ea
45 units @ 334.99/ea
5 units @ 369.29/ea
2 units @ 399.0/ea
2 units @ 353.27/ea
5 units @ 354.21/ea
It's pretty obvious which is the best price range, however I'm still trying to find some sort of average so we don't just pick the highest numbers.
My original thought was to simply multiply each set, add them all up, and divide by the total units (aka, finding the total average). The problem with that there is no consideration for the relationship between the amount of units sold and the price for each.
Does anyone have any advice for a way to find the best solution? Thanks!
--EDIT--
Factoring in analytical data such as click and view rates shouldn't be needed since all listing were done at the exact same time and were all the exact same. The amount of sales, views, etc are a direct result of the pricing. In other words, we are getting the sales based on what we price the item.
I'm not trying to find any profit margins, I'm trying to find the best LIST PRICE. We are already checking our profit margins and enabling/disabling campaigns thar are not meeting our thresholds. We're trying to find a medium price based on previous results so we can go into new markets and have an idea at an ideal price.
--2nd Edit--
When we list identical items for testing, regardless of price, some do get more views overall which does in fact result in more sales. Almost as if they go "viral" on the store. The reason for those views are completely out of our control. Every listing is identical except for pricing. Almost all online retailers have special algorithms to fetch the best match result to that customer.
The only reason we're trying to do this is to try and get an educated "guess" on the optimal list price based on previous results, regardless of how we obtained them. In other words, the stores and the customers are picking these prices for us, we just want to try and guess the price to start from instead of pricing listings randomly. From there we can work on increasing our margins.
我有一些在线商家的销售数据。 我随机定价同一项目以找到最优价格以试图获得最大利润。 以下是我们的一些示例数据: p>
6台@ 296.9 / ea
225台@ 331.69 / ea
45台@ 334.99 / ea
5台@ 369.29 / ea \ n2台@ 399.0 / ea
2台@ 353.27 / ea
5台@ 354.21 / ea
code> pre>
很明显哪个是最好的价格范围,不过我' 我仍然试图找到某种平均值,所以我们不只是选择最高的数字。 p>
我原来的想法是简单地将每个集合相乘,将它们全部加起来,然后除以总单位(也就是找到总平均值)。 问题在于没有考虑销售单位数量和每个单位的价格之间的关系。 p>
有没有人对找到最佳解决方案有什么建议? 谢谢! p>
- 编辑 - p>
因为所有列表都是在以下位置完成的,所以不需要保留分析数据,例如点击率和查看率。 完全相同的时间和完全相同。 销售额,观点等是定价的直接结果。 换句话说,我们根据我们对物品的定价来获得销售。 p>
我不是要找到任何利润空间,我正试图找到最好的列表价格。 我们已经在检查我们的利润率和启用/停用广告系列是否达不到我们的门槛。 我们正试图根据以前的结果找到中等价格,这样我们就可以进入新的市场并以理想的价格获得一个想法。 p>
- 第二次编辑 - p>
当我们列出相同的测试项目时,无论价格如何,有些项目总体上会得到更多的视图,这实际上会导致更多的销售。 几乎就像他们在商店里“病毒式”一样。 这些观点的原因完全不受我们的控制。 除定价外,每个商家信息都相同。 几乎所有在线零售商都有特殊算法来向该客户提取最佳匹配结果。 p>
我们尝试这样做的唯一原因是尝试根据以前的结果对最佳定价进行有根据的“猜测”,无论我们如何获得它们。 换句话说,商店和顾客正在为我们选择这些价格,我们只想尝试猜测价格而不是随机定价。 从那里我们可以努力增加利润。 p>
div>
This is more of a methodological critique (comment), but it's too long for the comments field and it is sort of and answer. But the basic answer to your question is that it is unanswerable given the data that you're providing:
How many times were each of these values presented to customers? It's a little surprising that you only sold 6 units at the lowest price... this leads me to believe that customers were not exposed equally to each of these price levels. You need to get the conversion rate delivered by a price level by calculating:
number_of_times_this_price_was_shown
divided by thenumber_of_times_customer_bought_item_at_this_price
What is your profit margin on each item? Selling 100 widgets at $5.01/widget is better than selling 5 widgets at $10.00/widget if my widgets cost me 1cent/widget, but if they cost me $5.00/widget then it's better to sell only 5 widgets at $10.00/widget ($5.00 profit/widget * 5 widgets = $25.00, vs one cent profit/widget * 100 widgets = $1.00).
If you can tell us those two pieces of information we can provide the correct algorithm.