An enquiry-to-enrolment tracker an institute can run on a spreadsheet

An enquiry-to-enrolment tracker is one sheet with a line for every family that asked about a place. About ten columns follow them from the first call to a yes or a no. That is all. Kept honestly, it shows which source brings enquiries, how many reach a visit and where the fee talk loses them. A sports academy, a tuition centre or a skills school can run it on a spreadsheet and a free hour on Saturday.

What does each line need to say?

One line is one child or learner, not one phone call. If a parent enquires for two children, that is two lines, because they may choose differently.

Set the columns once and do not add more for a month. This is the layout we suggest for a badminton or cricket academy taking children into age groups, and it works for most institutes with small changes:

Here is one finished line, with invented details: 12 Oct | Aarav, 9 | Instagram | Rekha | 12 Oct | trial 15 Oct | Yes, ₹3,000 a month, under-11 batch | call 20 Oct | Thinking | Distance.

The two columns people skip are "First call by" and "Next step and date". They are the two that find the leak. A line with no owner is nobody's problem, and a line with no date is a line that will be forgotten.

How do you keep it from becoming homework?

Keep it where the phone is. If the front desk takes calls, the sheet is open on the desk screen or in a shared phone sheet, and the line is added before the call ends. Staff who must walk to the manager's room to log enquiries stop logging.

Use a fixed list for source, decision and reason, set as dropdowns if your spreadsheet allows. Free text in those columns means "walk in", "Walk-in" and "walkin" become three sources and the count is useless.

Make one person responsible for the sheet itself, even if many people fill it. Each Saturday, that person scans for open lines with a past date and gives them to whoever owns them. That ten-minute pass is the whole management system.

What does the sheet tell you after a few weeks?

It answers four questions, each by counting a column.

1. Which sources bring enquiries, and which of those reach a trial or visit?
2. How long from enquiry to first reply, and does the slow reply lose families?
3. Where do lines stop: before the visit, after the visit, or at the fee talk?
4. What are the reasons on the lost lines, grouped?

You do not need formulas to read it. Filter by source and count. Filter by decision and count.

Do not read too much into small numbers. If you have twenty lines, one family can swing the pattern. Wait for a few dozen before you change a fee or drop a channel.

For example, a football academy in Kochi

This is an invented case with made-up figures. The academy takes boys and girls between six and sixteen across three age groups. After six weeks of honest logging there are 46 lines. The owner filters by source. School tie-ups and referrals bring 11 enquiries between them against 24 from Instagram, but 8 of the 11 come for a trial. Of the 24 from Instagram, 5 visit.

Then the owner filters on "Visit or trial date" against "Decision". Of the 13 families who tried a session, 9 joined. Of the four who dropped off after the fee talk, three say "distance" and one says "fee". The owner's assumption had been that price was the problem.

So the academy tests the distance, not the price. The Maps profile now shows the ground's gate, the nearest bus stop goes into every first reply, and families coming from far are offered the second batch first, which sits closer to school hours. The limit is plain: with only a handful of families behind the pattern, the owner keeps watching for another month rather than redesigning the academy, and two of the distance families join another academy anyway.

What do you do with a line that has gone quiet?

Set a rule for when a line becomes "quiet": for example, no reply to two attempts, a week apart, over your normal enquiry cycle. Choose your own numbers and write them on the sheet. Then mark the decision "thinking" until the rule is met, and only then change it to "no" with the reason "quiet". A family still thinking is not a loss, and a family you stopped calling is not a "no".

When a spreadsheet is the wrong tool

A spreadsheet fits while two people, at most, handle enquiries and nobody needs automatic reminders. It stops working when:

• Two staff open the same sheet and overwrite each other.
• Follow-ups are missed because nothing nudges the person who owns them.
• You want messages sent automatically after a visit.
• The sheet has grown to thousands of lines and takes a minute to open.

At that point you want a CRM, and the columns above carry across unchanged. Pipeline management describes how that setup is built around the same stages.

Start with the sheet you can finish

Copy the ten columns into a new sheet today and log only the enquiries from now on. Do not back-fill old ones from memory, because remembered dates are unreliable. After enough lines to see a pattern, sit with your counsellors and read the lost reasons aloud. The education and training hub lists how other kinds of institute are found and chosen, and if you would like the whole path from enquiry to enrolment looked at, management dashboards and reporting is the related work. Tell us what you need to start.