Tour, venue and caterer enquiries that never convert: finding where they drop

Keep one log with a row per enquiry and a tick for each step it reaches: enquiry, quote sent, visit or tasting done, booked. Count the ticks at the end of the month and divide each step by the one before. The step with the biggest fall is where to look first. Without the log it is easy to blame the enquiries or the price, when the loss may sit between two steps nobody measured.

The log: the columns that matter

Date | Name / phone | Source | Event date | Replied? (date) |
Quote sent? | Visit or tasting done? | Booked? | If lost: reason

Source means where they came from: Google, Instagram, a friend, a planner, a previous guest. Event date helps you spot enquiries that are too far ahead to count yet. Reason for loss is a short word: price, date unavailable, chose another place, no reply, plans cancelled.

Fill it in the same day. A log written from memory at the end of the month is unreliable.

Count the steps

At month end, count how many rows have each tick. Then work out the share that moved from one step to the next.

In an invented case, a caterer and event venue in Kochi logs 40 enquiries in a month (illustrative numbers):

The biggest drop is between quote and visit: 26 quotes, only 7 visits. The owner had assumed the enquiries were weak and had been thinking of more advertising. The log said the leak was after the quote. The other gap, 9 of 40 enquiries unanswered the same day, was real too but much smaller, so it came second. Note that the 71% at the last step looks healthy and is not the problem: five bookings from seven visits suggests the place does its job once people are in the room, though seven is a small number.

Reading the drop

Each gap points to a different cause, so match the fall to a fix.

Enquiry to reply. Nobody answered, or answered late. Look at who watches the phone, WhatsApp and the portal, and at what happens on a function day when everyone is busy. This is the cheapest gap to close.

Reply to quote. The caller did not give enough to quote, or you did not ask. Use the questions in a group-booking enquiry checklist and the layout in quoting a wedding or event.

Quote to visit. The quote went out as a PDF on WhatsApp with no invitation to see the place. People may not come on their own; they come when someone says, "Saturday at five, I will show you the hall and the kitchen." The Kochi caterer changed one thing: every quote ended with two named slots for a visit or tasting. Prices stayed as they were. The next month showed 12 visits instead of 7, though only 6 of those 12 booked, since the new visitors were less committed than the self-selected ones before. It was still a gain of one booking.

Visit to booking. The place or the tasting did not convince them, or the price looked heavy once they saw the competition. Ask the lost ones why. This is the one gap where a price change may be right.

A decision rule

Fix the earliest large gap first. Fixing a late gap while an early one leaks sends more people into a leaking pipe. If two gaps are close, choose the one that is cheaper to change.

Make one change at a time, and change nothing else for a month or two, so you know what moved the numbers. A new price list, a new reel and a new person on the phone in the same month tell you nothing.

Do not read too much into small numbers

With forty rows, one wedding is a big swing. Do not rebuild the sales approach on one bad month. Keep the log for a few months, and compare the same month in a busy season only with another busy one. Peak and quiet weeks behave differently, and so do wedding enquiries and corporate ones; if you can, log them in separate sheets.

Do not trust a percentage on a handful of rows. Seven visits is too few to say whether 71% is luck. Use the shares to point at a step, then look at the individual rows before you change anything. A tour operator with long planning cycles will see the booking step come weeks after the enquiry. Count by the date of the enquiry, not the date of the booking, or you will end up comparing this month's enquiries with last month's bookings.

Recover the ones that dropped

The log also gives you a list. Everyone who got a quote and went quiet is a person you can write to once, with something useful, such as a date that has just opened. Why businesses lose leads after the first conversation explains why a short second message works better than silence. If your lost-reason column says "no reply" often, that is the first thing to repair.

If the sheet gets unwieldy, how to track your sales pipeline shows a plainer layout. Other hospitality trades are under hospitality sales and marketing.

Start the log with this month's enquiries

Copy the column list into a sheet, fill in what you remember from the last thirty enquiries, and count the ticks. Look for the biggest fall between two steps and write one change you will make. If you would rather have someone else read the records, lead leakage analysis is the service, and tell us what you need is where we start.