I am adding my data to another database and require a 'last transaction date' for each user. This would be the most recent interaction the person had with one of our marketing campaigns. Could be actions like clicking through an email, registering or attending an event, or filling out a form.
Unfortunately 'updated date' won't work because that could have been triggered by an internal event and not necessarily the individual in question taking action. Ideally, I would like to set up some campaign where if 'clicked email' is true, then it would populate the transaction field with the date of their most recently clicked link, and so on.
I would probably also need to know how to sort through which of the actions is the most recent. For example, if one person had clicked email and attended event, I would want to be able to evaluate the date for both of the fields that I have created and then determine which is the most recent and populate that into a fourth field.
Any suggestions would be apprciated, maybe I can approach it a different way. Ultimately, I need to be able to take the date information of an activity and populate it into a field.