How to use Search Builder

How to use Search Builder

Search Builder lets you search for contacts based on any criteria in the database, such as contact type and donation information.



In this example, we'll look at creating a mailing list for a holiday campaign. We'll send solicitation letters to anyone who has donated in the past year, or attended your fall fundraiser, but not board members. Our criteria are:
1. has donated in the past year, or
2. has attended the fall fundraiser, and
3. is not a board member.

Start by creating a new search criterion or by clicking New Criterion in the top left.





First we'll find the people who donated in the last year, so we can name this criterion “donated in the last year.” In search builder, criterion names are optional, but are often convenient to help you remember the structure of your search.



To find those contacts, choose the Criterion Type of "Donation: made donations matching assorted criteria."

 

Now you can define all the criteria for your donation search. For this example, let’s choose the Time Period, Prior 366 days, to find contacts who donated in the past year.



Click OK to save this criterion. A box appears which represents all the contacts who donated in the past year. Click Search, and Sumac performs the search, showing how many contacts are represented by this criterion.



Next, we want a search criterion to find contacts who attended our fall fundraiser. Click New Criterion to create the next search. Name this search “Attended Fall Fundraiser.”



Attendance is tracked using Communication records, so choose the Criterion Type of "Communication: contact sent/received a communication matching assorted criteria."


Choose the Event: Fall Fundraiser and Choose type of communication: Attended event. Click OK.


Move the second criterion next to the Donation search.



Finally, make a New Criterion to exclude Board Members. Click New Criterion. Name this search “Not Board Members.” 



Choose Criterion: Contact Type and select Contact Type: Board Member.

This will find all the contacts who are board members, but we want to find all those who are not board members. Every search criterion in Search Builder has a check box to reverse it. Check Reverse the search to tell Sumac to find everyone who is not a Board Member.



Next, connect these individual searches. Select the Donation and Communication search criteria (Ctrl+Click) and click New Connector.



For this example, choose the OR connector, since we want to find contacts who donated in the past year, or attended the Fall Fundraiser.



When you click OK, Sumac creates a new box, which represents a list of contacts who either donated in the last year, or attended the fall fundraiser.



To exclude the Board Members, select the Board Member criterion, and the connector. Click New Connector.



This time choose AND, because we're looking for contacts who either donated or attended AND are not Board Members.



This new box represents contacts who have either donated or attended the event, but are not board members.



Click Search at the bottom, and Sumac performs all the searches and shows how many contacts are represented by each criterion.



You can save searches built in Search Builder as a Group in your database, which is very useful if you want to run the search regularly.

To save your search, Click Save Search Builder at the bottom of the window:


Then save the search as a new Search Builder Group by choosing the Group Type, providing a description, and clicking Save.


Sumac saves the search criteria. It does not save the list of contacts. Each time you use the saved search builder group, Sumac re-does all the searching to produce a list of contacts that is correct at that moment. Next year, if you use the search again, it will probably produce a different list of contacts.

Now that we've found the contacts we want to solicit, select the final criterion that represents that list of contacts, and click the Show Contacts button.



Sumac opens the contact list with 363 Contacts for our example.




In order to load a saved Search Builder criteria group, click Load at the bottom of the Search Builder window, and select the necessary group.





Search Builder groups can also be loaded as a search criterion in the Advanced search panel of any area in Sumac:





    Our products got an upgrade!



    Some screenshots and help videos have been made using older versions of our products. Though your version's colours and themes may appear different than what you see here, the instructions, links and advice in this article are still accurate and useful!


      • Related Articles

      • Using Search Builder to find all contacts who might be linked to the same membership record

        When trying to find contacts who have memberships matching assorted criteria, you can use Search Builder to find contacts who are listed in the Member field, or the Member 2, 3, 4, 5, 6 or Billing Contact fields of their corresponding membership ...
      • Which Connector Should I use in Search Builder?

        Here’s a picture to help you understand the connector you need to use to find what you want. Example Criteria Suppose Criterion 1 is: Has a Beard Suppose Criterion 2 is: Wears Glasses Results Here are the results you will get for each connector: AND ...
      • How to build a custom contact list using List Builder

        List Builder lets you build a list of specific contacts by dragging and dropping them into the List Builder Window.  You can search across different areas of Sumac CRM, compile those results in one list, and then take advantage of the tools in the ...
      • Searching in list using multiple search criteria

        Searching Donations On the Sumac Dashboard, expand Fundraising and click Donations. The search area always appears at the top of a list. The Search Type menu in the Donations list holds search criteria that relate to donations, such as when donations ...
      • Searching in list: Tips and Troubleshooting

        If you run a search in Sumac and get some unexpected results, review your search criteria to ensure that they are correct, and reflect on what you're trying to find. Common reasons for unexpected search results Search criteria are not specific ...
      Societ Academy

      Learn what you need to know, any time. Free!



      • High quality training on demand - sessions are available every day, so you can access training that fits into your schedule.
      • Training sessions that are easy to follow - helpful tips throughout each session, and access to training moderators ensure your questions get answered.
      • A certificate of completion - you can request a certificate of completion for every session you attend.