Free excel template · 30 minutes
20-enquiry audit tracker
A ready-made spreadsheet for the enquiry audit: enter each enquiry's source, arrival time, first reply and outcome. Response times, booking rate and cost per booked lead are calculated automatically.
- A log for 20 enquiries with drop-downs for source, owner and outcome
- Automatic first-response time and share answered within 5 minutes
- Booking rate and cost per booked lead by source
- A one-page summary to share with your team
How it works
Useful in one sitting.
01
Download the template
It opens in Excel, Google Sheets or Numbers. Example rows show how to fill it in.
02
Fill in the inputs
Only the shaded cells need your numbers. Everything else is calculated.
03
Read the summary
The summary tab shows the measures that matter, ready to share with your team.
More free resources
Keep going.
CalculatorLead leak calculator
See how many bookings slip away between enquiry and appointment, in rupees.
Use it free2 minutes
CalculatorBreak-even ROAS calculator
Know the ROAS and cost per order you need before you raise ad spend.
Use it free3 minutes
2-minute quizGrowth leak score
Score your business across the five stages and find the leak to fix first.
Use it free2 minutes
Want a second pair of eyes?
Get a free Scan: we show you where customers slip away between first view and a booking or an order, with a plan you can keep.