Hi,
I am trying to create a segment with audience of count of Unique purchases (SKU's) between 2 and 5 in the last 10 days.
Can I do this in one single segment in AEP?
Thanks
Solved! Go to Solution.
@an1989 I built this in the UI.
Here is the PQL:
CHAIN(xEvent, timestamp, [C0: WHAT(true) WHEN(<= 10 days before now) COUNT(ALL) WHERE(C0[productListItems.exists(SKU.isNotNull())].count() >= 2 and C0[productListItems.exists(SKU.isNotNull())].count() <= 5)])
@an1989 A few things to remember:
Thanks @Danny-Miller for the response.
Sorry for not being clear with my question above. I am trying to find the qualified audience who made more than 2 purchases and less than 5 purchases in last 10 days.
I earlier tried using the aggregate function count, but that doesn't have between option. I can either select greater than or equal to or less than equal to. But not both in the same segment. Is there any alternative approach here?
If I do count distinct of product(sku) purchases in PQL, Can I get the qualified audience here?
Thanks
Views
Replies
Total Likes
@an1989 I built this in the UI.
Here is the PQL:
CHAIN(xEvent, timestamp, [C0: WHAT(true) WHEN(<= 10 days before now) COUNT(ALL) WHERE(C0[productListItems.exists(SKU.isNotNull())].count() >= 2 and C0[productListItems.exists(SKU.isNotNull())].count() <= 5)])
Views
Replies
Total Likes
Not sure. Did you try PQL?
distinct().count()
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies