AEP audience based on recency

[Pradeep-Jaiswal]

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.

[itsMeTechy]

Start by qualifying all profiles that have a 'prod view' event. Then, in a sequential condition where the next event occurs after that, exclude any profiles that have a 'cart view' event for the same product as in the initial 'prod view'.

kind of combination of sequential segmentation and dynamic segmentation.

[Devyendar]

@Pradeep-Jaiswal The most reliable way is to use Computed Attribute's Most Recent to get the accurate most recent event matching your criteria. Use the Customer Attribute along with other inclusion and exclusion criteria in a Segment to get the desired audiences.

[Sukrity_Wadhwa]

Hi @Pradeep-Jaiswal,

Were you able to resolve this query with the help of the provided solutions, or do you still need further assistance? Please let us know. If any of the answers were helpful in moving you closer to a resolution, even partially, we encourage you to mark the one that helped the most as the 'Correct Reply.'

Thank you!