Identify profiles who enter a journey

[LuisCardenas]

Hi all,

I want to create an audience of profiles that matches the following conditions: profiles who entered a specific journey in last 30 days OR profile.variable1 OR profile.variable2 - This audience will be used to trigger a recurrent journey that communicates an specific offer if the profile matches any of those conditiones described above.

Note: The journey used as a condition is triggered by a unitary event

How can I identify those profiles who enetered that specific journey? - I understand JourneyVersionId is available to use as condition to create an audience but that is not ideal since it will change everytime a new journey version is created...is there any other way to do it?

Appreciate any help. Thanks!

[DavidKangni]

Hi @LuisCardenas 

journey step events dataset is not enabled for profile so you can't create an audience from the UI. But if you have data distiller, you can create a data distiller audience from query service using the journey step event table.

You can use 

_experience.journeyOrchestration.stepEvents.journeyVersionName but it's not optimal for performance 

Thanks,

David

[LuisCardenas]

Hi @DavidKangni thanks for the response!

I actually don't know if data distiller is available in our org...How could I confirm it?

Another question is, if it were available...could you provide an example query?

[DavidKangni]

@LuisCardenas 

check in your licensing if you have Compute hours

SELECT COUNT(DISTINCT _experience.journeyOrchestration.stepEvents.profileID)
FROM   journey_step_events
WHERE  _experience.journeyOrchestration.stepEvents.journeyVersionID = '<journeyVersionID>'
  AND  _experience.journeyOrchestration.stepEvents.nodeType = 'start'
  AND  timestamp > (NOW() - INTERVAL '24 hour');

Thanks,

David