Orders list in the orders report – Ometria Help Centre

Select List when creating or editing an orders report to see list of all orders which meet the requirements of the conditions you’ve set:

Screenshot 2024-10-14 at 14.16.42.png

You can select any order from the list to see the order details screen.

select order.gif

Metrics to view

Select the metrics to display as column headings in your report:

Column	Description
ID	The order ID.
Web ID	This is for cases where the orders placed on your site have a different ID from the one used in your ecommerce platform.
Order date	The date the order was placed.
Customer ID	The ID of the contact that placed the order.
Customer email	The email address of the contact that placed the order.
Customer name	The full name of the customer that placed the order.
Customer first name	The first name of the customer that placed the order.
Customer last name	The last name of the customer that placed the order.
Valid	Whether or not the order was valid or invalid.
Order status	The current status of the order: Open Cancelled Complete Pending
Order number	The position of the order in a customer’s sequence of orders - e.g. 1 = first order, 2 = second order, etc.
Grand total	The total revenue of the order (including tax, shipping etc.) This value includes invalid orders. The grand total in Orders grouped does not include invalid orders. See also: Why does the revenue in the orders report differ from campaign performance?
Sub total	The sub total revenue from the order (i.e. just the cost of the products in the order). Note: This value is calculated differently based on your integration (and your preferences if you have a custom integration). For most integrations it includes discount but not tax and shipping.
Tax	The tax paid on the order.
Shipping	The shipping cost for the order.
Discount	The total discounts for this order.
Local currency	The currency used by the customer’s home store, e.g. GBP, USD etc.
Local grand total	The total revenue of the order (including tax, shipping etc.) in the customer’s local currency.
Local sub total	The sub total revenue from the order (i.e. just the cost of the products in the order) in the customer’s local currency. Note: This value is calculated differently based on your integration (and your preferences if you have a custom integration). For most integrations it includes discount but not tax and shipping.
Local tax	The tax paid on this order in the customer’s local currency.
Local shipping	The shipping paid on this order in the customer’s local currency.
Local discount	Any discounts on this order in the customer’s local currency.
Number of units	The number of items included in the order.
Average unit price	The average unit price for this order, calculated by dividing the total unit price by the number of units.
Total unit price	The total unit price for this order.
Shipping method	The shipping method used to send the order, e.g. DHL, ParcelForce, ClickAndCollect.
Payment method	The payment method the customer used, e.g. CreditCard, PayPal etc.
Visit medium*	The medium this order is attributed to, e.g. Ometria email, social, cpc (cost per click), search, referral, etc. This column is useful if you are primarily interested in last click attribution.
Visit name	The name of the domain the order is attributed to, e.g. google, yahoo, facebook, etc.
Visit campaign*	The campaign this order is attributed to - if this cannot be found based on UTM parameters, this column will read 'Not provided'.
Visit domain*	The domain url the order is attributed to, e.g. google.com, facebook.com, your website, etc.
Device type	The device used by the customer to place the order, e.g. computer, mobile etc.
Coupon code	The coupon code (if any) used to pay for part/all of the order.
Store	The store the customer ordered from.
Store country	The store country, based on the definitions in your store settings.
Store state	The store state, based on the definitions in your store settings.
Store marketing region	The store marketing region, based on the definitions in your store settings.
Store categories	The store category, based on the definitions in your store settings.
Store sizes	The store size, based on the definitions in your store settings.
Attribution	The channel through which the order came - e.g. Ometria email, Visit (referral), Visit (social), Visit (cpc).
Ometria campaign	The name of the Ometria campaign this order is attributed to (if any).
Ometria campaign type	The type of campaign (broadcast or automation) this order is attributed to (if any).

*The fields ‘Visit name’, ‘Visit medium’ and ‘Visit domain’ can be used for order attribution.

Metrics to view

Related articles