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

How to Group SKUs based on Number of Orders

  • August 20, 2019
  • 14 replies
  • 11367 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
L
ltapariaAuthor
New Participant
August 20, 2019

Thanks @davidj85759080 , I was thinking of solving my problem using classification of Product but there are challenges which I over see here.

Let's assume I create a classification name: "Product Grouping on Order" and update this on daily basis, won't this overwrite ranking/grouping of product daily(assuming all products have order). How do you view "Product Group On Order"  report for a time period?

David_Jerome
David_Jerome
New Participant
August 20, 2019

One other - better way however (if I was doing this for myself) - would be to use the Adobe data feed into your data lake. Create a daily calculation here in SQL and then push that back in as a classification each day via automated FTP.

More likely one for your data scientists and I.T team however.

David_Jerome
David_Jerome
New Participant
August 20, 2019

So - I think this is what you are after (using the 1 to 5 system I mentioned this morning).

Based on some data today, I see the following:

The logic to get the ranking system is as follows:

and the last 30 days segment is simply "visits in the last 30 days".

Hope that helps.


Dave

David_Jerome
David_Jerome
New Participant
August 20, 2019

Not the perfect solution but if you are willing to use 1,2,3,4,5 rather than A,B,C,D,E then you should be able to do this using a nested if statement.

Terms & ConditionsAccessibility statement

Loading footer...