We have a few operational daily campaigns which send the same email (but has dynamic email scripting based on a custom object). We export all Email activity data via a static list every 3 hours but noticed there is no unique send key that persists through each activity row. Meaning, if Fred Flintstone received the same email Monday, Tuesday, Wednesday--but only opened 1 of the 3 sends, we wouldn't know which day's send Fred opened.
Has anyone else faced this or know of a persistent key we can pull through the API?
If you're doing an export via API, you can do this by using the Campaign Run ID that returns with activities_click_email; the trick is going to be reconciling the Campaign Run ID to the date sent. I've been getting around this lately by having a record that always opens or clicks automatically on the send date and using that as a master key of "on this date of the send, the Campaign Run ID was x".