Create Segment with Contacts that have interacted (either by clicking or opening an email) in the last 30 days

(0) Share

Report

Posted on by DGrassl2000

I would like to create 3 segments, one with contacts with interactions (email clicked) in the last 30 days, 2 segment of contact that interacted in the last 60 days and greater than 30 days, and 3 segment that interacted in the last 90 days but greater than 60 days. That is so the same contact is not in the first two lists. I have not been able to get that to work. My query for the 2nd segment is:

INTERACTION(EmailOpened, EmailOpened_Contact)
.FILTER(ISNOTNULL(Timestamp))
.HAVING(COUNT() > 0, UTCDAYS(60))
UNION
INTERACTION(EmailClicked, EmailClicked_Contact)
.FILTER(ISNOTNULL(Timestamp))
.HAVING(COUNT() > 0, UTCDAYS(60))

But it included all contacts that have interactions of less than 30 days. I only want contacts that are greater than 30 and less than 60.

Thank you.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Yuri ji Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can try adding a step that will exclude customers who interact within 30 days.

EXCEPT
INTERACTION(EmailClicked, EmailClicked_Contact)
.FILTER(ISNOTNULL(Timestamp))
.HAVING(COUNT() > 0, UTCDAYS(30))

Was this reply helpful? Yes No