AEP audience based on Adobe Analytics clickstream data into AEP event-time series based schema.
SKU can be part of any shopping cart events (prodView, OpenCart, cartView, CheckOut etc)
How do we create a segment for customer having SKU=ABC as part of prodView in their latest event for that SKU ?
Here are the sample example of customer events sorted in time ascending order:
Customer 1
Time1: SKU=ABC, ProdView
Time2:SKU=ABC, OpenCart
Time3:SKU=XYZ, ProdView
Time4:SKU=DEF, ProdView
Time5:SKU=DEF, OpenCart
Time6:SKU=ABC, ProdView
Time7:SKU=PQR, ProdView
Time8:SKU=PQR, cartView
Time9:SKU=PQR, CheckOut
Customer 2
Time1: SKU=ABC, ProdView
Time2:SKU=ABC, OpenCart
Time3:SKU=XYZ, ProdView
Time4:SKU=DEF, ProdView
Time5:SKU=DEF, OpenCart
Time6:SKU=ABC, ProdView
Time7:SKU=ABC, OpenCart
Time8:SKU=XYZ, ProdView
Time9:SKU=PQR, cartView
Time10:SKU=PQR, CheckOut
In the Above example, customer 1 should qualify as the latest status for SKU=ABS is prodView on time6.
However customer 2 would dis-qualify as the lates status for SKU=ABC is OpenCart on time7.
