Solved
Email linked to particular Journey
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.
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
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);
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.