← Back to blog

How to track inquiries and bookings in your event business

To track inquiries and bookings in your event business, a spreadsheet with one row per inquiry is enough: when it came in, through which channel, what event it was, whether you sent a quote, whether it booked and, if it didn’t, why. With that, once a month, you look at three numbers: what share of inquiries turns into an event, how long you take to reply and why the ones you lose fall through. You don’t need a system or a head for numbers.

Why track if “I more or less know how it’s going”

Everyone who runs an event company, a venue, a catering business or an event service has a feeling for how the month is going. But that feeling is built from the latest thing that happened: two parties booked and everything seems fine; three “no”s in a row and nothing seems to work.

The spreadsheet doesn’t replace your instinct, it corrects it. It shows you how many inquiries really came in, how many slipped away without a reply and whether the reason you lose sales is price, the date or something you can fix. Without that record, any change you make (raising prices, paying for ads, hiring someone to answer) is made blind.

The spreadsheet: one row per inquiry

Open whatever spreadsheet you use (Google Sheets, Excel, the one on your phone) and set up these columns:

Column What to log Example of how it’s filled in
Inquiry date The day they wrote to you Nov 3
Channel How it arrived WhatsApp, Instagram, email, website form, phone
How they found us What the person tells you Referral, Google, another supplier
Name and contact So you can write back Name and phone
Type of event What they want to do Wedding, quinceañera, birthday, company event
Event date When it’s for Feb 14 or “no date”
Guests Approximate number 120
First reply The day and time you replied Nov 3, 6 p.m.
Quote sent Yes or no, and the amount Yes, the amount you sent
Next follow-up When you’ll write again Nov 6
Status Where it ended up Open, booked, lost
Reason If lost, why Price, date taken, no reply, chose someone else, event canceled

Two rules for the spreadsheet to be useful:

  • Every inquiry goes in, even a lone “price?”. If you only log the ones that look serious, you won’t know how many fell through at the first message.
  • The reason for losing is picked from a short list. If you write something different each time, you can’t add them up at the end of the month. Five or six fixed options are enough. Add a notes column for detail.

The “How they found us” column is the one most people skip and the one that saves you the most decisions. How to ask without it sounding like a survey is in where your event clients come from and how to find out.

What to look at each month

Once a month, on the same day, sit down for fifteen minutes with the spreadsheet. Filter the previous month’s inquiries and pull out these three numbers.

1. Your booking rate

This is the share of inquiries that ended in a confirmed event with a deposit. The math is: booked inquiries divided by inquiries received, times one hundred. For example, if you logged 20 inquiries in the month and booked 5, your booking rate is 25%.

It’s worth calculating it two ways:

  • Over all inquiries. It tells you how well you filter and respond from the first message.
  • Over those that received a quote. It tells you how well your proposal sells once the person has it in hand.

If the first is low and the second is fine, the problem is before the quote: you’re slow, you reply halfway or you get inquiries that aren’t for you. If both are low, look at the proposal and the price.

Don’t compare your number with what someone says in a group or a talk. You don’t know how each person counts. Compare it with your own previous month: what matters is whether it’s going up or down.

2. Your response time

With the “Inquiry date” and “First reply” columns you know how long it took you to answer each one. Look at how many you answered the same day and how many took longer. Then cross it with the status: if the ones you were slow to answer book less often than the ones you answered fast, you know where part of the lost money is.

How to put together a fast, complete first reply is in answering quote requests on WhatsApp.

3. Why you lose the ones you lose

Count how many times each reason for losing appears. Each one calls for a different decision:

  • Price. Before lowering it, check whether the price is understood. Often the client isn’t comparing prices, they’re comparing what they think each option includes.
  • Date taken. Half good news: there’s demand you can’t serve. It may be time to raise prices on those dates or to have someone you trust to pass work to.
  • Stopped replying. It’s almost always follow-up. Check whether you wrote again and when. A simple follow-up plan is in venue inquiries that don’t convert, and it works for any type of event business.
  • Chose someone else. If you can, ask what made them decide, without reproach.
  • Event canceled. Not up to you. Log it so it doesn’t muddy the rest.

If one reason repeats month after month, that’s your first task for next month.

Mistakes that make the spreadsheet useless

  • Filling it in from memory at the end of the month. Inquiries get lost and response times end up made up. Log it on the spot, even if it’s just date, channel and name, and fill in the rest later.
  • One spreadsheet per person. If two people answer, it should be one sheet for both.
  • Deleting the lost ones. Lost inquiries are the ones that teach you most. You change their status, you don’t delete them.

If the spreadsheet gets too small, the same record can move into a system. But it has to work by hand first: a system doesn’t organize what isn’t organized.

Knowing where you stand

Tracking is one of the six areas I look at when working with event business owners: risk, what you sell and how you explain it, what you track, how you communicate, the numbers and who the business depends on. If tracking is your weak spot, start with this spreadsheet and message me on WhatsApp so we can go through it together.

Frequently asked questions

Do I need a CRM for this?

Not to start. A shared spreadsheet is enough as long as you fill it in every day. A system makes sense once you know what you want to look at and the spreadsheet has become hard to maintain.

Does someone who only asked for the price and never replied count as an inquiry?

Yes. Log it with the reason “no reply”. If you don’t count it, your booking rate will look better than it is and you won’t see that the problem is in the first message.

How often should I look at the numbers?

Once a month is enough to see trends. If you’re just starting and few inquiries come in, look at two or three months together, because with very few rows any number swings a lot.

Message me on WhatsApp