Create segment in AEP to identify audiences based on product purchase

selvendranr9588

02-06-2020

Hi Team,

Need your help on whether below usecase can be achived

 

How to create a segment in AEP to find the users who visted the product but not purchased it. Say user visits two product pages(P1 and P2) and bought one product(P1) only. How to create the segment for this use case in AEP where user has purchased a product P1 but not P2. How AEP understands or basically group the events based on product and find that the P2 has not been purchased.

 

I was able to do it say a positive use case with single product but not with multiple views of the same product or multiple products

 

Include audience who have at least 1 Any event where ((Value equals 1 and Value does not exist happening in a single event))

 

select _Any1 from xEvent where _Any1.commerce.productViews.value = 1.0 and _Any1.commerce.purchases.value.isNull()

 

Sample JSON ingested into AEP from website :  https://jsoneditoronline.org/#left=cloud.d78fce9b4fb34683976c8df3ffbcdc44&right=local.tofuba

 

 

Accepted Solutions (0)

Answers (0)