Pull Up Customers who Did Not Open a Campaign Email through a Campaign Saved Search

Currently, NetSuite does not use Boolean behavior when running criteria on a sublist. Take the following as an example:

Campaign: NS Campaign 2014
Recipients: Lead A & Lead B
Campaign Response:

    - Lead A: Queued
    - Lead A: Sent
    - Lead B: Queued
    - Lead B: Sent
    - Lead B: Opened

If you use the Criteria, Campaign Response: Response is not Opened, it would return Lead A and Lead B because Lead B has an entry where the Response is not Opened (Queued & Sent) which matched the Criteria.

In order to resolve the issue, you can create a saved search with the following criteria:

1. Navigate to Lists > Search > Saved Searches > New > Campaign.

2. In the Criteria tab > Summary, set the following:

Summary Type	Field	Description	Formula
Sum	Formula (Numeric)	is 0	Case When {response} = 'Opened' Then 1 ELSE 0 END

 

 

4. In the Results tab > Columns, set the following:

Field	Summary Type	Formula
Campaign ID	Group
Title	Group
Campaign Recipient: Name	Group
Campaign Recipient: Email	Group
Formula (Numeric)	Sum	Case When {response} = 'Opened' Then 1 ELSE 0 END

 

5. Click Save & Run. Verify if the list returns the correct records.