See the table below for definitions of all columns in the "Ratings Analysis" report. Report extraction steps
Important: This report is only available to users using the End Customer Portal (ECP) product. About ECP
Column |
Name |
Definition |
|---|---|---|
A |
DC ID |
Distribution center ID |
B |
DC Name |
Distribution center name |
C |
DC Time Zone |
Local DC time zone |
D |
Logistics Route ID |
Unique route Identifier (auto-generated with SDK and CSV imports, assigned on Server API imports) |
E |
Logistics Route Name |
Route Name |
F |
Planned Route Start Date |
Planned route start date in local DC time zone. Formatted as YYYY-MM-DD |
G |
Planned Route Start Timestamp |
Planned route start timestamp in local DC time zone. Formatted as YYYY-MM-DD HH:mm:SS |
H |
Driver ID |
Driver ID that was detected to have driven the route. Might differ from originally assigned or currently assigned driver |
I |
Driver Name |
Driver name that was detected to have driven the route. Might differ from originally assigned or currently assigned driver |
J |
Waypoint ID |
The unique identifier for this customer in this route. This is usually used by systems to identify a certain instance of a customer in a route. |
K |
Customer ID |
The unique identifier for this customer |
L |
Customer Name |
The name of this customer |
M |
Customer Rating ID |
Unique ID of the rating |
N |
Customer Rating Timestamp |
Date and time of the customer's rating in the DC's time zone. In format YYYY-MM-DD HH:MM:SS |
O |
Customer Rating Value |
Rating generated by the customer |
P |
Customer Rating Text |
The comment generated by the customer |
Q |
Delivery Timestamp |
Date and time of delivery of the planned route in the time zone of the DC. In format YYYY-MM-DD HH: mm: SS |