Pediatric Clinic Lead Tracking Sheet That Actually Gets Followed Up

It's 9:40 PM. Dr. Mishra's clinic closed an hour ago, but the front desk WhatsApp is still buzzing — a mother asking if her toddler's 102°F fever needs an ER visit or can wait till the 9 AM slot. The receptionist saw it, replied "will check and revert," and went home. By morning, that message is buried under six others from the night shift, two missed calls from a vaccination reminder, and a walk-in enquiry someone scribbled on a prescription pad. Nobody calls the mother back. She books with the clinic two lanes over.

This is the exact leak a pediatric clinic lead tracking sheet is built to plug — not a fancier phone, not a new receptionist, just one place where every enquiry (WhatsApp, call, walk-in, referral) lands with a name, a reason, and a "call by" date attached to it. The cost of not having this isn't dramatic — it's a slow bleed of 3-4 warm parents a month who assumed you didn't care enough to follow up, when really the message just got lost in the noise of a clinic that's genuinely busy doing clinical work.

This guide walks through what such a setup actually does for a child clinic, how it works message-by-message, what it costs, and what changes in a typical week — using the CRM Setup & Automation for Pediatric Clinics setup as the concrete example throughout.

What a CRM Setup actually does for a Pediatric Clinic

Strip away the software jargon and this is what it means for your front desk on a Tuesday:

• Every channel lands in one sheet. A Meta ad enquiry about the newborn care package, a Google Business Profile call, a walk-in grandmother asking about vaccination charges, and a referral from another parent — all show up as rows in the same tracker instead of living in four different phones and notebooks.
• Nobody has to remember to follow up. If a parent enquired about the flu vaccine schedule and didn't book, the sheet flags them for a call-back in 2 days — automatically, not because your front desk staff remembered between managing a crying toddler and a billing query.
• Night and holiday enquiries don't die. A message that comes in at 10 PM, or on a Sunday when the clinic is on chhutti, is captured with a timestamp so it's the first thing addressed when the desk reopens — not lost in scroll-back.
• You can see your pipeline without asking anyone. "How many vaccination enquiries came in this week and how many converted to bookings?" becomes a filter on a sheet, not a guess your front desk gives you when you ask.
• Repeat and follow-up families are tracked, not just new ones. A child due for a 6-month vaccine dose, or a parent who asked about a nutrition consult but wanted to "think about it," stays visible until they're closed — booked or genuinely not interested.

How it works, step by step

1. A parent messages or calls — through WhatsApp Business number, a Google/Meta ad click, or the clinic landline.
2. The enquiry is auto-logged into the tracking sheet (Google Sheets or Zoho CRM, whichever the clinic already leans toward) with name, number, channel, and enquiry type — no manual typing required for digital channels.
3. A first response goes out — either an automated acknowledgement ("Thanks for reaching out to [Clinic], we'll call you within the hour") or, for structured queries like vaccination charges or OPD timings, a direct answer.
4. The front desk sees a live queue, sorted by urgency and time-waiting, instead of a chat thread they have to scroll to find who hasn't been replied to.
5. Follow-up reminders fire automatically — if a lead isn't marked "booked" or "closed" within a set window (say 24 hours for an enquiry, 3 days for a "will think about it"), it resurfaces on the day's call list.
6. Every appointment or conversion updates the sheet — so the same enquiry doesn't get called twice, and the clinic knows which channel (ad, referral, walk-in) is actually bringing bookings.
7. A monthly pipeline report shows total enquiries, conversion rate by channel, and how many follow-ups were pending vs. closed — so decisions about ad spend or staffing aren't based on gut feel.

Two realistic conversations this setup handles at the first-response stage:

Customer: Hi, my daughter is 8 months old and due for her vaccine. What are your Saturday timings and is Dr. available? Bot: Hi! Saturday OPD is 10 AM to 1 PM. Dr. Sharma is available till 12:30 PM on Saturdays. Would you like us to block a slot for your daughter's vaccination? Please share her name and preferred time.

Customer: Beta ko raat se bukhar hai, 101 tak gaya tha. Kal appointment mil sakta hai kya subah? Bot: Samajh gaye, chinta na karein. Kal subah 9 AM se OPD start hota hai, hum aapke liye 9:15 ka slot hold kar rahe hain. Agar bukhar 102 se upar jaaye ya baby lethargic ho jaaye, turant humein call karein — yeh number hai [emergency contact].

A typical week, before and after

What it costs and what is included

