Free Admissions Funnel Calculator for Enquiry to Enrolment

What is an admissions funnel?

An admissions funnel is the sequence of stages a prospective student passes through, from first enquiry to paid enrolment. This admissions funnel calculator models five stages: enquiry, counselling, campus visit or demo class, application and enrolment. Each stage has a conversion rate, and multiplying them gives your overall admission conversion rate.

Every institution that sells a seat has some version of this funnel. A school has enquiry, campus tour, registration and admission. A coaching institute has enquiry, counselling, demo class and batch joining. A college has enquiry, counselling, application and fee payment. A study abroad consultancy has enquiry, profile evaluation, shortlisting, application and visa. The stage names change. The arithmetic does not.

The calculator asks for seven inputs: enquiries per month, enquiry to counselling, counselling to campus visit or demo class, visit or demo to application, application to enrolment, fee per student and marketing spend. It returns the number of students at every stage, enrolments, revenue, overall conversion, cost per enrolment and a lever analysis. The lever analysis adds 5 percentage points to one stage at a time and shows which change adds the most enrolments.

A few terms, defined once. Counselling means a structured conversation, by phone, video or in person, where an admissions counsellor understands the student's need and explains the programme. Counselling conversion is the share of counselled students who move to the next stage. A demo class is a trial session offered by an EdTech or coaching business. An application is a filled form or a registration with documents or a token amount. Enrolment is a paid seat.

The tool exists because admissions teams are usually measured on one number, total admissions, at the end of the season. By then it is too late to learn which stage failed. A funnel view during the season shows where students drop off while you can still act. It runs in your browser and uses only the numbers you type.

Why does admission conversion matter for Indian education businesses?

Admission conversion matters because enquiries are bought at a steady price, while seats are filled only at the end of the funnel. Small shifts in conversion change revenue far more than the same shift in lead volume.

Education in India is highly seasonal. Many schools and colleges depend on a fixed window, and coaching and EdTech businesses see surges around results, board exams and batch starts. During peak weeks, enquiries arrive faster than counsellors can handle them. In the default example, 2,000 enquiries a month at ₹6,00,000 of marketing spend cost ₹300 per enquiry. If a team cannot reach those students quickly, the money is gone before a single conversation happens.

The decision is also shared. A parent, a student and sometimes a grandparent all take part. They compare institutions, ask for fee details on WhatsApp and visit more than one campus. This is why counselling quality and follow up speed matter more in education than in many other sales settings. A counsellor who calls once and waits is competing against one who sends a fee structure, a campus visit slot and a reminder.

Drop off is large and mostly invisible. In the default example, 2,000 enquiries produce 118.1 enrolments. That means 1,000 never reach counselling, 650 are counselled but never visit or attend a demo, about 192 visit but do not apply, and about 39 apply but do not enrol. Each of those groups is a list you can work.

How to use the Admissions Funnel Calculator

Use last month's actual figures, or a full admission cycle if your intake is seasonal. Pull counts from your CRM, enquiry register or sheet. Do not estimate from memory, because teams usually overstate counselling.

1. Enter enquiries per month. Count unique students or parents who asked about a course, from Meta lead ads, Google, Shiksha style portals, Justdial, school website forms, WhatsApp and walk ins. Remove duplicates.
2. Enter enquiry to counselling. Count enquiries where a real counselling conversation happened, not just a missed call or a brochure sent. If 1,000 of 2,000 were counselled, enter 50%.
3. Enter counselling to campus visit or demo class. Count students who attended, not those who were invited. Divide attendance by counselled students.
4. Enter visit or demo to application. Divide applications or registrations by the number of students who attended a visit or demo.
5. Enter application to enrolment. Divide paid seats by applications. If a token payment counts as enrolment in your institute, use that definition every month.
6. Enter fee per student and marketing spend. Use the fee you actually collect for the first year or the first batch, in rupees, and the month's total ad and portal spend.
7. Read the lever table. The tool adds 5 points to each stage separately and ranks them by extra enrolments.

