Segment creation, Customer_id
Hello could you please help me in following issue:
I have customer database in Pega Markting with following structure:
Customer_ID (unique), User_ID, Project, Email, metric1
1A, 1, A, 1@gmail.com, 20
2A, 2, A, 2@gmail.com, 30
3A, 3, A, 3@gmail.com, 40
1B, 1, B, 1@gmail.com, 120
2B, 2, B, 2@gmail.com, 130
3B, 3, B, 3@gmail.com, 140
So I need select following emails to send campaign: those emails that are in project B but exclude emails that have metric1<25 in project A. Output should be 2@gmail.com, 3@gmail.com.
How I can create such segment in Pega Marketing?
Thank you!