Last updated: 5 November 2026 · By Leads Nimble Team (a product of Luminous Labs, Dhaka)
A study abroad CRM can start as a free student lead tracker: one spreadsheet row per student, with country, intake, IELTS score, budget, stage and next follow-up date. This guide gives you the exact columns, stages and follow-up schedule Bangladeshi agencies can copy today, and shows when to move to a real CRM.
Key takeaways
- One row per student, one owner per student, one “next follow-up date” per row. Without these three, any tracker fails.
- Use 9 fixed stages from “New inquiry” to “Visa granted / Enrolled”. Dropdowns only, no free typing.
- Track the facts that decide eligibility early: target country, intake, IELTS/PTE score, last degree, CGPA and budget.
- Reply to new inquiries within the hour. Published research shows interest fades fast after that.
- Outgrow the sheet when leads come from several Facebook pages, WhatsApp numbers and counsellors at once.
What is a student lead tracker?
A student lead tracker is a shared list of every prospective student who contacts your agency, with their profile, stage and next action. It turns scattered Messenger chats, WhatsApp threads and walk-in notes into one view.
A study abroad CRM is software that does the same job automatically. It captures inquiries from ads and chats, stores the full conversation history, assigns counsellors and reminds them to follow up.
Most agencies in Dhaka, Chattogram and Sylhet start with the first and move to the second. That’s a sensible path, if the tracker is built well.
Which columns should a study abroad lead tracker have?
Create these columns in Google Sheets or Excel. Keep the order. Columns A–H are filled at first contact; the rest are filled during counselling.
| Col | Column name | Type | Example |
|---|---|---|---|
| A | Lead ID | Auto number | STU-0142 |
| B | Date of inquiry | Date | 03-Nov-2026 |
| C | Student name | Text | Rafiul Islam |
| D | Phone / WhatsApp | Text | +8801XXXXXXXXX |
| E | Source | Dropdown | Facebook ad, Messenger, WhatsApp, Walk-in, Referral, Seminar, Website |
| F | Ad / campaign name | Text | UK Jan Intake – Nov Ad 2 |
| G | Target country | Dropdown | UK, Canada, Australia, USA, Malaysia, Germany, Other |
| H | Target intake | Dropdown | Jan 2027, May 2027, Sep 2027 |
| I | Study level | Dropdown | Foundation, Bachelor’s, Master’s, PhD, Diploma |
| J | Subject of interest | Text | MSc Data Science |
| K | Last degree + result | Text | BSc CSE, CGPA 3.45 |
| L | English test + score | Text | IELTS 6.5 (no band below 6.0) |
| M | Budget (BDT, per year) | Number | 2,500,000 |
| N | Stage | Dropdown | See stages below |
| O | Counsellor | Dropdown | Nusrat, Tanvir, Mitu |
| P | Last contact date | Date | 04-Nov-2026 |
| Q | Next follow-up date | Date | 06-Nov-2026 |
| R | Lead score | Dropdown | Hot, Warm, Cold |
| S | Lost reason | Dropdown | Budget, Low score, Chose other agency, Family decision, No response |
| T | Notes | Text | Wants scholarship; sister in Manchester |
Two tips save hours later. Write the English test score with the lowest band, because many universities and visa rules check each band, not only the overall score. And keep budget in Taka per year, since that’s how families in Bangladesh talk about it.
Useful formulas for the sheet
- Overdue follow-ups: in a helper column,
=IF(AND(Q2<>"",Q2<TODAY(),N2<>"Lost",N2<>"Enrolled"),"OVERDUE",""). Then filter or colour these rows red. - Leads per stage:
=COUNTIF(N:N,"Application submitted"). - Leads per source:
=COUNTIF(E:E,"Facebook ad"). This tells you which channel actually brings students. - Days since inquiry:
=TODAY()-B2.
For a full walkthrough of dropdowns and conditional formatting, see our free Google Sheets CRM template guide.
What stages should a study abroad pipeline have?
A pipeline stage is a fixed step that every student passes through on the way to enrolment. Fixed stages let you see where students get stuck.
| # | Stage | Exit rule (move on when…) |
|---|---|---|
| 1 | New inquiry | First reply sent and basic profile collected |
| 2 | Profile assessed | Counsellor confirms eligibility for at least one country |
| 3 | Counselling booked | Office or video session date is set |
| 4 | Counselling done | Shortlist of universities shared |
| 5 | Documents collecting | Transcripts, passport, test score, SOP, references received |
| 6 | Application submitted | University application confirmation received |
| 7 | Offer received | Conditional or unconditional offer in hand |
| 8 | Visa filed | Deposit paid and visa application lodged |
| 9 | Visa granted / Enrolled | Visa approved and student travels |
Add “Lost” and “On hold (next intake)” as separate statuses. Students who miss January often come back for September. Don’t delete them.
How fast should you follow up with a student lead?
As fast as you can, ideally within the hour. A study published in Harvard Business Review found that firms contacting online leads within an hour were nearly seven times more likely to qualify them than firms that waited an hour longer.
For study abroad, speed matters even more. A student who messages at 11 pm after seeing your ad has usually messaged two other agencies too. The first agency that answers the real questions (cost, scholarship, IELTS needed) often wins the counselling session.
We looked at what slow replies cost education businesses in how slow replies cost course enrolments.
A simple follow-up cadence
Use this schedule for students who have not booked counselling yet. Stop once they book or say no.
- Day 0 (within 1 hour): Answer their question. Ask for country, intake, last result and English score.
- Day 1: Send a short eligibility summary and two university options in their budget.
- Day 3: Offer a free counselling slot (office or video). Share the date options.
- Day 7: Share something useful: scholarship deadline, intake deadline or a seminar invite.
- Day 14: Ask one direct question: “Are you still planning for the January intake?”
- Day 30: Move to “On hold” and add them to your next-intake broadcast list.
After counselling, follow up on documents every 3–4 days. Students rarely say no. They just go quiet while waiting for a transcript or a bank statement.
How to qualify a student lead in five questions
Ask these early, in Bangla or English, whichever the student uses. They decide whether a lead is hot, warm or cold.
- Which country and intake are you planning for?
- What is your last degree and result (GPA/CGPA)?
- Have you taken IELTS, PTE or Duolingo? What score, and lowest band?
- What is your family’s yearly budget for tuition and living costs?
- Do you have any gap years or a previous visa refusal?
English requirements vary by course and country, so always check the university page and the visa rules. The UK, for example, publishes its Student visa English language rules on GOV.UK. For test formats and scoring, refer students to the official IELTS website.
Spreadsheet tracker vs study abroad CRM: which do you need?
| Need | Free tracker (Sheets/Excel) | Study abroad CRM |
|---|---|---|
| Cost | Free | Free plan or monthly fee |
| Capturing leads from ads and chats | Manual copy-paste | Automatic |
| Conversation history | Not stored | Full chat history per student |
| Follow-up reminders | Formula + discipline | Automatic tasks and alerts |
| Counsellor assignment | Dropdown, easy to clash | Routing rules and permissions |
| Which ad produced the student | Only if typed in | Tracked per lead |
| Night and weekend replies | None | AI assistant can answer 24/7 |
A sheet works well for a small agency with one or two counsellors and a few dozen inquiries a month. Signs you’ve outgrown it are in our free vs paid CRM checklist.
How Leads Nimble handles student leads
Leads Nimble is an AI sales CRM and unified inbox built in Dhaka. It pulls inquiries from Facebook Lead Ads, Messenger, Instagram, WhatsApp, website chat and Telegram into one pipeline. You can set the same stages and fields shown above.
The AI assistant is trained on your own knowledge base: countries, tuition ranges, intake dates, IELTS needs and your office address. It answers common questions in Bangla and English at any hour, collects the five qualifying answers, and hands the student to a counsellor.
Counsellors get follow-up reminders, the full chat history, and meeting booking synced with Google Calendar, Zoom or Calendly. You can also see which ad produced each student. See how agencies use it on our industries page and the full guide to study abroad CRM in Bangladesh.
Start with the free forever plan (one user, one Messenger page, 500 AI credits a month) on the pricing page, or book a demo to see a study abroad pipeline set up live.
Frequently asked questions
What is the best free study abroad CRM?
For very small agencies, a well-built Google Sheets tracker is the best free starting point. It costs nothing and everyone knows how to use it. When leads come from several channels, free CRM plans such as HubSpot, Zoho or the Leads Nimble free plan are the next step. Pick one that captures Messenger and WhatsApp chats, since most Bangladeshi students contact agencies there.
Which fields matter most in a student lead tracker?
The fields that decide eligibility and next action: target country, intake, study level, last degree and result, English test score with lowest band, budget in BDT, stage, counsellor and next follow-up date. Source and ad name are also important, because they show which marketing actually brings enrolled students rather than just inquiries.
How often should a counsellor follow up with a student?
Reply to a new inquiry within an hour. Then follow up on day 1, day 3, day 7 and day 14 until the student books counselling or declines. After counselling, check on documents every three to four days. At day 30 with no response, mark the lead “On hold” and add it to your next-intake list instead of deleting it.
How many stages should a study abroad pipeline have?
Around eight to ten. A practical set is: new inquiry, profile assessed, counselling booked, counselling done, documents collecting, application submitted, offer received, visa filed and visa granted or enrolled. Add “Lost” and “On hold” as statuses. Each stage needs a clear exit rule so counsellors move students consistently.
Can AI answer student inquiries in Bangla?
Yes. Leads Nimble’s AI assistant replies in Bangla and English using the knowledge base you provide, such as countries, tuition ranges, intakes and test requirements. It is best used for first answers and qualifying questions. Visa advice, scholarship decisions and anything outside your knowledge base should be handed to a human counsellor.
When should an agency move from a spreadsheet to a CRM?
Move when follow-ups slip, two counsellors contact the same student, or you can’t tell which ad produced which enrolment. Another clear sign is leads arriving through several Facebook pages and WhatsApp numbers that someone has to copy into the sheet by hand. At that point manual entry costs more than a CRM.

