Two Fat Ladies HQ

Connect to your Worker once. These details stay in this browser (an app saved to your home screen asks once more).

Two Fat Ladies HQ

Right now

Today so far

Claude only sees totals (sales, ads, competitions, site visits). No customer names, emails or contact details are sent.

Ask Claude

Competition planner

Add the prizes and Claude suggests ticket price, ticket count and run length from how your past competitions sold. By default a sell-out takes in double the prize cost (100% mark-up). All prize costs include VAT, as ticket sales are exempt and VAT can\u2019t be reclaimed.

Claude picks the prizes with estimated costs, fills in the form below and writes the plan. Then tweak it in the form or by chatting.

Or fill it in yourself

Instant wins

Where to buy

Prize cost (inc VAT)
For example

Fine-tune with Claude

House rules

Standing rules Claude follows on every plan. Claude offers to add one when you tell it something in a plan chat that sounds like a rule.

  • Sell-out takes in the prize cost plus the mark-up (100% unless you change it) (built in)
  • All prize costs include VAT: sales are exempt, so VAT can’t be reclaimed (built in)

Saved plans

Import an orders export to see customer value. For the first import, export all time rather than 30 days, so the dashboard knows who is genuinely new.
Import a users export too. Sign-up dates tell the dashboard which customers are new, so sign-up and joining-week figures stay empty without it.
Customers who bought in the last 30 days
Share of card revenue from your top 10 customers (30 days)
Sign-ups who buy within 24 hours (last 4 complete weeks)

New sign-ups

People who signed up in each period, how many placed an order in that same period, and what they spent by card. Wallet credit is shown separately and left out of the average order value, as in your monthly figures.

PeriodSigned upPlaced an orderConversion OrdersCard spendAverage order (card)Spend per buyerWallet credit used

No sign-ups loaded yet. Import a users export.

Sign-ups and first purchases

Most people who buy do so within minutes of signing up. A falling 24-hour line points to a sign-up or first-checkout problem rather than an ad problem.

New customers by the week they joined

What each week's new customers went on to spend by card. Meta spend per new customer is blended: all Meta spend that week divided by all new customers, including those who didn't come from ads. "…" means that group hasn't been around long enough yet.

Joined (week of)New customersMeta spend per new customer First 30 daysFirst 60 daysFirst 90 daysSpend to date Bought again within 30 daysBecame regulars in 90 daysPaid back so far

No new customers to show yet. This needs both an orders export and a users export.

New customers by the month they joined

Share who buy again within 30, 60 and 90 days of their first order, and average card spend. Blank until a month's customers are old enough.

MonthNew customersBuy again 30d60d90dSpend 30d60d90dTo date

Run customer-analytics.sql in Supabase to fill this in.

Discount code vs full price first orders

Do customers who started with a code (e.g. NEW20) come back as often, and spend as much, as those who paid full price?

First orderCustomersBuy again 30dBuy again 90dSpend 30dSpend 90dSpend to date

Who to contact

RaffleX doesn't show user IDs, so pick the customer export (the one with email, phone and joined_at) and the lists below are matched to names by sign-up time. The file is read in this browser only: nothing is uploaded, stored or saved, and the names disappear when you close or refresh the page.

Before contacting anyone, check their RaffleX Interventions and self-exclusion status and their marketing preferences.

Top 20 customers (last 90 days)

By card spend.

#User IDCustomerCard 90 daysCard 30 daysOrdersShare of revenueLast order

Regulars who have gone quiet

User IDCustomerOrders in those 60 daysCard spent in those 60 daysLast orderDays quiet

No regulars have gone quiet.

Card revenue, last 4 complete weeks
Wallet credit re-spent, last 4 complete weeks
Share of sales paid with credit
Wallet balances outstanding (users in your imports only)

Weekly sales

Card revenue and credit re-spent each draw week, with Meta spend for comparison.

Day of the week

Share of card revenue against share of Meta spend over the last 28 days. A day where the spend bar towers over the revenue bar is a candidate for ad scheduling.

Monthly check

New users and card revenue now fill in automatically from RaffleX (shown in grey). Type a figure only to override it. If Meta looks great but this doesn't improve, Meta is over-crediting itself.

MonthMeta spendRetainerNew usersCard revenue (£) Ad cost per new userIncluding retainerCard revenue per £1 Share credited to ads

Website settings

Boosts

Analytics

Loading…

Reveals

Anonymous website tracking since phase 4 went live. Your own admin visits aren't counted.

Phone notifications

Get sign-ups, new customers, big orders, a daily summary and your weekly briefing as notifications. They only ever show counts, totals and competition names – never customer names or details.

This browser can't receive notifications. On iPhone, use the home-screen app (iOS 16.4 or later); on a computer, use Chrome, Edge, Firefox or Safari.

Devices getting notifications

Recently sent

Gmail link: instant wins and withdrawals

A small script in the Gmail account that receives RaffleX's emails (info@) sends the dashboard just the facts from each instant-win and withdrawal-request email. It never sends customer names, emails, addresses, phone numbers or bank details, and its key can only add these – it can't read anything.

RaffleX read-only check: withdrawals waiting

Every hour the Worker logs in to RaffleX with its own admin account, reads the Withdrawals list (unpaid only), notes request numbers, amounts and how long they've waited, and logs out. Its code can only open the login page and the Withdrawals list – it can't pay, approve, reject or change anything. Names and bank details are never kept.

Customer value

Break-even is what a new customer is worth, times your margin. Use your own figure, or let the dashboard measure it from real first-purchase customers once there are at least 20 old enough to count.

Rules

Recent imports

WhenReportResult

Nothing imported yet.

Import reports

Choose any RaffleX exports: orders, sales report, users, or customer acquisition attribution. Each is recognised automatically. Names, emails, phone numbers and addresses are dropped on arrival.