0

I need to bring Triggered Send Name (available in Journey tracking) to Data Extension - preferably send log; for the purpose of updating Sales Cloud IER object. I haven't found any field in data views connected with that name. Are you able to help? enter image description here

Improve this question
1
  • You'd need to use the SOAP API's TriggeredSendDefintion object or the Journey Builder Interactions REST route to get the name of the TriggeredSend that relates to the ObjectIDs/CustomerKeys of the triggered send you see in the _JourneyActivity, _Sent and _Job data views. The email name's very easy to get from the _Job data view, though. The TriggeredSendDefinition name seems like it'd have fairly limited use in CRM, though. What's the use case for having it on the Individual Email Results?
    – Macca
    Mar 15, 2020 at 4:35

1 Answer 1

Reset to default
3

You shouldn't need to get the Triggered Send Name into a Data Extension to update the IER record in Sales Cloud as it's already in the Salesforce et4ae5__Automated_Send__c object. You can just add a lookup relationship to the IER object to display the Name field from this object. Refer to the Entity Relationship Diagram below that I've put together with the highlighted fields.

Marketing Cloud Connect ERD

Improve this answer
4
  • Hi Eliot, thank you for your comment! Let me explain the details: what I need to bring into IER object is the Campaign Member Id. In order to do that I need to have a journey in Marketing Cloud with "Update Sales Cloud Object" activity. In this activity I need to use Merge ID for mapping (there are only other two possibilities for mapping which are not unique). As Merge ID is nowhere to be found in Marketing Cloud, I want to receive it through joining Send Log with IER object on Contact ID, Date and Triggered Send Name. Therefore I am now wondering how to get Triggered Send Name to MC...
    – Klaudia Dmowska
    Mar 16, 2020 at 9:15
  • As the Triggered Send Name is stored in the et4ae5__Automated_Send__c object, can't you just create a Synchronized DE from this custom object?
    – Eliot Harper
    Mar 16, 2020 at 9:34
  • Thanks a lot, it helped much!
    – Klaudia Dmowska
    Apr 14, 2020 at 9:45
  • Good to hear. Please could you accept my answer for the benefit of others, if I’ve answered your question.
    – Eliot Harper
    Apr 14, 2020 at 9:47

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .