Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Suggested answer

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

(0) ShareShare
ReportReport
Posted on by 10

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.

  • Suggested answer
    Yuri ji Profile Picture
    Yuri ji on at
    RE: Create Segment with Contacts that have interacted (either by clicking or opening an email) in the last 30 days

    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))

    pastedimage1663134311691v1.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans