Click Here to view this article as a PDF.
Author: Kristenson, Joel
Last Updated: 2017-06-09
Overview
This article is primarily for nonprofits, but the techniques used are good for all Trail Blazer users to learn. It walks through the steps to create search queries that target new (first time) donors this month, and this year.
After you finish creating these types of reports (or other reports that you run often) you can add them onto your dashboard, here's how.
Tip: Read this article to learn how to create a popular query for donors who gave last year but unfortunately not this year (LYBUNT). Read this article to learn how to build and save a custom report with virtual filtered columns that goes hand-in-hand with the LYBUNT search query.
Steps – New Donors This Month
Open the Contacts (Donors) list.
Navigate to the Contribute tab, plug it in, select This Month from the date range drop-down, and click [Search]. In my example it produced 28 donors.
Expand the Advanced Functions Tool Strip under the Contribute tab and select the [&] button to add a SQL ‘AND’ statement.
Activate the sql NOT condition, set the ‘end date’ for one day prior to the 1st day of the month you searched for donors ‘in’, and click [Search]. In my example the end date was the last day of April, 2017 and the query returned 15 results for new donors this month.
The next section will show how to find new donors this year. Take a look at the related resources at the bottom of the article to find other useful articles and videos related to this topic.
Steps – New Donors This Year
Open the Contacts (Donors) list.
Navigate to the Contribute tab, plug it in, select This Year from the date range control, and click [Search]. In my example it produced 38 donors.
Click the [&] button on the Advanced Functions tool strip under the Contribute tab to add a sql AND statement.
Under the new Contribute tab that opens, activate the [NOT] condition, set an end date that’s one day prior to the start of the year you searched for donors ‘in’, and click [Search]. In my example I set an end date of 12/31/16 and the final query results were 20 new donors this year.
Take a look at the related resources below for links to other articles and videos related to this topic.
Related Resources
Article: How to Create a Year-by-Year Giving History Report using Filtered Contribution Columns in the Grid – Primarily for Nonprofits
Article: How to Create a Donor LYBUNT Search Query (Donors Who Gave Last Year But Unfortunately Not This Year) and How to Save it as a Search Favorite
Article: Save and Load a Search Query as a (Dynamic) Search Favorite
Article: How to Use the New Dashboard Features – Adding Graphs and Metrics with Drag-and-Drop
Article: Building a Search Query for ‘First Time Donors’ THIS Year – Save and Load it as a Favorite & Add it to your Dashboard
Article: How to Delete or Rename a Saved Search Favorite (Query)
Video: Getting Started 104 Queries with wildcards
Video: Filter Using New Date Controls
Video: Getting Started 102 Beginning Queries - Nonprofit
Video: Reporting 102 – Quick Reports and Export
Video: Getting Started 105 – Queries with an AND condition
Video: Getting Started 101 – Orientation to the screen
Trail Blazer Live Support
Phone: 1-866-909-8700
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.
