Marketing ROI and Customer Acquisition Model (Excel)
Compare which marketing channels pay back, using your own figures.
For UK prize-draw and competition operators. Enter one month of results for up to six channels (spend, new paying customers and what they spent), plus your contribution per £1 of ticket sales ((takings − prizes − VAT − payment fees) ÷ takings, from a recent draw) and how often customers come back. For each channel the model shows you:
- Cost per new customer
- First-month sales per £1 spent and first-month profit after marketing
- Lifetime value per customer, lifetime value ÷ cost and lifetime ROI
- The estimated month the customer pays back what it cost to win them (or "Never")
- The most you could pay per customer and still hit your target
- A verdict: loses money, profitable below target, or meets target
What's inside
- 5 sheets: Start Here, Inputs, Channels, Payback, Dashboard
- Payback table for every channel: months 1–12, 18 and 24
- Dashboard: totals, best and weakest channel, warnings and a cost vs lifetime value chart
- Calculation sheets protected (no password); plain-English definitions and a fictional worked example
Who built it
Ivan Soloviov, The Lottery CFO. 18 years in lottery finance. Former CFO, European national lottery operator. Earlier at IGT/GTECH.
Format
.xlsx file for Microsoft Excel on desktop. Not built for Google Sheets or Excel online. Version 1.0, November 2026. Instant download after payment.
Please note
This is a planning tool, not financial or legal advice. Lifetime value depends on the repeat rate you enter: check it against your own sales data. Results depend on the figures you enter.
Refunds: because this is an instant digital download, refunds aren’t offered once the file has been downloaded. If the file is faulty or won’t open, email ivan@thelotterycfo.com and I’ll fix it or refund you.
Rather have a person check your numbers? A Health Check of selected draws, from £495: thelotterycfo.com/health-check