Study Abroad CRM Pipeline Stages: A Template You Can Copy
Copy this study abroad CRM pipeline stages template: Inquiry to Enrolled with statuses, exit criteria, gates and deadlines, plus MBBS, PG and language routes.
This is a study abroad CRM pipeline stages template you can copy into whichever CRM you run: six stages from Inquiry to Enrolled, the statuses and sub-statuses under each, the sentence that has to be true before a student leaves a stage, the requirement to check at the door, and where each deadline belongs. It is for admissions heads and consultancy owners in India who are setting up a pipeline for the first time, or tidying one that has grown forty statuses nobody uses. The last section adapts the same skeleton for MBBS abroad, postgraduate and language-first routes.
Key takeaways
- Six stages are enough. Detail belongs in statuses and sub-statuses, not in a seventh or eighth stage.
- Every stage needs a written exit criterion. A status name such as "Offer received" is a label, not a criterion.
- Enforce requirements at the entry to a status (documents, fields, a scheduled follow-up), so a move is blocked only where it matters.
- Write deadlines as status-to-status pairs with an early warning, working back from the visa authority's own published timings.
- MBBS, PG and language routes keep the same six stages. Only the sub-statuses, the gates and the dates change.
Stage, status, sub-status: three levels, three jobs
A pipeline has three levels, and mixing them up is the most common reason a pipeline sprawls. If you are still deciding whether you need one at all, start with what a study abroad CRM is; this post assumes you do and shows the journey a study abroad CRM has to model.
| Level | What it answers | How many | Who changes it |
|---|---|---|---|
| Stage | Where is this student in the journey? | 6 | The system, when the exit criterion is met |
| Status | What is happening inside the stage? | 3–6 per stage | The role that owns the stage |
| Sub-status | What exactly are we waiting for? | 0–5 per status | The person doing the work |
Two rules follow. First, a stage change is a milestone that reporting depends on, so it should be rare and deliberate. Second, the first stage is special: nobody "moves into" Inquiry. Students are created into it, so when you count "new students in Inquiry this month", count by the date the record was created, not by any status change. Every later stage has an entry event; the first one does not.
Keep "Not proceeding" as a status inside each stage rather than a separate Lost stage at the end. When a student drops out at Deposit, you want the report to say so at Deposit, not in a bucket that hides where the drop-off happened.
The template: study abroad CRM pipeline stages in one table
Copy this table, rename to taste, and delete what you do not use. Sub-statuses are examples; the ones in your workspace should match the questions your counsellors actually ask each other.
| Stage | Statuses | Sub-statuses (examples) | Exit criterion (the sentence that must be true) | Gate on entering the next stage | Deadline that belongs here |
|---|---|---|---|---|---|
| Inquiry | New, Contacted, Not reachable, Not proceeding | Called once, Called twice, WhatsApp sent, Wrong number | Student has been spoken to, and country, intake and rough budget are recorded | Phone verified; country, intake and budget fields filled; a follow-up scheduled | New to Contacted, warn after 1 working day |
| Qualify | Profile assessment, Shortlisting, Shortlist shared, Not proceeding | Marksheets collected, English test pending, Budget confirmed, Awaiting parent | Eligibility checked against a shortlist of named universities and courses, and the student has agreed to proceed | Qualifications and test scores entered; at least one course or university attached; SOP or profile document uploaded | Profile assessment to Shortlist shared, warn at 7 days |
| Application | Documents pending, Application in progress, Submitted, Conditional offer, Unconditional offer, Rejected, Not proceeding | SOP draft, LOR pending, Transcripts pending, Application fee due, Conditions outstanding | At least one application holds an offer the student intends to accept | Passport, marksheets, SOP and LORs in the document folder; each application has an owner | Submitted to any offer, warn at the university's stated turnaround; Conditional to Unconditional, warn 14 days before the condition deadline |
| Deposit | Offer accepted, Deposit requested, Deposit paid, Deposit verified, Not proceeding | Payment link sent, Receipt awaited, Refund in progress | Deposit paid to the chosen university and confirmed by it | Receipt or confirmation uploaded; amount and date recorded | Offer accepted to Deposit verified, warn 7 days before the university's deposit deadline |
| Visa | Financials in progress, Confirmation document awaited, Application filed, Biometrics or interview done, Approved, Refused | Funds being arranged, TB test booked, Health cover bought, Interview prep | Visa granted, or refused with the reason recorded | Confirmation document (CAS, CoE, I-20, letter of acceptance) uploaded; financial documents uploaded; a follow-up on the appointment date | Confirmation document awaited to Application filed, warn 21 days before the earliest safe filing date |
| Enrolled | Travel planned, Arrived, Enrolled, Deferred, Withdrawn | Flight booked, Accommodation confirmed, Registration done | University confirms registration | Enrolment confirmation uploaded | Approved to Enrolled, warn 14 days before course start |
Two design choices deserve a word. The offer statuses sit under Application rather than in their own stage, because an offer is the outcome of an application, and a student with three applications can hold three different offer statuses at once. And "Refused" under Visa is a status, not a dead end: a refused student often reapplies, and you want that history on one record.
Writing exit criteria your team will actually apply
An exit criterion is a sentence a manager can check in ten seconds. If two counsellors can read it and disagree about whether a student has met it, rewrite it.
| Weak criterion | Why it fails | Better criterion |
|---|---|---|
| "Student is interested" | Nobody can check interest | "Student has confirmed country and intake on a call, and both are recorded" |
| "Documents collected" | Which ones? | "Passport, all marksheets and one LOR are in the folder" |
| "Offer received" | Received by whom, and for which application? | "One application holds an offer the student intends to accept" |
| "Visa done" | Refusals get mislabelled | "Visa granted, or refused with the reason recorded" |
Print the six criteria and put them next to the pipeline settings. When someone proposes a new stage, ask which two criteria it sits between. Usually the answer is a new sub-status.
Gates and deadlines, and the official timings behind them
A gate checks something at the moment of a move. A deadline watches the gap between two statuses and warns before it closes. Use both, but in different places: gates where a missing item would waste the next team's time, deadlines where an external clock is running.
Some of those external clocks are published. The table shows what the authorities themselves say (checked September 2026, with links), and the deadline it suggests for the template.
| Destination | Published rule | What it means for your Visa stage |
|---|---|---|
| UK | You can apply for a Student visa up to 6 months before the course starts, and a decision usually takes 3 weeks from outside the UK (GOV.UK). The application needs a CAS from the course provider and, where they apply, TB test results and an ATAS certificate (GOV.UK). | Set "Confirmation document awaited to Application filed" against the course start date, and add TB test and ATAS as sub-statuses under Financials in progress |
| UK money | Applicants must show £1,529 a month in London or £1,171 a month elsewhere, for up to 9 months, held for at least 28 days in a row (GOV.UK). | The 28-day holding period is a deadline in its own right: "Funds being arranged" should start at least a month before filing |
| Canada | A study permit application needs the letter of acceptance and, in most cases, a provincial or territorial attestation letter (IRCC). For applications on or after 1 September 2026, a single student outside Quebec must show CAD 23,448 a year for living costs on top of tuition (IRCC). | Make the attestation letter a document requirement before "Application filed", and put the funds figure in the Financials sub-status notes so counsellors stop quoting last year's number |
| Australia | The applicant must hold a valid Confirmation of Enrolment when the visa is decided, and hold Overseas Student Health Cover or fall in an exemption (Department of Home Affairs). The Genuine Student requirement applies to applications lodged on or after 23 March 2024, answered in the form with a 150-word limit per response (Department of Home Affairs). | Add "GS responses drafted" and "Health cover bought" as sub-statuses, and require the CoE before "Application filed" |
| Germany | Most German-taught programmes ask for German at B2 level; English-taught international programmes are exempt (DAAD). APS India verifies academic documents issued by Indian institutions for applicants who intend to study in Germany (APS India). | APS becomes a document requirement before Application, and the language route below applies |
Rules move. Put a "last checked" date next to every row of your own version, and re-read the official page before you advise a family.
Worked example: one student through the six stages
Take a hypothetical student, Rahul, who enquires on 3 February for a UK master's starting in late September.
| Date | Stage and status | What triggered it |
|---|---|---|
| 3 Feb | Inquiry, New | Meta lead form |
| 3 Feb | Inquiry, Contacted | First call: country UK, intake September, budget recorded |
| 10 Feb | Qualify, Shortlist shared | Marksheets and IELTS entered, three courses attached |
| 24 Feb | Application, Submitted | Passport, transcripts, SOP and two LORs in the folder; three applications, each with an owner |
| 28 Mar | Application, Conditional offer (application 2) | Condition: final-year marks by 30 June |
| 2 Apr | Application, Unconditional offer (application 1) | Student intends to accept this one |
| 9 Apr | Deposit, Deposit verified | Receipt uploaded |
| 20 May | Visa, Financials in progress | Funds must sit for 28 days before filing |
| 30 Jun | Visa, Application filed | CAS uploaded; filed inside the 6-month window |
| 21 Jul | Visa, Approved | Decision recorded |
| 22 Sep | Enrolled, Enrolled | University confirms registration |
Rahul's record shows one student, three applications and a single conversion. Application 2's conditional offer stays on its own application with the condition deadline attached; it never contaminates the status of the application he actually took. For the mechanics of keeping several applications under one student, see how to track multiple university applications.
Adapting the template for MBBS, PG and language routes
The six stages stay. What changes is what Qualify has to prove and what Application has to collect.
MBBS abroad
India's medical regulator sets rules that belong in your pipeline as gates, not as advice a counsellor may or may not remember. The National Medical Commission states that anyone taking admission to MBBS or an equivalent course abroad on or after May 2018 must have qualified NEET, that the NEET result is valid for three years, and that it does not endorse any list of foreign medical institutions (NMC). Under the Foreign Medical Graduate Licentiate Regulations, in force from 18 November 2021, the course must run for at least 54 months in English, followed by a 12-month internship at the same foreign institution, and the graduate must then complete a further 12-month supervised internship in India (NMC FAQ on the FMGL Regulations).
| Stage | Add | Gate |
|---|---|---|
| Qualify | Sub-statuses "NEET scorecard received" and "NEET year within validity" | NEET scorecard uploaded and NEET year field filled before Application |
| Application | Sub-status "Course duration and internship confirmed in writing" | A university letter confirming duration, medium and internship, uploaded |
| Enrolled | Statuses "Internship abroad", "Screening exam", "Internship in India" | None; these are for the alumni desk, if you keep one |
Postgraduate routes
PG applications are document-heavy and offer-heavy. Add sub-statuses for each SOP draft round and each LOR, and put the conditions of a conditional offer on the application as a checklist rather than in a note. Some UK courses need an ATAS certificate depending on subject and nationality (GOV.UK), so add "ATAS applied" and "ATAS granted" under Visa for those students only. Work experience letters join the Application gate.
Language-first routes
For German-taught programmes the language test is the real bottleneck. DAAD notes that TestDaF is offered in around 100 countries, while the DSH has to be taken in Germany (DAAD). Run the language work as a checklist inside Qualify: "A1 to B1 in progress", "B2 exam booked", "B2 result received", with a gate that blocks Application until the required level is recorded in a field. The same shape works for any route where a test score, not a document, decides eligibility.
Five mistakes that break a good template
- A "Follow-up" stage. Follow-ups are dates on a student, one per role, not a place in the journey; see role-based follow-ups for counselling teams.
- One status called "In process". It means nothing and everyone uses it.
- Country-specific stages. Use one Visa stage and country-specific sub-statuses, so a rule change is a rename, not a rebuild.
- Deadlines without a warning window. A deadline that fires on the day is a post-mortem.
- Gates on everything. If a counsellor hits three blocked moves an hour, they will start entering placeholder text.
How Xale handles this
Xale is our product, so weigh this section accordingly. A new Study Abroad workspace starts with Inquiry → Qualify → Application → Deposit → Visa → Enrolled, with statuses and sub-statuses for documents pending, conditional and unconditional offers, deposit and visa steps, and all of it is editable. There is one generic Visa stage rather than per-country workflows, so the country rows above become sub-statuses you name yourself. Each university application is its own deal under the student, with its own stage and owner, and the student counts once in conversions; our university application tracking page walks through that model.
Gates are stage requirements: a move into a status can be blocked until named documents, fields or custom fields, an attached course or university, an assigned role or user, a track, a move note or a scheduled follow-up are in place. Document requirements can instead be info-only checklist items that never block. Deadlines are status-to-status pairs that warn early and close themselves when the student reaches the target status. NEET and language checklists fit as tracks, which can be required on a stage. Documents sit in folders on the student's record and are shared by every application, the model behind our student document management page. Two honest limits: a document requirement checks the file's name, not its contents, so it is not verification; and there is no pre-loaded university library, since Course Finder searches the list you import.
Frequently asked questions
How many pipeline stages should a study abroad CRM have?
Six is enough for most consultancies: Inquiry, Qualify, Application, Deposit, Visa and Enrolled. When a team asks for a seventh, the request is almost always for a status or sub-status inside one of those six. Stages are milestones your reports depend on, so keep them rare and give each a written exit criterion that a manager can check in a few seconds.
Should rejected or dropped students get their own stage?
No. Keep a Not proceeding status inside every stage, and Rejected and Refused as statuses under Application and Visa. A student who drops out at Deposit should be reported at Deposit, because that tells you where the process leaks. A single Lost stage at the end hides that information and makes every drop-off look the same.
Where do offers belong, in the Application stage or in a stage of their own?
Under Application. An offer is the outcome of one application, and a student with three applications can hold a conditional offer, an unconditional offer and a rejection at the same time. Keeping offer statuses on each application preserves that picture. The student moves to Deposit only when one application holds an offer they intend to accept.
How do we keep the pipeline current when visa rules change?
Keep country-specific detail in sub-statuses and requirement checklists, never in stages, so a change is a rename. Put a last-checked date on every country note, assign one person to re-read the official pages before each intake, and update the notes in the CRM rather than in a counsellor's private file. The template's deadlines are built from published timings for exactly this reason.