HealthCORE

HealthCore Analytics

Updated on

This How Do I Document will teach you how to use and understand the Analytics.  The Analytics is designed to produce all of the critical weekly and monthly statistics to help monitor your practice.  Access to the Analytics is only given to users who the doctor/Owner has granted access.  The most important thing about the Analytics is understanding how the stats are calculated.  

Analytics

Reports

Previously Compiled - This report runs the night before so that you don't have to wait for the stats to calculate.  To get immediate results click drop down arrow to choose the date of the Previously Compiled data, once you select the date click the View button to see the stats for that date.  This will display results immediately. If you need current and up-to-date stats including things that have happened today, choose Run New.  You can choose any date, including today, in this section. Run New Stats will take a while to run since the computer is calculating a lot of data.

EZ Report Stats

Previously Compiled Stats

Previously Compiled - click drop down arrow, click the date you want to view, then click View to run data for that date.

Run New Stats

To see stats calculated for the exact date shown, use Run New Stats and select the day for which you want to see the report and hit OK.

Reports Displays

Reports Displays

This is the Analytics. Each calculation will be explained below

Calculations

 

  1. Day = Today's date calculations
  2. WTD = Week to Date calculation
  3. MTD = Month to Date calculations
  4. YTD = Year to Date calculations
  5. Previous 3 Mo. Avg = Previous 3 Month Average
  6. Previous 12 Mo. Total = Previous 12 Month Total
  7. Previous 12 Mo. Avg = Previous 12 Month Average

Service and Collections Calculations

  1. Charges = Sum of Charge Total based on the Charge Date
  2. Average Visit Service (AVS) = Charges divided by the number of Patient Visits (chargeable visits only)
  3. Collections (Payment Date) = Sum of Collections (Type = Payment) based on Payment Date.  This includes Carrier Payments.
  4. Average Visit Income (AVI) = Collections - Entry Date divided by the number of Patient Visits (Chargeable Patient visits)
  5. Case Average = Collections - Payment Date divided by Converted NP/RA/3rd Visit
  6. Product Sales = Number of Products sold
  7. Product Revenue = Collections from Product Sold
  8. A/R as of today = Sum of Charge Balances as of today's date

New Patients and Reactivations Calculations

  1. New Patient Prospects = Number of Patients having a 9920* CPT Code billed
  2. Converted NP = Number of 9920* Patients having a visit within 1-30 days after a ROF/2nd visit
  3. NP Conversion Percentage = Number of Converted NP Visit divided by Prospects and Reactivations
  4. Reactivation's (RA) = Number of Patients having a RA21* Item code billed
  5. Converted RA = Number of RA21* Patients having a visit within 1-30 days after a ROF/2nd visit
  6. RA Conversion Percentage = Number of Converted RA visit divided by Reactivation Visits

Patient Visits and Retention Calculations

  1. Patient Visits = Number of Charge Dates Patients were billed a Service with a non-zero dollar Unit Price
  2. $0.00 Visits = Number of Charge Dates Patients were billed a Service with a zero dollar Unit Price
  3. Wellness Visits = A wellness patient is defined as any patient whose conversion appointment was more than 90 days ago and who has had more than 12 visits since their conversion appointment.
  4. Wellness Visits % - Percentage of Patient Visits that are for patients who are past their Primary Care phase of treatment.  More specifically, a wellness patient is defined as any patient whose conversion appointment was more than 90 days ago and who has had more than 12 visits since their conversion appointment. Patient Visits does not include the $0.00 visits.
  5. PE1% = Prospects with Prospect Date between 30 and 120 Days and Total Visits >11 divided by Converted New Patients (3rd visit) with Prospect Date between 30 and 120 Days
  6. PE2% = Prospect Date Between 60 and 150 Days Previous. Prospect with Prospect Date between 60 and 150 Days and Total Visits > 19 divided by Converted New Patients with Prospect Date between 60 and 150 Days and Total Visits > 11 (essential showing out of all patients that made it to PE1 (12 visits) how many made it to PE2 (20 visits).
  7. PVA = Number of Patient Visits divided by the number of Converted NP/RA/3rd visit
  8. Total Active Patients = Number of Unique Patients with a Visit
  9. Progress Exams = Number of Charge Dates Patients were billed PE211- PE215 Item Codes

Therapy and Scheduling Calculations

  1. Total PT Units = Number of Units for Service Charges billed with a CPT Code of 97*, G0283, 95851, or S9090, S8948. Units for 97001 and S9090 are counted twice.
  2. PT Unit Average = Total PT Units divided by the number of Patient Visits where a PT Unit was entered
  3. PT Clinic Average = Total PT Units divided by the number of Patient Visits
  4. Signed In =   Number of appointments signed in during the time period
  5. Signed In % = Number of patient appointments signed in during the time period divided by the number of scheduled patients appointments during the time period.
  6. Future Appts per Active Patient = Number of future appointments scheduled for patients not on a wellness treatment plan divided by the total number of unique patients that are not on a wellness treatment plan in the last 60 days
  7. Future Appts. per Wellness Patient = Number of future appointments scheduled for patients currently on a wellness treatment plan divided by the number of unique wellness patients (S8990, 9894* w/GA modifier) with an appointment in the last 60 days
  8. No Show/Cancellations % = This is the number of appointments that are marked as a No Show and Canceled divided by the total number of appointments.
  9. Special Consultations = Number of Patient Appointments with a Visit Type SPEC and marked Signed IN
  10. Special Consultations % = Number of Special Consultations divided by the number of NP/3rd Visit (CHIRO) NOTE: RA # is excluded

 

Hovering with your mouse over a Calculation name will also show you the Analytics Definitions

Toolbar

1.  Printer Icon - Print, Print to Default Printer, Email, and Send to FileVault

2.  Export to Spreadsheet - Click Email or Save