A small spreadsheet can tell you which enquiries you replied to, which ones you quoted for and which turned into jobs. Start by recording what you actually know about where each enquiry came from.
Put one enquiry on each row
Use these headings in a spreadsheet you control. Give each enquiry a short reference so you can find the original message. You can keep names and contact details in the inbox if the tracker only needs the reference.
Spreadsheet headings
Date · Reference · Source · How you know · Status · Follow up on
Write down where it came from when you can
If someone says they found you on Instagram, enter “Instagram” and “Customer told me”. If they used a form and you don’t know what brought them to it, enter “Unknown”. A visit to the website and a message from a customer are two different things.
Update the row as the job moves on
Start with “Enquiry”, then change it to “Replied”, “Quoted” or “Booked” as you go. Record “Paid” when the payment comes in. Keep test messages out of your customer counts.
Example from a fictional business
6 November · G12 · Instagram · Customer told me · Quoted · Follow up on 10 November
Check it at the end of the month
Count the enquiries received that month and how many of those same enquiries booked or paid by your review date. Keep quotes that are still open visible. If a post had lots of clicks but none of the customers can be traced back to it, leave that source unknown.
Try it with AI
Find where your enquiries turn into workClaude Cowork, Claude or ChatGPT
Use this de-identified enquiry table. Count enquiries by recorded source and count how many of those booked or paid. Keep open, missing status and unknown source separate. Show numerator and denominator for every rate. If I give a date range, exclude undated rows from that period and show them separately. If I don’t, label the result “all supplied rows”. Don’t infer missing data or rank sources from tiny samples. Give one follow-up I can measure next month. Rows containing date, reference, source and status: [paste or attach]Browse all prompts