Skip to content

Dashboard templates

Healthcare · Marketing

Clinic or clinic chain running marketing (Facebook, Google, Zalo, free community check-ups). Visits, new patients and service revenue, plus the marketing funnel: spend, leads, booking rate, CPL, CAC, budget and marketing cost per new patient.

Free plan with no time limit · No card required · Sample workspace ready in minutes

For clinic marketing teams running Facebook, Google, Zalo and community health check events. The "Marketing and new patients" dashboard shows marketing cost per new patient, the share of new patients that came from marketing and marketing spend as a share of service revenue. The "Campaigns and budget" and "Marketing funnel" dashboards track spend, leads, CPL, CAC, lead-to-customer rate and budget utilization. Needs location, doctor, visit, service fee, daily marketing spend and lead data.

Use this template to

  • See which campaign brings new patients at the lowest cost.
  • Judge a community health check event by booked leads and real new patients.
  • Keep marketing spend within a set share of service revenue.

5 ready-made dashboards

Marketing and new patients

Marketing cost versus new patients and service revenue across facilities; lead-to-booking rate by campaign.

  • Marketing spend per new patient
  • Share of new patients from marketing
  • Marketing spend to service revenue
  • New patients
  • Weekly marketing cost per new patient
  • Monthly share of new patients from marketing
  • Lead-to-booking rate by campaign

Marketing funnel

Cost, leads, qualification rate, new customers and cost per new customer by channel and source.

  • Marketing spend
  • Leads
  • Cost per lead (CPL)
  • Customer acquisition cost (CAC)
  • Funnel by marketing channel
  • Lead qualification rate by source
  • Lead-to-customer rate by source
  • Weekly leads by channel

Campaigns and budget

Budget, cost, budget utilization and performance of each marketing campaign.

  • Budget utilization
  • New customer value to spend (marketing ROI)
  • New customers from marketing
  • Click-through rate (CTR)
  • Results by campaign
  • Budget utilization by campaign
  • Cost per new customer by channel
  • Weekly marketing cost by channel

Clinic overview

Visits, patients, service revenue and insurance-covered share by facility and specialty.

  • Visits
  • Unique patients
  • Service revenue
  • Revenue per visit
  • Weekly visits by facility
  • Monthly visits by specialty
  • Results by facility
  • Revenue by service group
  • Insurance-covered share by patient type

Appointment operations

No-show rate, cancellations, wait time and doctor productivity by facility, specialty and doctor.

  • Appointments
  • No-show rate
  • Average wait time (minutes)
  • Visits per doctor day
  • No-show rate by facility
  • Average wait time by facility
  • Weekly wait time by facility
  • Productivity by doctor
  • Follow-up visit share by specialty

Ask Si as soon as the build finishes

  • “How did share of new patients from marketing change compared with last month?”
  • “What is driving marketing spend per new patient this quarter?”
  • “Show marketing spend to service revenue by month for the last six months.”
  • “Where is campaign budget highest this month, and why?”

33 defined metrics

Versioned definitions, shared by dashboards, Si, reports and MCP.

MetricDefinitionUnit
Share of new patients from marketingLeads that came in for a visit (converted) in the period divided by new patients across all facilities.= New customers from marketing / New patientsRatio (%)
Marketing spend per new patientMarketing campaign cost in the period divided by new patients (from all sources) across all facilities.= Marketing spend / New patientsCurrency
Marketing spend to service revenueMarketing campaign cost divided by clinic service revenue across all facilities in the same period.= Marketing spend / Service revenueRatio (%)
Campaign budgetTotal budget of campaigns starting in the period. The full campaign budget is recorded on its start date.Currency
Budget utilizationMarketing spend divided by campaign budget. Above 100% means over budget.= Marketing spend / Campaign budgetRatio (%)
Customer acquisition cost (CAC)Marketing spend divided by new customers (by conversion date).= Marketing spend / New customers from marketingCurrency
ClicksTotal 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 / LeadsCurrency
Click-through rate (CTR)Clicks divided by impressions.= Clicks / ImpressionsRatio (%)
New customer first-order valueTotal value of the first transaction of leads converted in the period, by conversion date.Currency
ImpressionsTotal impressions (or reach) of campaigns by day.Count
Lead-to-customer rateLeads created in the period that have become customers divided by leads created in the period.= mkt_converted_leads / LeadsRatio (%)
LeadsNumber of leads (prospects) created in the period, by creation date.Count
MQL rateMarketing-qualified leads divided by leads created in the period.= Marketing-qualified leads (MQL) / LeadsRatio (%)
Marketing-qualified leads (MQL)Leads created in the period that passed marketing qualification (status MQL, SQL or converted to customer).Count
New customers from marketingLeads 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 spendNumber
Marketing spendTotal cost of marketing campaigns by spend date.Currency
AppointmentsTotal 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_visitsNumber
Cancellation rateCancelled appointments divided by total appointments.= hc_cancellations / AppointmentsRatio (%)
Insurance-paid amountTotal amount covered by insurance (public health insurance and private insurance) in the service charges of completed visits.Currency
Insurance shareInsurance-paid amount divided by service revenue.= Insurance-paid amount / Service revenueRatio (%)
New patientsDistinct patients with a completed visit of type new (not a follow-up) in the period.Count
No-show rateNo-shows divided by (completed visits + no-shows). Appointments cancelled in advance are excluded.= No-shows / (Visits + No-shows)Ratio (%)
No-showsAppointments with the standard status no_show (the patient did not attend).Count
Patient-paid amountTotal service charges minus the insurance-paid amount, for completed visits.Currency
Follow-up visit shareFollow-up visits divided by completed visits.= hc_return_visits / VisitsRatio (%)
Service revenueTotal service charges of completed visits (insurance portion plus patient portion), by visit date.Currency
Revenue per visitService revenue divided by completed visits.= Service revenue / VisitsCurrency
Unique patientsDistinct patients with at least one completed visit in the period.Count
VisitsAppointments with the standard status completed, by visit date.Count
Visits per doctor dayCompleted visits divided by doctor days (days on which a doctor had at least one completed visit).= Visits / hc_doctor_daysNumber

Data you need

Required

clinic, doctor, visit, visit_charge, mkt_spend_daily, mkt_lead

Add if you have it (unlocks more metrics)

patient, service, mkt_campaign

Three steps to this dashboard

  1. 1

    Connect your data

    Upload an Excel file or connect a source with: clinic, doctor, visit, visit_charge, mkt_spend_daily, mkt_lead.

  2. 2

    Approve Si's proposal

    Si proposes how to read your tables and map them to the industry's standard model; you fix anything highlighted and approve.

  3. 3

    Dashboards and Q&A

    The build gives you 5 dashboards and 33 metrics; ask Si anytime.

Data sources for this template

Connectors with a setup guide that feed the entities this template needs. Excel always works.

Related templates

Build Healthcare · Marketing with your own data

Free plan with no time limit · No card required · Sample workspace ready in minutes