Problem:
I'd like to exclude customers who are currently in journeys A and B from receiving newsletter send C.
Possible solution:
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.
Question:
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.