How can I successfully create a segment where I can get only SKUs which has more than 10 units ordered in a visit?

Avatar

Avatar

ltaparia

Avatar

ltaparia

ltaparia

11-02-2020

Hi Everyone,

 

I am trying to get all SKUs which has more than 10 units sold in a visit. Here is report with segment definition which is giving wrong output:

upload.png

I understand the fact that product variable could have multiple SKUs with varying quantity in an order hit and only all hits which qualifies my condition of the segment ( that is unit > 10) qualifies for this segment.

 

This brings other SKU’s which have units lesser than 10. How can I successfully create a segment where I can get only SKUs which has more than 10 units ordered in a visit? @ursboller Could you please help?

Adobe Analytics Segments
View Entire Topic

Avatar

Avatar

Asheesh_P

MVP

Avatar

Asheesh_P

MVP

Asheesh_P
MVP

11-02-2020

@ltaparia try using distinct count feature https://www.youtube.com/watch?v=7A00dkA2cPI