The setup fee and monthly plan are meant to pay for themselves in the most literal sense: if the tracker recovers even one booking a month that would otherwise have been forgotten — a vaccination follow-up, a consult that went cold — it's already worth more than the ₹2,500 care plan. Everything after that first recovered booking is the clinic keeping enquiries it was already generating, not paying for new ones.

Setup timeline

Day 0

You have a 20-minute call with us — walking through where enquiries currently come from (WhatsApp number, ad accounts, walk-in process) and what "urgent" means for your front desk (fever calls vs. general OPD queries, for instance). You share access to your WhatsApp Business number and any ad accounts already running.

Day 1

We build the tracking sheet structure — enquiry source, patient name, guardian contact, reason, urgency flag, follow-up date — and connect it to your WhatsApp and ad channels. We also set the first-response templates in your clinic's tone (formal vs. warm, English vs. Hinglish mix).

Day 2

The system goes live. Your front desk gets a 15-minute walkthrough on where to look each morning and how to mark a lead "closed" or "booked." We monitor the first day's live enquiries with you to catch any gaps before we step back.

What you need to have ready

• Access to your clinic's WhatsApp number (Business app or API, whichever you use)
• Login access to any Meta or Google ad accounts currently running
• A sense of your "urgent vs. non-urgent" enquiry types (most clinics: fever/breathing issues = urgent; vaccination/OPD timing queries = standard)
• Your OPD timings, doctor availability days, and vaccination charge list (for auto-replies to be accurate)
• One staff member (front desk or clinic manager) who will own checking the sheet daily
• A decision on Google Sheets vs. Zoho — Sheets if you want something free and simple, Zoho if you eventually want call-logging or SMS built in

Doing it yourself vs done-for-you

DIY genuinely works if your clinic gets under 5-10 enquiries a week and one person handles all of them personally — the overhead of any system isn't worth it yet. It starts breaking down once enquiries come from multiple channels or more than one staff member touches the front desk.

Mistakes child clinics make with this

• Treating WhatsApp chat history as the tracking system. Scrolling up to "remember" who hasn't been called back doesn't scale past a few enquiries a day. Fix: every enquiry gets a row with a follow-up date the moment it arrives.
• No urgency flag on fever/emergency messages. A vaccination timing query and a "baby not breathing well" message look identical in a plain chat list. Fix: tag urgency at entry so front desk triages, not just first-in-first-out.
• Losing ad leads because nobody checks the ads dashboard daily. Meta and Google leads sit in their own dashboards, disconnected from the clinic's actual workflow. Fix: pull ad leads into the same tracker the front desk already checks.
• Following up once and giving up. A parent who didn't answer the first call is marked "not interested" instead of getting a second attempt 2-3 days later. Fix: automated resurfacing instead of manual memory.
• No visibility for the clinic owner. Owners often don't know their actual conversion rate by channel, so ad spend decisions are guesses. Fix: a monthly pipeline report that shows source-wise numbers plainly.

FAQ

Do I need Zoho, or is Google Sheets enough?

Google Sheets is enough for most single-location clinics tracking under a few hundred enquiries a month — it's free and the follow-up automation still works. Zoho makes more sense once you want built-in call logging, SMS, or you're running multiple clinic branches.

Will this reply to parents automatically, even about medical questions?

No — the automation handles logistics (timings, availability, acknowledging receipt) and flags urgency for staff to call. It does not give medical advice; anything symptom-related is routed to a human, fast.

What happens to enquiries that came in before we set this up?

We typically do a one-time import of any recent WhatsApp or ad leads you can export, so the tracker doesn't start completely empty. Older leads sitting in a physical register are harder to backfill reliably, so we usually start fresh from Day 1 for those.

Can front desk staff use this without technical training?

Yes — the interface is a sheet or a simple CRM dashboard, not code. The Day 2 walkthrough covers everything a front desk person needs: where to look, how to mark a lead closed, how urgent flags appear.

What if we stop the care plan later?

The sheet or CRM setup remains fully yours — there's no lock-in. You'd lose ongoing tweaks and the monthly report, but the tracking structure and automations already built keep running.

How is this different from just hiring another receptionist?

A receptionist still has to remember to check four different channels and manually note follow-ups — this setup removes that memory burden entirely so the receptionist you already have can act on a clear list instead of hunting for it.

Next step

Send us on WhatsApp: your clinic type and city, and where enquiries are currently leaking (night messages, ad leads, walk-ins not logged). We'll tell you honestly if this setup fits or if something simpler will do. See the offer page for full scope, or check how we work before the call — reach us directly on WhatsApp.