NEW! There is now a training video guide available for the products report at the end of this article!
On this page:
The products report presents a list of all of your sold products, based on the date range and filters you select.
By default, the products report is ordered by product revenue.
Go to Reports > Products report:
Once you’ve configured the products report to your liking, you can select Export at any time and download the report as a CSV file or an .XLSX file (optimised for MS Excel).
You can set your date range for reporting at the top of this screen:
Select from any of the following options:
- Last 7 days
- Last 28 days
- Last 12 months
- This week
- Last week
- This month
- Last month
- This year
- Last year
Or select Custom Range and define the time period yourself:
To filter the data displayed in the orders report you can select a saved segment from the Showing data for drop-down:
You can use the Customer Filter to further filter your contacts (either in a specific segment, or all contacts):
Use the Product Filter to filter your products:
The Product Filter has the following filter conditions:
Filter products based on their SKU (stock keeping unit).
Filter products based on their name.
Filter products based on attributes.
Attributes are defined by you in your ecommerce platform and passed into Ometria.
Reading the products report
The Group by drop-down provides different ways to aggregate your product data.
These options are based on the attributes you have set up in your ecommerce platform.
You can select any combination of metrics from the columns drop-down:
The unique ID for this product.
An image of the product, if available.
The product’s title/name.
The product’s stock-keeping unit.
The total number of units sold (based on any conditions set).
The number of unique orders.
E.g. If Sophie has ordered two jars of the same moisturiser in one transaction, it will only count as one unique order.
The number of unique customers who have purchased this product at least once.
E.g. If Sophie has ordered the same moisturiser three times over her customer lifecycle, she only counts as one unique customer.
The total revenue earned from this product (based on any conditions set), excluding tax.
Product revenue with tax
The total revenue earned from this product (based on any conditions set), including tax.
The total discounts on all orders for this product.
Average revenue per unit
The average revenue per product sold.
First time orders
The number of customers’ first time orders which included this product.
Average units per customer
The average number of this product customers have ordered.
Based on the number of orders placed divided by the number of customers who ordered the product.
Percentage first time orders
The percentage of customers’ first time orders which included this product.
The current price of this product.