What insights and analytics are available on club lotto?

The Lotto dashboard on our admin portal provides details on lotto sales across a configurable time range.

This includes information such as

Details on the different product performance is also available

When a club had draw products that are recurring, our revenue allotment used a simple heuristic to assign revenue from each subscription to each draw. We simply took the total amount paid by the player over the lifetime of their subscription and divided by the number of draws entered, or due to be entered, so far. Depending on the timing of the draws and the product mix (weekly, monthly payments, 3 for a fiver), and whether draws were ever deleted, this heuristic could generate variation from draw to draw. This is likely what is reflected here.

We've recently (January 2024) changed the way we assign revenue for draws. We now allocate each incoming payment to future draw revenue on a pro-rata basis, taking into account the number of entries and draws per payment. This will slightly change the numbers vs historical, as it's a different approach, but it should show better consistency as it beds in.

Revenue is allocated per draw slot, not directly per purchase.

When a payment is received, we work out how many draws it covers.

We split the payment evenly across those draws.

If the purchase has multiple entries per draw, we split each draw's share evenly across those entries too.

Each paid draw slot stores its own revenue.

When a draw is assigned, it takes the next eligible slot for that player.

The draw summary totals the revenue on all slots assigned to that draw.

Example:

A player pays €40 for 4 weekly draws with 2 entries per draw.

€40 / 4 draws = €10 per draw

€10 / 2 entries = €5 per entry slot

When a given draw runs, it gets 2 slots x €5 = €10 revenue from that purchase.

For subscriptions:

Each subscription payment is treated the same way.

If the subscription payment covers 4 draws, the payment is spread over 4 future draw slots.

If invoice credit/proration applies, we reduce the number of covered draws accordingly.

Provisional entries can later be matched to the payment, and then carry that payment's revenue.

For paid-in-full purchases:

A single-draw purchase puts the full draw revenue into that one draw.

A multi-draw purchase spreads the purchase price evenly across the included draws.

If an old purchase has no payment record, we fall back to product price / draw count.

The report then groups the allocated revenue into:

Single Draw Revenue:

Multiple Draw Revenue

Subscription Revenue

So in plain terms: we slice the money into equal draw-sized pieces, attach those pieces to the player's draw entries, and each draw adds up the pieces that landed in that draw.