How can I successfully create a segment where I can get only SKUs which has more than 10 units ordered in a visit? | Community
Skip to main content
L
ltaparia
Level 2
February 11, 2020
Solved

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

  • February 11, 2020
  • 3 replies
  • 5713 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by BrianTophamAdobe

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.

3 replies

Asheesh_Pandey
Community Advisor
Asheesh_PandeyCommunity Advisor
Community Advisor
February 11, 2020

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

L
ltapariaAuthor
Level 2
February 12, 2020
@asheesh_pandey Thanks for the response. but distinct count only works for dimension. Isn't it? How can I use it for "Units" Metric?
Urs_Boller
Community Advisor
Urs_BollerCommunity Advisor
Community Advisor
February 13, 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"...

BrianTophamAdobe
Adobe Employee
BrianTophamAdobeAdobe EmployeeAccepted solution
Adobe Employee
August 3, 2021

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.

Terms & ConditionsAccessibility statement

Loading footer...