NEW! There is now a training video guide available for the products report at the end of this article!

On this page:


Overview

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:

  • Today
  • Yesterday
  • 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:

ConditionDescription

Product sku

Filter products based on their SKU (stock keeping unit).

Product name

Filter products based on their name.

Product attribute

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:

ColumnDescription

Product ID

The unique ID for this product.

Image

An image of the product, if available.

Product title

The product’s title/name.

Product SKU

The product’s stock-keeping unit.

Units sold

The total number of units sold (based on any conditions set).

Unique orders

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.

Unique customers

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.

Product revenue

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.

Product discount

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.

Price

The current price of this product.



Video guide

.