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

Question

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:

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? @urs_boller Could you please help?

BrianTophamAdobe · Accepted Answer

Since the product string is a "List Variable" (a variable that can hold more than one value at a time), such a segment will return the full product string for any production string that had at least one product with more than 10 units. So, there is not a way to create such a segment and ONLY get units over 10 back, unless the product string ONLY contained that single product with more than 10 units, and had no other product passed.

Urs_Boller · Answer

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"...

Sign up

Login with SSO

Login to the community

Login with SSO