Discussions
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
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?