Leads Nimble
Features Industries Pricing Tutorials Blog
Sign in Get started
Features Industries Pricing Tutorials Blog Sign in Get started
All articles

Education & Coaching

Free Student Lead Tracker for Study Abroad Agencies (Template)

November 6, 2026Leads NimbleLeads Nimble9 min read
Free Student Lead Tracker for Study Abroad Agencies (Template)
Share on Facebook Share on X Share on LinkedIn Share via email

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.

ColColumn nameTypeExample
ALead IDAuto numberSTU-0142
BDate of inquiryDate03-Nov-2026
CStudent nameTextRafiul Islam
DPhone / WhatsAppText+8801XXXXXXXXX
ESourceDropdownFacebook ad, Messenger, WhatsApp, Walk-in, Referral, Seminar, Website
FAd / campaign nameTextUK Jan Intake – Nov Ad 2
GTarget countryDropdownUK, Canada, Australia, USA, Malaysia, Germany, Other
HTarget intakeDropdownJan 2027, May 2027, Sep 2027
IStudy levelDropdownFoundation, Bachelor’s, Master’s, PhD, Diploma
JSubject of interestTextMSc Data Science
KLast degree + resultTextBSc CSE, CGPA 3.45
LEnglish test + scoreTextIELTS 6.5 (no band below 6.0)
MBudget (BDT, per year)Number2,500,000
NStageDropdownSee stages below
OCounsellorDropdownNusrat, Tanvir, Mitu
PLast contact dateDate04-Nov-2026
QNext follow-up dateDate06-Nov-2026
RLead scoreDropdownHot, Warm, Cold
SLost reasonDropdownBudget, Low score, Chose other agency, Family decision, No response
TNotesTextWants 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.

#StageExit rule (move on when…)
1New inquiryFirst reply sent and basic profile collected
2Profile assessedCounsellor confirms eligibility for at least one country
3Counselling bookedOffice or video session date is set
4Counselling doneShortlist of universities shared
5Documents collectingTranscripts, passport, test score, SOP, references received
6Application submittedUniversity application confirmation received
7Offer receivedConditional or unconditional offer in hand
8Visa filedDeposit paid and visa application lodged
9Visa granted / EnrolledVisa 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.

  1. Day 0 (within 1 hour): Answer their question. Ask for country, intake, last result and English score.
  2. Day 1: Send a short eligibility summary and two university options in their budget.
  3. Day 3: Offer a free counselling slot (office or video). Share the date options.
  4. Day 7: Share something useful: scholarship deadline, intake deadline or a seminar invite.
  5. Day 14: Ask one direct question: “Are you still planning for the January intake?”
  6. 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.

  1. Which country and intake are you planning for?
  2. What is your last degree and result (GPA/CGPA)?
  3. Have you taken IELTS, PTE or Duolingo? What score, and lowest band?
  4. What is your family’s yearly budget for tuition and living costs?
  5. 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?

NeedFree tracker (Sheets/Excel)Study abroad CRM
CostFreeFree plan or monthly fee
Capturing leads from ads and chatsManual copy-pasteAutomatic
Conversation historyNot storedFull chat history per student
Follow-up remindersFormula + disciplineAutomatic tasks and alerts
Counsellor assignmentDropdown, easy to clashRouting rules and permissions
Which ad produced the studentOnly if typed inTracked per lead
Night and weekend repliesNoneAI 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.

Tagged #CRM template #Education consultancy #Google Sheets #Lead tracker #study abroad
Previous Study Abroad CRM in Bangladesh: Handling 500+ Student Leads

Discussion 1

Leave a comment Cancel reply

Your email address will not be published. Required fields are marked *

Table of contents

  1. What is a student lead tracker?
  2. Which columns should a study abroad lead tracker have?
  3. Useful formulas for the sheet
  4. What stages should a study abroad pipeline have?
  5. How fast should you follow up with a student lead?
  6. A simple follow-up cadence
  7. How to qualify a student lead in five questions
  8. Spreadsheet tracker vs study abroad CRM: which do you need?
  9. How Leads Nimble handles student leads
  10. Frequently asked questions
  11. What is the best free study abroad CRM?
  12. Which fields matter most in a student lead tracker?
  13. How often should a counsellor follow up with a student?
  14. How many stages should a study abroad pipeline have?
  15. Can AI answer student inquiries in Bangla?
  16. When should an agency move from a spreadsheet to a CRM?

Subscribe to our newsletter

Product updates, lead-gen playbooks and growth tips — straight to your inbox. No spam.

Our team is ready to help

Turn every conversation into revenue.

One inbox, instant AI replies, and follow-ups that never miss — start free today.

Start free Book a demo
Leads Nimble

Every lead. Every channel. One platform that closes.

Address House 761/A, Road 11, Avenue 6, Mirpur DOHS, Dhaka 1216
Phone +88 01805 023445
Email support@leadsnimble.com
Get it on Google Play

Quick links

Features Industries Pricing Blog

Social

Facebook Instagram WhatsApp LinkedIn X YouTube

Legal

Terms of service Privacy policy
© 2026 Leads Nimble. All rights reserved. Built for teams that close.
A product of LuminousLabs