Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
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. 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.