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
    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. Mar 6, 2019 at 14:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.