Expand my Community achievements bar.

SOLVED

[AEP Frequency Segmentation]

Avatar

Level 4

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @SCB21 

 

You can use something similar like this while creating the segment

 

AvinashGupta01_0-1674176848729.png

 

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi @SCB21 

 

You can use something similar like this while creating the segment

 

AvinashGupta01_0-1674176848729.png

 

Avatar

Level 2

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.