Download - Conquer Your Queries
![Page 1: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/1.jpg)
Conquer Your Querieswith Luminate Online™ CHELSEA DEROCHÉ
![Page 2: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/2.jpg)
#bbcon#Interactive
#LuminateOnline#ChelseaDeRoche
Tweet this now
2 #bbcon
![Page 3: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/3.jpg)
Agenda
• Overview of queries in Luminate Online• Create a simple query• Create a time-frame query• Review • Summary
3 #bbcon
![Page 4: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/4.jpg)
Overview
4 #bbcon
How do I segment constituents based on location, interests, or
other criteria?
![Page 5: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/5.jpg)
Overview
You can use queries to target specific constituents.
5 #bbcon
![Page 6: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/6.jpg)
When Should I Use Query?
• You need to identify sets of constituents who share specific characteristics, such as “lives in Texas” or “joined our organization in the past week.”
• You need to be able to refresh the groups so they always include the most current group of constituents who match the characteristics.
• There is not an existing Constituent360 group or Report that will identify the constituents.
6 #bbcon
![Page 7: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/7.jpg)
When Should I Use Query?
7 #bbcon
Who are the people that live in
Texas and donated over $100 within
the past 30 days?
Who donated to our annual
membership campaign?
![Page 8: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/8.jpg)
Query vs. Report
8 #bbcon
Query Report
Generates a list of constituent records that meet specified criteria.
Generates various types of information based on fields and filters selected, not just constituent records.
Does not allow users to choose fields for output.
Allows users to select and rename output fields.
Does not include a scheduling option. Includes options for scheduling the report to run at a specific time or a specific frequency.
Can output results to a group or a mail merge.
Can output results as a constituent group (if applicable), CSV file, PDF file, HTML file, and/or printed document.
Supports automatic rebuilding of groups. Supports the addition of results to an existing or new group.
![Page 9: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/9.jpg)
A Simple Query
9 #bbcon
![Page 10: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/10.jpg)
Query: Lifetime Donors $1,000 or More
10 #bbcon
I need to find all of my Texas donors who have given $1,000 or more.
![Page 11: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/11.jpg)
Query Workflow
11 #bbcon
![Page 12: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/12.jpg)
Query List Tab
12 #bbcon
![Page 13: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/13.jpg)
Query Info Tab
13 #bbcon
![Page 14: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/14.jpg)
Steps to Start Creating a Query
1 On the Data Management menu, click Query.
2 On the Query List tab, click Create a new Query.
3 On the Query Info tab, enter a name and description, and then select asecurity category.
4 Click Save.
14 #bbcon
![Page 15: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/15.jpg)
PracticeYou want to create a query to find all Texas constituents who have given over $1,000.• Enter the following name: <My Last Name> Texas Constituents
Lifetime Giving Over $1,000.• Enter the following description: All donors who live in Texas
and have given a total of $1,000 or more.• Restrict the query to administrators.
15 #bbcon
![Page 16: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/16.jpg)
Query Builder Tab
16 #bbcon
![Page 17: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/17.jpg)
Types of Query Clauses• Field Clause
• Information in a constituent record• EX: State/Province, Origin Application Type, Last Transaction Amount
• Group Clause• Members of specified groups• EX: Interest Opt-In Groups, Donor Groups, Event Attendees Groups
• Interaction Clause• A specific interaction logged on a constituent record• EX: specific Survey Submitted, Sustaining Gift Payment Failed,
eCommerce Purchased from specific store
17 #bbcon
![Page 18: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/18.jpg)
Types of Query Clauses (Optional)• Action Alert Clause
• Available to organizations that have the Advocacy module enabled.• Filters by records that are eligible to participate in a specified action alert.• Lists only currently active Action Alerts.
• Center Opt-in Clause• Available to organizations that have the MultiCenter module enabled.• Filters by records in specified Center(s).• Lists only currently active Centers.
18 #bbcon
![Page 19: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/19.jpg)
Query Operations - AND
19 #bbcon
![Page 20: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/20.jpg)
Query Operations - OR
OR
20 #bbcon
![Page 21: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/21.jpg)
Query Operations - Parentheses
21 #bbcon
![Page 22: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/22.jpg)
Query Operations - Parentheses
22 #bbcon
![Page 23: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/23.jpg)
Query Operations - Parentheses
23 #bbcon
( )
![Page 24: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/24.jpg)
Steps to Define Field-Based Query Criteria
1 Click the Query Builder tab.
2 In the Field Type list, select the relevant field type.
3 In the Field list, select the appropriate field.
4 Click Add Field Clause. A window appears.
5 Select a query operator.
6 Select or enter a value.
7 Click Save.
8 Repeat steps 1 through 7 for each criterion you want to add to the query.
9 Join the clauses with OR or AND, and group clauses with parentheses as needed.
10 Click Save Query.
24 #bbcon
![Page 25: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/25.jpg)
PracticeAdd two field clauses to the query you created. Verify the clauses are linked with AND.• Field clause: Include donors whose Lifetime Giving Amount
(found under Transaction Information) is greater than or equal to $1,000.
• Field clause: Include donors whose State/Province Home Address is Texas.
25 #bbcon
![Page 26: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/26.jpg)
Results Tab
26 #bbcon
![Page 27: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/27.jpg)
Group Information Tab
27 #bbcon
![Page 28: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/28.jpg)
Steps to View the Query Results and Create a Group
1 Click Run Query.
2 On the Results tab, review the list of records to confirm that the correctrecords are included.
3 Click Use Query. A window appears.
4 Click Create a Group.
5 Click Go.
6 On the Group Information tab, determine the group name anddescription.
7 Select the security mode, security category, and group type.
8 Define settings for group rebuilding.
9 Click Save. A confirmation message and the Members tab appear.
28 #bbcon
![Page 29: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/29.jpg)
PracticeView the query results and create a group.• Run the query.• Create a group from the query results.• Accept the default settings.• Select Donors as the group type.• Rebuild the group once a year.
29 #bbcon
![Page 30: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/30.jpg)
Rebuilding a Query-Based Group
Texas $1,000 or More Donors
Moved to Texas
30 #bbcon
Moved from Texas
![Page 31: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/31.jpg)
Time-Frame Query
31 #bbcon
![Page 32: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/32.jpg)
Query: New Constituents
32 #bbcon
I need to find all constituents who joined in the last
week.
![Page 33: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/33.jpg)
Defining the Creation Time Frame
33 #bbcon
![Page 34: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/34.jpg)
Defining the Creation Time Frame
34 #bbcon
![Page 35: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/35.jpg)
Defining the Creation Time Frame
35 #bbcon
![Page 36: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/36.jpg)
Practice
Create a query to find constituents added to Luminate Online in the past 1 to 7 days.• Enter the following name: <My Last Name_First Name> New
Constituents - 1 week or less.• Enter the following description: Constituent records added in
past 7 days.• Restrict the query to administrators.• Field Clause: Include constituents added to the database on
or before 1 day prior to the current date.• Field Clause: Include constituents added to the database on
or after 7 days prior to the current date.• Link Clauses: AND.
36 #bbcon
![Page 37: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/37.jpg)
Excluding Constituents with a Suppression Group
37 #bbcon
Welcome Series Suppression
Group
I need to exclude constituents who have been involved with my organization for a long time, but just gave me their email address.
![Page 38: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/38.jpg)
Practice
Create a query to find constituents added to Luminate Online in the past 1 to 7 days.• Group Clause: Exclude constituents who are in the Welcome
Series Suppression Group.• Link Clauses: AND.• Run the query.• Create a group from the query results.• Accept the default settings.• Select Welcome Series as the group type.• Rebuild the group once a year.
38 #bbcon
![Page 39: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/39.jpg)
Discussion
How would you create this query:
A. Constituents who live in Texas, have given $1,000 or more total, and have purchased something via eCommerce?
39 #bbcon
![Page 40: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/40.jpg)
Discussion
How would you create this query:
B. People with credit cards expiring at the end of this month (card expires after tomorrow but before 30 days from today)?
40 #bbcon
![Page 41: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/41.jpg)
Discussion
How would you create this query:
C. LYBUNT constituents (those whose last donation is between 24 and 12 months ago)?
41 #bbcon
![Page 42: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/42.jpg)
Summary
• Overview of queries in Luminate Online• Segments constituent records by criteria.• Allows for creation of rebuildable groups.
• Create a simple query• Enter the query information.• Add clauses to the query to define criteria.• Run the query.
• Create a time-frame query• Add one clause going forward in time and one clause going backwards in
time.• Add suppression group(s), if desired.
42 #bbcon
![Page 43: Conquer Your Queries](https://reader035.vdocuments.us/reader035/viewer/2022081506/557c3debd8b42a28208b5055/html5/thumbnails/43.jpg)
Don’t forget to complete a session survey! Each completed survey enters you into a drawing to win a complimentary registration to bbcon 2015 in Austin, Texas*.
*Blackbaud reserves the right to change or withdraw this promotion at any time, without advance notice. Promotion has no cash value and may not be exchanged, applied to, or combined with any other offer.
Was this session the reboot you needed?
43 #bbcon