VIEW DESCRIPTION - PRODUCTS
Data view presenting sales results at the product level, based on data from the IdoSell e-commerce engine. The analysis covers transactions from store ID "1", focusing on orders with "finished" status.
The report aggregates data from all integrated sales channels, providing a complete picture of purchasing activity. The report includes orders from various sources, including:
Standard transactions made directly through the online store
Sales through marketplace platforms (Allegro, Empik, Amazon)
Orders manually entered by store staff
Transactions processed through the POS system It should be noted that the visibility of sales data is strictly tied to the integration configuration in the IdoSell system. This means that orders from external platforms (e.g., Allegro) will only be visible in the report when they are actively processed by the store engine.
TEMPORAL DATA RANGE
The report is created based on the last 30 days counted from yesterday.
SAMPLE INSIGHTS FROM THE DATA VIEW:
Analyze Net Revenue of individual products to identify best-selling items and assess their impact on overall sales performance.
Compare the number of Orders with the number of Clients to detect products frequently purchased by the same customers, which may indicate potential for loyalty programs or subscription sales.
Examine the Average Basket Position to understand which products most often initiate purchases and which are bought as complementary products.
Compare Item Quantity with Gross/Net Revenue to identify products with the highest sales effectiveness.
Monitor Product Age in Days along with sales results to evaluate how the product's length of presence in the offer affects its popularity.
Compare Gross/Net Revenue with Net Cost of Goods to identify products with the highest margins.
Track Quantity All Stocks in the context of sales to optimize inventory management and avoid stockouts of popular products.
Analyze Profit Level 1 in conjunction with the number of orders and clients to identify products most effectively contributing to business profitability.
DATA SCHEMA SPECIFICATION
Product Identifiers:
id - Unique identifier of the product variant in the system.
item_group_id - Product group identifier, used to link different variants of the same product.
title - Full product name displayed in the store.
brand - Product brand.
Product Categorization:
category_lev_1 - Main product category (first level of categorization).
category_lev_2 - Product subcategory (second level of categorization).
category_lev_3 - Detailed product category (third level of categorization).
Sales Data:
orders - Total number of orders for the product.
clients - Number of unique customers who purchased the product.
item_quantity - Total quantity of product units sold.
item_order_gross_value - Gross sales value.
item_order_net_value - Net sales value. Analytical Data:
avg_basket_position - Average position of the product in the shopping cart.
net_cogs - Net Cost of Goods Sold.
ecom_profit_level_1 - First-level profit, after considering product purchase costs. Inventory Management:
product_quantity_all_stocks - Total available quantity of the product across all warehouses.
product_age_days - Product age in days (number of days since introduction to the offer).