Hello! I need a Contact saved search that returns only contacts who have never Opened or Clicked Through any of my email campaigns. I created a Contact saved search with a Summary criteria using this formula: case when {campaignresponse.response} = 'Opened' or {campaignresponse.response} = 'Clicked Through' then 1 else 0 end (Summary Type: Sum, condition equal to 0.)
This correctly excludes contacts who have Opened responses. However it does NOT exclude contacts who have Clicked Through responses, even though "Clicked Through" is visible on their contact record under the Campaigns subtab.
In a Contact saved search, {campaignresponse.response} only returns Sent and Queued values , it never returns Opened or Clicked Through even when those responses exist on the contact record. What is the correct field ID to access engagement responses (Opened, Clicked Through) in a Contact saved search formula?
Or is there a different approach to achieve this?
Thank you!