The Query Builder allows you to slice and dice your data directly within GC Volunteer Management. With it, administrators can define specific groups of constituents, gifts, or volunteers based on a variety of characteristics.
You may use the Query Builder while creating:
This article explains the core functionality of the Query Builder tool, while the articles linked above show it in action.
Key Terminology
Condition - criteria used to define segments of constituents, gifts or volunteers. The available conditions vary based on where you're using a Query Builder as well as what data you send to GiveCampus.
Groups - combinations of conditions that can include or exclude larger or more specific segments.
An example of a query not using groups:
The result of the above would be a segment of constituents that contains all parents, all alumni, all of 2024 and all of 1980.
An example of a query using groups:
The results are now much more precise, in that the constituent group would include only Alumni with a year of 1980 and Parents with a year of 2024.
Groups are a fantastic tool for combining many different conditions without needing to create a different query for each related condition.
And/Or - Within Query Builder, there are two different types of logic that you can apply to combine conditions “And” or “Or”. In Query Builder, these read as “At least one condition must be met”, which is the “Or” logic; and as “All conditions must be met”, which is the “And” logic.
Generally, an “All conditions must be met” will return a narrower pool of constituents or volunteers while “Any of the conditions must be met” will return a broader group of constituents or volunteers.
An example using the "All conditions must be met" (And) logic:
To appear in this group, the constituent must both be an alumnus/a AND be in the Class of 1980.
The same example, using the “At least one condition must be met” (Or) logic:
This query would return all alumni and all members of the class of 1980, but no one else.
For more on the using the Query Builder for specific functions, continue to these other GCU articles:
Comments
0 comments
Article is closed for comments.