Customer Experience Model (CXM) Assessment
Overview
The cxm_country_assessment contains Customer Experience Model (CXM) KPIs and assessment. This dataset enables you to review your CXM performance. You can review the outcome of the CXM assessment and the performance of the individual KPIs. For more information about CXM and its KPIs, please refer to ZPU.
By design, the dataset cxm_country_assessment does not contain values for ZFS sales channels, which are not subject to CXM.
| Property | Description |
|---|---|
| Data granularity | Country, merchant level, daily |
| History available | Starting 02/01/2025 |
| Update frequency | Twice a day |
| Data Retention | Starting 02/01/2025 |
| Primary keys | dt, country, merchant_id |
| SLOs | First data update: 4:30 UTC; Second data update: 18:30 UTC |
| 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:
cxm_country_assessment_share.direct_data_sharing.cxm_country_assessment
Schema
| Column name | Data type | Description |
|---|---|---|
| dt | Date(yyyyMMdd) | The date of the CXM performance which is based on the rolling seven day period |
| assessment_at | Timestamp(yyyyMMdd HH:mm:ss) | The datetime of the CXM performance which is based on the rolling seven day period |
| account_id | varchar | Zalando Partner account ID |
| legal_entity_name | varchar | The name of the specific legal entity associated with the merchant |
| merchant_id | varchar | The merchant identifier. Also referred to as the Business Partner Identifier (BPID). For more information, see Merchant Identifier in the Developer Guide. |
| merchant_name | varchar | The official name you registered with when you signed up as a partner on Zalando |
| country | varchar | The country of the sales channel through which the offers and the sales were made (e.g. DE for zalando.de, PL for zalando.pl) |
| applied_visibility | varchar | The visibility of your articles in the specific country/sales channel on the date |
| has_KPI_warning | bool | true = the country has 3 substandard KPIs or 1-3 bad KPIs; false = no KPIs is substandard or bad or the underperforming KPI has applied KPI exclusion (see excluded_kpis). |
| cancellation_rate_assessment | varchar | KPI traffic light score for Cancellation Rate. Allowed values: good, substandard, bad, null. The value null indicates that you had no orders placed in the considered timeframe and hence no assessment was conducted |
| tracking_coverage_assessment | varchar | KPI traffic light score for Tracking Coverage. Allowed values: good, substandard, bad, null. The value null indicates that you had no shipments in the considered timeframe and hence no assessments were conducted |
| delivery_on_target_assessment | varchar | KPI traffic light score for Delivery on Target. Allowed values: good, substandard, bad, null. The value null indicates that you had no orders in the considered timeframe and hence no assessments were conducted. OR that your orders were fulfilled by ZSS. |
| reimbursement_on_target_assessment | varchar | KPI traffic light score for Reimbursement on Target. Allowed values: good, substandard, bad, null. The value null indicates that you had no returned orders in the considered timeframe and hence no assessments were conducted. OR that your orders were fulfilled by ZSS or ZRS. |
| test_order_id | varchar | Order id used for Quality Assurance. The value null indicates no test order was placed. |
| test_order_result | varchar | Quality Assurance test order result. The value null indicates no test order was placed. |
| test_order_exception | bool | Flag if any exception occurred during the test order processing. The value null indicates no test order was placed. |
| excluded_kpis | varchar | KPI(s) excluded from the visibility calculation. This means that this KPI has no impact on the country’s visibility. |
| cancellation_rate | float | The share of sold items that were cancelled by you. The value null indicates that you had no orders in the considered timeframe. |
| tracking_coverage | float | The share of shipments where you have provided Zalando with both the correct delivery tracking number and the correct return tracking number. The value null indicates that you had no shipments in the considered timeframe. |
| delivery_on_target | float | The share of tracked parcels successfully delivered within target. The value null indicates that you had no orders in the considered timeframe OR that your orders were fulfilled by ZSS. |
| reimbursement_on_target | float | The share of tracked return parcels successfully reimbursed within target. The value null indicates that you had no returned orders in the considered timeframe OR that your orders were fulfilled by ZSS or ZRS. |