Your Cart
Loading

Marketing ROI and Customer Acquisition Model (Excel)

On Sale
£39.00
£39.00
Added to cart

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

You will get a XLSX (26KB) file