Skip to main content
akwankl
Level 6
June 28, 2023
Solved

Segment building - Contract End Date > today()

Hello,

 

Apologies in advanced as this seems to be a simple question that's escaping my head. I have an attribute where it contains the contract end date of each profile, and I am trying to create a segment that target customers that are still in contract, ie. their contract end date is greater than today. How do I do that?

 

Thanks,

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
birthariyaAccepted solution
Level 3
June 28, 2023

One way is to use PQL where you can compare the contract date and today's date (Profile Query Language)

Another not-so-great way to put this is (Read Birth Date as  Contract Date):

 

View in thread

3 replies

birthariyaAccepted solution
Level 3
June 28, 2023

One way is to use PQL where you can compare the contract date and today's date (Profile Query Language)

Another not-so-great way to put this is (Read Birth Date as  Contract Date):

 

Translate
akwanklAuthor
Level 6
June 28, 2023

Thanks @birthariya, I resolved to using the "In Next" method too. Though, for the PQL suggestion, how do I use that in the segment builder?

 

Thanks,

Translate
birthariya
Level 3
June 28, 2023

PQLs are not meant for UI/Segment Builder, unfortunately.
We have to use API endpoints to define segment definitions when using PQL. 

Such segments can not be created/edited using AEP Segment Builder UI. (Not a marketer-friendly way).

 

 

 

Translate
Terms & ConditionsAccessibility statement

Loading footer...