HealthCORE

HealthSource 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.

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

Calculations

  1. Charges = Sum of Charge Total based on the Charge Date
  2. AVS (Average Visit Service) = 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. Collection - Entry Date = Sum of Collections (Type = Payment) based on Entry Date.  This includes Carrier Payments.
  5. A/R as of today = Sum of Charge Balances as of today's date

Calculations

  1. Gross Collection % = For charges in the previous 12 months, total applied payments divided by charge total
  2. Net Collection % = For charges in the previous 12 months, total applied payments divided by charge total minus adjustments
  3. AVI (Average Visit Income) = Collections - Entry Date divided by the number of Patient Visits (Chargeable Patient visits)
  4. PVA (Patient Visit Average) (NP/RA) = Number of Patient Visits divided by the number Converted NP/RA/3rd visit
  5. Case Average NP/RA = Collections - Payment Date divided by Converted NP/RA/3rd Visit
  6. Prospect (NE) = Number of Patients having a 9920* CPT Code billed
  7. ROF/2nd Visit (NE) = Number of Patients having a visit within 1-30 days after a Prospect or Reactivation visit.  If the patient comes in for the ROF visit and leaves without booking further and no charges are entered, the patient will count in this stat as long as they are signed in and within 1-30 days of an RA or NE visit.
  8. Converted NP = Number of Patients having a visit within 1-30 days after a ROF/2nd visit
  9. New Patient Conversion Ratio NP = Number of Converted NP/RA/3rd Visit divided by Prospects (Chiro) and Reactivations
  10. Reactivations = Number of Patients having a RA21*Item Code billed
  11. Converted RA = Number of RA21* Patients having a visit within 1-30 days after a ROF/2nd visit
  12. Reactivation Conversion Ratio RA = 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. Patient Visits $0.00 Services = Number of Charge Dates Patients were billed a Service with a zero dollar Unit Price
  3. Wellness Patient 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.  The Patient Visits value is the green line stat and it does not include the $0.00 visits.
  4. Total PT Units = Number of Units for Service Charges billed with a CPT Code of 97*, G0283, 95851, or S9090. Units for 97001 and S9090 are counted twice.
  5. PT Clinic Average - All Visits = Total PT Units divided by the number of Patient Visits
  6. PT Unit Average = Total PT Units divided by the number of Patient Visits where a PT Unit was entered
  7. Progress Exams = Number of Charge Dates Patients were billed PE211- PE215 Item Codes
  8. Special Consultations = Number of Patient Appointments with a Visit Type like SPEC and marked Signed In
  9. Special Consultation % = Number of Special Consultations divided by the number of NP/3rd Visits (CHIRO) NOTE: RA# is excluded
  10. Total Active Patients = Number of Unique Patients with a Visit

Calculations

  1. Product Revenue = Collections from Products Sold
  2. Product Sales = Number of Products Sold
  3. % No Show/Cancellations = Number of appointments that are marked as a No Show and Canceled divided by the total number of appointments
  4. 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
  5. Future Appt per Primary Care 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
  6. 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
  7. 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).
  8. Signed In = Number of appointments signed in during the time period
  9. Signed In % = Number of patient appointments signed in during the time period divided by the number of scheduled patients appointments during the time period.

 

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