I'd like to exclude customers who are currently in journeys A and B from receiving newsletter send C.
The only way I could come up with yet involves the following steps:
- Get the TriggeredSendCustomerKeys of the triggered sends for the first email send activities of journeys A and B.
- Create an Automation containing a SQL query activity that retrieves the SubscriberKey from Sent data view and filters by EventDate plus maximum journey duration greater than the current date for the TriggeredSendCustomerKeys of step 1.
- Use the created data extension as exclusion for the newsletter send.
Is there an easier and more accurate (different journey paths could have different durations) possibility to exclude contacts currently inside a specific journey or a defined set of journeys from the audience of an email send within Email Studio? Querying the current population of a journey would be a more straightforward approach, unfortunately I couldn't find any documentation on this.