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?
Solved! Go to Solution.
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.