[Donor Management System] Advanced Search for Contacts
Contacts Advanced Search lets you search for one or many Contacts based on criteria found on Contact Profiles.
You can filter and segment your Contacts based on one or more data points or search for a group of Contacts with information that falls within a set range of parameters.
When to Use Advanced Search for Contacts?
- Compile a list of potential donors,
- Prepare Contacts for a mailing,
- Create Groups or Smart Groups,
- Understand who has donated within a specific time period, or
- Find Contacts that have specific attributes that cannot be found using the Simple Name Search.
Example: retrieve a list of Contacts who have donated over $100 in the current year.
Additional examples that may call for an Advanced Search:
- A Contact that has a specific Note in their Contact Profile,
- A Contact where the City they reside in is known, as well as their First Name, but not their Last Name,
- All Contacts who contributed to a specific Campaign,
- All Contacts who have made Contributions under, over or between a certain range (e.g. between $50.00 and $500.00),
- All Contacts whose most recent Contribution is within the current month,
- All Contacts within a specific City or Postal Code range.
Using Advanced Search for Contacts
1. To perform an Advanced Search for Contacts, go to the Contacts Tab
2. On the top right corner of the screen, select Advanced Search to expand the search filters
3. The first two sections (1) Display Settings and (2) Contacts will be opened. The (3) subsequent sections are all collapsed and must be selected to open the available search fields
4. To open and close a section of Advanced Search, click on its name
5. Use the available fields to input your desired search criteria. Once you have performed your search criteria, select Search to generate your results.
6. If you wish to add additional components to your search, select Edit Criteria, include your new criteria and then select Search
7. To begin a new search, select Reset Form and all former search criteria will be reset.
Sections of Advanced Search for Contacts
Contacts Advanced Search is categorized by multiple sections containing specific information about your Contacts.
The following will provide context on how many of the fields and features of Contacts Advanced Search can be applied to your search.
- Results: the Contact Advanced Search function defaults to showing Contacts as a search result. However, the tool can be configured to display results of different items including Contributions and Activities.
When searching for Contacts, ensure the Results field is set to Contacts.
- View: Different data about your Contacts. To change the view, simply select one of the alternate views from the drop-down menu.
- Search Operator – And, Or: The search operators AND and OR define how the search criteria should be applied.
– Contacts who reside in your organisation’s City AND have Contributions that were received in 2020 would return a list of your local & active donors.
– Contacts who reside in your organisation’s City OR have Contributions that were received in 2020 would return a list of your local donors, regardless of Contribution dates as well as all your active donors, regardless of location.
- Search in trash (deleted contacts): Searches for deleted Contacts. This may be used if you are seeking to recover any accidentally deleted Contacts.
- Name & Email: Enter full or partial information in the Name or Email fields to retrieve Contacts.
- Contact Type(s): Individual, Household or Organization contacts can be searched on this field, as well as any additional Sub-Contact Types you may have configured. You can select one or multiple Contact Types at once.
- Group(s): search for Contacts that are members of the selected Groups or Smart Groups. You can select one or multiple Groups at once.
- Privacy Settings: you may decide to include or exclude Contacts based on their Privacy Settings. For example, if preparing a list of Contacts for a mail campaign, you will want to select Exclude Contacts who have been marked Do not mail. You can select one or more options at once.
- Contact ID & External ID: all Contacts within the DMS are assigned a unique Contact ID while if you imported historic Contacts from a former database, you may use the External ID field to search for Contacts based on their corresponding unique External IDs from your former system.
- You may enter partial information in the Street Address and Postal Code fields to retrieve data about your Contacts’ locations.
- If searching for Contacts within one or more Provinces, you must first set the Country before the list of Provinces can be selected.
- Select the desired Province(s)
- If you want to specify a region, you can select the City dropdown and select one or multiple locations from the list of Canadian towns and cities
- Email Consent: legacy field not being used at this time.
- Summary Fields: useful if you are seeking a list of Contacts based on their giving history within a set range.
– You can also use the first field to simply enter $500 and that will return all Contacts whose total lifetime Contributions are $500 and over.
- Contacts with Activities can be retrieved by Type, Priority, or text included in the Details of the Activity.
- You can also search for Activities based on Contact > ‘With’, ‘Assigned to’ or ‘Assigned by’. Then enter the name of the Contact or DMS User in the Name search field under the Contacts section.
- If you wish to view Activities themselves, go to Display Settings, change the Results from Contacts to Activities and refresh your search.
- Contacts with Relationships can be retrieved by Relationship Type (multi-select), Date or Status.
- If searching for all Contacts with a Relationship to a particular Contact, enter the name of that Contact in the Target Contact field.
- From the dropdown, select “Yes” in the ‘Contact is deceased’ box if seeking a list of Contacts that have been marked deceased. Select “No” to exclude those Contacts from the list
- If you’re seeking Contacts that have specific notes in their Profile, enter partial text that would be found in the Note (either by the Subject or Body of the Note).
- Retrieves Contacts based on which User of the DMS has modified them or their Last Modified Date.
The Contribution fields will retrieve Contacts based on their Contribution history. Below are some commonly selected fields.
- To search for Contacts that have made Contributions within a specific date range, use the Date Received field.
- You can apply a range of amounts that Contacts have given un Contribution Amounts
- If seeking Contacts who have made Contributions to any Campaign, Fund, or GL Account, select one or many values.
- Search by whether or not Contacts have received a Receipt or Thank You by selecting Yes, No or Any from the dropdown
- If you’re looking Contacts with recurring contributions (e.g. monthly donors) select the Is Contribution Recurring box. If you’re seeking recent monthly donors, you may wish to apply a Date Received to this search (e.g. Current Year).
- Dedication fields: if you wish to retrieve Contacts who have made Contributions In Honour or In Memory, apply the Yes option to the Dedication fields.
- Any Contact associated with Opportunities can be retrieved using the Opportunities fields.