Data Views
Brands
Data Octopus brands view using IdoSell data: "finished" orders for store ID "1", sales, customers, costs and profit.
View overview – Brands
This data view presents sales performance at the brand level using IdoSell store-engine data. It covers transactions for store ID "1", focusing on orders with status "finished". The report aggregates all integrated sales channels to provide a full picture of purchasing activity.
Sales-data visibility depends on IdoSell integration settings. Orders from external platforms (such as Allegro) appear only when processed by the store engine.
Data date range
The report covers the last 30 days, ending yesterday.
Example insights from the data view
- 1Analyse Net Revenue by brand to identify leading manufacturers and their contribution to store sales.
- 2Compare Orders with unique Clients by brand to identify customer loyalty and repeat purchases.
- 3Examine Avg Basket Position by brand to understand primary purchase drivers versus complementary purchases.
- 4Compare Item Quantity with Gross/Net Revenue by brand to identify sales efficiency and unit order value.
- 5Analyse Gross/Net Revenue with Net Cost of Goods to identify the highest-margin brands.
- 6Monitor Profit Level 1 against sales quantity to identify the most profitable brands.
- 7Compare each brand’s share of total sales to assess dependence on manufacturers and business risk.
- 8Divide revenue by orders to compare average order value and identify premium and budget brands.
- 9Use brand margin data to negotiate supplier terms and optimise the product portfolio.
Identification
| Field name | Description |
|---|---|
| brand | Product brand name in the system. |
Brand sales data
| Field name | Description |
|---|---|
| orders | Total number of orders containing the product or products in this group. |
| clients | Number of unique customers who purchased the product or products in this group. |
| item_quantity | Total quantity of items sold for the product or group. |
| item_order_gross_value | Total gross sales value (including tax) for the product or group. |
| item_order_net_value | Total net sales value (excluding tax) for the product or group. |
Brand analytical data
| Field name | Description |
|---|---|
| avg_basket_position | Average position of the product or products in this group in shopping baskets. |
| net_cogs | Total net cost of goods sold (COGS) for the product or group. |
| ecom_profit_level_1 | Level 1 profit after product acquisition costs, aggregated for this product or group. |
Related articles