Patient Lifetime Value: Know Your Best Patients (And Get More Like Them)
A patient who spends ₹50,000 with you over 5 years is worth more than 30 walk-ins. But most clinic software treats them all the same. Here's how to track patient value properly.
Most solo doctors can answer this question: "How many patients did I see last month?"
Far fewer can answer: "Of those patients, which 10 spent the most money? Where did they come from? What's the average lifetime value of a referral patient vs a Google patient?"
Those are the questions that decide whether your practice grows or stagnates. They're also the questions most clinic software can't answer.
Here's how DRP-OS tracks patient value, source, and engagement — and why it matters.
What gets tracked per patient
In DRP-OS, each patient record includes:
- grand_total_cached — total revenue from this patient (lifetime)
- status — patient lifecycle stage (new, active, lapsed, churned)
- source — where this patient came from (walk-in, referral, online, social, ads)
- tags — free-form tags for segmentation (e.g., "diabetes", "VIP", "elderly", "corporate")
- first visit date — when they first came (derived from created_at)
- last visit date — most recent contact (derived from visits)
- created_by_doctor — which doctor onboarded them (multi-doctor practices)
Together, these fields let you see patterns most clinics miss.
Lifetime value, cached
The grand_total_cached field is computed automatically. Every time a visit is finalized with payment, the patient's total updates.
From the patient list view, you can sort by lifetime value descending and see your top 50 patients immediately.
For most Indian solo clinics, this list is revealing:
- Top 20% of patients usually contribute 60-70% of revenue
- The "best" patient is rarely the one who comes most often — it's the one with chronic conditions who needs ongoing care
- Cosmetic/specialty patients have much higher LTV than general consultation patients
Source tracking: where do your best patients come from?
The source field captures the patient acquisition channel. Common values used by Indian clinics:
walk-in— came to the clinic without prior contactreferral— sent by another doctor (specialist referral)patient_referral— recommended by an existing patientonline— booked through the portal/websitegoogle_search— found you on Googlegoogle_ads— clicked a paid adfacebook/instagram— social mediapracto/justdial— directory listingsinsurance— referred by insurance/TPAcorporate— empanelled company
Track this from the patient's first visit. After 6 months of tracking, you can run a simple report: "Average LTV by source."
Typical findings in Indian clinics:
| Source | Average LTV | Conversion Rate |
|---|---|---|
| Patient referral | ₹12,000 - 25,000 | Highest — trust pre-built |
| Doctor referral | ₹15,000 - 40,000 | High — specific need |
| Walk-in | ₹3,000 - 8,000 | Lowest — often one-time |
| Google search | ₹6,000 - 15,000 | Medium |
| Google Ads | ₹4,000 - 12,000 | Medium-low |
| Social media | ₹2,000 - 6,000 | Lowest quality leads |
This tells you where to invest. A clinic that learns "patient referrals are 4x more valuable than ads" starts focusing on referral programs instead of more ad spend.
Status: patient lifecycle
The status field tracks where each patient is in their relationship with your clinic. Common statuses:
new— first-ever visit (default)active— recent visits, ongoing carefollowup_due— should come back but hasn'tlapsed— no visit in 6+ monthschurned— confirmed not returning (moved cities, switched doctors, etc.)chronic— ongoing chronic condition management
This lets you build a "win-back" workflow: filter for status = "lapsed", send a polite message asking if they need anything, recover 10-20% as active patients again.
Tags: segment by what matters to your practice
The tags field is free-form text. Use it however you want. Common Indian clinic tags:
- By condition: "diabetes", "hypertension", "thyroid", "pcod", "infertility"
- By age group: "pediatric", "geriatric"
- By insurance: "Star Health", "ICICI Lombard", "corporate-Infosys"
- By VIP status: "vip", "founder_friends", "doctor_family"
- By engagement: "responds_to_whatsapp", "phone_only", "prefers_hindi"
- By geography: "south_delhi", "noida", "ggn"
You can search/filter patients by tag. So you can quickly pull up "all diabetic patients" or "all corporate-Infosys patients due for a checkup."
Practical workflows this enables
Workflow 1: Quarterly review
Every quarter, spend 30 minutes reviewing:
- Top 20 patients by LTV — send them a "thank you" message
- Patients with "lapsed" status — send win-back outreach
- Source breakdown — see which channels are growing/shrinking
- Tag analysis — see which patient segments are increasing
Workflow 2: Targeted health campaigns
Filter all patients with tag = "diabetes". Send them a WhatsApp about your new HbA1c testing service. 200 messages → 30 bookings.
This is impossible without proper tagging. With it, marketing becomes targeted instead of spray-and-pray.
Workflow 3: Referral program
Identify patients with LTV > ₹20,000 and tag = "happy" (you tag them manually after positive feedback). Reach out and ask if they'd refer a friend. Track which referrals come back and tag them as source = "patient_referral".
Over 12 months, you see exactly which patients drive the most referrals. Those are the relationships you nurture personally.
Workflow 4: Doctor performance (multi-doctor)
The created_by_doctor field tracks which doctor onboarded each patient. So in a 3-doctor practice, you can see:
- Average LTV per doctor
- Patient retention per doctor
- Referral rates per doctor
- Specialties where each doctor performs best
This is uncomfortable data — different doctors will have different numbers. But it's the only way to improve as a practice.
What you can't do without this
If your clinic management system only tracks visits and bills (which most do), you cannot answer:
- Should I invest ₹30K/month in Google Ads or in a referral program?
- Which 50 patients should I focus on building relationships with?
- What's my real CAC vs LTV?
- Which patient segments are growing or shrinking?
- Should I add a specialty service? Will it find audience among my existing patients?
These are the questions that decide whether your practice doubles in 3 years or stagnates. Tracking the right data makes them answerable.
Try it
DRP-OS Clinic tracks lifetime value, source, status, tags, and per-doctor attribution from the starter plan (₹1,499/month). You can start a 24-hour free trial and import your existing patient data via CSV.
WhatsApp +91 9560793054 for setup help — including a sample tagging strategy for your specialty.
Try DRP-OS Clinic free for 24 hours
Built for Indian solo doctors. GST invoices, Hindi prescriptions, patient records. ₹1,499/month. No credit card.
Start free trial →