[AEP Frequency Segmentation]

[SCB21]

Hi Team,

How do I create a segment that consists of transaction data and has a frequency around it.  For example, I would like to segment users who have spent $100 in transaction 8 times in the last month?

Thanks

[Avinash_Gupta_ · Accepted solution]

Hi @SCB21 

You can use something similar like this while creating the segment

[Gagan_Dutta]

Hi There, Even though the OOB segmentation allow you to build some straightforward logic but you can build some custom rules using PQL through API. 

Count(account) > 8 and transactionvalue>amountvalue and transactionDate occurs > 30 days before today group by account) which you cannot build using UI.