Glossary
This glossary provides a complete overview of all data fields available in Delivery Services. Each section contains a structured table with field names and their descriptions, helping you understand exactly what each field or metric represents. All fields listed here are also directly accessible within Looker: you can view the same definitions by opening the Delivery Services Explore and clicking the info icon next to any field. This article brings all descriptions together in one place for easier browsing, filtering, and documentation purposes.
Last updated 2nd March 2026.
Carrier
| Field Name | Description |
|---|---|
| Carrier Name | The combination of the name and the country of the carrier. Based on data provided by the shop. |
| Country | Country of the Carrier (e.g Shipping with Colissimo to France, Country = France. But sending with DHL Express Germany to France Country = Germany) |
| Country [ISO2] | The country of the carrier represented as a 2 letter country code. |
| Count [#] | The number of individual carriers. Depending on the chosen fields and filters. |
| Share [%] | The share of individual carriers. Depending on the chosen fields and filters. |
Claim Service by 7S
| Field Name | Description |
|---|---|
| Claim Status | The current status of the claim. |
| Credit Notes Credit Note Number | |
| Credit Notes Status | Status of a credit note; draft or approved. |
| Declined Reason | Reason why the claim was declined. |
| Tags Is claim.me claim (Yes / No) | Non 7S claim flag is true. |
| Net Value | The net value of the consumer invoice in original currency. |
| Net Value Currency | Currency in which the net value is in. |
| Type | The type of claim chosen during submitting a claim via the Seven Senders Portal: investigation, whole damage or partial damage. |
| 🕒 Carrier Claim Acceptance Date Date | The date the carrier accepted the liability and agreed to pay compensation. |
| 🕒 Carrier Claim Acceptance Date Day of Week | The date the carrier accepted the liability and agreed to pay compensation. |
| 🕒 Carrier Claim Acceptance Date Month | The date the carrier accepted the liability and agreed to pay compensation. |
| 🕒 Carrier Claim Acceptance Date Quarter | The date the carrier accepted the liability and agreed to pay compensation. |
| 🕒 Carrier Claim Acceptance Date Time | The date the carrier accepted the liability and agreed to pay compensation. |
| 🕒 Carrier Claim Acceptance Date Week | The date the carrier accepted the liability and agreed to pay compensation. |
| 🕒 Carrier Claim Acceptance Date Year | The date the carrier accepted the liability and agreed to pay compensation. |
| 🕒 Claim Created Date Date | The time the claim was created via the Seven Senders Portal. Presented in the chosen format. |
| 🕒 Claim Created Date Day of Week | The time the claim was created via the Seven Senders Portal. Presented in the chosen format. |
| 🕒 Claim Created Date Hour of Day | The time the claim was created via the Seven Senders Portal. Presented in the chosen format. |
| 🕒 Claim Created Date Month | The time the claim was created via the Seven Senders Portal. Presented in the chosen format. |
| 🕒 Claim Created Date Quarter | The time the claim was created via the Seven Senders Portal. Presented in the chosen format. |
| 🕒 Claim Created Date Time | The time the claim was created via the Seven Senders Portal. Presented in the chosen format. |
| 🕒 Claim Created Date Time of Day | The time the claim was created via the Seven Senders Portal. Presented in the chosen format. |
| 🕒 Claim Created Date Week | The time the claim was created via the Seven Senders Portal. Presented in the chosen format. |
| 🕒 Claim Created Date Week of Year | The time the claim was created via the Seven Senders Portal. Presented in the chosen format. |
| 🕒 Claim Created Date Year | The time the claim was created via the Seven Senders Portal. Presented in the chosen format. |
| 🕒 Claim Drafted At Date Date | The date when the draft version of the claim was created. |
| 🕒 Claim Drafted At Date Day of Week | The date when the draft version of the claim was created. |
| 🕒 Claim Drafted At Date Month | The date when the draft version of the claim was created. |
| 🕒 Claim Drafted At Date Quarter | The date when the draft version of the claim was created. |
| 🕒 Claim Drafted At Date Time | The date when the draft version of the claim was created. |
| 🕒 Claim Drafted At Date Week | The date when the draft version of the claim was created. |
| 🕒 Claim Drafted At Date Year | The date when the draft version of the claim was created. |
| 🕒 Claim Submitted At Date Date | The date when a claim was submitted. Draft claims that have not been completed will not have this date populated. |
| 🕒 Claim Submitted At Date Day of Week | The date when a claim was submitted. Draft claims that have not been completed will not have this date populated. |
| 🕒 Claim Submitted At Date Month | The date when a claim was submitted. Draft claims that have not been completed will not have this date populated. |
| 🕒 Claim Submitted At Date Quarter | The date when a claim was submitted. Draft claims that have not been completed will not have this date populated. |
| 🕒 Claim Submitted At Date Time | The date when a claim was submitted. Draft claims that have not been completed will not have this date populated. |
| 🕒 Claim Submitted At Date Week | The date when a claim was submitted. Draft claims that have not been completed will not have this date populated. |
| 🕒 Claim Submitted At Date Year | The date when a claim was submitted. Draft claims that have not been completed will not have this date populated. |
| 🕒 Credit Note Approved Date Date | Time the credit note was approved. |
| 🕒 Credit Note Approved Date Day of Week | Time the credit note was approved. |
| 🕒 Credit Note Approved Date Hour of Day | Time the credit note was approved. |
| 🕒 Credit Note Approved Date Month | Time the credit note was approved. |
| 🕒 Credit Note Approved Date Quarter | Time the credit note was approved. |
| 🕒 Credit Note Approved Date Time | Time the credit note was approved. |
| 🕒 Credit Note Approved Date Time of Day | Time the credit note was approved. |
| 🕒 Credit Note Approved Date Week | Time the credit note was approved. |
| 🕒 Credit Note Approved Date Week of Year | Time the credit note was approved. |
| 🕒 Credit Note Approved Date Year | Time the credit note was approved. |
| Values AVG Value [EUR] | The average net value of all claims in Euros. Depending on the chosen fields and filters. |
| Count [#] | The number of individual claims submitted via the Seven Senders Portal. Depending on the chosen fields and filters. |
| Values Total Carrier Payout [€] | |
| Values Total Credit Notes [EUR] | Credit Note value for all related claims per shop. |
| Values Total Customer Payout [EUR] | |
| Values Total Expected Carrier Payout [€] | |
| Values Total Net Value | The total value of all claims in original currency. Depending on the chosen fields and filters. |
| Values Total Net Value [EUR] | Total net value of claims in Euros. |
Consumer
| Field Name | Description |
|---|---|
| Return Origin Address Origin | Origin address of the end consumer |
| Address Address | The address (street name and house number) of the consumer. Based on data provided by the shop. |
| Address City | The city the consumer is ordering to. Based on data provided by the shop. |
| Address Country | The country the consumer is ordering to. Based on data provided by the shop. |
| Address Country [ISO2] | The country the consumer is ordering to represented as a 2 letter country code. Based on data provided by the shop. |
| Address Address Details | Any additional information about the address of the consumer. Based on data provided by the shop. |
| Address Zip Code | The zip code the consumer is ordering to. Based on data provided by the shop. |
| Consumer Company | The company the consumer is ordering to. Based on data provided by the shop. |
| Consumer Email | The email address of the consumer. Based on data provided by the shop. |
| Consumer First Name | The first name of the consumer. Based on data provided by the shop. |
| Consumer Last Name | The last name of the consumer. Based on data provided by the shop. |
| Consumer Mobile Number | The mobile number of the consumer. Based on data provided by the shop. |
| Address Zip Code Region | The region of the consumer based on the first 2 digits of the consumers zip code in the format 'ISO2 - first 2 digits of zip code'. |
| Return Origin Country Origin | Origin address country of the end consumer |
| Return Origin Zip-Code Origin | Origin address zip-code of the end consumer |
| Return Origin Zip-Code Region Origin | Origin region of the consumer based on the first 2 digits of the consumers zip code in the format 'ISO2 - first 2 digits of zip code'. |
Customs
| Field Name | Description |
|---|---|
| SKU Article ID | |
| Manifest Commercial Invoice Number | Unique identifier of the commercial invoice created by 7S customs and is a required document for the export and import clearance process. |
| Shipment Customs Reference Number | |
| Shipment Departure Country Currency | |
| SKU Departure Country Description | |
| SKU Grading | Categorization of the returned articles based on defined performance criteria of a shipment for 7S Customs Customer. |
| Shipment Is Return Inspected (Yes / No) | Inspection of a return or undeliverable shipment by the return warehouse by opening the parcel and confirming the articles and their quantity. |
| Manifest Manifest ID | |
| Shipment Recipient Country | |
| Shipment Recipient First Name | |
| Shipment Recipient Last Name | |
| SKU Return Reason | Categorization of the issue why an article has been returned for a shipment for 7S Customs Customer. |
| SKU SKU ID | |
| Shipment Type | Type of shipment: outbound, inbound and return. |
| SKU UPC Code | |
| 🕒 Import Customs Cleared Date Date | |
| 🕒 Import Customs Cleared Date Day of Week | |
| 🕒 Import Customs Cleared Date Hour of Day | |
| 🕒 Import Customs Cleared Date Month | |
| 🕒 Import Customs Cleared Date Quarter | |
| 🕒 Import Customs Cleared Date Time | |
| 🕒 Import Customs Cleared Date Time of Day | |
| 🕒 Import Customs Cleared Date Week | |
| 🕒 Import Customs Cleared Date Week of Year | |
| 🕒 Import Customs Cleared Date Year | |
| 🕒 Manifest Created Date Date | |
| 🕒 Manifest Created Date Day of Week | |
| 🕒 Manifest Created Date Hour of Day | |
| 🕒 Manifest Created Date Month | |
| 🕒 Manifest Created Date Quarter | |
| 🕒 Manifest Created Date Time | |
| 🕒 Manifest Created Date Time of Day | |
| 🕒 Manifest Created Date Week | |
| 🕒 Manifest Created Date Week of Year | |
| 🕒 Manifest Created Date Year | |
| 🕒 Shipment Finished At Date Date | Timestamp that indicates when Seven Senders received the inspection information for a return shipment. |
| 🕒 Shipment Finished At Date Day of Week | Timestamp that indicates when Seven Senders received the inspection information for a return shipment. |
| 🕒 Shipment Finished At Date Hour of Day | Timestamp that indicates when Seven Senders received the inspection information for a return shipment. |
| 🕒 Shipment Finished At Date Month | Timestamp that indicates when Seven Senders received the inspection information for a return shipment. |
| 🕒 Shipment Finished At Date Quarter | Timestamp that indicates when Seven Senders received the inspection information for a return shipment. |
| 🕒 Shipment Finished At Date Time | Timestamp that indicates when Seven Senders received the inspection information for a return shipment. |
| 🕒 Shipment Finished At Date Time of Day | Timestamp that indicates when Seven Senders received the inspection information for a return shipment. |
| 🕒 Shipment Finished At Date Week | Timestamp that indicates when Seven Senders received the inspection information for a return shipment. |
| 🕒 Shipment Finished At Date Week of Year | Timestamp that indicates when Seven Senders received the inspection information for a return shipment. |
| 🕒 Shipment Finished At Date Year | Timestamp that indicates when Seven Senders received the inspection information for a return shipment. |
| 🕒 Shipment Processed At Date Date | The time of completion of a return or undeliverable shipment inspection by the return warehouse. |
| 🕒 Shipment Processed At Date Day of Week | The time of completion of a return or undeliverable shipment inspection by the return warehouse. |
| 🕒 Shipment Processed At Date Hour of Day | The time of completion of a return or undeliverable shipment inspection by the return warehouse. |
| 🕒 Shipment Processed At Date Month | The time of completion of a return or undeliverable shipment inspection by the return warehouse. |
| 🕒 Shipment Processed At Date Quarter | The time of completion of a return or undeliverable shipment inspection by the return warehouse. |
| 🕒 Shipment Processed At Date Time | The time of completion of a return or undeliverable shipment inspection by the return warehouse. |
| 🕒 Shipment Processed At Date Time of Day | The time of completion of a return or undeliverable shipment inspection by the return warehouse. |
| 🕒 Shipment Processed At Date Week | The time of completion of a return or undeliverable shipment inspection by the return warehouse. |
| 🕒 Shipment Processed At Date Week of Year | The time of completion of a return or undeliverable shipment inspection by the return warehouse. |
| 🕒 Shipment Processed At Date Year | The time of completion of a return or undeliverable shipment inspection by the return warehouse. |
| Values Net Value | Sum of net value from SKU level. |
| Values Total Net Value | Sum of total net value from SKU level. |
| Counts [#] Total Quantity | Total quantity on SKU level. |
| Values Total Sales Value | Sum of sales value from SKU level. |
Label
| Field Name | Description |
|---|---|
| Label Type | Type of label (regular, ad hoc return, return). |
| 🕒 Created Date Date | Time when the label was created. |
| 🕒 Created Date Day of Week | Time when the label was created. |
| 🕒 Created Date Hour of Day | Time when the label was created. |
| 🕒 Created Date Month | Time when the label was created. |
| 🕒 Created Date Quarter | Time when the label was created. |
| 🕒 Created Date Time | Time when the label was created. |
| 🕒 Created Date Time of Day | Time when the label was created. |
| 🕒 Created Date Week | Time when the label was created. |
| 🕒 Created Date Week of Year | Time when the label was created. |
| 🕒 Created Date Year | Time when the label was created. |
| Count [#] | Number of individual labels. |
Order
| Field Name | Description |
|---|---|
| Tags Boarding Complete | Information provided by the shop whether all shipments of an order have been shipped. Is yes, if all shipments of an order have been shipped. Is no, if not all shipments of an order have been shipped ... |
| Tags Completed (Yes / No) | All shipments of an order have been delivered. |
| Order Tag Consumer Country | |
| Status Current Status | The name of the status the order is currently in. Either based on data provided by the shop for the order or by the carrier for the shipment(s) belonging to the order. |
| Status Current Status - Date | The time the order received its current status. Either based on data provided by the shop for the order or by the carrier for the shipment. Presented in the chosen format. |
| Status Current Status - Day of Week | The time the order received its current status. Either based on data provided by the shop for the order or by the carrier for the shipment. Presented in the chosen format. |
| Status Current Status - Hour of Day | The time the order received its current status. Either based on data provided by the shop for the order or by the carrier for the shipment. Presented in the chosen format. |
| Status Current Status - Month | The time the order received its current status. Either based on data provided by the shop for the order or by the carrier for the shipment. Presented in the chosen format. |
| Status Current Status - Time | The time the order received its current status. Either based on data provided by the shop for the order or by the carrier for the shipment. Presented in the chosen format. |
| Status Current Status - Week | The time the order received its current status. Either based on data provided by the shop for the order or by the carrier for the shipment. Presented in the chosen format. |
| Lead Times Date Change Cluster [0-5]: Promised to Last FDA | Lead time in days from Promised Delivery Date to Last FDA in clusters of < 0 to > 5. |
| Tags FDA Tag (Yes / No) | Indicates if all shipments of an order had a First Delivery Attempt. Based on data provided by the carrier for the shipment(s) belonging to the order. |
| Status Historic Status | The name of a particular status the order once had. Either based on data provided by the shop or by the carrier for the shipment(s) belonging to the order. |
| Status Historic Status - Date | The time the order received a particular historic status. Either based on data provided by the shop for the order or by the carrier for the shipment. Presented in the chosen format. |
| Status Historic Status - Day of Week | The time the order received a particular historic status. Either based on data provided by the shop for the order or by the carrier for the shipment. Presented in the chosen format. |
| Status Historic Status - Hour of Day | The time the order received a particular historic status. Either based on data provided by the shop for the order or by the carrier for the shipment. Presented in the chosen format. |
| Status Historic Status - Month | The time the order received a particular historic status. Either based on data provided by the shop for the order or by the carrier for the shipment. Presented in the chosen format. |
| Status Historic Status - Time | The time the order received a particular historic status. Either based on data provided by the shop for the order or by the carrier for the shipment. Presented in the chosen format. |
| Status Historic Status - Week | The time the order received a particular historic status. Either based on data provided by the shop for the order or by the carrier for the shipment. Presented in the chosen format. |
| ID (Shop) | The unique order ID assigned by the shop and provided to 7S. |
| Tags Is Zalando Order (Yes / No) | End consumer placed order in Zalando. Identified via URL. |
| Language | The language the consumer placed the order in. Data provided by the shop. |
| Number of Outbound Shipments | The number of outbound shipments connected to an order. Data provided by the shop. |
| Tags On-time (Yes / No) | All parcels have a first delivery attempt within the given SLA days after their first hub scan, i.e. by the expected first delivery date. |
| Order Tag Order Tag | Name and content metainformation together to further distinguish the order. Data provided by the shop. |
| Order Tag Content | Metainformation details to further distinguish the order. Data provided by the shop. |
| Order Tag Name | Metainformation subject to further distinguish the order. Data provided by the shop. |
| URL | The URL of the webshop the order was placed. Data provided by the shop. |
| 🕒 Completed Date Date | Time when all shipments of an order have been delivered. |
| 🕒 Completed Date Day of Week | Time when all shipments of an order have been delivered. |
| 🕒 Completed Date Hour of Day | Time when all shipments of an order have been delivered. |
| 🕒 Completed Date Month | Time when all shipments of an order have been delivered. |
| 🕒 Completed Date Quarter | Time when all shipments of an order have been delivered. |
| 🕒 Completed Date Time | Time when all shipments of an order have been delivered. |
| 🕒 Completed Date Time of Day | Time when all shipments of an order have been delivered. |
| 🕒 Completed Date Week | Time when all shipments of an order have been delivered. |
| 🕒 Completed Date Week of Year | Time when all shipments of an order have been delivered. |
| 🕒 Completed Date Year | Time when all shipments of an order have been delivered. |
| 🕒 Created (Shop) Date Date | The time the order was placed by the consumer. Data provided by the shop. |
| 🕒 Created (Shop) Date Day of Week | The time the order was placed by the consumer. Data provided by the shop. |
| 🕒 Created (Shop) Date Hour of Day | The time the order was placed by the consumer. Data provided by the shop. |
| 🕒 Created (Shop) Date Month | The time the order was placed by the consumer. Data provided by the shop. |
| 🕒 Created (Shop) Date Quarter | The time the order was placed by the consumer. Data provided by the shop. |
| 🕒 Created (Shop) Date Time | The time the order was placed by the consumer. Data provided by the shop. |
| 🕒 Created (Shop) Date Time of Day | The time the order was placed by the consumer. Data provided by the shop. |
| 🕒 Created (Shop) Date Week | The time the order was placed by the consumer. Data provided by the shop. |
| 🕒 Created (Shop) Date Week of Year | The time the order was placed by the consumer. Data provided by the shop. |
| 🕒 Created (Shop) Date Year | The time the order was placed by the consumer. Data provided by the shop. |
| 🕒 First FDA Date Date | The first delivery attempt for a parcel of an order. Based on data provided by the carrier for the shipment(s) belonging to the order. |
| 🕒 First FDA Date Day of Week | The first delivery attempt for a parcel of an order. Based on data provided by the carrier for the shipment(s) belonging to the order. |
| 🕒 First FDA Date Hour of Day | The first delivery attempt for a parcel of an order. Based on data provided by the carrier for the shipment(s) belonging to the order. |
| 🕒 First FDA Date Month | The first delivery attempt for a parcel of an order. Based on data provided by the carrier for the shipment(s) belonging to the order. |
| 🕒 First FDA Date Quarter | The first delivery attempt for a parcel of an order. Based on data provided by the carrier for the shipment(s) belonging to the order. |
| 🕒 First FDA Date Time | The first delivery attempt for a parcel of an order. Based on data provided by the carrier for the shipment(s) belonging to the order. |
| 🕒 First FDA Date Time of Day | The first delivery attempt for a parcel of an order. Based on data provided by the carrier for the shipment(s) belonging to the order. |
| 🕒 First FDA Date Week | The first delivery attempt for a parcel of an order. Based on data provided by the carrier for the shipment(s) belonging to the order. |
| 🕒 First FDA Date Week of Year | The first delivery attempt for a parcel of an order. Based on data provided by the carrier for the shipment(s) belonging to the order. |
| 🕒 First FDA Date Year | The first delivery attempt for a parcel of an order. Based on data provided by the carrier for the shipment(s) belonging to the order. |
| 🕒 Last FDA Date Date | The date when the last shipment of an order received its first delivery attempt. Based on data provided by the carrier for the shipment(s) belonging to the order. |
| 🕒 Last FDA Date Day of Week | The date when the last shipment of an order received its first delivery attempt. Based on data provided by the carrier for the shipment(s) belonging to the order. |
| 🕒 Last FDA Date Hour of Day | The date when the last shipment of an order received its first delivery attempt. Based on data provided by the carrier for the shipment(s) belonging to the order. |
| 🕒 Last FDA Date Month | The date when the last shipment of an order received its first delivery attempt. Based on data provided by the carrier for the shipment(s) belonging to the order. |
| 🕒 Last FDA Date Quarter | The date when the last shipment of an order received its first delivery attempt. Based on data provided by the carrier for the shipment(s) belonging to the order. |
| 🕒 Last FDA Date Time | The date when the last shipment of an order received its first delivery attempt. Based on data provided by the carrier for the shipment(s) belonging to the order. |
| 🕒 Last FDA Date Time of Day | The date when the last shipment of an order received its first delivery attempt. Based on data provided by the carrier for the shipment(s) belonging to the order. |
| 🕒 Last FDA Date Week | The date when the last shipment of an order received its first delivery attempt. Based on data provided by the carrier for the shipment(s) belonging to the order. |
| 🕒 Last FDA Date Week of Year | The date when the last shipment of an order received its first delivery attempt. Based on data provided by the carrier for the shipment(s) belonging to the order. |
| 🕒 Last FDA Date Year | The date when the last shipment of an order received its first delivery attempt. Based on data provided by the carrier for the shipment(s) belonging to the order. |
| 🕒 New Date Date | Timestamp when the order changed into status 'new'. Normally the time when the order was placed by the consumer. |
| 🕒 New Date Day of Week | Timestamp when the order changed into status 'new'. Normally the time when the order was placed by the consumer. |
| 🕒 New Date Hour of Day | Timestamp when the order changed into status 'new'. Normally the time when the order was placed by the consumer. |
| 🕒 New Date Month | Timestamp when the order changed into status 'new'. Normally the time when the order was placed by the consumer. |
| 🕒 New Date Quarter | Timestamp when the order changed into status 'new'. Normally the time when the order was placed by the consumer. |
| 🕒 New Date Time | Timestamp when the order changed into status 'new'. Normally the time when the order was placed by the consumer. |
| 🕒 New Date Time of Day | Timestamp when the order changed into status 'new'. Normally the time when the order was placed by the consumer. |
| 🕒 New Date Week | Timestamp when the order changed into status 'new'. Normally the time when the order was placed by the consumer. |
| 🕒 New Date Week of Year | Timestamp when the order changed into status 'new'. Normally the time when the order was placed by the consumer. |
| 🕒 New Date Year | Timestamp when the order changed into status 'new'. Normally the time when the order was placed by the consumer. |
| 🕒 Paid Date Date | The time when the order was paid by the consumer. Data provided by the shop. |
| 🕒 Paid Date Day of Week | The time when the order was paid by the consumer. Data provided by the shop. |
| 🕒 Paid Date Hour of Day | The time when the order was paid by the consumer. Data provided by the shop. |
| 🕒 Paid Date Month | The time when the order was paid by the consumer. Data provided by the shop. |
| 🕒 Paid Date Quarter | The time when the order was paid by the consumer. Data provided by the shop. |
| 🕒 Paid Date Time | The time when the order was paid by the consumer. Data provided by the shop. |
| 🕒 Paid Date Time of Day | The time when the order was paid by the consumer. Data provided by the shop. |
| 🕒 Paid Date Week | The time when the order was paid by the consumer. Data provided by the shop. |
| 🕒 Paid Date Week of Year | The time when the order was paid by the consumer. Data provided by the shop. |
| 🕒 Paid Date Year | The time when the order was paid by the consumer. Data provided by the shop. |
| 🕒 Preparation Date Date | The time when the fulfillment of the order started. Data provided by the shop. |
| 🕒 Preparation Date Day of Week | The time when the fulfillment of the order started. Data provided by the shop. |
| 🕒 Preparation Date Hour of Day | The time when the fulfillment of the order started. Data provided by the shop. |
| 🕒 Preparation Date Month | The time when the fulfillment of the order started. Data provided by the shop. |
| 🕒 Preparation Date Quarter | The time when the fulfillment of the order started. Data provided by the shop. |
| 🕒 Preparation Date Time | The time when the fulfillment of the order started. Data provided by the shop. |
| 🕒 Preparation Date Time of Day | The time when the fulfillment of the order started. Data provided by the shop. |
| 🕒 Preparation Date Week | The time when the fulfillment of the order started. Data provided by the shop. |
| 🕒 Preparation Date Week of Year | The time when the fulfillment of the order started. Data provided by the shop. |
| 🕒 Preparation Date Year | The time when the fulfillment of the order started. Data provided by the shop. |
| 🕒 Production Date Date | The time when the production of the order item(s) belonging to the order started. Data provided by the shop. |
| 🕒 Production Date Day of Week | The time when the production of the order item(s) belonging to the order started. Data provided by the shop. |
| 🕒 Production Date Hour of Day | The time when the production of the order item(s) belonging to the order started. Data provided by the shop. |
| 🕒 Production Date Month | The time when the production of the order item(s) belonging to the order started. Data provided by the shop. |
| 🕒 Production Date Quarter | The time when the production of the order item(s) belonging to the order started. Data provided by the shop. |
| 🕒 Production Date Time | The time when the production of the order item(s) belonging to the order started. Data provided by the shop. |
| 🕒 Production Date Time of Day | The time when the production of the order item(s) belonging to the order started. Data provided by the shop. |
| 🕒 Production Date Week | The time when the production of the order item(s) belonging to the order started. Data provided by the shop. |
| 🕒 Production Date Week of Year | The time when the production of the order item(s) belonging to the order started. Data provided by the shop. |
| 🕒 Production Date Year | The time when the production of the order item(s) belonging to the order started. Data provided by the shop. |
| 🕒 Promised Delivery Date Date | The forecasted date of the delivery communicated to the consumer during the check out. Data provided by the shop. |
| 🕒 Promised Delivery Date Day of Week | The forecasted date of the delivery communicated to the consumer during the check out. Data provided by the shop. |
| 🕒 Promised Delivery Date Hour of Day | The forecasted date of the delivery communicated to the consumer during the check out. Data provided by the shop. |
| 🕒 Promised Delivery Date Month | The forecasted date of the delivery communicated to the consumer during the check out. Data provided by the shop. |
| 🕒 Promised Delivery Date Quarter | The forecasted date of the delivery communicated to the consumer during the check out. Data provided by the shop. |
| 🕒 Promised Delivery Date Time | The forecasted date of the delivery communicated to the consumer during the check out. Data provided by the shop. |
| 🕒 Promised Delivery Date Time of Day | The forecasted date of the delivery communicated to the consumer during the check out. Data provided by the shop. |
| 🕒 Promised Delivery Date Week | The forecasted date of the delivery communicated to the consumer during the check out. Data provided by the shop. |
| 🕒 Promised Delivery Date Week of Year | The forecasted date of the delivery communicated to the consumer during the check out. Data provided by the shop. |
| 🕒 Promised Delivery Date Year | The forecasted date of the delivery communicated to the consumer during the check out. Data provided by the shop. |
| 🕒 Shipped Date Date | The date when the last shipment of the order has been picked up by the carrier. |
| 🕒 Shipped Date Day of Week | The date when the last shipment of the order has been picked up by the carrier. |
| 🕒 Shipped Date Hour of Day | The date when the last shipment of the order has been picked up by the carrier. |
| 🕒 Shipped Date Month | The date when the last shipment of the order has been picked up by the carrier. |
| 🕒 Shipped Date Quarter | The date when the last shipment of the order has been picked up by the carrier. |
| 🕒 Shipped Date Time | The date when the last shipment of the order has been picked up by the carrier. |
| 🕒 Shipped Date Time of Day | The date when the last shipment of the order has been picked up by the carrier. |
| 🕒 Shipped Date Week | The date when the last shipment of the order has been picked up by the carrier. |
| 🕒 Shipped Date Week of Year | The date when the last shipment of the order has been picked up by the carrier. |
| 🕒 Shipped Date Year | The date when the last shipment of the order has been picked up by the carrier. |
| 🕒 Transfer Date Date | The time the order data was shared with Seven Senders. |
| 🕒 Transfer Date Day of Week | The time the order data was shared with Seven Senders. |
| 🕒 Transfer Date Hour of Day | The time the order data was shared with Seven Senders. |
| 🕒 Transfer Date Month | The time the order data was shared with Seven Senders. |
| 🕒 Transfer Date Quarter | The time the order data was shared with Seven Senders. |
| 🕒 Transfer Date Time | The time the order data was shared with Seven Senders. |
| 🕒 Transfer Date Time of Day | The time the order data was shared with Seven Senders. |
| 🕒 Transfer Date Week | The time the order data was shared with Seven Senders. |
| 🕒 Transfer Date Week of Year | The time the order data was shared with Seven Senders. |
| 🕒 Transfer Date Year | The time the order data was shared with Seven Senders. |
| Counts by Tag [#] Completed | The number of orders for which all shipments have been delivered. |
| Counts by Tag [#] Delivered As Promised | Number of orders that have a first delivery attempt on the given SLA days after their first hub scan, i.e. on the expected first delivery date. |
| Counts by Tag [#] Delivered Too Early | Number of orders that have a first delivery attempt before the given SLA days after their first hub scan, i.e. before the expected first delivery date. |
| Counts by Tag [#] Delivered Too Late | Number of orders that do not have a first delivery attempt within the given SLA days after their first hub scan, i.e. after the expected first delivery date. |
| Counts by Tag [#] Shipped | The number of individual orders, that have a current status 'shipped'. These orders are on their way to the consumer. |
| Counts by Tag [#] To Be Shipped | The number of individual orders, that have a current status 'in preparation', 'in production', or 'new'. They have not been shipped yet. |
| Count [#] | The number of individual orders. |
| Share by Tag [%] Completed | The share of orders for which all shipments of an order have been delivered. |
| Share by Tag [%] Delivered As Promised | The share of individual orders which have been delivered on the exact day promised to the consumer during the check out. Measures the expected delivery date of an order set by the shop against the las... |
| Share by Tag [%] Delivered Too Early | The share of individual orders which have been delivered before the day which was promised to the consumer during the check out. Measures the expected delivery date of an order set by the shop against... |
| Share by Tag [%] Delivered Too Late | The share of individual orders which have been delivered after the day which was promised to the consumer during the check out. Measures the expected delivery date of an order set by the shop against ... |
| Share by Tag [%] Shipped | The share of individual orders, that have a current status 'shipped'. These orders are on their way to the consumer. |
| Share by Tag [%] To Be Shipped | The share of individual orders, that have a current status 'in preparation', 'in production', or 'new'. They have not been shipped yet. |
| Share [%] - Column Total | The share of individual orders per column. Measures the relation of the individual orders of a column against the total amount of orders of a column. |
| Share [%] - Row Total | The share of individual orders per row. Measures the relation of the individual orders of a row against the total amount of orders of a row. |
Order Item
| Field Name | Description |
|---|---|
| Appearance | The appearance of the order item (usually the color). Based on data provided by the shop. |
| Currency | The currency in which the order item has been purchased by the consumer. Based on data provided by the shop. |
| Description | A more detailed description of the order item. Based on data provided by the shop. |
| ID | The Seven Senders ID for the order item. |
| Name | The name of the order item. Based on data provided by the shop. |
| Product URL | The webshop URL to the order item. Based on data provided by the shop. |
| Return Portal Refund w/o Return Cutoff Value | Indicates the total value up to which the consumer doesn’t need to return the items in case Refund Without Return is enabled. Based on the Return Portal Configuration. |
| Return Portal Refund w/o Return Enabled (Yes / No) | Indicates if the consumer has the possibility to keep the items of an order instead of returning them. Based on the Return Portal Configuration. |
| Return Portal ID | The unique hash of the Return Portal used by the consumer to request a return. |
| Return Reason | The reason why an order item was returned. Selected by the consumer. |
| Returnable (Yes / No) | Indicates if the consumer is allowed to return the order item. Based on data provided by the shop. |
| Returned (Yes / No) | Indicates if a return has been created for the order item(s) via the Return Portal. |
| SKU | The stock keeping unit of the order item. Based on data provided by the shop. |
| Sales Price | The sales price of the order item in the currency it was purchased. Based on data provided by the shop. |
| Size | The size of the order item. Based on data provided by the shop. |
| Status | Status of the order item. |
| Weight [kg] | The weight of the order item in kg. Based on data provided by the shop. |
| 🕒 Created Date Date | The time the order item was created in the system of Seven Senders. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Created Date Day of Week | The time the order item was created in the system of Seven Senders. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Created Date Hour of Day | The time the order item was created in the system of Seven Senders. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Created Date Month | The time the order item was created in the system of Seven Senders. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Created Date Quarter | The time the order item was created in the system of Seven Senders. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Created Date Time | The time the order item was created in the system of Seven Senders. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Created Date Time of Day | The time the order item was created in the system of Seven Senders. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Created Date Week | The time the order item was created in the system of Seven Senders. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Created Date Week of Year | The time the order item was created in the system of Seven Senders. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Created Date Year | The time the order item was created in the system of Seven Senders. Based on data provided by the shop. Presented in the chosen format. |
| Return Portal 🕒 Return Request Created Date | The date a return was requested by the consumer via the 7S Return Portal. |
| Share [%] Order Item Return Ratio [%] | The share of returned order items. Depending on the chosen fields and filters. |
| AVG Weight [kg] Outbound Order Items | The average weight of individual outbound order items in kg. Depending on the chosen fields and filters. |
| Count [#] Outbound Order Items | The number of individual outbound order items. Depending on the chosen fields and filters. |
| Share [%] Outbound Share [%] - Column Total | The share of individual outbound order items per column. Measures the relation of the individual outbound order items of a column against the total amount of outbound order items of a column. |
| Share [%] Outbound Share [%] - Row Total | The share of individual outbound order items per row. Measures the relation of the individual outbound order items of a row against the total amount of outbound order items of a row. |
| Value Outbound Order Items | The total sales price of all individual outbound order items. Depending on the chosen fields and filters. |
| AVG Weight [kg] Return Order Items | The average weight of individual return order items in kg. Depending on the chosen fields and filters. |
| Count [#] Return Order Items | The number of individual returned order items. Depending on the chosen fields and filters. |
| Share [%] Return Share [%] - Column Total | The share of individual return order items per column. Measures the relation of the individual return order items of a column against the total amount of return order items of a column. |
| Share [%] Return Share [%] - Row Total | The share of individual return order items per row. Measures the relation of the individual return order items of a row against the total amount of return order items of a row. |
| Value Return Order Items | The total sales price of all individual return order items. Depending on the chosen fields and filters. |
| AVG Weight [kg] Total Order Items | The average weight of all order items (outbound and returned) in kg. Depending on the chosen fields and filters. |
| Count [#] Total Order Items | The total number of all order items (outbound and returned). Depending on the chosen fields and filters. |
| Share [%] Total Share [%] - Column Total | The share of all order items (outbound and return) per column. Measures the relation of the individual order items of a column against the total amount of all order items of a column. |
| Share [%] Total Share [%] - Row Total | The share of all order items (outbound and return) per row. Measures the relation of the individual order items of a row against the total amount of all order items of a row. |
| Value Total Order Items | The total sales price of all individual order items (outbound and returned). Depending on the chosen fields and filters. |
| Returned (Yes / No) | A filter to choose whether a return has been created for the order item(s) via the Return Portal. |
Order Lead Times
| Field Name | Description |
|---|---|
| Lead Time Combination | Lead times name |
| Date Changes [0-30] | Use as a pivot to identify numbers of orders with 0,1,2,.. or 30+ days lead time for your selected lead time combinations. |
| Date Changes [0-5] | Use as a pivot to identify numbers of orders with 0,1,2,.. or 5+ days lead time for your selected lead time combinations. |
| AVG Lead Time | The time duration between the start of a tracking event and the occurrence of a subsequent change, excluding bank holidays from the calculation. |
| AVG Lead Time [Bank Holidays Included] | The time elapsed between the start of a tracking event and a subsequent change, with bank holidays counted as working days in the calculation. |
| Cumulative [%] lead time shares +5 days cumulative [%] | |
| Cumulative [%] lead time shares 0 days cumulative [%] | |
| Cumulative [%] lead time shares 1 days cumulative [%] | |
| Cumulative [%] lead time shares 2 days cumulative [%] | |
| Cumulative [%] lead time shares 3 days cumulative [%] | |
| Cumulative [%] lead time shares 4 days cumulative [%] | |
| Cumulative [%] lead time shares 5 days cumulative [%] | |
| [#] Orders With Leadtime | |
| Lead Time | Filter to select which lead time(s) to calculate. To visualise lead times, select 'Lead Time Combination' under 'Dimensions'. |
| Time Metrics | Filter to select type of lead time: hours, days or date changes |
| Working Days | Filter to select days of week for lead time calculations |
Shipment
| Field Name | Description |
|---|---|
| Event Current Event | The name of the event the shipment is currently in. Mainly based on data provided by the carrier. |
| Event Current Event - Date | The time the shipment received its current event. Mainly based on data provided by the carrier. |
| Event Current Event - Day of Week | The time the shipment received its current event. Mainly based on data provided by the carrier. |
| Event Current Event - Hour of Day | The time the shipment received its current event. Mainly based on data provided by the carrier. |
| Event Current Event - Month | The time the shipment received its current event. Mainly based on data provided by the carrier. |
| Event Current Event - Time | The time the shipment received its current event. Mainly based on data provided by the carrier. |
| Event Current Event - Week | The time the shipment received its current event. Mainly based on data provided by the carrier. |
| Status Current Status | Status the parcel is currently in. Mainly based on data provided by the carrier. |
| Status Current Status - Date | The time the shipment received its current status. Mainly based on data provided by the carrier. Presented in the chosen format. |
| Status Current Status - Day of Week | The time the shipment received its current status. Mainly based on data provided by the carrier. Presented in the chosen format. |
| Status Current Status - Hour of Day | The time the shipment received its current status. Mainly based on data provided by the carrier. Presented in the chosen format. |
| Status Current Status - Month | The time the shipment received its current status. Mainly based on data provided by the carrier. Presented in the chosen format. |
| Status Current Status - Time | The time the shipment received its current status. Mainly based on data provided by the carrier. Presented in the chosen format. |
| Status Current Status - Week | The time the shipment received its current status. Mainly based on data provided by the carrier. Presented in the chosen format. |
| Counting Working Days Day Tiers | Groups the number of counted days into tiered buckets based on the selected day-counting method. |
| Goods Value | Value of the shipped goods. |
| Goods Value Currency | Currency of the shipped goods value. |
| Tags Has Claim (Yes / No) | Indicates if a claim was submitted for a shipment via the Seven Senders Portal. |
| Tags Has Customs (Yes / No) | Does this parcel need to go through customs clearance, i.e. the process of getting permission from the government agency to either move goods out of a country (export) or bring goods into the country ... |
| Tags Has Delivery Appointment (Yes / No) | An appointment for the delivery has been defined between the LMC and the customer. |
| Tags Has Delivery Information Changed (Yes / No) | Indicates whether the shipment's delivery information has changed. 'Yes' if one or more carrier messages apply: carrier changed, delivery address changed, delivery date changed. |
| Tags Has FDA (Yes / No) | Indicates if a shipment had a First Delivery Attempt. Based on data provided by the carrier. |
| Tags Has FDA Timeout (Yes / No) | Indicates if a shipment missed its expected First Delivery Attempt. Based on data provided by the shop within the settings in the Seven Senders Portal. Is yes when a shipment did not receive a First D... |
| Tags Has FHS (Yes / No) | Indicates if a shipment received a First Hub Scan. Based on data provided by the carrier. |
| Tags Has FHS Timeout (Yes / No) | Indicates if a shipment missed its expected First Hub Scan. Based on data provided by the shop within the settings in the Seven Senders Portal. Is yes when a shipment did not receive a First Hub Scan ... |
| Tags Has FHS, No FDA (Yes / No) | Indicates whether the shipment has a first hub scan [FHS] but no first delivery attempt [FDA]. A shipment is tagged no by this metric if FHS and FDA are both populated or if neither FHS nor FDA are po... |
| Holiday Impact Impacted (Yes / No) | Indicates if a shipment was on the way during a public nation wide holiday in the country of the warehouse, the consumer or the carrier. |
| Tags Has Pickup, No FDA (Yes / No) | Indicates whether the shipment has a planned pickup but no first delivery attempt [FDA]. A shipment is tagged no by this metric if Pickup and FDA are both populated or if neither Pickup nor FDA are p... |
| Tags Has Pickup, No FHS (Yes / No) | Indicates if a shipment is missing a first hub scan although it was picked up already. A shipment is tagged no by this metric if Pickup and FHS are both populated or if neither Pickup nor FHS are popu... |
| Tags Has Seven Senders Hub Scan [SHS] (Yes / No) | Indicates whether the parcel had a Seven Senders hub scan [SHS]. |
| Tags Has Successful FDA (Yes / No) | Indicates if a parcel was successfully delivered, or delivered to a pick-up location, on the first delivery attempt. Based on data provided by the carrier. |
| Event Historic Event | Events the shipment has had. Mainly based on data provided by the carrier. |
| Event Historic Event - Date | Time of the events the shipment has had. Mainly based on data provided by the carrier. |
| Event Historic Event - Day of Week | Time of the events the shipment has had. Mainly based on data provided by the carrier. |
| Event Historic Event - Hour of Day | Time of the events the shipment has had. Mainly based on data provided by the carrier. |
| Event Historic Event - Month | Time of the events the shipment has had. Mainly based on data provided by the carrier. |
| Event Historic Event - Time | Time of the events the shipment has had. Mainly based on data provided by the carrier. |
| Event Historic Event - Week | Time of the events the shipment has had. Mainly based on data provided by the carrier. |
| Status Historic Status | The name of a particular status the shipment once had. Mainly based on data provided by the carrier. |
| Status Historic Status - Date | The time the shipment received a particular historic status. Mainly based on data provided by the carrier. Presented in the chosen format. |
| Status Historic Status - Day of Week | The time the shipment received a particular historic status. Mainly based on data provided by the carrier. Presented in the chosen format. |
| Status Historic Status - Hour of Day | The time the shipment received a particular historic status. Mainly based on data provided by the carrier. Presented in the chosen format. |
| Status Historic Status - Month | The time the shipment received a particular historic status. Mainly based on data provided by the carrier. Presented in the chosen format. |
| Status Historic Status - Time | The time the shipment received a particular historic status. Mainly based on data provided by the carrier. Presented in the chosen format. |
| Status Historic Status - Week | The time the shipment received a particular historic status. Mainly based on data provided by the carrier. Presented in the chosen format. |
| Status Historic Status - Year | The time the shipment received a particular historic status. Mainly based on data provided by the carrier. Presented in the chosen format. |
| Tags Is 7S Shipment (Yes / No) | Is parcel shipped with Seven Senders. If not, customer ships their own parcels and tracks via Seven Senders. |
| Tags Is Cash on Delivery (Yes / No) | Is the shipment paid in cash on delivery by end-consumer. |
| Tags Is Damaged (Yes / No) | Indicates if a shipment was damaged. Based on data provided by the carrier. |
| Tags Is Delayed (Yes / No) | Indicates if a shipment is delayed, based on data provided by the carrier or by the shop. Is yes if the carrier reported a delay or the SLA Days provided by the shop within the Seven Senders Portal se... |
| Tags Is Delivered (Yes / No) | Indicates if a shipment was delivered. Based on data provided by the carrier. |
| Tags Is Delivered to Pickup Point (Yes / No) | Indicates if a parcel was delivered to a pickup point. Based on data provided by the carrier. |
| Tags Is Lost (Yes / No) | Indicates if a shipment was lost. Based on data provided by the carrier. |
| Tags Is On The Way (Yes / No) | All shipments that are not delivered. Includes shipments in transit, as well as those that are lost, undeliverable, cancelled, or experiencing delivery issues. For further details see Current Event. |
| Tags Is Pickup Point Selected (Yes / No) | Indicates if the consumer selected the parcel to be delivered to a pickup point during the check out. Based on data provided by the shop. |
| Tags Is Postal Return (Yes / No) | Indicates if the carrier was not able to deliver a parcel and therefore returned it to the sender. Based on data provided by the carrier. |
| Tags Is Redirected (Yes / No) | Indicates if a shipment has been redirected. |
| Tags Is Refunded (Yes / No) | Indicates if a return shipment is refunded to end-consumer. |
| Tags Is Return Parcel (Yes / No) | Indicates if a shipment is returned by the consumer. Based on data provided by the shop. |
| Tags Is Return Portal (7S) (Yes / No) | Indicates if a return shipment was created via the Seven Senders Return Portal or Parcel Finder. |
| Tags Is Trackable (Yes / No) | Indicates if a shipment is marked as trackable regardless of the existence of a tracking code. Based on data provided by the shop. |
| Tags Is Undeliverable (Yes / No) | Indicates whether the shipment is undeliverable. 'Yes' if one or more carrier messages apply: wrong address, refused, postal return, invalid address, unaccessible address, storage period at the pick-u... |
| Holiday Impact Impacted by | The name of the public nation wide holiday which took place in the country of the warehouse, the consumer or the carrier during the transportation of the shipment. |
| Reference Number | A number to further distinguish a shipment, which is also printed on the label. Based on data provided by the shop. |
| Reference Number 2 | Additional identification for the shipments, for identifiers from CRM or ERP. |
| SLA Days [FHS to FDA] | The number of days between the first hub scan and the first delivery attempt as agreed with the carrier of the shipment. Provided by the shop within the settings of the Seven Senders Portal. |
| Shipment Tag Shipment Tag | Any metainformation to further distinguish a shipment. Based on data provided by the shop. |
| Shipment Tag Content | Metainformation details to further distinguish the shipment. Data provided by the shop. |
| Shipment Tag Name | Metainformation subject to further distinguish the shipment. Data provided by the shop. |
| Tracking Code | The unique shipment number to check the current status and event history of a shipment. |
| Weight [kg] | The weight of a shipment in kg. Based on data provided by the shop. |
| 🕒 Created Date Date | The time the shipment was created in the system of Seven Senders. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Created Date Day of Week | The time the shipment was created in the system of Seven Senders. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Created Date Hour of Day | The time the shipment was created in the system of Seven Senders. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Created Date Month | The time the shipment was created in the system of Seven Senders. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Created Date Quarter | The time the shipment was created in the system of Seven Senders. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Created Date Time | The time the shipment was created in the system of Seven Senders. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Created Date Time of Day | The time the shipment was created in the system of Seven Senders. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Created Date Week | The time the shipment was created in the system of Seven Senders. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Created Date Week of Year | The time the shipment was created in the system of Seven Senders. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Created Date Year | The time the shipment was created in the system of Seven Senders. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Delivered to Dropoff Point [DDP] Date Date | The time the consumer handed over the return shipment at a carrier's dropoff point. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Delivered to Dropoff Point [DDP] Date Day of Week | The time the consumer handed over the return shipment at a carrier's dropoff point. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Delivered to Dropoff Point [DDP] Date Hour of Day | The time the consumer handed over the return shipment at a carrier's dropoff point. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Delivered to Dropoff Point [DDP] Date Month | The time the consumer handed over the return shipment at a carrier's dropoff point. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Delivered to Dropoff Point [DDP] Date Quarter | The time the consumer handed over the return shipment at a carrier's dropoff point. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Delivered to Dropoff Point [DDP] Date Time | The time the consumer handed over the return shipment at a carrier's dropoff point. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Delivered to Dropoff Point [DDP] Date Time of Day | The time the consumer handed over the return shipment at a carrier's dropoff point. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Delivered to Dropoff Point [DDP] Date Week | The time the consumer handed over the return shipment at a carrier's dropoff point. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Delivered to Dropoff Point [DDP] Date Week of Year | The time the consumer handed over the return shipment at a carrier's dropoff point. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Delivered to Dropoff Point [DDP] Date Year | The time the consumer handed over the return shipment at a carrier's dropoff point. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Delivery Date Date | The time the shipment was delivered. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Delivery Date Day of Week | The time the shipment was delivered. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Delivery Date Hour of Day | The time the shipment was delivered. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Delivery Date Month | The time the shipment was delivered. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Delivery Date Quarter | The time the shipment was delivered. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Delivery Date Time | The time the shipment was delivered. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Delivery Date Time of Day | The time the shipment was delivered. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Delivery Date Week | The time the shipment was delivered. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Delivery Date Week of Year | The time the shipment was delivered. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Delivery Date Year | The time the shipment was delivered. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Expected FDA Date Date | Expected First Delivery Attempt is calculated based on SLA and First Hub Scan timestamp, adjusted for carrier working days and national holidays. |
| 🕒 Expected FDA Date Day of Week | Expected First Delivery Attempt is calculated based on SLA and First Hub Scan timestamp, adjusted for carrier working days and national holidays. |
| 🕒 Expected FDA Date Month | Expected First Delivery Attempt is calculated based on SLA and First Hub Scan timestamp, adjusted for carrier working days and national holidays. |
| 🕒 Expected FDA Date Quarter | Expected First Delivery Attempt is calculated based on SLA and First Hub Scan timestamp, adjusted for carrier working days and national holidays. |
| 🕒 Expected FDA Date Week | Expected First Delivery Attempt is calculated based on SLA and First Hub Scan timestamp, adjusted for carrier working days and national holidays. |
| 🕒 Expected FDA Date Week of Year | Expected First Delivery Attempt is calculated based on SLA and First Hub Scan timestamp, adjusted for carrier working days and national holidays. |
| 🕒 Expected FDA Date Year | Expected First Delivery Attempt is calculated based on SLA and First Hub Scan timestamp, adjusted for carrier working days and national holidays. |
| 🕒 Expected Return Delivered Date Date | Expected Return Delivered is calculated based on SLA and Delivered to Drop Off Point timestamp, adjusted for warehouse and carrier working days, and national holidays. This value is empty if no SLA ha... |
| 🕒 Expected Return Delivered Date Day of Week | Expected Return Delivered is calculated based on SLA and Delivered to Drop Off Point timestamp, adjusted for warehouse and carrier working days, and national holidays. This value is empty if no SLA ha... |
| 🕒 Expected Return Delivered Date Month | Expected Return Delivered is calculated based on SLA and Delivered to Drop Off Point timestamp, adjusted for warehouse and carrier working days, and national holidays. This value is empty if no SLA ha... |
| 🕒 Expected Return Delivered Date Quarter | Expected Return Delivered is calculated based on SLA and Delivered to Drop Off Point timestamp, adjusted for warehouse and carrier working days, and national holidays. This value is empty if no SLA ha... |
| 🕒 Expected Return Delivered Date Week | Expected Return Delivered is calculated based on SLA and Delivered to Drop Off Point timestamp, adjusted for warehouse and carrier working days, and national holidays. This value is empty if no SLA ha... |
| 🕒 Expected Return Delivered Date Year | Expected Return Delivered is calculated based on SLA and Delivered to Drop Off Point timestamp, adjusted for warehouse and carrier working days, and national holidays. This value is empty if no SLA ha... |
| 🕒 First Delivery Attempt [FDA] Date Date | The time the shipment had its first delivery attempt. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 First Delivery Attempt [FDA] Date Day of Week | The time the shipment had its first delivery attempt. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 First Delivery Attempt [FDA] Date Hour of Day | The time the shipment had its first delivery attempt. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 First Delivery Attempt [FDA] Date Month | The time the shipment had its first delivery attempt. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 First Delivery Attempt [FDA] Date Quarter | The time the shipment had its first delivery attempt. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 First Delivery Attempt [FDA] Date Time | The time the shipment had its first delivery attempt. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 First Delivery Attempt [FDA] Date Time of Day | The time the shipment had its first delivery attempt. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 First Delivery Attempt [FDA] Date Week | The time the shipment had its first delivery attempt. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 First Delivery Attempt [FDA] Date Week of Year | The time the shipment had its first delivery attempt. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 First Delivery Attempt [FDA] Date Year | The time the shipment had its first delivery attempt. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 First Hub Scan [FHS] Date Date | The time the shipment received its first hub scan. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 First Hub Scan [FHS] Date Day of Week | The time the shipment received its first hub scan. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 First Hub Scan [FHS] Date Hour of Day | The time the shipment received its first hub scan. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 First Hub Scan [FHS] Date Month | The time the shipment received its first hub scan. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 First Hub Scan [FHS] Date Quarter | The time the shipment received its first hub scan. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 First Hub Scan [FHS] Date Time | The time the shipment received its first hub scan. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 First Hub Scan [FHS] Date Time of Day | The time the shipment received its first hub scan. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 First Hub Scan [FHS] Date Week | The time the shipment received its first hub scan. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 First Hub Scan [FHS] Date Week of Year | The time the shipment received its first hub scan. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 First Hub Scan [FHS] Date Year | The time the shipment received its first hub scan. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 New Date Date | Timestamp when the order related to the shipment moved to status 'new'. Normally the time when the order to which a shipment belongs to was placed by the consumer. |
| 🕒 New Date Day of Week | Timestamp when the order related to the shipment moved to status 'new'. Normally the time when the order to which a shipment belongs to was placed by the consumer. |
| 🕒 New Date Hour of Day | Timestamp when the order related to the shipment moved to status 'new'. Normally the time when the order to which a shipment belongs to was placed by the consumer. |
| 🕒 New Date Month | Timestamp when the order related to the shipment moved to status 'new'. Normally the time when the order to which a shipment belongs to was placed by the consumer. |
| 🕒 New Date Quarter | Timestamp when the order related to the shipment moved to status 'new'. Normally the time when the order to which a shipment belongs to was placed by the consumer. |
| 🕒 New Date Time | Timestamp when the order related to the shipment moved to status 'new'. Normally the time when the order to which a shipment belongs to was placed by the consumer. |
| 🕒 New Date Time of Day | Timestamp when the order related to the shipment moved to status 'new'. Normally the time when the order to which a shipment belongs to was placed by the consumer. |
| 🕒 New Date Week | Timestamp when the order related to the shipment moved to status 'new'. Normally the time when the order to which a shipment belongs to was placed by the consumer. |
| 🕒 New Date Week of Year | Timestamp when the order related to the shipment moved to status 'new'. Normally the time when the order to which a shipment belongs to was placed by the consumer. |
| 🕒 New Date Year | Timestamp when the order related to the shipment moved to status 'new'. Normally the time when the order to which a shipment belongs to was placed by the consumer. |
| 🕒 Pickup (Planned) Date Date | The time the shipment is supposed to be picked up. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Pickup (Planned) Date Day of Week | The time the shipment is supposed to be picked up. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Pickup (Planned) Date Hour of Day | The time the shipment is supposed to be picked up. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Pickup (Planned) Date Month | The time the shipment is supposed to be picked up. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Pickup (Planned) Date Quarter | The time the shipment is supposed to be picked up. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Pickup (Planned) Date Time | The time the shipment is supposed to be picked up. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Pickup (Planned) Date Time of Day | The time the shipment is supposed to be picked up. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Pickup (Planned) Date Week | The time the shipment is supposed to be picked up. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Pickup (Planned) Date Week of Year | The time the shipment is supposed to be picked up. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Pickup (Planned) Date Year | The time the shipment is supposed to be picked up. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Refunded Date Date | The time the consumer received a refund for the return shipment. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Refunded Date Day of Week | The time the consumer received a refund for the return shipment. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Refunded Date Hour of Day | The time the consumer received a refund for the return shipment. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Refunded Date Month | The time the consumer received a refund for the return shipment. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Refunded Date Quarter | The time the consumer received a refund for the return shipment. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Refunded Date Time | The time the consumer received a refund for the return shipment. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Refunded Date Time of Day | The time the consumer received a refund for the return shipment. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Refunded Date Week | The time the consumer received a refund for the return shipment. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Refunded Date Week of Year | The time the consumer received a refund for the return shipment. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Refunded Date Year | The time the consumer received a refund for the return shipment. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Return Pickup [RPU] Date Date | This timestamp just refers to a return shipment. It represents the time when a return shipment has been picked up by the carrier. |
| 🕒 Return Pickup [RPU] Date Day of Week | This timestamp just refers to a return shipment. It represents the time when a return shipment has been picked up by the carrier. |
| 🕒 Return Pickup [RPU] Date Hour of Day | This timestamp just refers to a return shipment. It represents the time when a return shipment has been picked up by the carrier. |
| 🕒 Return Pickup [RPU] Date Month | This timestamp just refers to a return shipment. It represents the time when a return shipment has been picked up by the carrier. |
| 🕒 Return Pickup [RPU] Date Quarter | This timestamp just refers to a return shipment. It represents the time when a return shipment has been picked up by the carrier. |
| 🕒 Return Pickup [RPU] Date Time | This timestamp just refers to a return shipment. It represents the time when a return shipment has been picked up by the carrier. |
| 🕒 Return Pickup [RPU] Date Time of Day | This timestamp just refers to a return shipment. It represents the time when a return shipment has been picked up by the carrier. |
| 🕒 Return Pickup [RPU] Date Week | This timestamp just refers to a return shipment. It represents the time when a return shipment has been picked up by the carrier. |
| 🕒 Return Pickup [RPU] Date Week of Year | This timestamp just refers to a return shipment. It represents the time when a return shipment has been picked up by the carrier. |
| 🕒 Return Pickup [RPU] Date Year | This timestamp just refers to a return shipment. It represents the time when a return shipment has been picked up by the carrier. |
| 🕒 Return Ready for Linehaul Collection Date Date | Timestamp indicating when the return shipment is ready for pickup after processing by the carrier or third-party logistics provider. |
| 🕒 Return Ready for Linehaul Collection Date Day of Week | Timestamp indicating when the return shipment is ready for pickup after processing by the carrier or third-party logistics provider. |
| 🕒 Return Ready for Linehaul Collection Date Hour of Day | Timestamp indicating when the return shipment is ready for pickup after processing by the carrier or third-party logistics provider. |
| 🕒 Return Ready for Linehaul Collection Date Month | Timestamp indicating when the return shipment is ready for pickup after processing by the carrier or third-party logistics provider. |
| 🕒 Return Ready for Linehaul Collection Date Quarter | Timestamp indicating when the return shipment is ready for pickup after processing by the carrier or third-party logistics provider. |
| 🕒 Return Ready for Linehaul Collection Date Time | Timestamp indicating when the return shipment is ready for pickup after processing by the carrier or third-party logistics provider. |
| 🕒 Return Ready for Linehaul Collection Date Week | Timestamp indicating when the return shipment is ready for pickup after processing by the carrier or third-party logistics provider. |
| 🕒 Return Ready for Linehaul Collection Date Week of Year | Timestamp indicating when the return shipment is ready for pickup after processing by the carrier or third-party logistics provider. |
| 🕒 Return Ready for Linehaul Collection Date Year | Timestamp indicating when the return shipment is ready for pickup after processing by the carrier or third-party logistics provider. |
| 🕒 Returned To Warehouse [RWH] Date Date | The time the return shipment was returned to the warehouse of the sender. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Returned To Warehouse [RWH] Date Day of Week | The time the return shipment was returned to the warehouse of the sender. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Returned To Warehouse [RWH] Date Hour of Day | The time the return shipment was returned to the warehouse of the sender. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Returned To Warehouse [RWH] Date Month | The time the return shipment was returned to the warehouse of the sender. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Returned To Warehouse [RWH] Date Quarter | The time the return shipment was returned to the warehouse of the sender. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Returned To Warehouse [RWH] Date Time | The time the return shipment was returned to the warehouse of the sender. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Returned To Warehouse [RWH] Date Time of Day | The time the return shipment was returned to the warehouse of the sender. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Returned To Warehouse [RWH] Date Week | The time the return shipment was returned to the warehouse of the sender. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Returned To Warehouse [RWH] Date Week of Year | The time the return shipment was returned to the warehouse of the sender. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 Returned To Warehouse [RWH] Date Year | The time the return shipment was returned to the warehouse of the sender. Based on data provided by the shop. Presented in the chosen format. |
| 🕒 SLA (Calculated) Date Date | The time the shipment should receive its first delivery attempt as agreed with the carrier. Represents the sum of the timestamp of the first delivery attempt plus the SLA Days set within the settings ... |
| 🕒 SLA (Calculated) Date Day of Week | The time the shipment should receive its first delivery attempt as agreed with the carrier. Represents the sum of the timestamp of the first delivery attempt plus the SLA Days set within the settings ... |
| 🕒 SLA (Calculated) Date Month | The time the shipment should receive its first delivery attempt as agreed with the carrier. Represents the sum of the timestamp of the first delivery attempt plus the SLA Days set within the settings ... |
| 🕒 SLA (Calculated) Date Quarter | The time the shipment should receive its first delivery attempt as agreed with the carrier. Represents the sum of the timestamp of the first delivery attempt plus the SLA Days set within the settings ... |
| 🕒 SLA (Calculated) Date Week | The time the shipment should receive its first delivery attempt as agreed with the carrier. Represents the sum of the timestamp of the first delivery attempt plus the SLA Days set within the settings ... |
| 🕒 SLA (Calculated) Date Week of Year | The time the shipment should receive its first delivery attempt as agreed with the carrier. Represents the sum of the timestamp of the first delivery attempt plus the SLA Days set within the settings ... |
| 🕒 SLA (Calculated) Date Year | The time the shipment should receive its first delivery attempt as agreed with the carrier. Represents the sum of the timestamp of the first delivery attempt plus the SLA Days set within the settings ... |
| 🕒 Seven Senders Hub Scan [SHS] Date Date | The time the shipment received its first scan in a Seven Senders hub. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Seven Senders Hub Scan [SHS] Date Day of Week | The time the shipment received its first scan in a Seven Senders hub. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Seven Senders Hub Scan [SHS] Date Hour of Day | The time the shipment received its first scan in a Seven Senders hub. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Seven Senders Hub Scan [SHS] Date Month | The time the shipment received its first scan in a Seven Senders hub. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Seven Senders Hub Scan [SHS] Date Quarter | The time the shipment received its first scan in a Seven Senders hub. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Seven Senders Hub Scan [SHS] Date Time | The time the shipment received its first scan in a Seven Senders hub. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Seven Senders Hub Scan [SHS] Date Time of Day | The time the shipment received its first scan in a Seven Senders hub. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Seven Senders Hub Scan [SHS] Date Week | The time the shipment received its first scan in a Seven Senders hub. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Seven Senders Hub Scan [SHS] Date Week of Year | The time the shipment received its first scan in a Seven Senders hub. Based on data provided by the carrier. Presented in the chosen format. |
| 🕒 Seven Senders Hub Scan [SHS] Date Year | The time the shipment received its first scan in a Seven Senders hub. Based on data provided by the carrier. Presented in the chosen format. |
| Counting Working Days AVG Working Days count | Average number of days between the selected starting timestamp and today. The calculation adapts based on the chosen day-counting rule (Mon–Fri, Mon–Sat, Mon–Sun). |
| Counts by Tag [#] Damaged | The number of individual shipments which have been reported as damaged. Based on data provided by the carrier. |
| Counts by Tag [#] Delayed | The number of individual shipments that are delayed. A shipment can be either counted as delayed based on data provided by the carrier or when the SLA Days provided by the shop within the Seven Sender... |
| Counts by Tag [#] With Delivery | The number of individual shipments which were delivered. Based on data provided by the carrier. |
| Counts by Tag [#] FDA Timeout | The number of individual shipments that missed their expected First Delivery Attempt. Based on data provided by the shop within the settings in the Seven Senders Portal. |
| Counts by Tag [#] With FDA | The number of individual shipments with a first delivery attempt. Based on data provided by the carrier. |
| Counts by Tag [#] FHS No FDA | The number of individual shipments that have a first hub scan [FHS] but no first delivery attempt [FDA]. A shipment is tagged no by this metric if FHS and FDA are both populated or if neither FHS nor ... |
| Counts by Tag [#] FHS Timeout | The number of individual shipments which missed their expected First Hub Scan. A shipment receives a First Hub Scan Timeout as soon as it did not receive a First Hub Scan within the defined amount of ... |
| Counts by Tag [#] With FHS | The number of individual shipments with a first hub scan. Based on data provided by the carrier. |
| Counts by Tag [#] Impacted by Holidays | The number of individual shipments where a public nation wide holiday took place in the country of the warehouse, the consumer or the carrier during the transportation of the shipment. |
| Counts by Tag [#] Lost | The number of individual shipments which have been reported as lost. Based on data provided by the carrier. |
| Counts by Tag [#] On The Way | Shipments, which current status is NOT Delivered, Lost, or Delivered to pickup point. |
| Counts by Tag [#] Pickup No FDA | The number of individual shipments having a planned pickup but no first delivery attempt [FDA]. A shipment is tagged no by this metric if Pickup and FDA are both populated or if neither Pickup nor FDA... |
| Counts by Tag [#] Pickup No FHS | The number of individual shipments missing a first hub scan although have been picked up already. A shipment is tagged no by this metric if Pickup and FHS are both populated or if neither Pickup nor F... |
| Counts by Tag [#] Postal Return | The number of individual shipments the carrier was not able to deliver and therefore returned it to the sender. Based on data provided by the carrier. |
| Counts by Tag [#] Return Parcel | The number of individual return shipments. Based on data provided by the shop. |
| Counts by Tag [#] Return Portal (7S) | The number of individual return shipments created via the Seven Senders Return Portal or Parcel Finder. |
| Counts by Tag [#] Successful FDA | The number of individual shipments which were successfully delivered with the first delivery attempt. Based on data provided by the carrier. |
| Counts by Tag [#] To Pickup Point | The number of individual shipments which were delivered to a pick up point. Based on data provided by the carrier. |
| Share by Tag [%] Has Tracking Code | Share of shipments, that have a tracking code. |
| Parcel Count w/ Tracking Codes [#] | Number of shipments that have a tracking code. |
| Share by Tag [%] Damaged | The share of individual shipments which have been reported as damaged. Based on data provided by the carrier. |
| Share by Tag [%] Delayed | The share of individual shipments that are delayed. A shipment can be either counted as delayed based on data provided by the carrier or when the SLA Days provided by the shop within the Seven Senders... |
| Share by Tag [%] Delivered To Pickup Point | The share of individual shipments which were delivered to a pick up point. Based on data provided by the carrier. |
| Share by Tag [%] Is Delivered | The share of individual shipments which were delivered. Based on data provided by the carrier. |
| Share by Tag [%] FDA Timeout | The share of individual shipments that missed their expected First Delivery Attempt. Based on data provided by the shop within the settings in the Seven Senders Portal. |
| Share by Tag [%] Has FDA | The share of individual shipments with a first delivery attempt. Based on data provided by the carrier. |
| Share by Tag [%] FHS No FDA | The share of individual shipments that have a first hub scan [FHS] but no first delivery attempt [FDA]. A shipment is tagged no by this metric if FHS and FDA are both populated or if neither FHS nor F... |
| Share by Tag [%] FHS Timeout | The share of individual shipments which missed their expected First Hub Scan. A shipment receives a First Hub Scan Timeout as soon as it did not receive a First Hub Scan within the defined amount of h... |
| Share by Tag [%] Has FHS | The share of individual shipments with a first hub scan. Based on data provided by the carrier. |
| Share by Tag [%] Impacted by Holidays | The share of individual shipments where a public nationwide holiday took place in the country of the warehouse, the consumer or the carrier during the transportation of the shipment. |
| Share by Tag [%] Lost | The share of individual shipments which have been reported as lost. Based on data provided by the carrier. |
| Share by Tag [%] On The Way | Shipments, which current status is NOT Delivered, Lost, or Delivered to pickup point. |
| Share by Tag [%] Pickup No FDA | The share of individual shipments that have a planned pickup but no first delivery attempt [FDA]. A shipment is tagged no by this metric if Pickup and FDA are both populated or if neither Pickup nor F... |
| Share by Tag [%] Pickup No FHS | The share of individual shipments missing a first hub scan although have been picked up already. A shipment is tagged no by this metric if Pickup and FHS are both populated or if neither Pickup nor FH... |
| Share by Tag [%] Postal Return | The share of individual shipments the carrier was not able to deliver and therefore returned it to the sender. Based on data provided by the carrier. |
| Share by Tag [%] Return Parcel | The share of individual return shipments. Based on data provided by the shop. |
| Share by Tag [%] Return Portal (7S) | The share of individual return shipments created via the Seven Senders Return Portal or Parcel Finder. |
| Share by Tag [%] Successful FDA | The share of individual shipments which were successfully delivered with the first delivery attempt. Based on data provided by the carrier. |
| Share [%] - Column Total | The share of individual shipments per column. Measures the relation of the individual shipments of a column against the total amount of shipments of a column. |
| Share [%] - Row Total | The share of individual shipments per row. Measures the relation of the individual shipments of a row against the total amount of shipments of a row. |
| Shipment Count [#] | The number of individual shipments. Based on data provided by the shop. |
| Weight [AVG] | The average weight of shipments. Based on data provided by the shop. |
| [AVG] SLA Fulfillment [%] | The percentage of parcels where the First Delivery Attempt occurred within the expected number of days (SLA) after the First Hub Scan, irrespective if an FDA occurred or not. Adjusted for carrier work... |
| Return (Yes / No) | A filter to indicate if a shipment is returned by the consumer. Based on data provided by the shop. |
| Return Portal (Yes / No) | A filter to indicate if a return shipment was created via the Seven Senders Return Portal or Parcel Finder. |
| Counting Working Days Choose Datetime Source | Select which timestamp is used as the starting point for counting days. |
| Counting Working Days Working Day | Choose how days are counted: Monday–Friday excludes weekends, Monday–Saturday excludes Sundays, and Monday–Sunday counts all days. |
Shipment Lead Times
| Field Name | Description |
|---|---|
| Lead Time Combination | All available lead times. Suggestion: Pivot this measure if using multiple lead times for improved visualisation, if applicable. For filtering use Filter Only Fields 'Lead Time'. |
| Carrier Info Carrier Working Days | The weekdays carrier does delivery. Default for both outbound and inbound parcels, unless otherwise specified - then see 'Carrier Working Days - Inbound'. |
| Carrier Info Carrier Working Days - Inbound | If customer has provided 7S carrier working days for inbound parcels that differ from default working days, this field is populated. If populated, it will impact the following lead time combinations: ... |
| Carrier Info Carrier → Destination | Last-mile carrier used for delivery and the consumer country. |
| Date Changes Tier | Categorizes the number of days a shipment's lead time has changed into predefined tiers. |
| Custom Fields Date Changes Tier [0-6]: Current Status to Current Time | Lead time in days from Current Status to Current Time in clusters of < 0 to > 6. This combination is not available in other lead time fields. |
| Carrier Info Zalando Working Days | The weekdays when the carrier does the delivery as agreed with Zalando. (May be different from carrier working days) Default for both outbound and inbound parcels. |
| AVG Lead Time | The time duration between the start of a tracking event and the occurrence of a subsequent change, excluding bank holidays from the calculation. |
| AVG Lead Time [Bank Holidays Included] | The time elapsed between the start of a tracking event and a subsequent change, with bank holidays counted as working days in the calculation. |
| Cumulative [%] lead time shares +5 days [%] | The percentage of total shipments where the lead time changed by more than 5 days (i.e., 6 days or more). This measure is not cumulative. |
| Cumulative [%] lead time shares 0 days cumulative [%] | The percentage of total shipments where the lead time changed by less than 1 day (i.e., 0 days change). |
| Cumulative [%] lead time shares 1 days cumulative [%] | The percentage of total shipments where the lead time changed by less than 2 days (i.e., 0 or 1 day change). |
| Cumulative [%] lead time shares 2 days cumulative [%] | The percentage of total shipments where the lead time changed by less than 3 days (i.e., 0, 1, or 2 days change). |
| Cumulative [%] lead time shares 3 days cumulative [%] | The percentage of total shipments where the lead time changed by less than 4 days (i.e., 0, 1, 2, or 3 days change). |
| Cumulative [%] lead time shares 4 days cumulative [%] | The percentage of total shipments where the lead time changed by less than 5 days (i.e., 0, 1, 2, 3, or 4 days change). |
| Cumulative [%] lead time shares 5 days cumulative [%] | The percentage of total shipments where the lead time changed by less than 6 days (i.e., 0, 1, 2, 3, 4, or 5 days change). |
| Day Cluster [#] Within 0 Days [#] | Total count of shipments where the lead time was 0 days, i.e. both events happened the the same day. |
| Day Cluster [%] Within 0 Days [%] | The share of shipments where the lead time was 0 days (same day) out of all shipments with a selected lead time. |
| Day Cluster [#] Within 1 Days [#] | Total count of shipments where the lead time was 1 days or less. |
| Day Cluster [%] Within 1 Days [%] | The share of shipments where the lead time was 1 days or less out of all shipments with a selected lead time. |
| Day Cluster [#] Within 2 Days [#] | Total count of shipments where the lead time was 2 days or less. |
| Day Cluster [%] Within 2 Days [%] | The share of shipments where the lead time was 2 days or less out of all shipments with a selected lead time. |
| Day Cluster [#] Within 3 Days [#] | Total count of shipments where the lead time was 3 days or less. |
| Day Cluster [%] Within 3 Days [%] | The share of shipments where the lead time was 3 days or less out of all shipments with a selected lead time. |
| Day Cluster [#] Within 4 Days [#] | Total count of shipments where the lead time was 4 days or less. |
| Day Cluster [%] Within 4 Days [%] | The share of shipments where the lead time was 4 days or less out of all shipments with a selected lead time. |
| Day Cluster [#] Within 5 Days [#] | Total count of shipments where the lead time was 5 days or less. |
| Day Cluster [%] Within 5 Days [%] | The share of shipments where the lead time was 5 days or less out of all shipments with a selected lead time. |
| [#] Shipment With Leadtime | |
| Lead Time | Filter to select which lead time(s) to calculate. To visualise lead times, select 'Lead Time Combination' under 'Dimensions'. |
| Time Metrics | Filter to select type of lead time output: hours, days or date changes. |
| Working Days | Filter to select which weekdays are used to calculate lead times. Select 'Carrier' for automated selection of weekdays per carrier working days. |
Shipment SLA Performance
| Field Name | Description |
|---|---|
| E+ | Expected number of days parcel delivery is expected to take. Can vary per lead time combination. Data provided by the customer. |
| Event Combination | SLA performance calculated as the duration from the initial event to the final expected event. |
| SLA Status | Identifies whether the shipment’s lead time for the specific lead time combination is in accordance with the SLA E+ days. |
| # Breached | Count of shipments that did not meet the SLA threshold. [Requires filter 'Event Combination'] |
| # Projected Breach | Count of shipments that are projected not meet the SLA threshold. [Requires filter 'Event Combination'] |
| # Projected Within | Count of shipments that are projected to meet the SLA threshold. [Requires filter 'Event Combination'] |
| # Within | Count of shipments that met the SLA threshold. [Requires filter 'Event Combination'] |
| % Breached | Percentage of shipments that did not meet the SLA threshold. [Requires filter 'Event Combination'] |
| % Customized SLA Performance | Percentage of shipments that were completed within SLA compared to all shipments (within, breached, and projected breach). [Requires filter 'Event Combination'] |
| % Projected Breached | Percentage of shipments that are projected not meet the SLA threshold. [Requires filter 'Event Combination'] |
| % Projected Within | Percentage of shipments that are projected to meet the SLA threshold. [Requires filter 'Event Combination'] |
| % Within | Percentage of shipments that met the SLA threshold. [Requires filter 'Event Combination'] |
Shop
| Field Name | Description |
|---|---|
| Account | The name of the account the shop is belonging to. One account can have multiple shops. |
| Shop | The name of the shop. |
| Shop Count [#] | The number of individual shops. Depending on the chosen fields and filters. |
| Shop Share [%] | The share of individual shops. Depending on the chosen fields and filters. |
Warehouse
| Field Name | Description |
|---|---|
| City | |
| Country | |
| Country [ISO2] | |
| Warehouse Name | Warehouse of shipment. Set by shop. |
| Zip Code |
Updated about 2 hours ago