Daily Deal and Coupon Calculator
In an effort to try and bring some reality as opposed to hype Daily Deals, we've put together an interactive spreadsheet sheet to try and help you get to the bottom of the numbers.
There are so many variables it can really be a bit of a nightmare. But hopefully below will at least give you an indication of how a potential promotion might do.
There are a few items that you can fill in with certain levels of confidence and others that are very much picked out of the ether. One those, it’s best to try and err on the side of caution.
- Face value is as it says; the normal price of the goods or services you are going to offer.
- Voucher value is the promotional price. Discount is worked out automatically.
- What percent will be new customers
- What would, on average, be the spend of a regular customer
- What are the costs of the goods sold (specifically the voucher good)
- Number of vouchers sold and the percent redeemed
- Number redeemed – we’ll default that at 15% not redeemed
- “Sales above voucher” is trying to estimate the number of people that will buy more that simply what’s on offer. Change the % there
- The percent of new customers that will come back again
- The Daily Deal site cut
- The cost proportion of the deal. From the face value, what’s the cost portion as a percent
- Fill in these and see what you get at first pass. Then you can move some of the subjective elements to get the what if scenario.
It appears that if more than one person is using this - service can be disrupted! In that event you can download the file here
| Related articles: |
|---|
|