Once you have the result, look at the lever table first. The top lever is where one focused change pays most. Give it a single owner, such as the head of admissions for the counselling step or the campus manager for the visit step. Rerun the calculator at the end of the month using the same definitions. If you also want to know what slow replies cost before counselling, the Lead Response Time Calculator models that gap.

How is the admissions funnel calculated?

The calculator multiplies each stage rate by the number of students who reached that stage. Each output is the input to the next, so a gain early on flows to every later stage.

Counselled = enquiries x enquiry to counselling Visit or demo = counselled x counselling to visit or demo Applications = visit or demo x visit to application Enrolments = applications x application to enrolment Revenue = enrolments x fee per student Overall rate = enrolments / enquiries Cost per enrolment = marketing spend / enrolments

What each input means:

• Enquiries per month. The top of the funnel, counted once per student.
• Enquiry to counselling. Mostly a function of how fast and how many times you try to reach the family.
• Counselling to campus visit or demo. Shows how well counselling creates a reason to take the next step.
• Visit or demo to application. Shows the quality of the experience and how clearly the next step was explained.
• Application to enrolment. Shows fee clarity, documentation friction, scholarship decisions and competing offers.
• Fee per student. Revenue per seat. If fees vary by course, run the tool once per course.
• Marketing spend. Total paid spend for the month.

The lever analysis keeps everything else fixed, raises one stage rate by 5 percentage points and recalculates enrolments. It is not a forecast. It shows where a given improvement is worth most, and the answer depends on how many students sit at the front of each stage.

Assumptions to keep in mind. The tool assumes all students in a month finish the funnel in that same month, whereas many admissions take several weeks. Benchmarks vary widely by course, city and institute type, so use your own best months as the target.

Worked example: 2,000 enquiries and a ₹60,000 fee

This example uses the default inputs the tool shows on first load. It is an illustration of the arithmetic and not an industry benchmark.

The funnel loses the most students at the second stage. Of 1,000 counselled students, only 350 go on to visit or attend a demo. That is 650 students who spoke to a counsellor and then stopped.

Now the lever analysis, adding 5 percentage points to one stage at a time:

Counselling to visit or demo wins because it acts on 1,000 students and every gain then passes through two more stages. The final stage has the smallest lever because the base is smallest. In rupees, 16.9 extra enrolments at ₹60,000 is about ₹10.1 lakh a month. Your own ranking may differ, and that is the point of running it with your numbers.

How do you read your result?

Read your result from the bottom line upward. Check cost per enrolment and overall conversion first, then find the stage with the largest lever and the largest gap against your own best month.

There is no universal good admission conversion rate. A selective college, an open enrolment coaching centre, a low fee EdTech course and a study abroad consultancy all behave differently. Treat the table below as a reading guide for the default example only.

Admissions funnel by industry

The five stages apply in education, but the same logic works in other sectors where a prospect has to be counselled, shown the product and signed. Here is how it plays out.

Real estate

The equivalent of counselling is the qualifying call and the demo class is a site visit. A buyer who is counselled on budget, loan and timeline is more likely to attend a visit. Track enquiry to qualified call, qualified call to visit and visit to booking. The Site Visit to Booking Calculator covers the property version in detail.

Education: schools, colleges, EdTech and study abroad

Schools should track enquiry, campus tour, registration and admission, and watch the gap after the tour. Colleges should add a scholarship or entrance test stage. EdTech and coaching teams should measure demo class attendance separately from demo to purchase. Study abroad teams should add profile evaluation and shortlisting before application. Always keep parents in the loop for minors.

Manufacturing and B2B

Counselling becomes requirement gathering. The visit or demo becomes a plant visit, sample or trial, and the application becomes a quotation or purchase order. Cycles are longer and several people decide, so record a dated next step for every account. Fee per student becomes order value.

Healthcare and clinics

Counselling is the patient coordinator's call. The visit is the first consultation. The application is a treatment plan accepted and enrolment is treatment started. Patients drop off when costs are unclear, so share procedure and cost ranges only through approved messages. Handle health information carefully under the DPDP Act.

Automotive

