I had a journey that I stopped because we are updating our email strategy on the journey.
Out of 4MM subscribers, only about 1MM received the first message. I want to segment the 4MM into 4 groups and keep the 1MM that already received email 1 from receiving the same email.
Struggling to identify where to pull that group from. Here's my query:
SELECT usr.contact_key, usr.email, usr.platform, usr.platform_user_id, usr.first_name, usr.last_name, usr.created_at, usr.last_login_at FROM ENT.[Users] usr INNER JOIN _Sent s ON usr.contact_key = s.subscriberkey INNER JOIN _job j ON s.jobid = j.jobid WHERE j.EmailName = 'NGB Email 3 - 82f87a6eb77e4687ba09fa088ec05abe'
I wanted to use JobId as the link between
job but there's not a good way for me to identify that without created a separate data extension.