I have a journey in Marketing Cloud which basically sends an email (with an Email activity) and afterwards updates some fields of the campaign member in Sales Cloud (with a Campaign Member activity). I need to prevent the campaign member from being updated in Sales Cloud if the email has not been actually sent for whatever reason (because it is in a suppression list, it is bounced, it is globally unsubscribed...)

How can I check that to make some decisions within the journey based on that?


1 Answer 1


I would use a query on _Sent Data View (link) + Journey Activity Data view (link), all joined with your journey's data entry on Subscriber Key.

You can then use the target data extension in a decision split: - Subscriber Key IS NOT NULL -> means the contact did receive the email. - Otherwise, he did not receive the email.

  • Thanks for your reply Rachid. Then I have another question. To check this target data extension in a decision split, I need to link it to the Contact Builder, right? If that's the case, how should I link it? I mean, if the Subscriber Key can be NULL, which field should I use to link it with the Contact Key so I can find it from the journey? Thanks a lot.
    – Laura
    Commented Mar 6, 2019 at 14:01
  • Yes, you should link it in Contact Builder with the Suscriber Key. You will use the fact that a Subscriber Key is not in the Data Extension as sign that the contact did not receive the email. Commented Mar 6, 2019 at 14:34

You must log in to answer this question.

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