How Can I Find All AJO Journeys Associated with an Audience?
Hi Everyone,
I have a list of Audience Names along with their corresponding Audience IDs in Adobe Experience Platform (AEP).
I would like to identify which Adobe Journey Optimizer (AJO) journeys are using each of these audiences. In other words, for each Audience ID in my list, I would like to extract the associated Journey Name and Journey ID.
Since the list contains a large number of audiences, manually checking each journey is quite time-consuming.
Could anyone please advise if there is an AEP Query Service SQL query, system dataset, or any other recommended approach/API that can be used to extract this information in bulk?
Ideally, I am looking for an output in the following format:
| Audience Name | Audience ID | Journey Name | Journey ID |
|---|---|---|---|
| Audience A | xxx-xxx | Journey 1 | xxx-xxx |
| Audience A | xxx-xxx | Journey 2 | xxx-xxx |
| Audience B | yyy-yyy | Journey 1 | yyy-yyy |
| Audience B | yyy-yyy | Journey 2 | yyy-yyy |
| Audience B | yyy-yyy | Journey 3 | yyy-yyy |
| Audience B | yyy-yyy | Journey 4 | yyy-yyy |
Any guidance on the appropriate system dataset(s), join conditions, or API would be greatly appreciated.