How to Implement 30/90 Day Audience Qualification Logic in AEP

[AJODev]

Hi, I have a scenario where I need to create an audience in AEP such that:

• A profile should qualify for the audience if they meet certain criteria in the last 30 days.

• Once qualified, they should not be able to re-qualify for the same audience again until 90 days have passed.

Can anyone suggest the best approach to implement this logic?

• How should I manage the datetime attribute or event tracking in my schema so I can check time-based eligibility?

• What’s the recommended way to set up the segment definition using Segment Builder or PQL to enforce this “qualify-in-30, block-for-90” logic?

Thanks

AJODev

[ReenaJohn · Accepted solution]

Hi @AJODev 

You could do this both ways - Segment UI Builder and PQL.

It would be easier to build this on the Segment UI builder using below steps.

Segment UI Builder :

1. Add an attribute say lastQualified in profile level that does the 90 day check.

For this you can use Computed Attributes or JO to update this attribute when a profile qualifies the first time.

Adobe Journey Optimizer: Trigger a journey when a profile qualifies and use the “Update Profile” activity.
Computed Attributes: Aggregate event timestamps and store the most recent qualifying date.

2. Create an audience with the condition as below -

(Event in last 30 days : Where we have event type of desired event and timestamp of last 30 days) AND ( lastQualified is null or older than 90 days).

Warm Regards,

Reena John