Average order value
This page explains the calculation types, dimensions and filters available to you for the key figure Average order value. This page is for reference purposes only and assumes that you already have basic knowledge about the plentyBI tool.
PlentyONE calculates the key figure Average order value by multiplying the quantity of order items with the corresponding prices.
This result is then divided by the quantity of orders:
(Quantity × Price) : Quantity of orders = ø Order value
In addition, select a dimension to determine how the result is grouped.
Set filters to specify the criteria for the calculation of the average order value.
Make sure to be aware of the information given for the filter Order type.
1. plentyBI edition
How many and which key figures and corresponding dimensions you can create depends on the edition you have booked.
-
New customers: Choose the appropriate plentyBI edition while you order plentysystems.
-
Existing customers: Choose the appropriate plentyBI edition in the "My account" area.
2. Dimension
2.1. Item category, creation date
The average order value is displayed grouped by item category and creation date. This way, you can see at a glance how much average order value is generated by which item category. A further differentiation is made according to the creation date of the orders.
2.2. Order referrer plugin, creation date
The average order value is displayed grouped by order referrer (further grouped by plugin) and creation date. This way, you can see at a glance how much average order value is generated broken down by plugins that create orders in your PlentyONE system. A further differentiation is made according to the creation date of the orders.
2.3. Order referrer, creation date
The average order value is displayed grouped by order referrer and creation date. This way, you can see at a glance how much average order value is generated through which order referrer. A further differentiation is made according to the creation date of the orders.
2.4. Order referrer, completion date
The average order value is displayed grouped by order referrer and date of outgoing items. This way, you can see at a glance how much average order value is generated through which order referrer. A further differentiation is made according to the date on which outgoing items were booked for the orders.
2.5. Order referrer, payment date
The average order value is displayed grouped by order referrer and payment date. This way, you can see at a glance how much average order value is generated through which order referrer. A further differentiation is made according to the date on which a payment was assigned to the order.
2.6. Creation date
The average order value is displayed grouped by creation date. This means that the date on which the orders were created is considered in the calculation.
2.7. Manufacturer, creation date
The average order value is displayed grouped by manufacturer and creation date. This way, you can see at a glance how much average order value is generated broken down by manufacturer. A further differentiation is made according to the creation date of the orders.
2.8. Contact, creation date
The average order value is displayed grouped by contact and creation date. This way, you can see at a glance how much average order value is generated through which contact. A further differentiation is made according to the creation date of the orders.
2.9. Warehouse, creation date
The average order value is displayed grouped by warehouse and creation date. This way, you can see at a glance how much average order value is generated through which warehouse. A further differentiation is made according to the creation date of the orders.
2.10. Warehouse, completion date
The average order value is displayed grouped by warehouse and date of outgoing items. This way, you can see at a glance how much average order value is generated through which warehouse. A further differentiation is made according to the date on which outgoing items were booked for the orders.
2.11. Warehouse, payment date
The average order value is displayed grouped by warehouse and payment date. This way, you can see at a glance how much average order value is generated through which warehouse. A further differentiation is made according to the date on which a payment was assigned to the order.
2.12. Delivery country, creation date
The average order value is displayed grouped by delivery country and creation date. This way, you can see at a glance how much average order value is generated in which country of delivery. A further differentiation is made according to the creation date of the orders.
2.13. Client, creation date
The average order value is displayed grouped by client and creation date. This way, you can see at a glance how much average order value is generated through which client. A further differentiation is made according to the creation date of the orders.
2.14. Client, completion date
The average order value is displayed grouped by client and date of outgoing items. This way, you can see at a glance how much average order value is generated through which client. A further differentiation is made according to the date on which outgoing items were booked for the orders.
2.15. Client, payment date
The average order value is displayed grouped by client and payment date. This way, you can see at a glance how much average order value is generated through which client. A further differentiation is made according to the date on which a payment was assigned to the order.
2.16. Invoice country, creation date
The average order value is displayed grouped by invoice country and creation date. This way, you can see at a glance how much average order value is generated in which invoice country. A further differentiation is made according to the creation date of the orders.
2.17. Return reason, creation date
The average order value is displayed grouped by return reason and creation date. This way, you can see at a glance how the average order value is affected by return reasons. A further differentiation is made according to the creation date of the orders.
2.18. Date of outgoing items
The average order value is displayed grouped by date of outgoing items. This means that the date on which outgoing items were booked for the orders is considered in the calculation.
2.19. Payment method, creation date
The average order value is displayed grouped by payment method and creation date. This way, you can see at a glance how much average order value is generated through which payment method. A further differentiation is made according to the creation date of the orders.
3. Filters
Filters allow you to narrow down the data calculated by the key figure. The following chapters contain an overview of all available filters.
Important: Different filters are available depending on the dimension you have selected for the key figure.
3.1. Amazon account
Filters the selected key figure and dimension additionally by one or several amazon accounts. For this filter you can select the amazon accounts that are saved in your system. Select a comparison operators on the left and then the desired accounts (check_box).
3.2. Item ID
Filters the selected key figure and dimension additionally by one or several item IDs. Select a comparison operator on the left and enter the desired item IDs into the text field separated by comma.
3.3. Order referrer
Filters the selected key figure and dimension additionally by one or several order referrers. For this filter you can select the order referrers that are available in your system. Select a comparison operator on the left and then the desired order referrers (check_box).
3.4. Order item type
Filters the selected key figure and dimension additionally by one or several order item types. The available selection of order item types depends on the selected key figure and dimension. Select a comparison operator on the left and then the desired order item types (check_box).
3.5. Order status
Filters the selected key figure and dimension additionally by one or several order statuses. For this filter you can select the order statuses that have been setup in your system. Select a comparison operator on the left and then the desired order statuses (check_box).
3.6. Order type
Filters the selected key figure and dimension additionally by one or several order types. The available selection of order types depends on the selected key figure and dimension. Select a comparison operator on the left and then the desired order types (check_box).
Note: If credit notes and returns are selected in this filter, the prices of these order types are subtracted. Also, credit notes and returns are not counted into the quantity of orders, by which the result is divided.
3.7. Paid at
Filters the selected key figure and dimension additionally by the date of receipt of payment. Select a comparison operator on the left. Then determine the desired date or time period on the right.
3.8. eBay account
Filters the selected key figure and dimension additionally by one or several eBay accounts. For this filter you can select the eBay accounts that are saved in your system. Select a comparison operator on the left and then the desired accounts (check_box).
3.9. Revenue account
Filters the desired key figure and dimension additionally by revenue accounts. For this filter you can select the revenue accounts that have been set up in your system. Select a comparison operator on the left and then enter the desired revenue account.
3.10. Created at
Filters the selected key figure and dimension additionally by the creation date of the orders. Select a comparison operator on the left. Then determine the desired date or time period on the right.
3.11. Manufacturer
Filters the selected key figure and dimension additionally by one or several manufacturers. For this filter you can select the manufacturer data records that have been set up in your system. Select a comparison operator on the left and then the desired manufacturer data records (check_box).
3.12. Contact ID
Filters the selected key figure and dimension additionally by one or several contact IDs that are linked with the messages. For this filter you can select the contact IDs that are available in your system. Select a comparison operator on the left and enter the desired contact IDs into the text field separated by comma.
3.13. Warehouse
Filters the selected key figure and dimension additionally by one or several warehouses. For this filter you can select the warehouses that have been set up in your system. Select a comparison operator on the left and then the desired warehouses (check_box).
3.14. Delivery country
Filters the selected key figure and dimension additionally by one or several countries of delivery. For this filter you can select the countries of delivery that have been set up in your system. Select a comparison operator on the left and then the desired countries of delivery (check_box).
3.15. Client
Filters the selected key figure and dimension additionally by one or several clients. For this filter you can select the clients that have been set up in your system. Select a comparison operator on the left and then the desired clients (check_box).
3.16. Invoice country
Filters the selected key figure and dimension additionally by one or several invoice countries. For this filter you can select the countries that are available in your system. Select a comparison operator on the left and then the desired invoice countries (check_box).
3.17. Return reason
Filters the selected key figure and dimension additionally by one or several return reasons. For this filter you can select the return reasons that have been set up in your system. Select a comparison operator on the left and then the desired return reasons (check_box).
3.18. Order property type
Filters the selected key figure and dimension additionally by order property types. Select a comparison operator on the left and then the desired order property type (check_box). If you want to narrow down the selected type even further, use the filter Order property value. By additionally setting this filter, you can define your own values, which are then applied to the type.
3.19. Variation ID
Filters the selected key figure and dimension additionally by one or several variation IDs. Select a comparison operator on the left and enter the desired variation IDs into the text field separated by comma.
3.20. Shipping provider
Filters the selected key figure and dimension additionally by one or several shipping service providers. For this filter you can select the Shipping service providers that have been set up in your system. Select a comparison operator on the left and then the desired shipping service providers (check_box).
3.21. Shipping profile
Filters the selected key figure and dimension additionally by one or several shipping profiles. For this filter you can select the shipping profiles that have been set up in your system. Select a comparison operator on the left and then the desired shipping profiles (check_box).
3.22. Outgoing items booked
Filters the selected key figures and dimensions additionally by whether outgoing items have been booked. Select a comparison operator on the left.
3.23. Date of outgoing items
Filters the selected key figures and dimensions additionally by the date at which outgoing items have been booked. Select a comparison operator on the left. Then determine the desired date or time period on the right.
3.24. Order property value
Is used in combination with the filter Order property type. This combination filters the selected key figure and dimension additionally by order property values that you defined yourself. Select a comparison operator on the left and enter the corresponding values for whichever order property type you selected. Use commas to separate multiple values.