Skip to main content
erinwestlake
Level 2
June 6, 2023
Solved

My table rows are not adding up correctly to the top number.

As you can see in the picture below, the orders of our products are not adding up correctly to the number at the top. I am curious why this would be and how to fix it. 

 

Thanks! 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Jennifer_Dungan
Jennifer_DunganAccepted solution
Adobe Champion and Community Advisor
June 6, 2023

What is your dimension breakdown? Product?

 

If there are multiple products in the same order, the total orders will be de-duplicated.

 

Example: If I go to your site and purchase "Item A", "Item B" and "Item C" in the same order, the report will look like:

 

                               Orders

                                    1

Products

     Item A                     1

     Item B                     1

     Item C                     1

 

 

You wouldn't count this as "3" orders when all three products were purchased in the same order, with the same Order ID / Transaction ID... it's still one order.

View in thread

2 replies

Jennifer_Dungan
Adobe Champion and Community Advisor
Jennifer_DunganAdobe Champion and Community AdvisorAccepted solution
Adobe Champion and Community Advisor
June 6, 2023

What is your dimension breakdown? Product?

 

If there are multiple products in the same order, the total orders will be de-duplicated.

 

Example: If I go to your site and purchase "Item A", "Item B" and "Item C" in the same order, the report will look like:

 

                               Orders

                                    1

Products

     Item A                     1

     Item B                     1

     Item C                     1

 

 

You wouldn't count this as "3" orders when all three products were purchased in the same order, with the same Order ID / Transaction ID... it's still one order.

Translate
    Adobe Employee
    BrianAu1Adobe Employee
    Adobe Employee
    June 6, 2023

    @jennifer_dungan is correct - this is a scenario of the Orders metrics having different contexts when applied at different dimension levels (Top Line vs. Product line item level). Conceptually in the case of orders where the metrics are dually applied at a per-product line item level AND against corresponding top line overall count, the top line represents the de-duplicated total orders metric count. The per-product line items that are not de-duplicated actually represents more an 'order involved count' since it's a many-to-one data relationship of products within a given order.

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...