Create an audience with criteria comparing two profile attributes

[GabrielaNa1]

Hi, I have a question about how to specify a certain rule when defining an audience in AEP. I have these two date fields into the profile: RefDate1 and RefDate2. In audience builder I want to have some condition like RefDate1 <= RefDate2. How do I specify it in the GUI?

[supratim320 · Accepted solution]

Hi @GabrielaNa1 ,

Helpful video here

You can drag and drop the field like this:

You can choose how to compare: whether to form a group with the 1st attribute or use in comparison. Once I have chosen for comparison, it will look something like below:

Hope this resolves!

[GabrielaNa1]

Thanks, @supratim320 , that is exactly what I was looking for!

[AnkitJasani29]

Hi @GabrielaNa1 ,

Not sure about GUI based direct comparison between two attributes like you mentioned but you can try Query Service to write a SQL query that flags profiles where RefDate1 <= RefDate2, and store the result in a new profile attribute.

[GabrielaNa1]

Thanks. This will work for that particular one example, but lacks flexibility. @supratim320 answer is what I was looking for.