Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
NetSuite has launched SuiteSuccess Wholesale Distribution Edition, in Japan. Please join us the webinar on February 12 that introduces NetSuite solution with demos and case studies for Wholesale Industry.
Register Now
Saved Search Summary for Contact Vs Campaign Response Vs Event
We would like to create a saved search of summarized counts based on contacts the purpose of this is to see any campaign responses a contact may have and any events (meetings) that have been subsequently created to see the relationship between response and meeting.
The structure of the saved search then would be the following
Response Name (i.e. October Mailing)
Number of Respondents (i.e. Number of contacts linked to that Mailing)
Number of Events (i.e. Number of meetings that have subsequently been subsequently booked - This requires event.createddate to be greater than campaignresponse.responsedate
I have tried to create this and am halfway there but keep hitting a brick wall in terms of counts as it seems to be counting the same contact a number of times depending on number of events that have been created against them.