Activity API Persistent Send Key

Wyatt_Bales4
Level 4

Activity API Persistent Send Key

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?

1 REPLY 1
Casey_Grimes
Level 10

Re: Activity API Persistent Send Key

Hi Wyatt,

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".