1 Reply Latest reply on Oct 10, 2018 10:21 AM by Courtney Grimes

    Activity API Persistent Send Key

    Wyatt Bales

      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?

        • Re: Activity API Persistent Send Key
          Courtney Grimes

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