Orders grouped in the orders report – Ometria Help Centre

Select Orders grouped when creating or editing an orders report to see list of all orders which meet the requirements of the conditions you’ve set, grouped by whichever criteria you select:

Screenshot 2024-10-14 at 14.12.11.png

Note: The Orders grouped report does not include invalid orders in its totals. The Orders list report does.

Screenshot 2024-10-14 at 14.13.24.png

Metrics to group by

You can group the data in this report using any combination of the following:

Group by	Description
Date placed	Group orders by the date they were placed.
Hour placed	Group orders by the hour they were placed (24 hour clock).
Day of the week placed	Group orders by the day of the week they were placed on.
Month placed	Group orders by the month they were placed in.
Year/Month placed	Group orders by the month and year they were placed, e.g. 04-2020.
Year placed	Group orders by the year they were placed.
Store	Group orders by the store the customer ordered from.
Order channel	Group orders based on the channel through which they received the campaign their orders attributed to, e.g. email, SMS, push.
Coupon code	Group orders by coupon code use.
Shipping type	Group orders by shipping type, e.g. DHL, ParcelForce, ClickAndCollect
Billing country	Group orders based on the country in the billing address.
Shipping country	Group orders based on the country in the shipping address.
Is valid?	Group based on whether an order is valid (True) or invalid (False).
Status	Group based on the order status, e.g. pending, complete, cancelled.
Shipping method	Group orders based on the shipping method.
Payment method	Group orders based on the payment method the customer used, e.g. CreditCard, Paypal, etc.
Visit medium	Group orders based on the medium they are attributed to, e.g. Ometria email, social, cpc (cost per click), search, referral, etc.
Visit campaign	Group orders based on the campaign they are attributed to - if this cannot be found based on UTM parameters, this column will read 'Not provided'.
Visit domain	Group orders based on the domain URL the order is attributed to, e.g. google.com, facebook.com, your website, etc.
Visit name	Group orders based on the domain they are attributed to, e.g. ometria, google, yahoo, facebook, etc.
Device type	Group orders based on the device the customer used to place them, e.g. computer, tablet, mobile etc.
Broadcast campaign	Group orders based on the broadcast campaign they are attributed to (if any).
Customer order sequence	Group orders based on the position of an order in a customer’s sequence of orders - e.g. first order, fourth order etc.
Billing city	Group orders based on the city in the billing address (i.e. City of last order).
Shipping state	Group orders based on the state in the shipping address.
Shipping city	Group orders based on the city in the shipping address.
Geo shipping place	Group orders based on the town/city name. This data is taken from the Shipping city field and then 'cleaned up' (spelling and capitalisation standardised).
Geo shipping region	Group orders based on the country/state name. This data is taken from the Shipping country and state fields and then 'cleaned up' (spelling and capitalisation standardised).
Geo shipping subregion	Group orders based on the county name. This data is taken from the county submitted with the order and then 'cleaned up' (spelling and capitalisation standardised).
Attribution	Group based on order order attribution. Examples: Ometria/Email - for orders attributed to Ometria cpc/google - for cost per click via a search engine search/google - for direct searches social/facebook - for social media clicks Not provided or Not tracked - when neither the visit medium or name are known. See: Attribution in the orders report
Ometria campaign	Group orders based on the Ometria campaign they're attributed to. See: Attribution in the orders report
Ometria campaign type	Group orders based on the Ometria campaign type they're attributed to: Automation Broadcast

Metrics to view

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

Column	Description
Store country	The store country for this group, based on the definitions in your store settings.
Store state	The store state for this group, based on the definitions in your store settings.
Store marketing region	The store marketing region for this group, based on the definitions in your store settings.
Store categories	The store category for this group, based on the definitions in your store settings.
Store sizes	The store size for this group, based on the definitions in your store settings.
Attempted orders	The number of orders attempted in this group, i.e. both valid and invalid.
Valid orders	The number of valid orders in this group.
First time orders	The number of orders in this group which were the first orders for that customer.
Total units sold	Total number of products included in orders for this group.
Unique customers	Total number of unique customers who placed orders in this group, e.g. if Sue Smith placed two separate orders, she will only be counted as one customer.
Total tax	The total amount of tax paid on orders in this group.
Total shipping	The total shipping costs for orders in this group.
Total discount	The total value of discounts for orders in this group.
Subtotal	The sub total revenue from orders in this group (i.e. just the cost of the products in the orders). 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.
Grand total	The total revenue from orders in this group (including tax, shipping etc.) This value doesn't include invalid orders, but the grand total in the Orders list does. See also: Why does the revenue in the orders report differ from campaign performance?
Average order value	The average order value (AOV) for customers in this group. See also: Average order value (AOV)
Average customer spend	The average customer spend for customers in this group, calculated by dividing the group's grand total by the number of unique customers in the group.
Average units per order	The average number of units per order for this group, calculated by dividing the total units sold by the number of valid orders.
Average order frequency	The average order frequency for customers in this group, calculated by dividing the number of valid orders by the number of unique customers.
Total unit price	The total price of all units sold in orders placed by this group.
Average unit price	The average unit price for customers in this group, calculated by dividing the total unit price by the total units sold.

Metrics to group by

Metrics to view

Related articles