Creating buckets of percentile

Avatar

Avatar
Level 1
moa83214703
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
moa83214703
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
moa83214703
Level 1

21-10-2019

Hi I am trying to create groups of users such that they fit into one of the 4 groups below:

0 -25th percentile

26th - 50th percentile

51 -75th percentile

76th - 100th percentile

based on amount of money they have spent. I tried both percentile and quartile functions but they dont seem to work correctly.

Accepted Solutions (0)

Answers (3)

Answers (3)

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

23-10-2019

after think about the question I don't believe you can use the calculated metrics (they can't be used within a segment).

maybe you can try the Histogram or Scatterplot  with calc. metric "revenue per visitor" and "unique visitors" to see some patterns?

Avatar

Avatar
Affirm 1
Level 3
surajp86368405
Level 3

Likes

21 likes

Total Posts

77 posts

Correct reply

1 solution
Top badges earned
Affirm 1
Validate 10
Validate 1
Contributor
Shape 1
View profile

Avatar
Affirm 1
Level 3
surajp86368405
Level 3

Likes

21 likes

Total Posts

77 posts

Correct reply

1 solution
Top badges earned
Affirm 1
Validate 10
Validate 1
Contributor
Shape 1
View profile
surajp86368405
Level 3

23-10-2019

can we do based on all orders counted together ?

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

22-10-2019

how do you create the segment/function so far? is the "amount" based on a single order or more orders counted together?