| Share of new patients from marketing | Leads that came in for a visit (converted) in the period divided by new patients across all facilities.= New customers from marketing / New patients | Ratio (%) |
|---|
| Marketing spend per new patient | Marketing campaign cost in the period divided by new patients (from all sources) across all facilities.= Marketing spend / New patients | Currency |
|---|
| Marketing spend to service revenue | Marketing campaign cost divided by clinic service revenue across all facilities in the same period.= Marketing spend / Service revenue | Ratio (%) |
|---|
| Campaign budget | Total budget of campaigns starting in the period. The full campaign budget is recorded on its start date. | Currency |
|---|
| Budget utilization | Marketing spend divided by campaign budget. Above 100% means over budget.= Marketing spend / Campaign budget | Ratio (%) |
|---|
| Customer acquisition cost (CAC) | Marketing spend divided by new customers (by conversion date).= Marketing spend / New customers from marketing | Currency |
|---|
| Clicks | Total clicks (or engagements that drive traffic) of campaigns by day. | Count |
|---|
| Cost per lead (CPL) | Marketing spend divided by leads created in the period.= Marketing spend / Leads | Currency |
|---|
| Click-through rate (CTR) | Clicks divided by impressions.= Clicks / Impressions | Ratio (%) |
|---|
| New customer first-order value | Total value of the first transaction of leads converted in the period, by conversion date. | Currency |
|---|
| Impressions | Total impressions (or reach) of campaigns by day. | Count |
|---|
| Lead-to-customer rate | Leads created in the period that have become customers divided by leads created in the period.= mkt_converted_leads / Leads | Ratio (%) |
|---|
| Leads | Number of leads (prospects) created in the period, by creation date. | Count |
|---|
| MQL rate | Marketing-qualified leads divided by leads created in the period.= Marketing-qualified leads (MQL) / Leads | Ratio (%) |
|---|
| Marketing-qualified leads (MQL) | Leads created in the period that passed marketing qualification (status MQL, SQL or converted to customer). | Count |
|---|
| New customers from marketing | Leads that became customers in the period, by conversion date. Converted leads with no conversion date fall in no period. | Count |
|---|
| New customer value to spend (marketing ROI) | New customer first-order value divided by marketing spend. Above 1 means first orders have covered the cost.= New customer first-order value / Marketing spend | Number |
|---|
| Marketing spend | Total cost of marketing campaigns by spend date. | Currency |
|---|
| Appointments | Total appointments by appointment date, in every status (completed, no-show, cancelled). | Count |
|---|
| Average wait time (minutes) | Average minutes from check-in to the start of the consultation, over completed visits that have both timestamps.= hc_wait_minutes_total / hc_wait_measured_visits | Number |
|---|
| Cancellation rate | Cancelled appointments divided by total appointments.= hc_cancellations / Appointments | Ratio (%) |
|---|
| Insurance-paid amount | Total amount covered by insurance (public health insurance and private insurance) in the service charges of completed visits. | Currency |
|---|
| Insurance share | Insurance-paid amount divided by service revenue.= Insurance-paid amount / Service revenue | Ratio (%) |
|---|
| New patients | Distinct patients with a completed visit of type new (not a follow-up) in the period. | Count |
|---|
| No-show rate | No-shows divided by (completed visits + no-shows). Appointments cancelled in advance are excluded.= No-shows / (Visits + No-shows) | Ratio (%) |
|---|
| No-shows | Appointments with the standard status no_show (the patient did not attend). | Count |
|---|
| Patient-paid amount | Total service charges minus the insurance-paid amount, for completed visits. | Currency |
|---|
| Follow-up visit share | Follow-up visits divided by completed visits.= hc_return_visits / Visits | Ratio (%) |
|---|
| Service revenue | Total service charges of completed visits (insurance portion plus patient portion), by visit date. | Currency |
|---|
| Revenue per visit | Service revenue divided by completed visits.= Service revenue / Visits | Currency |
|---|
| Unique patients | Distinct patients with at least one completed visit in the period. | Count |
|---|
| Visits | Appointments with the standard status completed, by visit date. | Count |
|---|
| Visits per doctor day | Completed visits divided by doctor days (days on which a doctor had at least one completed visit).= Visits / hc_doctor_days | Number |
|---|