Is it possible to update campaign member status for salesforce list emails,(for eg-update status to "email open" if list email was opened), how can i do it with process builder?
It is tricky and only possible in a scheduled APEX class because you cannot set a trigger on the EMailStatus object. What you can do is to write a job which does the following: - SELECT Id,(SELECT Id,FirstOpenDate,TaskID FROM EmailStatuses) FROM Contact - you may want to filter on contacts in a campaign or other reasonable filters - run through the list and find the EMailStatuses where taskID.whoID matches the list email sent to the campaign - when FirstOpenDate is set update the campaign member status
The feature you are requesting is still in Idea face,
https://trailblazer.salesforce.com/ideaView?id=0873A0000003VF6QAM
Vote it so that it can be implemented in the future.
Check this Idea too (https://trailblazer.salesforce.com/ideaView?id=08730000000XhJkAAK).
Let me know if it helps you and close your query by marking it as solved so that it can help others in the future.
Thanks.
- SELECT Id,(SELECT Id,FirstOpenDate,TaskID FROM EmailStatuses) FROM Contact
- you may want to filter on contacts in a campaign or other reasonable filters
- run through the list and find the EMailStatuses where taskID.whoID matches the list email sent to the campaign
- when FirstOpenDate is set update the campaign member status
Run this job once a day.