Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

[AEP Frequency Segmentation]

Avatar

Level 2

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
Level 9

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
Level 9

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.