How to Group SKUs based on Number of Orders | Community
Skip to main content
L
ltaparia
Level 2
August 20, 2019
Solved

How to Group SKUs based on Number of Orders

  • August 20, 2019
  • 14 replies
  • 11368 views

Hi,

I want to classify SKUs based on Number of orders placed per day. This Classification/ ranking will help our asset team to understand which SKUs are sold most in the selected time period and they can plan their stock level based on the historical purchase trend on our website. Let's take below definition for my case

Definition (Per Day)Demand Label
Orders >= 100A
90 <=Orders< 100B
70 <=Orders< 90C
50<=Orders< 70D
Orders<50E

How can I create a report in Work space which shows demand label against SKU in Omniture as below?

Product CodeDemand Label
1215561A
23F004A
SA01504B
1123951D
1123435D

ursboller​ Can you please help?

Similar grouping I want to do based on Revenue generated as well as on Units sold.

Regards

Lalit

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 David_Jerome

Hi ya,

The segment is dynamic.

The approx distinct count (day) will return a value of 1 if you pick just yesterday, 7 if you pick last week, 28 if you select the last 4 weeks etc).

So if for example you have sold 3,444 units in the last 4 weeks and 300 in the last 7 days you would see the following:

28 day report

3444 units      /  28 = 123.

This would give the product a ranking of 5 (average daily units above 100).

7 day report

300 units      /  7 = 42.85.

This would give the product a ranking of 1 (average daily units below 50).

14 replies

Show previous replies
David_Jerome
David_Jerome
Level 6
August 21, 2019

Hi Lalit,

I think there may be some confusion. :-)

If you look at my solution (post at 21-Aug-2019 00:37) you will see I reference a before and after.

In the after I have removed the 30 day reference.

Thanks

Dave

    L
    ltapariaAuthor
    Level 2
    August 29, 2019

    Here is the final working logic. Thanks for all the help davidj85759080​

    David_Jerome
    David_Jerome
    Level 6
    August 29, 2019

    No worries.

    jantzen_b
    Adobe Employee
    jantzen_bAdobe Employee
    Adobe Employee
    March 17, 2020

    Do any of these replies provide an answer to your original question? If so, please mark the most correct answer. If not, can you provide some additional details to help the community better answer your question.

    Terms & ConditionsAccessibility statement

    Loading footer...