[AEP Frequency Segmentation] | Community
Skip to main content
S
SCB21
New Participant
January 19, 2023
Solved

[AEP Frequency Segmentation]

  • January 19, 2023
  • 2 replies
  • 869 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Avinash_Gupta_

Hi @scb21 

 

You can use something similar like this while creating the segment

 

 

2 replies

Gagan_Dutta
Gagan_Dutta
New Participant
January 24, 2023

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.

Avinash_Gupta_
Avinash_Gupta_Accepted solution
New Participant
January 20, 2023

Hi @scb21 

 

You can use something similar like this while creating the segment

 

 

    Terms & ConditionsAccessibility statement

    Loading footer...