Admission Funnel Tracker: See Where Enquiries Stop, Not Just How Many

How it is usually done

Admission enquiries arrive by phone, at the front desk, through a website form, from school visits and from parents who were told about you by another parent. In most institutes each of those lands somewhere different: a register, a notebook, an inbox, a counsellor phone. At the end of the season somebody counts admissions and compares them with last year.

That comparison arrives far too late to change anything. A funnel tracker exists so that the state of the season is readable in February rather than explicable in July, and so that an enquiry which has not moved in nine days is visible on the ninth day.

One record per prospective student, created at first contact from any source.

• Enquiry date and source — captured once, from a fixed list, never overwritten.
• Student name and current qualification — including board or stream where it affects eligibility.
• Parent or guardian name and mobile — separately from the student contact.
• Course of interest and preferred batch timing — timing is a common and under-recorded reason for loss.
• Locality or travel distance — a real decision factor that rarely appears in any system.
• Assigned counsellor — with a log when ownership changes.
• Stage and stage entry date — the two fields the whole funnel is built from.
• Days in current stage — derived, and the fastest way to find stalled enquiries.
• Next action and due date — every open enquiry should have one.
• Fee quoted and concession requested — recorded rather than remembered.
• Institutes being compared — where the family volunteers it.
• Outcome and reason — enrolled, deferred to next intake, or lost with a coded reason.

Illustrative example only. The counts below are invented to show how the funnel is read, not figures from any institute.

The right-hand column is the whole point. A funnel without an interpretation is a set of numbers that makes everyone defensive.

One counsellor with forty enquiries can hold the season in their head. Five counsellors across two campuses cannot, and the sheet they share becomes a file somebody has open in edit mode when the person who needs it is with a parent.

In a CRM each enquiry is a record with an owner, a stage and a next action. The counsellor sees their own list, the head of admissions sees the funnel, and the stalled enquiries surface themselves. Conversations on WhatsApp attach to the record, so a colleague covering a leave day can pick up mid-discussion.

Stages that describe intent. Following up is not a stage. An appointment on a date is.

Overwriting source at enrolment. It destroys the only link between spend and admissions.

Closing the file after counselling. The decision usually happens after the meeting, not in it.

Not interested as a lost reason. It is a sentence, not a reason, and it prevents every useful change.

Continue with lead management software, WhatsApp CRM, AI CRM, the built-in dialer, sales automation, and the tools library.