Average product quantity (orders)

Reports and working with data
1

Hi team,
I just have a question regarding the metric Average product quantity (order)
In my ecommerce reports, I look at this metric but can’t understand the displayed result.

Let’s say I have :

  • 3967 orders
  • 12843 products sold for those orders

Average product quantity (order) show 1,15 instead of 3,2 (products/orders).
How is Piwik getting 1,15 ? Can someone explain ?

Many thanks :slight_smile:

2

Hi @AudreyR,

Product quantity is a number of the same product in a cart.
For example:
Order 1:
2 x Item A
1 x Item B
1 x Item C
Order 2:
1 x Item A
1 x Item B
1 x Item C

Average product quanitity is: sum of quanitities per product / sum of product orders
(2+1+1+1+1+1)/6 = 7/6
while what you are looking for is more of a: sum of quantities per product / orders
(2+1+1+1+1+1)/2 = 7/2
You can create this type of value in calculated metrics this way:
{product_quantity,transformation_id=sum,event_type=9}/{ecommerce_conversions}

Best,
Oliwer