How can I measure my DNA rates?
To reduce your DNA rates, you need to measure them. This brief article explains what you need to do to measure your DNA rates from within WriteUpp:
Create a a new appointment status and call it "DNA", or something similar. Read How do I add an appointment status to learn how to do this.
Record DNA's as and when they occur by setting the appointment status of the appointment to "DNA" instead of "complete"
To see the data, go to Activity under Business Views from the main menu
If your DNA status is set to 'Patient is attending' then...
You may be wondering why you would set an appointment status, such as DNA, to mean the patient is attending, when they actually are not. This is because if you charge for DNAs, then you MUST have the appointment status set to mean the patient is attending, so that you can still invoice for it. If you do not have 'Does it mean the Patient is attending?' set to Yes, then you will not be able to create an invoice for any appointment using that status. To read more on this, check out the following article - How do I charge for DNAs and Cancellations
Go to the Attended Activity tab
Select the date range that you want to measure - we would suggest doing this monthly. Why not use a WriteUpp task to remind you!
Export the activity into Excel or just eyeball those appointments that have the status "DNA" to get a feel for your DNA rate
Did you know? You can use the blue 'Status' column header to order the Activity list alphabetically by status. This will group all the appointments with the DNA status together, so you can easily count them.
If you export into Excel, you can then use the countif function (in Excel) on the status column and divide the total count of DNA's by the total number of appointments to get a DNA %
If your DNA status is set to 'Patient is NOT attending' then...
Go to the Non-attended Activity tab
Select the date range that you want to measure
You will be able to see all the appointments that have a status which means the patient did not attend.
Again, you can export the list to excel or order the Status column alphabetically, so all appointments with the status 'DNA' appear together. This will be useful if you have more than one status set up that means the client is not attending.
Then just analyse the data as you need to!
Create a a new appointment status and call it "DNA", or something similar. Read How do I add an appointment status to learn how to do this.
Record DNA's as and when they occur by setting the appointment status of the appointment to "DNA" instead of "complete"
To see the data, go to Activity under Business Views from the main menu
If your DNA status is set to 'Patient is attending' then...
You may be wondering why you would set an appointment status, such as DNA, to mean the patient is attending, when they actually are not. This is because if you charge for DNAs, then you MUST have the appointment status set to mean the patient is attending, so that you can still invoice for it. If you do not have 'Does it mean the Patient is attending?' set to Yes, then you will not be able to create an invoice for any appointment using that status. To read more on this, check out the following article - How do I charge for DNAs and Cancellations
Go to the Attended Activity tab
Select the date range that you want to measure - we would suggest doing this monthly. Why not use a WriteUpp task to remind you!
Export the activity into Excel or just eyeball those appointments that have the status "DNA" to get a feel for your DNA rate
Did you know? You can use the blue 'Status' column header to order the Activity list alphabetically by status. This will group all the appointments with the DNA status together, so you can easily count them.
If you export into Excel, you can then use the countif function (in Excel) on the status column and divide the total count of DNA's by the total number of appointments to get a DNA %
If your DNA status is set to 'Patient is NOT attending' then...
Go to the Non-attended Activity tab
Select the date range that you want to measure
You will be able to see all the appointments that have a status which means the patient did not attend.
Again, you can export the list to excel or order the Status column alphabetically, so all appointments with the status 'DNA' appear together. This will be useful if you have more than one status set up that means the client is not attending.
Then just analyse the data as you need to!
Updated on: 29/06/2023
Thank you!