Skip to content

Dashboard templates

Healthcare · Sales

A clinic or clinic chain serving walk-in patients, with a sales team selling health check packages to companies. Visits, service revenue and no-show rate plus opportunities, win rate and quota attainment of the sales team.

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

For clinics with a sales team selling corporate health check packages alongside walk-in visits. The "Walk-in visits and corporate packages" dashboard shows total revenue, the corporate package share and corporate packages compared with walk-in visits. The "Opportunities and quota" dashboard tracks opportunities, win rate, contract value and quota attainment, while the clinic dashboards show visits and no-show rate. Needs location, doctor, visit, service fee and sales opportunity data.

Use this template to

  • Know how much of total revenue comes from corporate packages.
  • Track who hits their health check package quota.
  • Prepare clinic capacity before a large corporate contract starts.

4 ready-made dashboards

Walk-in visits and corporate packages

Total revenue, including walk-in services at facilities and corporate health check package contracts signed by the sales team.

  • Total revenue (walk-in and corporate)
  • Service revenue
  • Won amount
  • Corporate package share
  • Weekly total revenue
  • Monthly corporate packages vs walk-in visits
  • Signed package value by team

Opportunities and quota

New opportunities, win rate, closed value and quota attainment of the sales team.

  • Won amount
  • Win rate
  • Open pipeline value
  • Average sales cycle (days)
  • Results by salesperson
  • Quota attainment by team
  • Win rate by opportunity source
  • Monthly closed value by region

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 corporate package share change compared with last month?”
  • “What is driving corporate packages vs walk-in revenue this quarter?”
  • “Show total revenue (walk-in and corporate) by month for the last six months.”
  • “Where is average deal size highest this month, and why?”

28 defined metrics

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

MetricDefinitionUnit
Corporate package shareValue of signed corporate health check contracts divided by total revenue (walk-in visits and corporate packages).= Won amount / (Service revenue + Won amount)Ratio (%)
Corporate packages vs walk-in revenueValue of signed corporate health check contracts divided by walk-in visit service revenue in the same period.= Won amount / Service revenueRatio (%)
Total revenue (walk-in and corporate)Walk-in visit service revenue across clinics plus the value of corporate health check contracts signed in the period.= Service revenue + Won amountCurrency
Average deal sizeWon amount divided by the number of won opportunities.= Won amount / Won opportunitiesCurrency
Average sales cycle (days)Average days from creation to win for opportunities won in the period.= won_cycle_days_total / Won opportunitiesNumber
Lost opportunitiesNumber of opportunities lost, by close date.Count
New opportunitiesSales opportunities created in the period (by creation date), including open, won and lost ones.Count
Open pipeline valueTotal value of opportunities created in the period that are still open (neither won nor lost).Currency
Sales targetTotal sales targets of sales reps. Targets are set monthly and recorded on the first day of the month.Currency
Quota attainmentWon amount divided by sales target. Above 100% means the target is exceeded.= Won amount / Sales targetRatio (%)
Win rateWon opportunities divided by all closed opportunities (won plus lost) in the period. Open opportunities are excluded.= Won opportunities / (Won opportunities + Lost opportunities)Ratio (%)
Won amountTotal value of won opportunities, by close date.Currency
Won opportunitiesNumber of opportunities won, by close date.Count
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, opportunity

Add if you have it (unlocks more metrics)

patient, service, sales_rep, sales_target

Three steps to this dashboard

  1. 1

    Connect your data

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

  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 4 dashboards and 28 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 · Sales with your own data

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