Search All Customers Who Did Not Receive an Email Campaign

A campaign or customer (or whatever the target group type was used for the campaign) saved search can be used for this. To create the search perform the following steps:

     1. Navigate to Lists > Search > Saved Searches > New.
     
     2. Select a Type (e.g. Customer).
     
     3. Provide a Search Title.
     
     4. In the Criteria tab > Standard subtab, add the filter Campaign Response Fields: Internal ID is [ID of the Campaign].
     
     Note: If ID is not available use the Campaign Title field instead.
     
     5. In the Results tab > Columns subtab, set the following:

Field	Summary Type	Formula	Summary Label
Name	Group
Formula (Numeric)	Count	CASE WHEN {campaignresponse.response} = 'Failed - invalid Address' OR {campaignresponse.response} = 'Failed - content spam' OR {campaignresponse.response} = 'Failed - delivery failure' OR {campaignresponse.response} = 'Failed - other' THEN 1 ELSE 0 END	Received

     6. Click Save and Run.
     

Note: The formula above returns the value of 1 for every campaign response equal to Failed - invalid Address, Failed - content spam, Failed - delivery failure or Failed - other. The formula field is then summed per customer. If the sum is equal to 1 then the customer has a Failed campaign response.