Sales performance

Sales performance data are shared pre-aggregated across multiple different timeframes (e.g. last_7_days, year_to_date) - see the timeframe column. Numerators and denominators of key measures are represented separately to enable re-aggregation at different granularity of dimenions (e.g. brand_name, country). Example measures and their calculation logic are provided in the Example Measures section. Note that Measures should not be re-aggregated across different timeframes.

Table Reference

The table can be accessed using the following data reference:

sales_performance.direct_data_sharing.sales_performance_kpi_pp

Schema

Column	Parquet Type	Description
account_id	String	Zalando Partner account id.
legal_entity_name	String	Legal entity name of the Zalando Partner.
brand_name	String	The name of the brand.
country	String	The sales channel country where this item is being sold (e.g. DE, PL)
target_gender	Integer	The gender the product is intended for (e.g., “1”, "2", "3").
target_age_group	Integer	Age group category (e.g., "1", "2",”8”).
article_type	String	Type of article (e.g., "t_shirt_top", "trouser", "sneaker").
zalando_sku	String	Zalando article variant (e.g. “15248715_LightBlueDenim ON321N1QS-K11”).
season	String	Season classification (e.g., "HW24", "AUTUMN_WINTER_BASICS").
fulfilled_by	String	Type of fulfillment (e.g., "Partner", "ZFS”).
timeframe	String	Time period of data aggregation (e.g., "last_7_days", “year_to_date”). To be used as a rolling day window filter.
nmv_before_returns	Double	Net merchandise value of sold items excluding returns, VAT and missed deliveries in EUR.
offerable_articles	Long	Count of articles that are live and have prices and stock.
available_simples	Long	Number of simples with stock.
total_simples	Long	Total number of simples with or without stock.
gmv_before_cancellation	Double	Gross merchandise value before cancellations in EUR.
sold_items_before_cancellations	Long	Sold items before cancellations.
gmv_before_discount	Double	Gross merchandise value before discount in EUR.
gmv_before_coupon	Double	Gross merchandise value before coupon in EUR.
pdp_views	Long	Unique Product Details page views on the Zalando store.
add_to_basket_clicks	Long	Number of times an item is added to the customer basket.
sold_items_before_returns	Long	Sold items before returns.
created_at	Timestamp	Timestamp when the data is updated. (e.g. 2025-12-02T17:24:04.128 )
gender	String	The gender the product is intended for (e.g. Female, Male, Unisex).
age_group	String	Age group category (e.g, Baby, Kid, Teen, Adult)

Example Measures

Average SKU productivity

The Net Merchandise Volume (NMV) divided by offerable articles.

COALESCE(sum(nmv_before_returns)/NULLIF(sum(offerable_articles), 0), 0)

Average size availability rate

Proportion of sizes with available stock.

LEAST(COALESCE(100*sum(available_simples)/NULLIF(sum(total_simples), 0), 0), 100)

Average item value

The average item value of articles (in EUR).

COALESCE(sum(gmv_before_cancellation)/NULLIF(sum(sold_items_before_cancellations), 0), 0)

Discount rate

The percentage reduction in the original (black) price of an article before coupon deductions.

COALESCE(100*(sum(gmv_before_discount) - sum(gmv_before_coupon))/NULLIF(sum(gmv_before_discount), 0), 0)

Average SKU visibility

PDP views divided by offerable articles.

COALESCE(sum(pdp_views)/NULLIF(sum(offerable_articles), 0), 0)

Add to basket

The percentage of article views where the article was also added to the basket by customers.

LEAST(COALESCE(100*sum(add_to_basket_clicks)/NULLIF(sum(pdp_views), 0), 0), 100)

Conversion rate

Sold items before return divided by the total number of Product Detail Page (PDP) views of a specific merchant and config level article.

LEAST(COALESCE(100*sum(sold_items_before_returns)/NULLIF(sum(pdp_views), 0), 0), 100)

Sample Data Model

Below is a sample data model you can build when combining the dimensions and measures in the previous sections.

Category	Dimension/Measure	Type	Description
Measure	nmv_before_returns	Float	Net merchandise volume of sold items excluding returns, VAT and missed deliveries
	offerable_articles	Integer	Count of articles that are live and complete with price and stock
	avg_sku_productivity	Float	NMV divided by the number of offerable articles
	avg_size_availability_rate	Float	Proportion of sizes with available stock.
	avg_item_value	Float	The average item value of articles in a particular category
	discount_rate	Float	Average price reduction of articles, expressed as a percentage
	pdp_views	Integer	Total Product Detail Page (PDP) views in the Zalando Fashion Store
	avg_sku_visibility	Integer	Product Detail Page (PDP) views divided by offerable articles
	add_to_basket	Float	The percentage of article views where the article was also added to the basket by customers
	conversion_rate	Float	Sold items before return divided by the total number of PDP views
	sold_articles	Integer	Sold items before returns
Dimension	brand	String	The name of the brand.
	gender	String	The gender the product is intended for (e.g., "Male", "Female", "Unisex").
	age_group	String	Age group classification (e.g., "Adult", "Teen”, "Kid") of the article
	country	String	The sales channel country where this item is being sold (e.g. "DE", "PL")
	article_type	String	Type of article (e.g., "t_shirt_top", "trouser", "sneaker").
	season	String	Season classification (e.g., "HW24", "AUTUMN_WINTER_BASICS").
	fulfilled_by	String	Type of fulfillment (e.g., "Partner", "ZFS").
	article variant	String	Zalando article variant from zalando_sku dimension (e.g. “15248715_LightBlueDenim ON321N1QS-K11”)
	timeframe	String	Time period of data aggregation (e.g., "last_7_days", “year_to_date”). To be used as a rolling window filter.
	created_at	Timestamp	Timestamp when the data is updated. (e.g. 2025-12-02T17:24:04.128 )

Contact Support