Skip to main content
Queries let you answer precise questions about your data—“households in Oregon who gave over $100 last year,” “individuals with no email on file,” and so on. Open Queries in the sidebar.

​
Pick what you’re looking for

Start by choosing the result mode—what each row in your results represents:
Switching modes clears your current conditions and results, since each mode has its own set of fields.

​
Build the conditions

1

Add a condition

Each condition is a field, an operator, and a value—for example, State / is one of / CA, OR, WA.
2

Combine with AND / OR

Set the group logic: AND requires every condition; OR matches any. You can nest groups for more complex logic.
3

Execute

Choose Execute, then pick which fields (columns) to show in your results.
4

Save (optional)

Choose Save, name the query, and optionally share it with your team.

​
The kinds of filters

Fields span contact info, the people in a household, contact methods (email/phone and opt-in status), addresses (down to congressional district), tags, and giving. Operators adapt to the field—text supports contains and starts with; numbers and currency support greater than and between; dates support in the last N days; tags support has tag and doesn’t have tag.

​
Saved queries

The Saved queries tab lists everything you’ve saved. Filter by search, result mode, and ownership; click any query to load it back into the builder to run, adjust, or remove.
A query is the fastest way to build a one-time list. If you want an audience that keeps itself current for email, build a segment instead.