Analytics

Ella Clinic · 2026-01-01 → 2026-04-30 · 255.544 transactions

Ask ERIC →
Total Revenue
Rp 101.80 M
Jan–Apr 2026
Visits
79.749
transactions
Unique Patients
35.555
active base
Avg / Visit
Rp 1.3 jt
blended ARPU
Branches
2
Panjaitan & Supomo
Doctors
3
active practitioners

Monthly Trend

Revenue (Rp millions), visits, and ARPU per month

Peak month: 2026-03 at Rp 28.52 M (21.364 visits). Period-over-period change from 2026-01 → 2026-04: +0.1%. March overperformed driven by JASA category mix.

Branch Performance

Revenue share and unit economics

Panjaitan
51.2%
Rp 52.08 M
Visits
40.377
Patients
17.899
ARPU
Rp 1.3 jt
Supomo
48.8%
Rp 49.72 M
Visits
39.372
Patients
17.721
ARPU
Rp 1.3 jt
Panjaitan leads with 51.2% of revenue and a Rp 27.199 higher ARPU. Branches are nearly matched in patient base — the gap is driven by visit frequency, not acquisition.

Doctor Productivity

Revenue, visits, and ARPU per doctor

DoctorRevenueVisitsARPU
BobRp 34.51 M26.791Rp 1.3 jt
BagasRp 33.74 M26.335Rp 1.3 jt
AditRp 33.55 M26.623Rp 1.3 jt
Doctors are tightly clustered within a ~3% revenue spread — load-balancing is healthy. Bob has the highest ARPU and visit count; marginal upside is in pricing mix, not capacity.

Treatment / Category Mix

Revenue concentration by SKU category

JASA
Rp 63.08 M61.8%
PRODUK
Rp 37.16 M36.4%
PAKET PERAWATAN
Rp 1.68 M1.6%
LAIN-LAIN
Rp 187.9 jt0.2%
REDEEM
Rp -317.4 jtredemption
JASA (services) drives 62% of revenue at Rp 2.14 jt ARPU — 3.7× higher than PRODUK. Strategy: protect JASA capacity and use PRODUK as a high-frequency retention anchor. REDEEM is a -Rp 317.4 jt drag from loyalty redemptions — monitor liability vs. retention lift.

Patient Demographics

Gender and age cohorts

Gender mix
Wanita
Rp 96.02 M
33.331 patients · 94.3%
Pria
Rp 5.77 M
2.226 patients · 5.7%
Age cohorts — Revenue
Wanita = 94.3% of revenue. Core cohort is 25–34 (36% of revenue), but 35–44 has the highest ARPU at Rp 1.47 jt — premium upsell sits here.

Day-of-Week Pattern

Revenue and visit volume by weekday

Peak day: Sat (Rp 16.67 M, 12.171 visits). Weekends (Sat+Sun) generate 31.6% of total revenue from just 2 of 7 days — staff scheduling should follow this skew.

Hour-of-Day Pattern

When patients actually arrive (and spend)

Peak hour: 10:00 (Rp 13.47 M, 9.225 visits). Revenue concentrates 09:00–14:00 (~70% of daily total); evening tail after 18:00 is negligible — opportunity to test extended-hour pilots only on high-demand SKUs.

Top SKUs by Revenue

Top 20 of {?} products & treatments

#SKURevenueQty
1REJUVE MALAM PA01Rp 3.23 M10.853
2CLEAR BRIGHT ACNE FACIAL (PHYTO)Rp 2.75 M2.013
3DETOX WAJAH TREATMENTRp 2.19 M7.948
4LUMINOUS PICO DNA SALMON GLOW LASERRp 1.94 M941
5FLASH GLOW TREATMENTRp 1.94 M1.703
6INSTANT GLOW WHITE DNA SALMON LASER FOR ACNE (PHYTO)Rp 1.82 M577
7REHYDRATE GLOW-C FACIALRp 1.62 M1.190
8DAY GEL B SPF 30Rp 1.57 M6.434
9UV INTENSIVE PROTECTOR SUNSCREEN SPF 40Rp 1.49 M5.947
10REJUVE MALAM WA01Rp 1.41 M4.574
11ADVANCED VIT CRp 1.40 M2.643
12INSTANT CRYSTAL GLOW DNA SALMON LASERRp 1.33 M418
13DAY CREAM 50Rp 1.29 M4.553
14GLOW ACNE FACIAL PHYTORp 1.21 M1.216
15PLATINUM NANOGENESIS SUPER GLOW + DNA SALMONRp 1.21 M170
16PLATINUM SWITZERLAND SUPER GLOW BOOSTERRp 1.18 M91
17REJUVE MALAM CH-01Rp 1.17 M3.572
18PLATINUM DEEP REJUVE X DNA SALMONRp 1.15 M189
19SERUM VIT. CRp 1.14 M3.123
20REJUVE MALAM WH01Rp 1.12 M3.513
REJUVE MALAM PA01 tops revenue and volume (10,853 units) — flagship product, watch stock-outs. High-revenue / low-volume items like PLATINUM SWITZERLAND (91 units, Rp 1.18 M) are premium services — protect with capacity, not promo.
Ask ERIC

Ask a business question

AI report

Ask ERIC

Pick a suggestion above or type your own question to generate an AI report from the live dataset.