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

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

Accepted Solutions (0)

Answers (2)

Answers (2)

ursboller

MVP

13-02-2020

I don't think there is a way in analytics to get the sum of the metrics within segments. The missing part is the ability to use "calculated metrics" within a segment which would allow to do the math.
meanwhile (if it is important), you could change the tracking implementation and add a counter "client side"...

Asheesh_P

MVP

11-02-2020

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