Display Most Recent Campaign Response Through Saved Search

There is currently no standard field that displays the most recent campaign response. As an alternate solution, a saved search can be run with below formula:

max(to_char(substr({response},1,3900)))keep(dense_rank last order by {responsedate}, decode({response}, 'Queued', 1,'Sent', 2, 'Opened', 3, 4))

To create the saved search:

1. Navigate to Lists > Search > Saved Searches > New.
2. Select Campaign.
3. Provide a search title.
4. Under Criteria tab, enter the required filters (e.g. Campaign ID).
5. Under Results tab, add the following:

Field	Summary Type	Formula
Campaign Recipient Fields… > Email	Group
Formula (Text)	Maximum	max(to_char(substr({response},1,3900))) keep(dense_rank last order by {responsedate}, decode({response}, 'Queued', 1, 'Sent', 2, 'Opened', 3, 4))

6. Click Save & Run.