Can I create a segment with an aggregate using count between in AEP

Question

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

Danny-Miller · Accepted Answer

Hi @danny-miller , just checking in to see if you have some insight on this?

Thanks

@avinashwiley 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)])

Danny-Miller · Answer

@avinashwiley A few things to remember:Segments do not produce an "audience count".  They are rules that define if someone qualifies for membership in a Segment.You can do a Count of Purchases (not Count Distinct) using Aggregate functions in the UI. https://experienceleague.adobe.com/docs/experience-platform/segmentation/ui/segment-builder.html?lang=en#aggregation-functionsYou can do a Count Distinct in PQL.  https://experienceleague.adobe.com/docs/experience-platform/segmentation/pql/array-functions.html?lang=en#distinctEven though you can do a Count Distinct, this is within the context of a single Array.  I do not think this will do a count Distinct across Events, but it is worth a try.

Sign up

Login with SSO

Login to the community

Login with SSO