Level 2

Question

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

Forum|Forum|30 days ago
September 11, 2026
8 replies
88 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.

DavidKangni

Adobe Champion and Community Advisor

Hi @Virendra_Pratap,

Use AI Assistant to get these details.

Thanks,

David

David Kangni

V

Virendra_PratapAuthor

Level 2

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

@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

H

hegi90

Adobe Champion

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;

V

Virendra_PratapAuthor

Level 2

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?

H

hegi90

Adobe Champion

I’m not quite sure about that. But journey_step_events has information about every node. Si my guess it that it is supported, but currently not have done this myself. When you say, you are using an audience as journey condition, are you talking about “global exit criteria” or like “read audience” in a journey? My starting point would be to make a SELECT * Statement on journey_step_events and then looking for audience memberships or audience id’s on the specific node (may even filter on nodes).

Sign up

Login with SSO

Login to the community

Login with SSO