Product Performance Config Daily

Overview

The product_performance_metrics_config_daily.share contains selected daily commercial figures and selected attributes for Config SKUs (i.e., colour variants - SKUs that include colour-level information, such as a red t-shirt) that you offer. The commercial figures provided can be used to calculate additional KPIs (including KPIs shared via zDirect). For more details, see the Example measures section. This dataset enables you to review your daily performance.

Key information

Property	Description
Data granularity	Config SKU, daily, country level
History available	Past 45 days
Update frequency	Daily. The entire 45-day window is refreshed daily, so values for past dates may change within this window.
Data retention	Rolling 45 days. You must persist historical data on your side for long-term analysis.
Primary keys	dt, config_sku, country, merchant_id

Table Reference

The table can be accessed using the following data reference from delta sharing client applications:

product_performance_metrics_config_daily_share.direct_data_sharing.product_performance_metrics_config_daily

Schema

Column	Format	Description
dt	Date (yyyyMMdd)	The date when the config_sku (article) was offered (and sold if applicable).
created_at	Timestamp (yyyyMMdd HH:mm:ss)	The timestamp when the data was written to the table (reference timezone: UTC).
account_id	string	The Zalando Partner account ID.
config_sku	string	Zalando's reference code for a SKU (Stock Keeping Unit) at the article and colour level. A config SKU might have multiple sizes (referred to as Simple SKUs).
merchant_sku	string	Your reference code for a SKU (Stock Keeping Unit) at the article and colour level.
legal_entity_name	string	The name of the specific legal entity associated with the merchant.
merchant_id	string	The merchant identifier. Also referred to as the Business Partner Identifier (BPID). For more information, see Merchant Identifier in the Developer Guide.
country	string	The country of the sales channel through which the offers and sales were made (e.g., DE for zalando.de, PL for zalando.pl).
brand_name	string	The name of the brand.
target_gender	string	The gender the product is intended for (e.g., female, male, unisex). This is provided during article creation.
target_age_group	string	The age group the product is intended for (e.g., baby, kid, teen, adult). This is provided during article creation.
article_type	string	The article type as defined on Zalando. This is provided during article creation and refers to groups of products (e.g., trousers, skirts).
category	string	The category of a product (e.g., clothing, accessories).
season	string	The season the article belongs to.
first_date_offered	Date (yyyyMMdd)	The earliest date on which an article became available for customers to buy. This might not be the first time you offered the article.
days_offered	int	The number of calendar days that an article is in stock and available for sale. If your article goes offline for any reason (e.g. CXM deactivation, no stock) these days will not be counted.
listed_by	string	Who has listed the article, though they may not be currently selling it.
fulfilled_by	string	Who is fulfilling the article (e.g., Partner, ZFS).
offerable_articles	int	Whether an article is offerable (value = 1) or not offerable (value = 0). An article is considered offerable if it fulfills the following conditions: The article has a price set; The article is available, meaning it is not blocked (e.g., blocked by CXM); Your offer is ranking first in the Offer Selection. The article may or may not have stock.
available_simples	int	The number of Simple SKUs with stock.
total_simples	int	The number of Simple SKUs with or without stock and price.
pdp_views	int	The total unique views of a product detail page (PDP). Unique views are defined as per session per user.
add_to_basket_clicks	int	The number of times an item is added to the customer basket.
gmv_before_coupon	float	Gross Merchandise Value before coupons, cancellations and returns in EUR. This is also known as the red price.
gmv_before_discount	float	Gross Merchandise Value before discounts, coupons, cancellations and returns in EUR. This is also known as the black price (at unit level).
gmv_before_cancellation	float	Gross Merchandise Value before cancellations and returns in EUR.
nmv_before_returns	float	Net Merchandise Value is the monetary value of sold items, before any returns, and excludes VAT. Note: if there are missing deliveries and a customer does not receive their item, then sold items = 1 but NMV = 0.
sold_items_bef_cancellation	int	Number of items sold before cancellations and before returns.
sold_items_bef_return	int	Number of items sold before returns (but after cancellation).

Example measures

Below, we provide key KPIs that you can calculate using only the table product_performance_metrics_config_daily. To ensure you calculate the values correctly, please use the code snippets below.

Average item value

The average gross value after discount and coupon to which an item is bought by the customer.

COALESCE(
    sum(gmv_before_cancellation::double) / 
    NULLIF(sum(sold_items_bef_cancellation::double), 0), 
    0
)

Average SKU productivity (based on NMV before return)

The Net Merchandise Volume (NMV) before return realised on average by buyable Config SKUs.

COALESCE(
    sum(nmv_before_returns::double) / 
    NULLIF(COUNT(DISTINCT CASE WHEN available_simples > 0 THEN config_sku END), 0), 
    0
) AS sku_productivity

Average SKU visibility

The average visibility received by buyable Config SKUs.

COALESCE(
    sum(pdp_views::double) / 
    NULLIF(COUNT(DISTINCT CASE WHEN available_simples > 0 THEN config_sku END), 0), 
    0
)

Add to basket rate

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

LEAST(
    COALESCE(
        100 * SUM(add_to_basket_clicks::double) / 
        NULLIF(SUM(pdp_views::double), 0), 
        0
    ), 
    100
)

Conversion rate

Sold items relative to the views of Product Detail Pages (PDPs).

LEAST(
    COALESCE(
        100 * sum(sold_items_bef_return::double) / 
        NULLIF(sum(pdp_views::double), 0), 
        0
    ), 
    100
)

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
)

Offerable Articles (zDirect)

Aggregated level: The total number of articles live with price and stock.

COALESCE(
    COUNT(DISTINCT CASE WHEN available_simples > 0 THEN config_sku END), 
    0
)

Config level: Whether the article is live with price and stock.

CASE WHEN available_simples > 0 THEN 1 ELSE 0 END

Size Availability Rate

The share of sizes with available stock out of the total number of sizes initially offered by you during article creation. If there are 5 sizes initially offered in total and only 3 have available stock, the size availability rate would be 60%.

LEAST(
    COALESCE(
        100 * SUM(available_simples::double) / 
        NULLIF(SUM(total_simples::double), 0), 
        0
    ), 
    100
)

Contact Support