In SiteCatalyst, De-Duplicate Orders in Products Classification

Avatar

Avatar

ericmatisoff1

Avatar

ericmatisoff1

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

Avatar

Avatar

tmcilheran

Avatar

tmcilheran

tmcilheran

27-04-2010

+1

Avatar

Avatar

BretGundy

Employee

Avatar

BretGundy

Employee

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

Avatar

Avatar

paul_zaras

Avatar

paul_zaras

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?

Avatar

Avatar

BretGundy

Employee

Avatar

BretGundy

Employee

BretGundy
Employee

07-04-2011

This is available in SiteCatalyst 15.