ChannelEngine: Insights

About this article

This article describes ChannelEngine’s Insights feature, which provides you with real-time data on the state of your business.

Table of contents

Introduction

Setup

Overview

• Summary
• Order
• Channel & Product
• Availability
• Product performance
• Return

Visualization options

• Charts
• Tables

Introduction

Insights is an extension of ChannelEngine’s Statistics page. It includes reports on revenue, sales, orders, product performance, and overall growth metrics. These reports can also be exported, so you can conduct the analysis on your preferred application.

The data that populates the Insights feature is refreshed twice a day, at 06:00 CET and 14:00 CET.

Setup

Insights is available as part of the Scale package, or as an optional add-on to your existing package. To enable this feature in your tenant, contact your customer success manager at ChannelEngine – or contact the Support team.

Overview

The reports are divided across five tabs: Summary, Order, Channel & Product, Return, Availability, and Buy box. Some of these tabs have unique filters, but most filters are available throughout.

• Channel - the channel for which you want to see statistics. E.g.: Truffaut.
• Channel group - the group of channels for which you want to see statistics. E.g.: all Mirakl-based marketplaces or all Amazon marketplaces.
• EAN - the GTIN of the product for which you want to see statistics.
• Merchant product number - the Merchant product number for which you want to see statistics. E.g.: S123K456U789.
• Order date - an exact date or a date range to see only the orders that apply to it. Note that, by default, the timezone is set to Central European Time (CET).
• Product - the product for which you want to see statistics. E.g.: Nitro Smartest smartphone 512 GB.
• Product brand - the product brand for which you want to see statistics. E.g.: Sustainable Suits.
• Product category - the product category for which you want to see statistics. E.g.: solar panels.
• Tenant - one or more tenants for which you want to see statistics.
• VAT selection - include or exclude sales tax from the totals shown.

Summary

The Summary tab contains a rundown of your performance, including gross merchandise value (GMV), the number of published and unpublished products, the stock associated with unpublished products, return rate, and average order value (AOV).

Note that shipping costs are excluded from this overview.

Order

The Order tab contains a chart that can be configured to show the data for a selected period:

• Number of orders
• AOV
• GMV
• GMV (after returns)
• Order value

To compare the revenue and orders per marketplace, refer to the table on the right.

Channel & Product

The tables on the Channel & Product tab show the following data:

• Channels - your revenue per marketplace.
• Brand - your revenue per brand.
• Category - your revenue per category.
• Product - your revenue per product.

Availability

The charts on the Availability tab show the following data for a selected period:

• Stock availability - the percentage of products that are available for sale (i.e.: in stock) out of the total products sold over the period. The period is the last 7 or 30 days. 
  • Weighted availability - percentage of unique products available for sale (i.e.: in stock) out of the total unique products sold. A unique product is defined by its distinct product name. E.g.: if 3 of the same products are sold, the number of unique products is 1.
  • Unweighted availability - percentage of products available for sale (i.e.: in stock) out of the total products sold. It is calculated per product and then averaged across all products.
    
• Quantity sold vs. unique products sold - a comparison between the total number of products sold and the number of unique products sold over the period. The period is the last 7 or 30 days. 

Product performance

The table on the Product performance tab can be configured to list your products according to the following metrics:

• SKU
• GTIN
• Name
• Current stock
• Yesterday's GMV
• Yesterday's stock quantity
• Yesterday's surplus

As well as data from the day before, you can also check data from the past 7 days or 365 days.

Return

The Return tab contains a chart that can be configured to show the following:

• Return %
• Last year (LY) return %
• Return value
• LY return value

Additionally, you can see:

• A table listing the number of returns marketplace, Merchant product number, product name, etc.
• A table listing the most common return reasons per marketplace.

Visualization options

ChannelEngine’s Insights tool offers multiple ways to engage with your data, depending on the type of chart you are interacting with. Tables also offer a few options.

Charts

Drill up

To use this option, hover your mouse over a chart and click the Drill up button (↑). Alternatively, you can right-click a data point in the chart and select Drill up. Your chart is then updated to display the data one level higher. E.g.: to switch from orders in a specific month to orders for the year.

Drill down

To enable this option, hover your mouse over a chart and click the Drill down button (↓). You can then click a data point in the chart to display the data one level lower. Alternatively, you can right-click a data point in the chart and select Drill down. E.g.: to switch from orders for the year to orders in a specific month.

Go to the next level in the hierarchy

To use this option, hover your mouse over a chart and click the Go to the next level in the hierarchy button (↓↓). Your chart is then updated to display the data one level lower. E.g.: from years to months.

Expand all, down one level in the hierarchy

To use this option, hover your mouse over a chart and click the Expand all, down one level in the hierarchy button (it looks like a downward-facing fork). Alternatively, you can right-click a chart and select Expand to next level. Your chart is then updated to display all available data one level lower. E.g.: from years to months.

Focus mode

To enable this option, hover your mouse over a chart and click the Focus mode button (it looks like an ‘open in another window’ button). The chart is then displayed across the entire screen, so you can better visualize it. To go back to the previous visualization, click Back to report in the top-left corner of the chart.

Tables

To access the options available for tables, click the three-dot menu in the top-right corner of a table.

Export data

Select this option to export the data within a table. You can choose to export it with the current layout (in the XLSX format) or in a summarized way (in the CSV or XLSX format).

Show as a table

Select this option to display the table across the entire screen, so you can better visualize it. To go back to the previous visualization, click Back to report in the top-left corner of the table.

Spotlight

Select this option to display the table by itself, in its current size, so you can better visualize it. To go back to the previous visualization, click the three-dot menu and select Spotlight again.

Sort descending

Select this option to sort the data in the table from the highest value to the lowest value.

Sort ascending

Select this option to sort the data in the table from the lowest value to the highest value.

Sort by

Select this option to sort the data in the table according to one of the parameters within it. E.g.: AOV, number of orders, etc.