Capture the last time an email was opened

Capture the last time an email was opened

Hi,

 

I have a conundrum…

I want to be able to parse the Last opened date and time from Campaigns and have this populate a field within the CRM whenever this has occurred e.g Last Email Opened Date 01/01/2022 and updated with 13/09/2022 as they opened the email today.

I am unable to find any field to pull off from the API, workflow or even webhooks – so I am stuck somewhat and want to be able to record the last opened date specifically.

Would this be able to done by member status within the campaigns module e.g whenever Member status is changed on any campaign to opened it updates a field within the contacts module with the execution time ?

I have sent this to support, but thought I may get more answers or workaround using the forum :)