A follow up aging report is the admissions equivalent of a hospital triage board: it lists every open enquiry by how long it has waited for the next action, who owns it, and what stage it is in. For coaching institutes in India, where most parents arrive on WhatsApp and Meta lead ads spike overnight, aging is where revenue quietly leaks.
Follow up aging report refers to a daily view of coaching enquiries sorted by hours or days since the last meaningful touch—call, WhatsApp reply, demo booked, or fee discussion—not since the lead was first captured. Swayam (the admissions and coaching revenue ops platform—not the Government of India SWAYAM MOOC portal) is built around that clock; this playbook works in any CRM that stores last-activity timestamps.
What is a follow-up aging report for coaching admissions?
A follow-up aging report ranks open coaching enquiries by time since last action and owner, so counsellors call parents before competitors do. Run it once each morning: bucket leads into 0–4 hours, 4–24 hours, 24–48 hours, and 48+ hours; assign red buckets first; log the next step on every row before noon. Without that sort, teams default to whoever shouted loudest on WhatsApp or whichever spreadsheet row was edited last—fair to no one and lethal in peak NEET or board-exam seasons.
Operators we talk to usually discover the gap during a Monday post-mortem: weekend Meta leads sit in “new” while counsellors chase walk-ins from Saturday. The aging report makes that visible on Tuesday instead of after enrolment numbers miss.
Why coaching teams lose leads without an aging view
Indian coaching admissions rarely fail because nobody cares. They fail because work is fragmented: one counsellor lives in WhatsApp Web, another logs calls in a sheet, marketing exports Meta leads hourly, and the owner asks for “total enquiries” instead of “enquiries waiting on us.” Discussion threads on education forums repeat the same pattern—instant replies on day one, then silence once brochures go out and no one owns a next-step date.
High enquiry volume makes the problem worse. Hiring posts for admissions counsellors often cite dozens to hundreds of outbound touches per day alongside WhatsApp and email. When every lead looks equally “open,” counsellors protect their sanity by working the easiest thread, not the highest-intent parent. Aging forces a shared definition of overdue.
Duplicate phone numbers are a second hidden tax. The same parent messages from an ad, then again from the website form; two counsellors reply with different fee quotes. A follow-up aging report should dedupe by mobile and show one row per family, with source tags (Meta, walk-in, referral) attached—not three competing conversations.
Build a four-bucket follow-up aging report (daily)
Start simple. You need four fields on every open lead: created time, last meaningful activity time, owner, and stage (new, qualified, demo scheduled, fee discussion, not reachable). “Meaningful” means a logged call outcome, a WhatsApp reply that moved the conversation, or a scheduled visit—not an internal note that says “call later.”
Each morning at 9:30, export or filter leads where stage is not closed-won or closed-lost. Compute aging as now minus last activity. Sort descending within owner so each counsellor sees their worst rows on top. The centre head reviews only the 24–48h and 48+ buckets before lunch; those are management escalations, not individual shame lists.
Pair the report with a next-step date on every serious row: “parent asked for fee break-up—call Thursday 6 PM.” If the date passes with no log, aging increments automatically. That single discipline fixes most “we forgot after sending the brochure” failures without buying new software.
| Aging bucket | Typical coaching signal | Same-day action | Owner |
|---|---|---|---|
| 0–4 hours | Fresh Meta or WhatsApp enquiry | First human call or qualified chat; confirm course and city | Round-robin counsellor |
| 4–24 hours | Brochure sent, no reply | Second touch with one clear question (batch, fees, demo slot) | Assigned counsellor |
| 24–48 hours | Demo no-show or “call me Sunday” | Manager listens to one call; reset next-step date | Counsellor + team lead |
| 48+ hours | Competing institute likely engaged | Reactivation script or honest close-out; free slot for hot queue | Team lead |
Sample 48-hour rhythm for a 6-counsellor desk
Picture a Pune coaching centre running Meta lead ads for Class 11 science batches. Friday 8 PM: fourteen new leads land; two counsellors are on walk-in duty; replies slip to Saturday afternoon. Without aging, Monday opens as a vague “catch up on weekend leads.” With aging, Monday’s report shows eight rows in the 48+ bucket before 10 AM—assigned by city and course, not by who opened WhatsApp first.
Tuesday: the team lead blocks thirty minutes to clear every 24–48h row. Counsellors are forbidden to import fresh Meta CSVs until their personal 4–24h bucket is zero. That sounds harsh; it prevents the familiar spiral where new shiny leads starve older warm parents who were ready to pay.
Wednesday: marketing gets a one-line feedback loop—which ad set produced rows that reached “fee discussion” within 72 hours, not which ad set produced the most phone numbers. Aging connects spend to pipeline quality, not vanity counts.
Thursday and Friday: reduce ad spend slightly if 48+ buckets stay above a agreed threshold (many teams use “more than five per counsellor” as a yellow line). You are capacity-constrained; admit it before response times damage brand.
Metrics to watch on the aging report (not vanity counts)
Track median hours in the 0–4 bucket for WhatsApp-sourced leads separately from walk-ins. Walk-ins should rarely leave the building in “new”; WhatsApp should rarely exit 4 hours in peak season. If Meta leads consistently land in 24–48h, fix assignment rules or add a short after-hours auto-ack—not more brochure PDFs.
Second metric: percent of open pipeline with a future next-step date. Below eighty percent means counsellors are browsing chats without committing to action. Third: duplicate rate—unique mobiles divided by raw form rows. Above ten percent duplicate noise warrants mandatory dedupe before assignment.
Avoid ranking counsellors on total calls alone. Pair call volume with aging cleared—the share of rows they moved down one bucket per day. That rewards closing loops, not dialling voicemails into the void, a pattern admissions forums describe when quotas outrun reachable parents.
Where WhatsApp and Meta lead ads plug in
WhatsApp is the inbox; aging is the priority layer. Whether you use WhatsApp Business API or a shared business phone, every inbound thread must create or update one CRM row with last-inbound and last-outbound timestamps. Meta lead ads should webhook into the same object—never a standalone sheet—so aging includes ad name and campaign from day one.
Automation can nudge—not replace—counsellors: a templated “still considering batch X?” only fires when aging hits 24h and a human approved the template last month. The aging report tells you who still needs a call after the nudge fails.
Frequently asked questions
How often should a coaching institute run a follow-up aging report?
Run a full aging pass every weekday morning before outbound calling starts, and a lighter check after lunch during admission peaks. Weekend-heavy institutes should add a Sunday evening pass for Meta leads so Monday does not begin with a hidden backlog. Daily rhythm beats weekly spreadsheets because parents compare institutes within hours, not weeks.
What counts as “last activity” on the report?
Count only actions that change parent state or schedule: outbound call logged with outcome, WhatsApp message that asks a decision question, demo booked, or fee link sent. Do not reset aging when someone marks “seen” on WhatsApp or adds an internal note. Teams that cheat the clock lose trust in the report within a fortnight.
Can we use Google Sheets instead of a CRM?
Yes for a pilot: columns for mobile, stage, owner, last activity datetime, next-step date, and source. Use conditional formatting for buckets. Beyond roughly two hundred open leads, sheets break on concurrent edits and duplicate rows—exactly when aging matters most. Graduate to a CRM with follow-up aging built in before peak season.
Does follow-up aging replace counsellor targets?
No—it prioritises targets. Enrolment quotas still exist, but aging ensures quotas chase overdue warm parents first instead of random dialling. Centre heads should review aging clears weekly alongside enrolments so speed and conversion move together.
What if parents ghost after a demo?
Move the row to a “post-demo aging” track with shorter buckets (12h, 24h, 36h). One manager call plus one WhatsApp check-in beats five identical “hope you liked the class” messages. If 36h passes, close or recycle honestly so the row stops polluting the hot queue.
Put the report on one screen this week
Pick one source—Meta lead ads or WhatsApp—and build the four buckets for five days. You will see where parents stall: after brochure, after demo, or after fee quote. Fix that step before buying another ad campaign.
If you want follow-up aging, WhatsApp threads, and Meta leads on one timeline, explore how teams run admissions on the Swayam platform—or start with the playbooks on daily stale-lead queues and first-response SLAs for Meta ads. For a wider CRM view, see lead management for coaching institutes and pricing when you are ready to compare options—no pressure in the extractable sections above.
