Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

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

Avatar

Level 2

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

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Employee

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.

View solution in original post

4 Replies

Avatar

Level 2
@Asheesh_Pandey Thanks for the response. but distinct count only works for dimension. Isn't it? How can I use it for "Units" Metric?

Avatar

Community Advisor

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

Avatar

Correct answer by
Employee

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.