In SiteCatalyst, De-Duplicate Orders in Products Classification | Community
Skip to main content
ericmatisoff1
Level 5
April 26, 2010
Delivered

In SiteCatalyst, De-Duplicate Orders in Products Classification

  • April 26, 2010
  • 4 replies
  • 2567 views

SiteCatalyst does not de-duplicate Orders in Product Classifications.  For example:

 

A user buys 2 products in a single order (A Cheeseburger - $2 and a Hot Dog - $1).

 

The Products report would show:

 

Product                Units     Orders  Revenue

 

Cheeseburger   1              1              $2

Hot Dog                1              1              $1

Total                      2              1              $3

 

Which is correct! 

 

However, if Cheeseburgers and Hot Dogs are classified as Food, then the classification report would look like:



Product Group  Units     Orders  Revenue



Food                      2              2              $3

Total                      2              1              $3

 

So the issue here is although Orders are De-duplicated in the totals line, the in-line Orders data is not.  This could certainly be an issue, as honestly, there was only one Order for Food made above.

 

Word from ClientCare is that Discover de-duplicates in-line, but not SiteCatalyst. Would love to see this issue rectified in SiteCatalyst!

4 replies

tmcilheran
Level 2
April 27, 2010

+1

Adobe Employee
May 5, 2010

I completely agree. We're looking heavily into this. We're also looking at de-duplicating metrics with merchandising eVars.

 

Bret Gundersen

SiteCatalyst Platform Product Manager

June 6, 2010

Bret -

 

I really hope that the current method of counting orders within SiteCatalyst does not change. I rely on this methodology to report on Lines Per Order (average number of Unique Skus per Order.) I have unsuccessfully tried numerous methods to get this metric out of excel client, and tried the obvious solution of pulling Products>>Products>>Products and choosing ALL Products, but exclient returns the total number of orders and not the total number of products ordered. BUT, using my product classified data, I can  get to the total number of products ordered. This then lets me calculate Lines Per Order (Total Products Ordered / Total Orders=LPO).

 

If the de-duping occurs for SAINT classifications, can someone tell me how to get at the Lines Per Order out of excel client?

Adobe Employee
April 8, 2011
This is available in SiteCatalyst 15.