Trail Blazer Knowledge Base

 

Home : Queries : How to Create a Donor LYBUNT Search Query (Donors Who Gave Last Year But Unfortunately Not This Year) and How to Save and Load it as a Search Favorite

Knowledge Base







User:

Password:



Article ID: KB195
Keyword Name: Advanced Function, Tool Strip, Query, LYBUNT, Target,sybunt
Created: February 15, 2017
Viewed: 25567

How to Create a Donor LYBUNT Search Query (Donors Who Gave Last Year But Unfortunately Not This Year) and How to Save and Load it as a Search Favorite




Click Here to view this article as a PDF.






Author: Joel Kristenson

Last Updated: 2016-03-24






Overview


This article will teach you how to save an advanced search query as a favorite and re-load it again.  It’s useful to store queries you run often to save time, and improve consistency in the future.  Saved queries are dynamic so as soon as the data changes, the search results will change accordingly.  Saved queries are stored in the “Cloud”, accessible by any of the database users.


IMPORTANT: Saved queries only reside within the search window you build them in (ex: if you save a search in the ‘Contacts/Voters/Donors’ list it will only be available in that list vs other lists such as Households/Contributions/Etc.)



http://www.us-cert.gov/sites/default/files/images/tip-icon.pngTip: Use the Ctrl+F hot key to jump to different sections of this article (example: “#1”, “#2” or “Related Resources”.




Outline

#1 – Steps to Create an Advanced “LYBUNT” Donor Query

#2 – Save and Load your Search Query as a ‘Favorite’

#3 – Related Resources






#1 – Steps to Create an Advanced “LYBUNT” Donor Query



http://www.us-cert.gov/sites/default/files/images/tip-icon.pngTip:  LYBUNT and SYBUNT queries are extremely useful to solicit lapsed donors.



First, navigate to the Contacts (Donors/Voters) list under the Application Menu.



Navigate to the Contribute tab, [Plug] it in the tab to activate it, select Last Year from the date range drop-down, and then click [Search] to execute the query.


IMPORTANT:  If you’re running on a cycle that’s different than a calendar year you’ll need to enter those date ranges vs selecting them from the date range drop-down.


In my example I also select ‘just individuals’ from the General tab, if you don’t want to do that it will include both individuals as well as companies.



If your record count is over 1k, select the ‘all’ radio button, and click [OK]In my example the query produced 3,029 donors who gave last year.  If the record count is under 1k it will auto-populate.



Expand the Advanced Functions tool strip by clicking the circular blue button, and then click the orange [&] button to add an SQL ‘AND’ statement.  This will add a new search sub-tab also called ‘Contribute’.



In the new sub-tab that opens select ‘This Year’ from the date range drop-down, and then click on the ‘NOT’ condition to activate it.  Once the ‘NOT’ button is clicked it will turn from a little green + into a red x.



Click [Search] to refresh your query results and load ‘all’ if the list is over 1k.  You could build the entire query without ever clicking [Search] in-between but it’s usually beneficial to see the record counts change as new search criteria is added.



Once the records are populated you may want to verify the query results by building a filtered contribution (giving history) format to display how much your donors have given year-by-year.








#2 – Save and Load your Search Query as a ‘Search Favorite’


Now that the advanced query has been created you may want to save it so that it can be reused in the future.


First, click on the topmost [Advanced Function] to expand the Advanced Function tool strip.  This is always located directly below the [Search] button as shown in the image below.



Click the [Save] button which looks like a blue floppy disc.  This will allow you to save the query as a search favorite.



Give the saved search a descriptive name that any other user could easily distinguish.  When you or another user loads the query again it won’t show you what search criteria is included (unless you are fluent at reading SQL) so it’s important to be as descriptive as possible.


Click [Save] to complete the process.  In this example I called my saved favorite “LYBUNT (Last Year But Unfortunately Not This)”.



That completes the steps to save your search.


To load the saved favorite navigate to the Contacts (Donors/Voters) list, click on the ‘Favorites’ tab, check the box next to the query you saved, and click [Search].




http://www.us-cert.gov/sites/default/files/images/tip-icon.pngTip:  You have the ability to rename and delete saved queries, for more information checkout the related resources below.















#3 – Related Resources


Article: Creating Formats for Custom Views and Editing of Your Data

Article: How to Create a Year-by-Year Giving History Report Using Filtered Contribution Columns in the Grid – Primarily for Nonprofits

Article: Creating Formats

Article: Delete Saved Search Queries

Article: Advanced Queries – the SQL Tab

Article: How to Mass Update a List of Contacts with an Attribute Item

Video: Filtered Contribution Columns in Format

Video: Reporting 104 – Joined tables

Video: Formatting the Grid

Video: Reporting 102 – Quick Reports and Export

Video: Attributes – Add attribute dates and notes to your lists

Video: Filter Using New Date Controls

Video: Search – Contribution AndOr (donated in 1 time period but not another)






Trail Blazer Live Support

http://www.somebodysattic.org/images/phone%20icon_lower%20rez.jpg  Phone:  1-866-909-8700

http://sisyphus-js.herokuapp.com/assets/email_icon-0f32f4da45c2822cbb02fb36f9b9429e.png   Email:  support@trailblz.com

   Facebook: https://www.facebook.com/pages/Trail-Blazer-Software/64872951180

   Twitter: https://twitter.com/trailblazersoft



* As a policy we require that you have taken our intro training class before calling or emailing our live support team.

Click here to view our calendar for upcoming classes and events.  Feel free to sign up other members on your team for the same training.


* After registering you’ll receive a confirmation email with the instructions for how to log into the GoToMeeting session where we host our live interactive trainings.


* This service is included in your contract.



 

Are you ready to learn more? Contact Us