Orders list in the orders report – Ometria Help Centre

The Orders list in the orders report tab presents a list of all orders which meet the requirements of the conditions you’ve set (above).

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

You can select the columns you want to appear:

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.
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 items	The number of items included in the 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.
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. Find out more here.

Related articles