FOLLOW-UP & ADMISSIONS

Spreadsheet, WhatsApp or CRM? How Overseas Education Consultants Should Track Leads

Intake seasons are long and students take months to decide. Here is how overseas education consultants can track leads properly — and when a CRM is actually worth it.

ఈ ఆర్టికల్ తెలుగులో చదవండి →

Lead tracking for overseas education consultants: spreadsheet, WhatsApp or CRM

For an overseas education consultancy, a lead is not a quick sale. A student might enquire in January about a September intake, go quiet for six weeks while preparing for IELTS, and come back ready to apply. Good lead tracking for overseas education consultants has to survive that whole journey — otherwise warm students quietly drift to the consultant who remembered to call.

Why WhatsApp alone doesn’t work

Most consultancies run on WhatsApp, and that’s fine for conversations. The problem is using it as the system of record:

  • Important chats get buried under new messages within days.
  • There’s no status — you can’t see who is at counselling, documents or offer stage.
  • When a counsellor leaves, their chats and context leave with them.
  • There’s no way to see which source (Instagram, Google, referrals, seminars) actually produced applications.

Keep WhatsApp for talking to students. Track them somewhere else.

The fields every student lead needs

Whether you use a sheet or a CRM, record the same core fields for every enquiry:

FieldWhy it matters
SourceShows which marketing actually produces applications
Preferred country & course levelLets you segment follow-ups (UK PG vs Canada diploma)
Target intakeTells you how urgent the lead is
StageEnquiry → Counselling → Documents → Applied → Offer → Visa → Enrolled
OwnerOne counsellor responsible
Next follow-up dateMakes sure nobody is forgotten
NotesBudget, test scores, parents’ concerns, objections

Spreadsheet vs CRM: an honest comparison

When a spreadsheet is enough

A shared Google Sheet with the fields above, filters by counsellor and next follow-up date, and a stage column works well for small teams. It’s free, everyone already knows it, and it forces the basics. The risk is discipline: it only works if counsellors update it after every conversation.

When a CRM is worth it

A CRM starts paying for itself when you have multiple counsellors, steady enquiry volume across several channels, or you need automatic reminders and reports by source and stage. The best CRM is the one your team actually updates — an expensive tool nobody opens is worse than a clean sheet.

Track by stage, not just by lead

The real value of tracking is seeing where students get stuck. If many students reach counselling but few submit documents, the problem may be your document checklist or follow-up at that stage. If offers are high but visas low, the issue is elsewhere entirely. Without stages, you only know “we didn’t convert enough”.

Not sure where your consultancy’s leads leak? The free Business Growth Audit looks at your enquiry sources, tracking and follow-up and gives you a score out of 100 in five minutes.

A 15-minute weekly lead review

Tracking only helps if someone looks at it. Once a week, sit with the counselling team for 15 minutes and go through three questions:

  1. Which leads have no next follow-up date? Every one of them is at risk of being forgotten.
  2. Which leads have been in the same stage for more than two weeks? Call them first — something is blocking them.
  3. Which sources produced applications this week? Over a month this shows where your marketing money is really working.

Mistakes that make tracking useless

  • Too many fields. If updating a lead takes two minutes, counsellors stop doing it. Keep it to the essentials above.
  • Free-text stages. “Interested”, “int.”, “will call” and “hot” all mean different things to different people. Use a fixed dropdown.
  • No source on walk-ins and referrals. These are often your best-converting leads; if they aren’t recorded, you’ll undervalue them.
  • Deleting “dead” leads. Move them to a nurture list instead. Students who weren’t ready for one intake often come back for the next.

Plan follow-up around the intake calendar

Overseas education has natural deadlines: intake dates, application windows, test dates. Use them. A student targeting September doesn’t need daily calls in February, but they do need a nudge when applications open and again before deadlines. Building follow-up around the intake calendar is exactly how the work for Mentriq Overseas Education and the Growth System are structured.

Frequently asked questions

What should an overseas education consultant record for every lead?

At minimum: name, phone, source, preferred country, target intake, course level, current stage, assigned counsellor and the next follow-up date. Notes from each conversation help the next counsellor pick up where the last one stopped.

When should a consultancy move from a spreadsheet to a CRM?

When you have several counsellors, enough enquiries that daily follow-ups are hard to manage by hand, or you need reports by source and stage. If the team won’t update a CRM consistently, a disciplined spreadsheet is the better choice until they will.

Is WhatsApp enough to manage student leads?

WhatsApp is the right channel to talk to students, but it is not a tracking system. Conversations get buried, and there is no status or reminder. Use WhatsApp to communicate and a sheet or CRM to track.

5-MINUTE ASSESSMENT

Find out exactly where your admissions are leaking.

Get a Business Growth Score out of 100, a breakdown across five areas, and the two gaps worth fixing first. Free, no call required.