To query on constituents who gave to a specific campaign:

  1. Create a constituent query.
  2. On the Criteria tab, select Gifts, Campaigns, Campaign ID equals [the campaign].


To query on gifts to a specific campaign:

  1. Create a gift query.
  2. On the Criteria tab, select Campaigns, Campaign ID equals [the campaign].


To query on constituents who have given to only one campaign:

  1. Create a constituent query (Query A) and filter on Gifts, Campaigns, Description one of [the specific campaigns].
  2. Create a constituent query (Query B) and filter on Gifts, Campaigns, Description one of [all other campaigns].
  3. Merge the queries with Query A as the primary, Query B as the secondary, and use SUB as the operator.

Note: This includes constituents who have gifts to one or more of the selected campaigns but have never given to any other campaigns. It does not include constituents whose only gift(s) has a blank campaign.

Note: Use equals/does not equal as the operator if selecting only one campaign.

For example, if you are querying on constituents who have given to the Annual Campaign and the Capital Campaign but no other campaign:

  1. Create a constituent query (Query A) and filter on Gifts, Campaigns, Description one of Annual Campaign, Capital Campaign.
  2. Create a constituent query (Query B) and filter on Gifts, Campaigns, Description one of [select all other campaigns in the list].
  3. Merge the queries with Query A as the Primary, Query B as the secondary, and use SUB as the operator.
 

To query on constituents who gave to one specific campaign and to any other campaign:

  1. Create a constituent query (Query A) and filter on Gifts, Campaign Description equals [the name of the campaign].
  2. Create another constituent query (Query B) and filter on Last gift, Campaign description one of [all of the campaigns except the one used in step 1]
  3. Merge the queries using the AND operator. The order of the queries does not matter.
 

To query on constituents who gave to one specific campaign but not to another specific campaign:

  1. Create a constituent query.
  2. On the Criteria tab, select:

    Summary Information*, Summary for Gift, Total Number of gifts Greater than or equal to 1. On the Filters tab, select:

    Campaigns, Campaign ID equals [campaign].

    AND Summary Information*, Summary for Gift, Total Number of gifts Equals 0.
    On the Filters tab, select:

    Campaigns, Campaign ID One Of [campaigns].

    * For more information on selecting and filtering Summary Information fields in query, refer to BB237530.

Note: If you want to find constituents who gave to an campaign last year but not this year, run the LYBUNT report.