Use Power Diary's advanced search to generate refined client, referrer, contact, and third-party lists, exportable to PDF or Excel for marketing or detailed reporting.
The advanced search functionality is a powerful tool that can be used to generate client, referrer, contact and third-party lists. The search itself is broken down into varying sections, each with their own filters and fields that can be used to refine the list that is generated by the advanced search.
The advanced search interface is also used to generate client lists for marketing communication (i.e. bulk SMS or email) as well as for sending clients to MailChimp.
The advanced search can be accessed via People > Clients , Contacts, Referrers or Third Parties > Advanced Search.
![](https://support.powerdiary.com/hubfs/Knowledge%20Base%20Import/d33v4339jhl8k0.cloudfront.netdocsassets5bd7e33f2c7d3a01757a8daeimages66172dac477c990280e43673file-76IBOjJBJy-1.png)
In this article:
Understanding the filters
While a majority of the filters and fields on the advanced search are fairly straightforward (first name, last name, telephone, email etc.), some might not be as immediately obvious.
![](https://support.powerdiary.com/hubfs/Knowledge%20Base%20Import/d33v4339jhl8k0.cloudfront.netdocsassets5bd7e33f2c7d3a01757a8daeimages66172ddd4db6eb7a51d9356efile-Nk72nIlqaI-1.png)
Filtering by Practitioner Type
It is possible to generale a list of clients based on available practitioner types and their relationship to client profiles.
- Primary Practitioner: a practitioner that is set as a Primary Practitioner in a client profile > Admin Manage page.
- Assigned Practitioners: practitioners that are set as Assigned Practitioners in a client profile > Admin Manage page.
- Appointment Practitioner: a practitioner who provided appointments to the clients which will be included in the list.
Had an Appointment Between and No Appointments Between
These two filters can be extremely powerful if you're looking for information specific to a client's activity within your business. For example, you might want to find a list of all clients who have had an appointment this year but don't have an appointment booked for the future. To do this you would simply set the 'Had an Appointment Between Dates' to the 01/01/2022 to today's date and then toggle the 'No Future Appointments Slider':
![](https://support.powerdiary.com/hubfs/Knowledge%20Base%20Import/d33v4339jhl8k0.cloudfront.netdocsassets5bd7e33f2c7d3a01757a8daeimages66172e76d9cffa6c1049d34bfile-jSYY5Wel9n-1.png)
Using Multiple Filters to Refine Search Results
You are able to use all of these filters in conjunction with each other. This means that you can refine the results of the search down to look only at what you're after.
For example, you might want to run the above search but only look at data relevant to a specific practitioner and clients with a particular classification applied. In this case, you would set the above filters up and then simply select the relevant classification (or classifications) and the calendar/practitioner that you're wanting to report on.
![](https://support.powerdiary.com/hubfs/Knowledge%20Base%20Import/d33v4339jhl8k0.cloudfront.netdocsassets5bd7e33f2c7d3a01757a8daeimages66172fc9477c990280e43674file-ZWY0iJ1JSU-1.png)
Exporting and refining the results
Once you have tweaked the various filters to your liking you can generate the list of clients (or referrers, third parties or contacts) you can click 'Show Filtered List' to generate the list. Once the list has been generated you can further refine the results:
![](https://support.powerdiary.com/hubfs/Knowledge%20Base%20Import/d33v4339jhl8k0.cloudfront.netdocsassets5bd7e33f2c7d3a01757a8daeimages66172f065b008e1c56a99247file-PNm4tS9GGP-1.png)
Export it to either PDF, Excel or print it.
![](https://support.powerdiary.com/hubfs/Knowledge%20Base%20Import/d33v4339jhl8k0.cloudfront.netdocsassets5bd7e33f2c7d3a01757a8daeimages66172f1cd9cffa6c1049d34cfile-s0Qz24DsDH-1.png)