Although coreplus doesn't have any particular report on clients who have never booked an appointment with your practice, but we have come up with a smart workaround that'll help you generate this report with the help of data backups. For this, you'll need to run two data backups, one for all the clients and the other for all the appointments booked in your account.

This article includes:

1. Running the data backups

2. Processing the data in excel

1. Go to Setup > Settings > Data Backup > Run New Backup > tick Appointments under Client Data > click Save Backup

You can see below how to run a data backup:

2. Go to Dashboard > Clients > click Instant Backup

You can see below how to run an instant data backup:

3. After you've run the backups, paste the data from the text document into an excel sheet

You can see below how to do this:

After transferring the data from the backups into excel, you'll need to reformat and process them so that they can be compared and the clients with no appointments can be identified.

In the Appointments backup, remove all the information except for the clientID and clientName.

And in the Instant Backup, remove all the information except for the clientID, title, firstname, middlename, preferredname, and surname.

Once the data has been trimmed, just copy all the data from the Appointments backup and paste it into the Instant Backup and save it.

After combining the data, select all the data and then go to Home > Conditional formatting > Highlight Cell Rules > Duplicate Values > OK. This will highlight all the duplicate cells in red meaning these cells are present in both the 'Appointments' section and in the 'Instant backup' section.

That means the Client Ids that are red are the ones with appointments. So, the Client Ids that have not been highlighted are the ones that have never booked an appointment.

You may also be interested in:

📝Reporting - Calendar

📝Email or SMS all clients
📝Reporting - Financial
📝Availability report
​