Email linked to particular Journey

[user36079]

Hi,

I would like to create a segment for users who have received the email linked to particular journey.

What attributes are needed? What dataset are they in?

thank you very much.

[Anuhya-Y · Accepted solution]

@user36079 

The below query gives the number of distinct profiles that entered the given journey in the given time frame.

SELECT count(distinct _experience.journeyOrchestration.stepEvents.profileID)
FROM journey_step_events WHERE _experience.journeyOrchestration.stepEvents.journeyVersionID = '<journeyVersionID>'
AND _experience.journeyOrchestration.stepEvents.nodeType='start'
AND _experience.journeyOrchestration.stepEvents.instanceType = 'unitary'
AND DATE(timestamp) > (now() - interval '<last x hours>' hour);