Home / CRM for educational consultants / Family follow-up template
The IEC family follow-up template
A free, copy-paste educational consultant client tracker, with the exact columns to use and four follow-up scripts you can send today. No signup to grab it. Build it in a blank Google Sheet in five minutes, and use the scripts whether or not you ever touch the sheet.
Most independent educational consultants run on email, a calendar, and a practice-management platform, and that is genuinely fine until the follow-ups start slipping. The problem is almost never that you dropped the enrolled work. It is that the family from Tuesday's discovery call never got a second touch, and the school counselor who sent you two families last year never got a thank-you. This tracker gives you a place to see which family is overdue, and the scripts give you something to actually send.
On this page
The client tracker: columns to copy
Open a blank Google Sheet and make the top row these nine columns. The two that earn their keep are Last touch and Next touch: sort by Next touch and the overdue families float to the top. One example row is filled in so the shape is clear.
| Inquiry date | Family / Student | Grad year | Source | Discovery call? | Stage | Last touch | Next touch | Notes |
|---|---|---|---|---|---|---|---|---|
| 2026-07-22 | Patel family / Aanya | 2028 | Referral: Lincoln HS counselor | Yes, 2026-07-30 | Deciding | 2026-07-31 | 2026-08-04 | Rising junior, reach-heavy list, wants a long runway |
A few notes on the columns. Grad year keeps your timing straight and your follow-up specific, because "planning for the class of 2028" lands better than "your college stuff." Source is the one people skip and regret; it is how you know which school counselor or past family to thank and where your best families come from. Discovery call? and Stage can stay plain: Inquiry, Discovery booked, Deciding, Signed, In cycle, Past family. You do not need more than that.
Four follow-up scripts to copy
Short, human, and easy to make your own. Swap {first_name} and the bracketed bits, and keep them plain, this is a two-line email or a text, not a brochure. Parents are busy and comparing consultants, so end each one with a single clear next step.
1. Post-discovery-call follow-up (prospective family still deciding)
Hi {first_name}, thank you for the discovery call today, it was great to meet you and hear about [Aanya's junior year and the reach-heavy list she is drawn to]. From what you described, this is exactly the kind of [class of 2028] plan I love helping families build, and I think we would work well together. No pressure at all, I know you are talking to a few people. I just did not want it to slip while you are weighing your options. Happy to answer any questions. Want me to send over what the first few months of the package would look like? {your_name}
2. Per-cycle check-in (a signed family mid-admissions-cycle)
Hi {first_name}, quick check-in on where things stand for [Aanya] this cycle: [the school list is set and we are drafting the personal statement, next up is the supplement for her top choice]. Nothing urgent on your end right now, I will keep things moving and flag anything I need from you. If any deadlines or worries are on your mind, just reply here and we will talk it through. {your_name}
3. Referral thank-you (to a past family or school counselor)
Hi {first_name}, thank you for sending [the Patel family] my way, I really appreciate you thinking of me. We had a great first call and I will take good care of them. If it is ever helpful, I am always glad to be a resource for [your students / families you cannot take on], and I will keep you posted on how things go. Owe you one. {your_name}
4. Summer-inquiry nurture (an inquiry that should become a fall enrollment)
Hi {first_name}, circling back on the note you sent this summer about [planning for a rising junior]. Fall fills up fast once the school year starts, and families who map out the [class of 2028] plan early tend to feel a lot calmer come application season. No rush, but if you would like, I can hold a spot to get started and walk you through how the package works. Want me to send a couple of times for a quick call? {your_name}
Why the tracker goes stale (and the fix)
Here is the honest limitation of any spreadsheet, this one included: it tracks follow-ups but never sends them. The tracker will happily tell you that the Patel family was due for a touch four days ago, and then it is still on you, between enrolled-family sessions and essay edits, to open the thread and write the message. That is the exact chore that slips during application season, which is precisely when a warm prospective family is easiest to lose to a consultant who circled back first.
The fix is not a fancier spreadsheet. It is to move the sending off your plate. That is what the layer below does, using these same scripts.
Spreadsheet vs. a layer that sends
| Compared on | This spreadsheet | Capstone Outreach |
|---|---|---|
| Cost | Free | Paid, with a free trial |
| Tells you which family is overdue | Yes, if you sort by Next touch | Yes, automatically |
| Writes the message | You copy a script and edit it | Drafts it from your one-line note |
| Sends the message | No, you do | From your own Gmail or Outlook, after you approve |
| Fires after the discovery call | You remember to, later | Calendar or Calendly integration drafts it on the spot |
| Schedules the next touches | You retype the date | Yes, and stops the moment they reply |
Capstone drafts and sends these for you, right after the discovery call. Because IECs run discovery calls on a schedule, a calendar or Calendly integration means the post-call follow-up drafts itself. You review it, and it sends from your own inbox on a schedule you approve, stopping the moment the family replies.
Set up in minutes. You review and approve every message before it sends. See how it fits an IEC practice on the CRM for educational consultants page.
Frequently asked questions
What columns should an educational consultant client tracker have?
Enough to know who to touch next, and no more: inquiry date, family or student, grad year, source, whether you have run the discovery call, stage, last touch, next touch, and notes. The two columns that do the real work are last touch and next touch, because sorting by next touch tells you exactly which family is overdue. Grad year and source are the context that makes a follow-up sound like you remember the student and know where the family came from.
Is a spreadsheet enough to track IEC family follow-ups?
A spreadsheet is fine while you can hold every prospective family and referral source in your head, usually a handful of live conversations. It tracks follow-ups but never sends them, which is the actual leak. Once you are past that, either you keep the tracker religiously or the follow-ups quietly stop during application season. The scripts on this page make the tracker usable today; a follow-up-first layer makes the sending happen without you.
How soon should I follow up after a discovery call?
Same day or the next morning, while the conversation is still fresh and before the family talks to the next consultant on their list. A common rhythm is a note the day after the discovery call, a lighter check-in three or four days later, and a third about a week out, then space it wider. Families interview several consultants, so the early touches carry the most weight. Stop the moment they reply and pick the conversation back up by hand.
Can I automate these follow-up scripts?
Yes. Capstone Outreach takes the same scripts, drafts each one from your one-line note after the discovery call, and sends it from your own Gmail or Outlook after you approve, then schedules the next touches and stops the moment the family replies. Because IECs run discovery calls on a schedule, a calendar or Calendly integration means the post-call follow-up drafts itself, and the tracker never goes stale between calls.
Where to go next
- The full picture: College counseling software and CRM
- Weighing a platform: The honest CounselMore alternative
- The follow-up moments: College counseling follow-up
- Discovery-call mechanics: Calendly follow-up
- The topic hub: Follow-up CRM