Trail Blazer Knowledge Base

 

Home : Queries : Search Query - New Donors This Month, and This Year (Primarily for Nonprofits)

Knowledge Base







User:

Password:



Article ID: KB1376
Keyword Name: New, Donor, This Year, Month, First Time, Query, Search, Report
Created: June 09, 2017
Viewed: 11122

Search Query - New Donors This Month, and This Year (Primarily for Nonprofits)




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.



http://www.us-cert.gov/sites/default/files/images/tip-icon.pngTip: 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


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