Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Answered

Segment based on dynamic dates

(0) ShareShare
ReportReport
Posted on by 205

Hello, 

I like to segment my customer based who submitted the form today only do you know how I can add this to query, here is my current filter:

INTERACTION(FormSubmitted, FormSubmitted_Contact)
.FILTER(FormId == 'xxx' && Timestamp >= DATE(2020, 5, 19, 0, 0))
.HAVING(COUNT() > 0)

Segment.JPG

Many Thanks, 
Elly

  • Elly-Farokhi Profile Picture
    Elly-Farokhi 205 on at
    RE: Segment based on dynamic dates

    you are amazing Cofly, thank you so much

  • Verified answer
    cloflyMao Profile Picture
    cloflyMao 25,202 on at
    RE: Segment based on dynamic dates

    Hi Elly,

    You could set a moving-window filter to only consider interactions that occurred recently.

    e.g: The segment will find contacts who submitted a specific form in last 1 day.

    1184.JPG

    https://docs.microsoft.com/en-us/dynamics365/marketing/segments-interaction

    2318.JPG

    Regards,

    Clofly

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…

Vahid Ghafarpour – Community Spotlight

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

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,162 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans