Orders by customer – Ometria Help Centre

Select Orders by customer when creating or editing an orders report to see list of all orders which meet the requirements of the conditions you’ve set, listed by the customer who placed the order:

Screenshot 2024-10-14 at 13.06.56.png

Select any customer from the list to see their contact details screen.

Choose any combination of columns to view in the report:

Column	Description
Customer ID	The customer’s unique ID.
Name	The customer’s full name.
Email	The customer’s email address.
Number of valid orders	The number of valid orders the customer has placed.
Number of attempted orders	The number of orders attempted - valid and invalid.
Unique customers	The number of unique customers in this report - e.g. if one customer has placed three orders, they are only counted once in this column.
Number of units	The number of items the customer has purchased.
Grand total	The customer’s lifetime spend.
Total unit price	The total unit price for all orders.
Subtotal	The total of all of the order sub totals.
Tax total	The total of all of the tax on all orders.
Shipping total	The total of all the shipping costs on all orders.
Discount total	The total of all discounts on all orders.
Average units per order	Calculated by dividing the total unit price by the number of valid orders.
Average unit price	Calculated by dividing the total unit price by the number of units.
Average order value	Calculated by dividing the grand total by the number of valid orders.

Screenshot 2024-10-14 at 13.10.23.png

Related articles