Discussions
Registration opens June 9. Be ready when passes drop. Get the green light now - Convince your boss
Contact Saved Search. Filter contacts who have never Opened or Clicked Through any email campaign
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?