In SiteCatalyst, De-Duplicate Orders in Products Classification

ericmatisoff1

26-04-2010

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 Comments (4 New)
4 Comments

tmcilheran

27-04-2010

+1

BretGundy

Employee

05-05-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

paul_zaras

06-06-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?

BretGundy

Employee

07-04-2011

This is available in SiteCatalyst 15.