Educational foundation: Use these measures as a Clinic baseline. International reference and DentalDNS India benchmark labels are reserved for sourced future research; no target ranges are invented here.
Enquiry Conversion Rate
Definition and formula: Appointments Booked ÷ Valid Enquiries × 100
Required data: Count valid enquiries and booked appointments.
Register method: Record the numerator and denominator in the Clinic KPI Tracker each month. Excel method: use the linked dashboard formula and keep input rows editable.
Worked example: Example: 24 ÷ 60 × 100 = 40%.
Interpretation and corrective action: Use a clinic baseline; example values are not benchmarks. Example values are illustrative, not benchmarks.
Show Rate
Definition and formula: Attended Appointments ÷ Confirmed Appointments × 100
Required data: Confirmed and attended appointment counts.
Register method: Record the numerator and denominator in the Clinic KPI Tracker each month. Excel method: use the linked dashboard formula and keep input rows editable.
Worked example: Example: 42 ÷ 50 × 100 = 84%.
Interpretation and corrective action: Investigate reminder and access friction. Example values are illustrative, not benchmarks.
Diagnosis-to-Plan Rate
Definition and formula: Treatment Plans Presented ÷ Completed First Consultations × 100
Required data: First-consultation and plan counts.
Register method: Record the numerator and denominator in the Clinic KPI Tracker each month. Excel method: use the linked dashboard formula and keep input rows editable.
Worked example: Example: 18 ÷ 30 × 100 = 60%.
Interpretation and corrective action: Review explanation and documentation. Example values are illustrative, not benchmarks.
Case Acceptance Rate
Definition and formula: Accepted Treatment Plans ÷ Treatment Plans Presented × 100
Required data: Presented and accepted plan counts.
Register method: Record the numerator and denominator in the Clinic KPI Tracker each month. Excel method: use the linked dashboard formula and keep input rows editable.
Worked example: Example: 12 ÷ 18 × 100 = 66.7%.
Interpretation and corrective action: Review clarity, timing and follow-up. Example values are illustrative, not benchmarks.
Average Accepted Plan Value
Definition and formula: Total Accepted Plan Value ÷ Number of Accepted Plans
Required data: Accepted plan values and count.
Register method: Record the numerator and denominator in the Clinic KPI Tracker each month. Excel method: use the linked dashboard formula and keep input rows editable.
Worked example: Example: ₹4,80,000 ÷ 12 = ₹40,000.
Interpretation and corrective action: Compare only with your clinic baseline. Example values are illustrative, not benchmarks.
Treatment Completion Rate — Value Weighted
Definition and formula: Completed Treatment Value ÷ Accepted Plan Value × 100
Required data: Completed and accepted value.
Register method: Record the numerator and denominator in the Clinic KPI Tracker each month. Excel method: use the linked dashboard formula and keep input rows editable.
Worked example: Example: ₹2,40,000 ÷ ₹3,00,000 × 100 = 80%.
Interpretation and corrective action: Track continuity and barriers. Example values are illustrative, not benchmarks.
Collection Rate
Definition and formula: Actual Collections ÷ Net Billable Completed Value × 100
Required data: Collections and net billable completed value.
Register method: Record the numerator and denominator in the Clinic KPI Tracker each month. Excel method: use the linked dashboard formula and keep input rows editable.
Worked example: Example: ₹1,80,000 ÷ ₹2,00,000 × 100 = 90%.
Interpretation and corrective action: Review payment timing and reconciliation. Example values are illustrative, not benchmarks.
Contribution
Definition and formula: Collected Fee − Direct Material − Lab Cost − Variable Treatment Cost
Required data: Collected fees and direct variable costs.
Register method: Record the numerator and denominator in the Clinic KPI Tracker each month. Excel method: use the linked dashboard formula and keep input rows editable.
Worked example: Example: ₹1,00,000 − ₹20,000 − ₹15,000 − ₹5,000 = ₹60,000.
Interpretation and corrective action: Use for service-line review, not a benchmark. Example values are illustrative, not benchmarks.
Contribution per Chair Hour
Definition and formula: Contribution ÷ Productive Chair Hours
Required data: Contribution and productive chair hours.
Register method: Record the numerator and denominator in the Clinic KPI Tracker each month. Excel method: use the linked dashboard formula and keep input rows editable.
Worked example: Example: ₹60,000 ÷ 120 = ₹500/hour.
Interpretation and corrective action: Review scheduling and productive mix. Example values are illustrative, not benchmarks.
Privacy and use
Do not enter patient names, phone numbers, health information or other identifying data. Keep the register inside your clinic and use aggregated monthly counts.