Skip to content

Dashboard templates

Healthcare · Customer service

A clinic or clinic chain with a booking call center and a post-visit care team answering on Zalo, Facebook page and email. Visits, wait times and revenue plus support tickets, response speed, CSAT, abandoned calls and wait time complaints per 1,000 visits by facility and specialty.

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

For booking call center managers and post-visit care teams at clinics and clinic chains. The "Visits and feedback" dashboard links support tickets to visits, so you see wait time complaints per 1,000 visits by location and specialty instead of a raw ticket count. The "Customer service" and "CS agents" dashboards cover response time, resolution rate, CSAT and missed call rate. Needs location, doctor, visit, service fee and support ticket data.

Use this template to

  • See which location gets the most wait time complaints relative to real visit volume, and adjust doctor schedules.
  • Add call center staff in peak season when the missed call rate rises.
  • Track post-visit CSAT by agent and by channel: Zalo, Facebook page, email.

5 ready-made dashboards

Visits and feedback

Visit-linked tickets by facility and specialty; wait-time complaints against visits and wait time.

  • Wait time complaints per 1,000 visits
  • Wait time complaints
  • Visit-linked support tickets
  • Average wait time (minutes)
  • Wait-time complaints by facility
  • Weekly visit-linked tickets by specialty
  • Weekly tickets by category

Customer service

Ticket volume, response and resolution speed, and customer satisfaction by channel and category.

  • Support tickets
  • Average first response time (hours)
  • Resolution rate
  • CSAT (satisfaction rate)
  • Daily tickets by category
  • By contact channel
  • Tickets by category
  • First response by channel group
  • NPS
  • Call abandonment rate

CS agents

Productivity, speed and quality of handling for each customer service agent and team.

  • Resolved tickets
  • Tickets per agent per day
  • First contact resolution rate
  • Ticket reopen rate
  • Results by agent
  • CSAT by team
  • Weekly CSAT by team

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 visit-linked support tickets change compared with last month?”
  • “What is driving wait time complaints this quarter?”
  • “Show wait time complaints per 1,000 visits by month for the last six months.”
  • “Where is call abandonment rate highest this month, and why?”

31 defined metrics

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

MetricDefinitionUnit
Visit-linked support ticketsSupport tickets created in the period whose reference code matches a visit; broken down by that visit's facility and specialty.Count
Wait time complaintsSupport tickets created in the period in the "Wait time" category; broken down by the facility and specialty of the visit mentioned (tickets not linked to a visit count only in the total).Count
Wait time complaints per 1,000 visitsWait time complaints divided by completed visits, times 1,000. How many long-wait complaints there are for every 1,000 visits.= Wait time complaints * 1000 / VisitsNumber
Call abandonment rateCalls where the customer hung up before reaching an agent divided by all inbound calls.= cs_abandoned_calls / Inbound callsRatio (%)
Average first response time (hours)Average hours from when the customer created a ticket to the agent's first response, over tickets created in the period that have a response.= cs_first_response_hours_total / cs_responded_ticketsNumber
Average resolution time (hours)Average hours from creation to resolution for tickets resolved in the period.= cs_resolution_hours_total / Resolved ticketsNumber
Inbound callsCalls into the call center in the period, including calls abandoned by the customer.Count
CSAT (satisfaction rate)Share of surveys with a CSAT score of 4 or 5 on a 1-5 scale, among surveys with a valid CSAT score.= cs_csat_positive / Survey responsesRatio (%)
First contact resolution rateTickets resolved with a single contact and never reopened divided by tickets resolved in the period.= cs_fcr_tickets / Resolved ticketsRatio (%)
NPSNet Promoter Score = (promoters 9-10 minus detractors 0-6) x 100 / NPS responses. Scale -100 to 100.= cs_nps_points * 100 / cs_nps_responsesNumber
Ticket reopen rateTickets resolved in the period that were ever reopened divided by tickets resolved in the period.= cs_reopened_tickets / Resolved ticketsRatio (%)
Resolution rateTickets created in the period that are resolved divided by tickets created in the period.= cs_created_resolved / Support ticketsRatio (%)
Resolved ticketsTickets resolved in the period (by resolution date); status resolved or closed with a resolution timestamp.Count
Survey responsesPost-support surveys with a valid CSAT score (1-5), by customer response date.Count
Support ticketsSupport tickets created in the period (by creation date), any status.Count
Tickets per agent per dayTickets created in the period divided by agent working days with tickets.= Support tickets / cs_agent_daysNumber
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, cs_ticket

Add if you have it (unlocks more metrics)

patient, service, cs_agent, cs_survey, cs_call

Three steps to this dashboard

  1. 1

    Connect your data

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

  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 31 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 · Customer service with your own data

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