Turn your own ad and lead spend into a cost per call and cost per booked job

One Essex locksmith says paying for clicks has squeezed genuine locksmiths out, and agencies that sell leads or ads publish their own price examples. Whatever a seller says, the only figures that matter are yours: what you spent, how many calls became booked jobs and what each job paid. AI can lay your own totals out in a table and write a few plain sentences. It must not bring in outside benchmarks or recommend a seller.

A free AI chat tool, then your own email or messaging app

Steps

1. Copy last month's spend by source (ads, lead sellers, directories) from your own statements, with the calls, quotes sent and jobs booked from each.
2. Add what each booked job paid on average, and your own cost per job for parts and fuel, from your records.
3. Paste only those totals into the prompt and leave out customer names, addresses and phone numbers.
4. Ask for a table of cost per call, cost per booked job and the share of the job price spent winning it, with a few plain sentences. Check the sums yourself with a calculator.
5. Decide yourself what to change, and run the same table next month so you can compare like with like.

The exact prompt

I am a UK locksmith. Using ONLY the figures below, produce a table and a short plain-English commentary. Do not use any industry benchmark, average, rule of thumb or price that I have not given, do not recommend any seller or platform, and do not say what I should spend.
Month: [month]. For each source (name it): spend £[amount]; calls [number]; quotes sent [number]; jobs booked [number]; average job price £[amount] (planned work and emergency work separately if I give both).
My own average cost of parts and fuel per job: £[amount].
Produce: (1) a table with columns source, spend, cost per call, cost per quote, cost per booked job, cost per booked job as a percentage of the average job price; (2) five sentences saying what the table shows, comparing sources only with each other; (3) a list of what I would need to track to make the next month more useful.