Learn More About Shipment Dashboard Data Variables
Overview
Find the complete list of Basic, Advanced, to Custom Fields filters along with their definitions and how each can be used in combination with another to drill down shipments data tailored to your specific needs.
Basic filters
Here are the list of basic filters that you can use to filter your shipment data based on specific business requirements.
The Basic filters are divided into three categories
General: Filter shipments based on the general information like carrier, destination, source, etc.
Timeline: Filter shipments based on the specific dates and timelines like estimated delivery date, pickup date, shipment creation date, and more
Events: Filter shipments based on the specific events that happened with the shipment like latest location, issues, latest checkpoint date, and more
| Filter | Definition |
|---|---|
| Carrier/Service | The carrier and the corresponding service type of the shipment. If the tracking has both destination and origin courier, then the origin courier will be populated as the Carrier by default. |
| Origin | The origin country/state/city the parcel is shipped from. |
| Destination | The Destination country/state/city the parcel is shipped to. |
| Source | The source from where the shipments is imported. E.g., Shopify, Tracking API etc. |
| Filter | Definition |
|---|---|
| Status | Current status of tracking. |
| Estimated delivery date | The estimated delivery date of the shipment. |
| Order promised date | The promised delivery date of the order. |
| Order date | The ordered date of the shipment. |
| Create date | The date that the shipment created in AfterShip Tracking. |
| Pickup date | The date the shipment was picked up by the carrier. |
| Delivery date | The delivered date of the shipment. |
| Latest updated date | The date of the latest checkpoint of the shipment. |
| Latest location | The location of the latest checkpoint of the shipment. |
| Failed delivery attempts | The failed delivery attempts count of the shipment. |
| Transit time | Total delivery time in days. |
| On-time status | Describing whether the tracking is delivered on time or not. |
| Issue | Issues happened to a shipment. |
| List of issues | |
| Returned to sender | |
| Shipment lost | |
| Shipment damaged | |
| Historical events | Historical events of a shipment. |
| List of events | |
| Shipment canceled | |
| Redelivery scheduled | |
| Shipment dropped off at a collection point | |
| Misrouted rerouted | |
| Rejected by recipient | |
| Delivered to neighbor | |
| Signed by customer | |
| Delivered to a location | |
| Held by customs (More to come) | |
| Tag | The shipment tags defined by user |
| Shopify order tag | The Shopify order tags that are imported from the Shopify store. |
Advanced events
Here is the list of advanced events you can use for a more microscopic view of your shipments.
| Events | Reasons | Definition | Example checkpoint |
|---|---|---|---|
| Shipment canceled | The shipment has been voided or canceled by the sender or carrier. | ||
| Redelivery scheduled | An attempt to deliver the shipment failed. The carrier will try again. | e.g.1. We tried to deliver the package, but the receiver was unavailable and the delivery agent needs a signature as proof. A second attempt will be made the next business day. We'll contact the sender or receiver about this delivery. e.g.2. The receiver has moved. We're attempting to obtain a new delivery address for this receiver. Your delivery has been rescheduled for the next business day. | |
| Reasons | |||
| No access to delivery location | The carrier had no access to the delivery location at the time of delivery. | ||
| Absent recipient | The customer was not at the given address. | ||
| Business closed | The business was closed at the time of delivery. | ||
| Customer moved | The customer is no longer at the given address. | ||
| Dropped off at a collection point | The shipment has been dropped off at a collection point for the customer to collect it. | ||
| Misrouted | The shipment has arrived at an incorrect address or checkpoint. The carrier must reroute the package. | We've misrouted the package. This may cause a delay. | |
| Rerouted | The shipment's delivery address has been changed. | Delivery address changed | |
| Rejected by recipient | Delivery of the shipment failed as the customer refused to accept the package. | The receiver states the product was not ordered and has refused the delivery. Your delivery has been rescheduled for the next business day. | |
| Delivered to neighbor | The shipment has been left with a neighbor. | ||
| Signed by customer | The shipment has been delivered and signed for by the customer. | Signature obtained | |
| Delivered to a location | The shipment has been delivered to the address or specified location. | Shipment has been delivered to consignee | |
| Return to sender | The customer has requested to return the shipment to the sender. The shipment was not collected by the customer. | e.g.1. Incomplete address information may delay delivery. We are attempting to update this information. The package is being returned to the sender at a different service level. e.g.2. The maximum days to hold the package at the UPS Access Point™ location expired. The package will be returned. | |
| Reasons | |||
| No access to delivery location | The carrier had no access to the delivery location at the time of delivery. | ||
| Customer moved | The customer is no longer at the given address. | ||
| Incorrect missing address | The shipment has an incorrect or missing address. | ||
| Unclaimed parcel | The shipment was not collected by the customer. | ||
| Held by customs | The shipment has been held at customs. | Your shipment is being held under the General Order regulations and may be taken into customs possession. / Your package is on the way | |
| Reasons | |||
| Prohibited item | The shipment has been found to include prohibited items. | ||
| Shipment lost | The shipment was lost. | ||
| Shipment damaged | The shipment was damaged. | Damage noted by consignee, partial receipt accepted | |
| Shipment undelivered | The shipment can't be delivered. | ||
| Reasons | |||
| Unable to collect payment | The carrier was unable to collect payment at the time of delivery. | ||
| Outside delivery limits | The shipment has arrived at a carrier facility that no longer covers the customer's address. | ||
| Incorrect/Missing address | The shipment has an incorrect or missing address. | ||
| No such number | The delivery address has a nonexistent house/apartment number. | ||
| Shipment update | The carrier has sent an update regarding the shipment. |
Filter options
Property type
| Property type | Description | Example | |
|---|---|---|---|
| String | Status | A shipment only have one value under this property. | For example, Status is a string property, as a shipment only have one status |
| Carrier | |||
| Origin | |||
| Destination | |||
| On-time status | |||
| Source | |||
| Array | A shipment have multiple values under this property. | For example, Tags is an array property, as a shipment have one of multiple tags. | |
| Tags | |||
| Shopify order tags | |||
| Shopify tags | |||
| Issues | |||
| Historical Events | |||
| Custom field keys | |||
| Date/Time | Estimated delivery date | The date to a specific process/milestone of a shipment. | |
| Order promised date | |||
| Order date | |||
| Create date | |||
| Pickup date | |||
| Delivery date | |||
| Latest updated at | |||
| Numerical | Transit time |
Filter options for String property
| Filter options | Definition | Example |
|---|---|---|
| is any of | A Shipment's property must have at least one of these values to be included in the list. | For example, if you filter by Status and select is any of In Transit or Info Received, the shipments list will include Shipments with status that is either In Transit or Info Received |
| is none of | A Shipment's property must not have all of these values to be included in the list. | For example, if you filter by Status and select is none of In Transit or Info Received , the shipments list will include Shipments with status that is neither In Transit nor Info Received |
Filter options for Array property
| Filter options | Definition | Example |
|---|---|---|
| is any of | For Array properties, a shipment’s property must have at least one of the selected values to be included in the list. | For example, if you filter by Tags and select is any of Restock, Approved, the shipments list will include Shipments with tags contains either Approved or Restock. |
| is none of | For Array properties, a shipment’s property must have at least one of the selected values to be included in the list. | For example, if you filter by Tags and select is none of Restock, Approved, the shipments list will include Shipments with tags contains neither Approved nor Restock. |
| is all of | For Array properties, a shipment’s property must have all of these values to be included in the list. | For example, if you filter by Tags and select is all of Restock, Approved, the shipments list will include Shipments with tags contains both Approved and Restock. |
| is null | All Shipments that do not have a value for the property will be included in the list. | For example, if you filter by Tags and select is null, the shipments list will include Shipments without tags. |
| is not null | All Shipments with a value for the property will be included in the list. | For example, if you filter by Tags and select is not null, the shipments list will include Shipments with atleast one tag. |
Filter options for Date/Time property
| Filter options | Definition | Example |
|---|---|---|
| is between | A record’s property must have a date value that is equal to or after the first selected date and equal to or before the second selected date to be included in the list. | |
| is equal to | A record’s property must have a date value that is exactly the selected date to be included in the list. | |
| before | A record’s property must have a date value that is before the selected date to be included in the list. | |
| after | A record’s property must have a date value that is after the selected date to be included in the list. | |
| is null | All Shipments that do not have a value for the property will be included in the list. | For example, if you filter by Estimated delivery date and select is null, the shipments list will include Shipments without Estimated delivery date. |
| is not null | All Shipments with a value for the property will be included in the list. | For example, if you filter by Estimated delivery date and select is not null, the shipments list will include Shipments with Estimated delivery date. |
| is in the last x days | A record’s property must have a date value that is in the last number of days you enter. | For example, if you filter by Latest updated at and select is in the last 7 days, the shipments list will include Shipments with Latest updated at in the last 7 days. |
| not in the last x days | A record’s property must not have a date value that is in the last number of days you enter. | For example, if you filter by Latest updated at and select not in the last 7 days, the shipments list will include Shipments list that is not Latest updated in the last 7 days. |
| (i) The records with empty values will not be included. (ii) last x days counts today | ||
| updated in last x days | A record's property must have been updated within the last number of days you enter. | For example, if you filter by Estimated delivery date and select updated in the last 7 days, the shipments list will include Shipments with Estimated delivery date updated in the last 7 days. |
| (i)* Only applies to filters: Estimated delivery date and filter. (ii) Update include a value get revised/turned empty/added. (iii) last x days counts today | ||
| not updated in last x days | A record's property must not have been updated within the last number of days you enter. | For example, if you filter by Estimated delivery date and select not updated in the last 7 days, the shipments list will include Shipments with Estimated delivery date without any updates in the last 7 days. |
| (i) Only applies to filters: Estimated delivery date and filter. (ii) The records with empty values will not be included. (iii) last x days counts today | ||
| is in the next x days | A record’s property must have a date value that is in the next number of days you enter. | For example, if you filter by Estimated delivery date and select is in the next 7 days, the shipments list will include Shipments with Estimated delivery date in the next 7 days. |
| (i) Only applies to filters Estimated delivery date and Order promised date |
Filter options for Numerical property
| Filter options | Description |
|---|---|
| is equal to | Equals |
| is between X and Y | Greater than or equal to X, but Less than or equal to Y |
| is greater than | Greater than |
| is greater than or equal to | Greater than or equal to |
| is less than | Less than |
| is less than or equal to | Less than or equal to |
Uses cases
| Use cases | Filter combinations |
|---|---|
| Specific events | |
| Rerouted shipments | Historical event is any of Rerouted |
| Returned caused by missing or incorrect address | (i) Historical event is any of Returned to sender (ii) Reason is any of Incorrect/Missing Address |
| Held by custom clearance at HK | (i) Historical event is any of Held by customs (ii) Event date is today (iii) Location is any of HK |
| Stalled shipments | |
| Scenario 1 - Pending carrier to ship: It happens when a tracking number and the shipping label is already generated, where indeed information was only sent digitally but the package is still not shipped. When this tracking number is not updated with a status after 1-2 days I need an internal note to inform me. | |
| Scenario 2 - Carrier not moving for a period: It happens when a carrier is carrying a parcel but the status is not updated for a while, potentially caused by exception scenarios. E.g. The package is Lost | |
| Shipments with no updates for X days | Latest update is not in last X days |
| Shipments with no updates for 5 days since Shipping label created | (i) Latest update is not in last X days (ii) Status is any of info received |
| Shipment estimations | |
| EDD revised in last week | Estimated delivery date is updated in last 7 days |
| Arriving tomorrow | Estimated delivery date is in the next 1 day |
| Shipments without EDD | Estimated delivery date is null |
| Estimated to be late than the order promised day | (i) Estimated delivery date is after YYYY-MM-DD (ii) Order promised date is before YYYY-MM-DD |
| Others | |
| Lastly checked in California that is currently under exception (because of a hurricane) | (i) Latest location is any of California (ii) Status is any of Exception |
Updated on: 18/01/2024
Thank you!