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:

Create a a new appointment status called something like "DNA"

Record DNA's as and when they occur by setting the appt status to "DNA" instead of "complete"

To see the data go to Activity under Business Views in the main menu

Select the date range that you want to measure - I would suggest doing it monthly perhaps using a WriteUpp task to remind you

Export the activity into Excel or just eyeball those appts that have status "DNA" to get a feel for your DNA rate

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 appts to get a DNA %

Updated on: 06/07/2022