Skip to main content
Virendra_Pratap
Level 2
September 11, 2026
Question

How Can I Find All AJO Journeys Associated with an Audience?

  • September 11, 2026
  • 6 replies
  • 76 views

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.

 

6 replies

DavidKangni
Adobe Champion and Community Advisor
DavidKangniAdobe Champion and Community Advisor
Adobe Champion and Community Advisor
September 14, 2026

Hi ​@Virendra_Pratap,

Use AI Assistant to get these details.

Thanks,

David

David Kangni
Virendra_PratapAuthor
Level 2
September 15, 2026

Hi ​@DavidKangni,

Thank you for the quick response. Currently, AI is not enabled on our platform, so I’m exploring alternative approaches to retrieve this information, possibly using Query Service. However, I agree that this would be a great option to consider in the future once AI is enabled on our platform.

DavidKangni
Adobe Champion and Community Advisor
DavidKangniAdobe Champion and Community Advisor
Adobe Champion and Community Advisor
September 17, 2026

​@Virendra_Pratap 
as you have the list of audience ids, you can run a query on the journey step events table. 

There is a field _experience.journeyorchestration.stepevents.exportsegmentid that contains audience ID. 

You can also filter on nodetype = ‘start’

From the journey step events, you will get audience ID, journeyversionID and journeyname. You can get the audience name by joining with adw_dim_segments

 

Thanks,

David

David Kangni
Adobe Champion
hegi90Adobe Champion
Adobe Champion
October 1, 2026

Hi ​@Virendra_Pratap 

May try this one:

SELECT
    _experience.journeyorchestration.stepevents.exportsegmentid AS Audience_ID,
    _experience.journeyorchestration.stepevents.journeyVersionName AS Journey_Name,
    _experience.journeyorchestration.stepevents.journeyVersionId AS Journey_Version_ID,
    COUNT(DISTINCT timestamp) AS Entry_Count
FROM
    journey_step_events
WHERE
    _experience.journeyorchestration.stepevents.exportsegmentid IN (
        'AUDIENCE_ID_1',
        'AUDIENCE_ID_2',
        'AUDIENCE_ID_3'
    )
GROUP BY
    1, 2, 3;

 

Virendra_PratapAuthor
Level 2
October 2, 2026

Thanks for query yes but as mentioned above my response, I believe it may not cover scenarios where the same audience is used within the journey as a condition at an intermediate step rather than as the entry audience. Could you please confirm whether this scenario is also supported?

Terms & ConditionsAccessibility statement

Loading footer...