Marketing · Patient Acquisition
Mandaya Hospital Group · 184,247 patients · Senin, 16 September 2024
Total patient base
184,247
Royal Puri + Karawang
Active (last 6 mo)
89,431
48% · ↑ 2.1pp QoQ
Lapsed (>6 mo)
38,206
21% · → vs Q2 · View cohort
Win-back rate (90-day)
23.4%
↑ from 19.1% last quarter
Patient cohorts · auto-generated by Semesta AI
Re-computed nightly. Last refresh 04:00 WIB.
Lapsed Chronic — High Value
4.238 patients- 40-5438%
- 55-6441%
- 65+21%
- L:P 58:42 · avg age 58
Condition mix
DM only42%
HTN only31%
Both27%
Sample patients
| Patient | Age/G | Conditions | Lapsed | LTV |
|---|---|---|---|---|
| Budi Hartono | 55L | DM + HTN | 8 mo | Rp 12.4M |
| Iskandar Halim | 62L | DM + Cardio | 11 mo | Rp 9.8M |
| Maria Tjandra | 58P | HTN | 7 mo | Rp 6.2M |
| Ari Susanto | 64L | DM | 9 mo | Rp 7.4M |
| Dewi Kartika | 51P | DM + HTN | 14 mo | Rp 11.1M |
Recommended action · AI
Launch Diabetes-Cardio MCU campaign. Predicted response rate 24.0% · ROI 6.2x
Best channel: WhatsApp (89% open). Best time: weekday 09:00-11:00.
