Fulfillment Data Analysis
- Rahul Kumar Sahukar
Introduction
Fenix provides a data analytics platform that helps the retailers with in depth information about their shipments what will help them to optimize their shipping process and save a significant amount on their shipping spend by selecting the most cost effective service to deliver the product, meeting the shopper estimated delivery date promises.Â
Information needed for the data analysis
The following information is needed to do the shipment analysis
Shipment data - Fenix does the analysis on retailer’s past order data. To get an in depth review, it would need at least an year’s worth of order data. The data should contain the following information.
Â
Field Name | Required | Details |
order id | Yes | The order id of the shipment |
shipment id | Yes | The shipment id |
order created date time | No | The order created date and time |
shipment created date time | No | The shipment created date and time |
shipment pick up time | No | The date and time when the shipment is picked up by the carrier |
shipment delivery time | No | The date and time when the shipment is delivered by the carrier |
shipping method | No | The shipping option the customer chose on the checkout |
origin address line | No | The address line of the fulfillment location |
origin city | No | The city of the fulfillment location |
origin state | No | The state of the fulfillment location |
origin country | Yes | The country of the fulfillment location |
origin zip code | Yes | The zip code of the fulfillment location |
destination address line | No | The address line of the buyer |
destination city | No | The city of the buyer |
destination state | No | The state of the buyer |
destination country | Yes | The country of the buyer |
destination zip code | Yes | The zip code of the buyer |
carrier | Yes | The carrier selected for shipping |
service | Yes | The shipping service selected for shipping |
tracking number | Yes | The tracking number of the shipment |
shipment length | Yes | The shipping box length in inches |
shipment width | Yes | The shipping box width in inches |
shipment height | Yes | The shipping box height in inches |
shipment weight | Yes | The shipping box weight in inches |
ship cost paid | Yes | The shipping cost paid to the carrier in USD |
Â
File Format
The file should be provided in the comma separated format
If a field data is not available, pass an empty value