Counselling is the product advisor's call. The visit is the test drive or showroom visit. Application becomes a quotation or booking form and enrolment becomes booking confirmed. Compare enquiry to test drive across sources, and follow up within a day of the drive with a finance option.

Insurance and financial services

Counselling is the needs analysis. The visit or demo is a plan illustration or review meeting. Application is the proposal form and enrolment is policy issued. Dropouts commonly happen at documents and medical checks. A checklist and a dated reminder reduce them. Keep call and consent records.

SMBs and services

Counselling is a discovery call, a demo is a trial or proposal walkthrough, and enrolment is a signed work order or subscription. If the owner runs every demo, protect that calendar and send a WhatsApp recap the same day.

What mistakes do teams make with admissions funnels?

Admissions teams tend to measure outcomes but not the stages that produce them. These are the mistakes that cost the most.

• Counting a call attempt as counselling. A missed call or a brochure on WhatsApp is not counselling. Count only conversations where the student's need was understood.
• Treating invited as attended. A booked demo or campus visit is not a completed one. Record attendance separately.
• Quoting one blended rate for all courses. A short course and a full degree behave differently, so run them separately.
• Ignoring the parent. For school and college admissions, the parent decides. Counselling only the student leaves out the person who signs the cheque.
• Letting the fee conversation happen late. Students who learn the fee at application stage often drop. Share the fee structure in the first counselling, in writing.
• Stopping follow up after two attempts. Education decisions take weeks. A short, polite sequence across call and WhatsApp keeps you in the running. Use the Follow Up Cadence Planner to build one.
• Judging a campaign on cost per lead alone. A cheap enquiry that never reaches counselling is not cheap.

How can you improve your admission conversion?

Improvement comes from the biggest lever, a named owner and a weekly review. Start with the stage the calculator ranks first, then work down.

Fix counselling to visit or demo

The owner is the head of admissions. Every counselling call should end with a booked date for the visit or demo, not a suggestion. Offer two slots. Send the confirmation on WhatsApp straight after the call with the location or class link. Send a reminder the day before and on the morning. Record the call and review five recordings a week using the Sales Call Scorecard Generator criteria.

Fix enquiry to counselling

The owner is the telecalling lead. Reach new enquiries within minutes during peak admission weeks. Make at least three attempts across two days on different times of day, with a WhatsApp message in between. Route each enquiry to a named counsellor on arrival. Check that numbers are valid and that Meta lead ad forms capture the parent's number.

Fix visit or demo to application

The owner is the campus manager or the demo lead. Brief the faculty or host about the student's interest before the visit. End the session with a clear next step: a form, a deposit or a counsellor call fixed for a specific time. Send the application link the same day.

Fix application to enrolment

The owner is the admissions coordinator. Keep a document checklist, a payment link and a named person for queries. Call applicants with incomplete files every second day. Offer instalment or scholarship information where your policy allows, without quoting numbers you have not approved.

Admissions funnel tracking: spreadsheet, CRM or Erino?

A spreadsheet can run a small intake, a generic CRM adds structure, and a CRM built for high velocity Indian teams adds follow up discipline. The right choice depends on volume, number of counsellors and how many channels feed you.

Sheets work when one person handles a few hundred enquiries. They fail when enquiries come from portals, ads and WhatsApp at the same time and several counsellors share the file. Generic CRMs such as Zoho CRM, HubSpot, Kylas, LeadSquared and TeleCRM offer stages, reports and automation. Features and plans change, so check each vendor's current plans. What matters for admissions is whether every stage has an owner, a next follow up and a record of the counselling conversation.

Erino is an AI first sales CRM for high velocity sales teams in India, including EdTech, coaching, schools, colleges and study abroad. It supports customizable pipelines, so you can model enquiry, counselling, demo, application and enrolment as your own stages. See the education and EdTech page and the platform overview. Dhee Coding Lab reached 650+ monthly admissions, up from 40 to 50, and Arivihan saw 22% higher enrolment conversion, as described in the Dhee Coding Lab story and the Arivihan story. Results vary by team. Pricing is quoted after a free 15 minute demo. Security includes DPDP Act alignment and data hosted in India.

Frequently asked questions