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
Validate 1
Level 2
ltaparia
Level 2

Likes

5 likes

Total Posts

29 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Give Back
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
ltaparia
Level 2

Likes

5 likes

Total Posts

29 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Give Back
Boost 5
Boost 3
Boost 1
View profile
ltaparia
Level 2

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?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 10
Employee
BrianTophamAdobe
Employee

Likes

0 likes

Total Posts

6 posts

Correct reply

3 solutions
Top badges earned
Validate 10
Affirm 3
Affirm 1
Validate 1
View profile

Avatar
Validate 10
Employee
BrianTophamAdobe
Employee

Likes

0 likes

Total Posts

6 posts

Correct reply

3 solutions
Top badges earned
Validate 10
Affirm 3
Affirm 1
Validate 1
View profile
BrianTophamAdobe
Employee

03-08-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.

Answers (2)

Answers (2)

Avatar

Avatar
Coach
MVP
ursboller
MVP

Likes

525 likes

Total Posts

1,020 posts

Correct reply

257 solutions
Top badges earned
Coach
Contributor
Bedrock
Seeker
Springboard
View profile

Avatar
Coach
MVP
ursboller
MVP

Likes

525 likes

Total Posts

1,020 posts

Correct reply

257 solutions
Top badges earned
Coach
Contributor
Bedrock
Seeker
Springboard
View profile
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"...

Avatar

Avatar
Applaud 500
MVP
Asheesh_P
MVP

Likes

130 likes

Total Posts

334 posts

Correct reply

146 solutions
Top badges earned
Applaud 500
Affirm 100
Contributor
Boost 100
Give Back 10
View profile

Avatar
Applaud 500
MVP
Asheesh_P
MVP

Likes

130 likes

Total Posts

334 posts

Correct reply

146 solutions
Top badges earned
Applaud 500
Affirm 100
Contributor
Boost 100
Give Back 10
View profile
Asheesh_P
MVP

11-02-2020

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