Wednesday, September 19, 2018

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:


Summary Type


Summary Label





Formula (Numeric)


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


     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.


No comments:

Post a Comment