Data Views
Categories
Data Octopus categories view using IdoSell data: "finished" orders for store ID "1", sales, customers, costs and profit.
View overview – Categories
This data view presents sales performance at the category 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 across categories to identify key revenue contributors and areas needing assortment or marketing improvements.
- 2Compare Orders with unique Clients by category to identify repeat-purchase and loyalty potential.
- 3Examine Avg Basket Position by category to distinguish purchase drivers from complementary products and optimise cross-selling.
- 4Track Item Quantity and Gross Revenue by category to plan inventory and promotions.
- 5Compare net revenue with net_cogs and ecom_profit_level_1 to identify the most and least profitable categories.
- 6Analyse average basket value (Gross Revenue/Orders) to identify premium and budget categories and adjust pricing and promotions.
- 7Compare Item Quantity with Net Revenue by category to identify pricing or assortment optimisation opportunities.
- 8Analyse each category’s share of total sales and profit to assess strategic importance and concentration risk.
Category structure
| Field name | Description |
|---|---|
| category_name | Category name. |
| category_lev_1 | Main category (first categorisation level). |
| category_lev_2 | Subcategory (second categorisation level). |
| category_lev_3 | Detailed category (third categorisation level). |
Category 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. |
Category 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. |