Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

In SiteCatalyst, De-Duplicate Orders in Products Classification

Avatar

Avatar
Validate 1
Level 9
ericmatisoff1
Level 9

Likes

356 likes

Total Posts

154 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Level 9
ericmatisoff1
Level 9

Likes

356 likes

Total Posts

154 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
ericmatisoff1
Level 9

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
Boost 5
Level 2
tmcilheran
Level 2

Likes

8 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
View profile

Avatar
Boost 5
Level 2
tmcilheran
Level 2

Likes

8 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
View profile
tmcilheran
Level 2

27-04-2010

+1

Avatar

Avatar
Employee
BretGundy
Employee

Likes

0 likes

Total Posts

99 posts

Correct Reply

0 solutions
View profile

Avatar
Employee
BretGundy
Employee

Likes

0 likes

Total Posts

99 posts

Correct Reply

0 solutions
View profile
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
Validate 1
Level 1
paul_zaras
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Applaud 5
View profile

Avatar
Validate 1
Level 1
paul_zaras
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Applaud 5
View profile
paul_zaras
Level 1

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
Employee
BretGundy
Employee

Likes

0 likes

Total Posts

99 posts

Correct Reply

0 solutions
View profile

Avatar
Employee
BretGundy
Employee

Likes

0 likes

Total Posts

99 posts

Correct Reply

0 solutions
View profile
BretGundy
Employee

07-04-2011

This is available in SiteCatalyst 15.