How to Track Student Enquiries Without Losing Any

Enquiries do not usually disappear dramatically. They disappear because they arrived on a channel nobody checks, were written on a register nobody reconciles, or were handled once by someone who then got busy.

Here is the minimum system that prevents that, whether you implement it in a spreadsheet or a CRM.

Step 1: List every channel

Most institutes underestimate this. Write down every route by which a parent can reach you:

• Website enquiry form
• Phone calls to the office landline
• Calls and messages to staff mobile numbers
• WhatsApp to the institute number
• Walk-ins to the front desk
• Facebook and Instagram lead ads
• Referrals from existing parents
• Enquiry forms collected at fairs and events

Any channel not on this list is a channel where enquiries vanish silently. The staff-mobile route is almost always the leakiest, because those conversations are invisible to everyone else.

Step 2: Route everything to one place

One destination. Not one per channel.

This is the step institutes skip, and skipping it makes everything downstream impossible — you cannot prioritise, follow up systematically or report on a list that does not exist as a single list. Website and ad enquiries should arrive automatically; walk-ins and phone calls need someone entering them the same day, which is a discipline question rather than a technical one.

Step 3: Capture the right fields — and no more

Every extra field is a field that gets left blank. The minimum useful set:

• Parent name and phone — phone is the identity key, so it must be clean
• Student name, and class or course wanted
• Source — from a fixed dropdown, never free text
• Date received
• Stage — from a fixed list
• Owner — one named person, never "the team"
• Next action and its date — the single most important field

Use dropdowns for source and stage. Free text degrades within weeks, and then reporting requires cleaning the data first, which is how reporting stops happening.

Step 4: Define stages that mean something

Four or five, no more. A workable default:

1. New — received, not yet contacted
2. Contacted — spoken to, qualified
3. Visit / Demo — campus visit or demo class booked or attended
4. Admitted — enrolled
5. Closed — with a reason

A stage should mean the same thing to everyone who uses it. If two counsellors would classify the same enquiry differently, the stage definition is too vague.

Step 5: Make follow-up automatic

This is where a spreadsheet reaches its limit. A sheet can record that a follow-up is due; it cannot perform one.

Minimum viable follow-up: contact within 24 hours, then on roughly day 3, day 7 and day 14 if there is no response. On WhatsApp, because that is what gets read.

If you are doing this manually, one person owns the "due today" filter each morning and it is their first task. If you are automating it, the sequence runs regardless of leave, workload or memory — which is the entire reason automation is worth paying for.

Step 6: Close properly

Every enquiry ends in Admitted or Closed-with-a-reason. Nothing sits in New for six weeks.

Use a fixed reason list — fee, location, timing, chose a competitor, unreachable, not serious. After one season that becomes a ranked list of what is actually costing you admissions, which is far more useful than a conversion percentage.

Step 7: The weekly review

Fifteen minutes, four numbers:

1. Enquiries in New older than 48 hours. Should be zero. If it is not, first-contact is broken and nothing else matters.
2. Enquiries with no next action date. Should be zero. These are the ones about to disappear.
3. Enquiries at Visit/Demo for more than 10 days. Your most recoverable group. Work it.
4. Closed this week, by reason. Watch what tops the list over time.

Only the first two are about discipline. The other two are where you learn something.

When to move beyond a spreadsheet

This system works in Excel. It stops working when enquiry volume exceeds what one person can review daily, when several people need to work the same list simultaneously, or when the follow-up needs to happen without anyone remembering.

We wrote about where that line sits in school CRM vs Excel. If you have crossed it, the lead management page covers how SCRMAI handles capture, deduplication and automated follow-up.