Systems and methods for collaborative offer generation
Systems and methods for a collaborative offer portal is provided. A proposed offer is received from a manufacturer, including an offer structure and a number of consumers they wish to target. Transaction logs of a retailer are accessed to determine an audience for the offer by calculating a return on investment (ROI) for the customer base using the retailer's records given the offer type. The consumers are then grouped by their ROI distribution, and the ROI for the deal is calculated based upon the offer size in light of this distribution. From the offer ROI a discount percentage to be paid by the retailer versus the merchant can be created. The retailer may then choose to accept the offer for deployment.
1. A computer implemented method for a collaborative offer portal comprising:
receiving a proposed offer from a manufacturer, wherein the proposed offer includes a number of consumers to target, a product, and an offer structure;
accessing transaction logs for a retailer;
receiving a set of weights from the retailer;
calculating a return on investment (ROI) value for each consumer by multiplying the set of weights to a set of the metrics and then combining the resulting weighted metrics by multiplication or normalized addition, wherein the first of the three metrics is a measure if a given consumer has purchased the product in the past, the second of the three metrics is a calculation of price elasticity for the given consumer for the product, and the third of the three metrics is a measure of purchase frequency of the product by the given consumer;
grouping the consumers into equal sized buckets by ROI value to generate an ROI distribution;
selecting a plurality of buckets in the ROI distribution which are largest based upon the number of consumers to target;
calculating an average ROI value for the offers in the selected plurality of buckets.
2. The method of claim 1 , further comprising calculating a cost for a manufacturer based upon the offer structure, number of consumers to target, and the discount percentage.
3. The method of claim 1 , further comprising calculating a predicted redemption rate for the offer, predicted sales responsive to the predicted redemption rate, predicted incremental sales, and gross margin estimates.
4. The method of claim 1 , wherein the discount percentage is linearly correlated to the average ROI value.
5. The method of claim 1 , wherein the discount variable value is constrained such that the value deviates less than 10% from a value of the proposed offer.
6. A collaborative offer portal system comprising:
a web-based server for receiving a proposed offer from a manufacturer, wherein the proposed offer includes a number of consumers to target, a product, and an offer structure, and for receiving a set of weights from the retailer;
a database for accessing transaction logs for a retailer; and
a processor for calculating a return on investment (ROI) value for each consumer by multiplying the set of weights to a set of the metrics and then combining the resulting weighted metrics by multiplication or normalized addition, wherein the first of the three metrics is a measure if a given consumer has purchased the product in the past, the second of the three metrics is a calculation of price elasticity for the given consumer for the product, and the third of the three metrics is a measure of purchase frequency of the product by the given consumer, and grouping the consumers into equal sized buckets by ROI value to generate an ROI distribution,
selecting a plurality of buckets in the ROI distribution which are largest based upon the number of consumers to target,
calculating an average ROI value for the offers in the selected plurality of buckets.
7. The system of claim 6 , wherein the processor is further for calculating a cost for a manufacturer based upon the offer structure, number of consumers to target, and the discount percentage.
8. The system of claim 6 , wherein the processor is further for calculating a predicted redemption rate for the offer, predicted sales responsive to the predicted redemption rate, predicted incremental sales, and gross margin estimates.
9. The system of claim 6 , wherein the discount percentage is linearly correlated to the average ROI value.
10. The system of claim 6 , wherein the discount variable value is constrained such that the value deviates less than 10% from a value of the proposed offer.