ChannelEngine: revenue (statistics)
About this article
This article describes the Revenue tab of the Statistics module and how to use it to monitor your gross and net merchandise value across orders and products.
Table of contents
Introduction
The Revenue tab of the Statistics module provides a high-level summary of your sales performance. Use the Revenue tab to monitor key revenue metrics and compare current data with previous periods.
The tab has two view modes: Per order and Per product. Each mode has its own filters and widgets.
Requirements
- To use the Segments filter and the segment performance widgets in the Per product view, provide values for the Segment field via a product feed or the Merchant API endpoints. See ChannelEngine: product segments for details.
- To calculate Surplus, activate pricing v2 on your connected channels.
Revenue metrics
In both view modes, the metric selector offers the following options:
- Total GMV including VAT - total gross merchandise value (GMV) including the sales tax/VAT. This reflects the total gross revenue from all customer checkouts before deductions, such as returns or cancellations, are factored in.
- Total GMV excluding VAT - total GMV minus the sales tax/VAT. Use this to track top-line sales growth independently of regional tax rates.
- Total GMV after cancellations including VAT - total GMV including the sales tax/VAT. This metric deducts cancellations only.
- Total GMV after cancellations excluding VAT - total GMV minus the sales tax/VAT. This metric deducts cancellations only.
- Total NMV including VAT - net merchandise value (NMV) including the sales tax/VAT. This metric deducts cancellations and refunds.
- Total NMV excluding VAT - NMV minus the sales tax/VAT. This metric deducts cancellations and refunds.
View modes
In the top right corner of the tab, use the view mode selector to switch between Per order and Per product. The view mode determines which filters and widgets are available:
- Per order - revenue aggregated at order level. Use this view to monitor your KPIs, track performance over time, and compare channels and delivery countries.
- Per product - revenue aggregated at product level. Use this view to find the brands, segments, channels, and individual products that drive your revenue.
Per order view
The Per order view contains four key metric cards, a performance graph, a channel performance section, and a country performance section.
The channel and country sections each contain a pie chart and a table. In the pie charts, the center displays the combined total for the selected period and filters; each color-coded segment represents a share of the selected metric, and the legend below the chart lists the items included. Hover over a segment to see its detailed metrics.
Key metrics
At the top of the tab, four cards highlight your KPIs. Each card displays the current total, the percentage change (increase or decrease), and a comparison value from the previous period, e.g.: the same days of last month.
- Your selected metric, e.g.: GMV, showing your total sales during the selected period.
- Orders - the total number of orders placed during the selected period.
- AOV (Average Order Value) - the average amount spent per order.
- Surplus - the revenue earned by selling a product above its minimum price. Calculated as:
Surplus = (Selling price - Min. price) × Quantity sold.
Performance graph
The main line graph shows your performance over the selected time period. In the top right corner of the graph, use the toggle to choose which data the graph displays:
- Revenue (default) - the metric selected in the metric selector, e.g.: Total GMV including VAT.
- Orders - the total number of orders placed during the selected period.
In both cases, the graph plots two lines:
- Current period (solid blue line) - data for the selected time period up to the current date.
- Previous period (dotted gray line) - data from the equivalent previous period. Use it to spot seasonal trends and changes in trajectory.
If there is no period available for comparison, you only see a blue graph for the current period – and the comparison statistics remain empty.
Channel performance
Use the Breakdown per channel table and the related pie chart to track which channels drive your sales. The pie chart shows how the selected metric, e.g.: GMV including VAT, is distributed across your connected channels.
The Breakdown per channel table presents the selected metric for each connected channel, along with the order count, surplus, and AOV. Click on a value in Orders to open the related orders.
Country performance
Use the Breakdown per delivery country table and the related pie chart to track where your orders are delivered and inform your logistics decisions. The pie chart shows how the selected metric, e.g.: GMV including VAT, is distributed across delivery countries.
The Breakdown per delivery country table shows the selected metric, order count, surplus, and AOV for each delivery country. Click on a value in Orders to open the related orders.
Orders
To see which orders make up an order count, click on a value in the Orders column. A modal opens with all orders that match your filters and the selected row. E.g.: all orders placed on Kaufland last month.
The modal lists orders from newest to oldest, with the following columns: order number, status, order date, channel, country, revenue, and surplus. You can click on an order number to open the order details page.
To narrow down the list, use the search bar or the Country or Channel filter.
Per product view
The Per product view shows your sales performance broken down by brand, segment, channel, and individual product.
The brand, segment, and channel sections each contain a pie chart and a table. The pie charts work the same way as in the Per order view.
Brand performance
The Breakdown per brand table and the related pie chart show performance metrics for each brand in your catalog. Use this section to identify your best- and worst-performing brands.
Segment performance
The Breakdown per segment table and the related pie chart show performance metrics for each of your custom product groups. Use this section to identify which segments bring you revenue.
Channel performance
The Breakdown per channel table and the related pie chart show performance metrics for each connected channel, based on product-level data.
Product performance
The Breakdown per product table at the bottom of the tab shows performance metrics for individual products in your catalog. To find a specific product, use the search bar at the top of the tab.
The table contains six columns:
- Image - a thumbnail preview of the product. If no image is available, a placeholder is displayed.
- Details - the product name and its identifiers, such as the merchant product number and GTIN.
- Quantity count - the total number of units ordered for that product during the selected period.
- [Selected metric] - the selected metric for that product, e.g.: Total GMV including VAT.
- Surplus - the surplus earned on that product.
- ASP (Average Selling Price) - the average price at which units of that product were sold during the selected period.
Filters
In the top right corner of the tab, use the filters to narrow down the data. The available filters depend on the selected view mode. To reset all filters, click Clear filters.
Filters in the Per order view
- Channel - filter metrics by a specific channel.
- Time period - select the time frame you want to analyze. E.g.: today, this month, last month. If no suitable option is available, select Custom and configure your start and end dates as well as your time zone.
- Metric selector - select which metric to display across the tab. See Revenue metrics.
Filters in the Per product view
The Per product view has the same filters as the Per order view, plus a search bar and two more filters:
- Search - search for a specific product. Enter a search term and select what to search in from the dropdown next to the field. E.g.: Product info (contains).
- Segments - filter metrics by a segment. A segment is a custom product grouping that you define to view statistics for a specific subset of your catalog. E.g.: shoes.
- Labels - filter metrics by one or more product labels. See ChannelEngine: product labels for details.
Sorting
By default, each table is sorted by the selected metric, from highest to lowest.
Click the Sort order icon (the triangles) next to a column name, and click it again to reverse the order. The icon shows the active sort order: an upward triangle for ascending (lowest to highest) and a downward triangle for descending (highest to lowest).
- Numeric columns - e.g.: Orders, Quantity count, Surplus. Sort in ascending or descending order.
- Text columns - e.g.: Name, Brand, and Country. Sort alphabetically from A to Z or from Z to A.
FAQs
How frequently are the statistics on this tab updated?
ChannelEngine aggregates order line data and updates the statistics once per hour.
Why do the totals differ between the Per order and Per product views?
The Per order view includes shipping costs in its totals, and the Per product view does not. This means totals in the Per product view may be lower than in the Per order view for the same filtered dataset.
Which time zone do the statistics use?
ChannelEngine uses the time zone you selected with the Custom time period. If you did not select one, it uses the time zone configured in Account settings, My profile, which defaults to your browser time zone. See ChannelEngine: how to configure a timezone.
Comments
0 comments
Article is closed for comments.