Study Abroad Funnel Metrics: Enquiry to Enrolment, Stage by Stage
Study abroad funnel metrics defined stage by stage: numerators, denominators, created vs moved clocks, cohort vs calendar views and a monthly review.
Study abroad funnel metrics tell you how many enquiries became qualified students, applications, offers, deposits, visas and enrolments, and where everyone else dropped out. Most consultancies quote a conversion rate; few can say what its numerator and denominator are or which date it counts on. This guide defines each stage conversion, explains the two date clocks and cohort versus calendar views, and ends with a monthly review you can run. It is for consultancy owners, admissions heads and branch managers in India.
Key takeaways
- Every funnel metric needs four things written down: numerator, denominator, grain (students or applications) and date clock.
- Count the first stage by created date. Every later stage counts by the date a student moved into it.
- Calendar views measure a month's activity. Cohort views follow one group of enquiries to the end, and only they give true conversion rates.
- Recent cohorts always look worse because they are not finished. Compare cohorts of the same age.
- There is no published benchmark you can trust for your market. Your own last three mature cohorts are the baseline.
Four things every funnel metric needs
A conversion rate is a fraction. Before anyone quotes one in a meeting, write down its four parts.
| Part | Question it answers | What goes wrong when it is vague |
|---|---|---|
| Numerator | Who succeeded? | Counting students "in Qualify now" makes the rate fall as students move on |
| Denominator | Out of whom? | A visa rate over all filed cases looks low while decisions are pending |
| Grain | Students (leads) or applications (deals)? | A student with three applications counts three times |
| Clock | Created date, or date moved into a stage? | Created-date lists and moved-date reports never agree |
Grain matters more in study abroad than in most sales work, because one student can hold several university applications. One rule settles most arguments: student grain for anything about people (qualifying, deposit, visa, enrolment), application grain only for the university's decision (offer rate, applications per student). If you are still deciding how to record several applications per student, read how to track multiple university applications first.
The study abroad funnel metrics, stage by stage
The definitions below follow a six-stage pipeline: Inquiry, Qualify, Application, Deposit, Visa, Enrolled. Rename the rows to match your stages; our pipeline stages template sets out the statuses under each stage.
| Metric | Numerator | Denominator | Grain | Clock |
|---|---|---|---|---|
| New enquiries | Students created in the period | None, it is a count | Student | Created date |
| First contact within a working day | Students with a logged call or WhatsApp outcome within a working day | New enquiries | Student | Created date |
| Enquiry to Qualify | Students in the group who ever entered Qualify | Students created in the group | Student | Created date |
| Qualify to Application | Students with at least one application submitted | Students who entered Qualify | Student | Date moved into stage |
| Applications per applying student | Applications submitted | Students who applied | Application per student | Date moved into stage |
| Offer rate | Applications with a conditional or unconditional offer | Applications that have received a decision | Application | Date of decision |
| Offer to Deposit | Students who paid a deposit | Students holding at least one offer | Student | Date moved into stage |
| Visa approval rate | Students granted a visa | Students whose visa was granted or refused | Student | Date of decision |
| Visa to Enrolled | Students enrolled | Students granted a visa | Student | Date moved into stage |
| Enquiry to Enrolment | Students in the group who enrolled | Students created in the group | Student | Created date |
Three choices in that table are deliberate.
- Ever entered, not in it now. A student who qualified on 3 October and applied on 20 October has left Qualify. Count only students sitting in Qualify today and your fastest counsellors get the worst rates.
- Decided, not filed. Offer and visa rates leave pending cases out of the denominator. Show the pending count beside the rate so a backlog cannot hide behind a healthy percentage.
- Not proceeding gets a reason. Record why a student stopped, as a status or sub-status at that stage. A drop-off without a reason shows where the funnel leaks, never why.
The created clock and the moved clock
The created clock is the date the student record was made. Your first stage has no other date, because students are created straight into Inquiry; nobody "moves in". So new enquiries, and any cohort, are counted by created date.
The moved clock is the date a student entered a later stage. "Students who qualified in October" means students whose move into Qualify happened in October, whenever they first enquired.
Mixing the two is the commonest funnel error. Take a hypothetical consultancy that logged 400 enquiries in October. In the same month, 130 students entered Qualify, but 45 of them had enquired in August or September. Dividing 130 by 400 gives 32.5%, a number that describes nobody: the numerator runs on the moved clock and the denominator on the created clock. Two honest statements replace it.
- "130 students qualified in October." That is activity, on the moved clock.
- "Of October's 400 enquiries, 85 have qualified so far." That is a cohort figure, and it will keep rising.
When the dashboard and the leads list disagree for this reason, the diagnosis is in our post on why a CRM report does not match the leads list.
Cohort view vs calendar view
| Calendar view | Cohort view | |
|---|---|---|
| Who is counted | Everything that happened in the month | One fixed group, such as March's enquiries |
| Clock | Moved date for each event | Created date picks the group |
| Answers | How busy were we? Who did the work? | Did March convert? Are we improving? |
| Final when | The month ends | Every student has enrolled, dropped out or deferred |
| Typical trap | Dividing a month's events by that month's enquiries | Comparing a young cohort with a mature one |
Study abroad adds a third grouping: the intake cohort, everyone targeting September 2027, say, whenever they enquired. It answers "how is the September intake shaping up?", which neither of the other views can, and it only works if intake is a structured field rather than a note.
Why young cohorts look bad
A cohort is not finished until its students' intake has passed, and government timelines set the pace. For the UK, GOV.UK says the earliest a student outside the UK can apply for a Student visa is 6 months before the course starts, and that a decision usually comes within 3 weeks. A November enquiry for a September course cannot file that visa before March, so the November cohort shows no visa conversions for months, and nothing is wrong.
Here is one hypothetical cohort of 400 March enquiries for September courses, measured at the end of four different months:
| Measured at end of | Entered Qualify | Applied | Deposit paid | Enrolled |
|---|---|---|---|---|
| March | 88 | 9 | 0 | 0 |
| May | 128 | 41 | 6 | 0 |
| July | 138 | 64 | 25 | 0 |
| September | 140 | 70 | 34 | 27 |
Read in May, this cohort's enquiry-to-enrolment rate is zero; in September it is 6.75%. So pick a maturity point, such as the end of the target intake month, and compare cohorts only at the same age.
Worked example: build your own baseline
We will not tell you what a good conversion rate is: published figures rarely define an enquiry or say whether they counted students or applications. Build the baseline from your own data. Here is the same hypothetical March cohort, fully mature:
| Step | Students in | Students out | Conversion | Students lost |
|---|---|---|---|---|
| Enquiry to Qualify | 400 | 140 | 35% | 260 |
| Qualify to Application submitted | 140 | 70 | 50% | 70 |
| Application to at least one offer | 70 | 58 | 83% | 12 |
| Offer to Deposit | 58 | 34 | 59% | 24 |
| Deposit to Visa granted | 34 | 29 | 91% of 32 decided, 2 pending | 3 refused |
| Visa to Enrolled | 29 | 27 | 93% | 2 |
| Enquiry to Enrolled | 400 | 27 | 6.75% | 373 |
At application grain, those 70 students submitted 182 applications, 2.6 each. 164 had a decision and 109 of those were offers, an offer rate of 66%.
- The biggest loss is not always the one to fix first. Enquiry to Qualify loses 260 students, but split it by reason before acting. Wrong numbers and ineligible profiles are a targeting problem for whoever runs the ads; "not reachable" is a follow-up problem for the team.
- The most expensive loss is Offer to Deposit. Those 24 students had already used counsellor hours and application fees. Finances, a competing offer and visa worries each need a different response.
- Small counts move a lot. With 32 visa decisions, one refusal moves the rate by about three points. Watch refusal reasons across cohorts, not one month's percentage.
To turn this into a baseline, take your last three mature cohorts and note the lowest and highest rate at each step. A new cohort outside that band at any step deserves a conversation. Inside the band, it is noise.
Time between stages
Conversion tells you how many students moved; velocity tells you how long they waited. A stage can convert well and still be too slow for the calendar.
| Interval | Compare it with |
|---|---|
| Created to first contact | Your own first-response target |
| Qualify to first application submitted | How long document collection should take |
| Offer to Deposit | The deposit windows your partner universities give |
| Deposit to visa filed | Each destination's earliest filing date |
| Visa filed to decision | The destination's published processing time |
Use the median, not the average: a few students who went quiet for six months drag an average far from the typical case. Export a row per student with the date each stage was first entered, add a column of differences in days, and take the median of the non-blank cells. If your median offer-to-deposit gap is longer than a university's deposit window, students are losing offers to the clock.
A monthly funnel review that holds up
Use the same definitions when you slice by source, counsellor and branch, the way a student recruitment CRM should report: cohort results go to the source that created the lead, and counsellors are judged on calendar activity within their own scope. A 45-minute agenda:
| Time | Look at | View | Question to settle |
|---|---|---|---|
| 10 min | Enquiries, qualified, applications submitted, deposits, visas filed | Calendar | Did the work happen this month? |
| 10 min | Stage conversions for the newest mature cohort against the last three | Cohort | Is any step outside its band? |
| 10 min | Median days between stages | Cohort | Where are students waiting? |
| 10 min | Top three not-proceeding reasons at the costliest step | Cohort | What one change do we try next month? |
| 5 min | Click one number and count the list it opens | Either | Can we trust today's figures? |
Before the meeting, check that:
- A one-page sheet lists numerator, denominator, grain and clock for every metric.
- One person pulls every figure with the same branch selection and IST dates.
- Pending counts sit beside the offer and visa rates.
How Xale handles this
Xale is our product, so weigh this section accordingly. In Xale's CRM reports and analytics, "conversions" means distinct students who entered your final stage in the period, with one definition on the KPI strip, the funnel, the source table and the team leaderboard. The first pipeline stage is counted by created date, in the number and in the list it opens, and the rule follows stage order rather than the stage's name. Filter a report by a stage or status and the date window follows when students entered that stage or changed that status.
Each university application is its own deal under one student record, so a student with three applications counts once in conversions, while the Admissions report follows every application through offer, deposit, visa and enrolment. Any number opens the exact leads behind it, days follow India Standard Time, and figures are limited to what the viewer is allowed to see. Intake custom fields and intake filters support intake cohorts, and saved report views can be shared and scheduled for the monthly review.
The limit: reports come as fixed report tabs and dashboard widgets. A ratio they do not show, with a denominator you choose yourself, means exporting the lists and doing the division in a spreadsheet. The study abroad CRM page shows how reports sit alongside the pipeline.
Frequently asked questions
What is a good enquiry to enrolment conversion rate for a study abroad consultancy?
There is no published figure we would trust for your market, because conversion depends on your lead sources, destination mix, fees and how you define an enquiry. A consultancy that counts every ad form fill will show a far lower rate than one that counts only walk-ins. Use your last three mature cohorts as the baseline and investigate any step outside their range.
Should funnel conversion rates count students or applications?
Count students for every step that is about a person: qualifying, submitting at least one application, paying a deposit, getting a visa and enrolling. Count applications only for the university's decision, such as the offer rate and applications per student. Counting applications at the people steps lets a student with three applications count three times, which makes sources and counsellors look better than they are.
Why does this month's cohort look so much worse than last year's?
Because it is not finished. A cohort of recent enquiries has not had time to apply, receive offers, pay deposits or file visas, and for the UK a student visa cannot be requested more than six months before the course starts. Compare cohorts at the same age, such as six months after enquiry or the end of the target intake month, never a young cohort against a mature one.
How often should a consultancy review its funnel metrics?
Check calendar activity weekly, because it shows whether calls, applications and deposits are happening. Review cohort conversions and time between stages monthly, once a cohort is mature enough to compare. Revisit the definitions each quarter or whenever the pipeline changes, since a renamed or added stage can quietly change what a familiar number means.
