Product Performance Config Daily

Overview

The product_perf_metrics_config_daily 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.

Property Description
Data granularity Config SKU, daily, country level
Primary keys dt, config_sku, country, merchant_id
History available Rolling 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.
SLOs Daily at 9:00 UTC time
Notice period for changes Sunsetting: minimum 2 months;
Versioning: minimum 1 month
Support Support available via zdirect-tech-support@zalando.de.
No 24/7 support available.

Table Reference

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

product_perf_metrics_config_daily_share.direct_data_sharing.product_perf_metrics_config_daily

Note: Column order in this documentation is organized logically and may differ from the physical database schema.

Schema

Column name Format Description
dt date
yyyy-MM-dd		 The date when the config_sku (article) was offered (and sold if applicable).
created_at timestamp
yyyy-MM-dd HH:mm:ss		 The datetime when the data was written to the table (reference timezone: UTC).
updated_at timestamp
yyyy-MM-dd HH:mm:ss		 The datetime when the data was updated in 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
yyyy-MM-dd		 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).
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_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_coupon float Gross Merchandise Value before coupons, cancellations and returns in EUR. This is also known as the red price.
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_perf_metrics_config_daily_share.direct_data_sharing.product_perf_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
) AS average_item_value

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
) AS average_sku_visibility

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
) AS add_to_basket_rate

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
) AS conversion_rate

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
) AS discount_rate

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
) AS offerable_articles

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

CASE WHEN available_simples > 0 THEN 1 ELSE 0 END AS is_offerable

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
) AS size_availability_rate
Contact Support