Create an audience with criteria comparing two profile attributes | Community
Skip to main content
G
GabrielaNa1
Level 3
May 7, 2025
Solved

Create an audience with criteria comparing two profile attributes

  • May 7, 2025
  • 2 replies
  • 677 views

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?

Best answer by supratim320

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!

2 replies

S
supratim320Accepted solution
Level 5
May 7, 2025

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!

    G
    GabrielaNa1Author
    Level 3
    May 9, 2025

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

      AnkitJasani29
      AnkitJasani29
      Level 6
      May 8, 2025

      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.

        G
        GabrielaNa1Author
        Level 3
        May 9, 2025

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

        Terms & ConditionsAccessibility statement

        Loading footer...