[ATTEMPT ANALYTICS] What does each column in the 'Attempt Analytics' report mean?

See the table below for definitions of all columns in the "Attempt Analytics" report. Extract reports

Column	Name	Definition
A	DC ID	Distribution center ID
B	DC Name	Distribution center name
C	DC Time Zone	Local DC time zone
D	Route ID	Unique route identifier (auto-generated with SDK and CSV imports, assigned on server API imports)
E	Route Name	Name of route
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	Driver Groups	Driver Group Name the driver belongs to. If the driver does not belong to any groups, this field is blank.
K	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)
L	Customer ID	The unique identifier for this customer
M	Customer Name	Name of this customer
N	Customer Location Confidence	Indicates whether the location for this customer that was used for sequencing and measuring the driver performance was confident and trusted
O	Visit Start Timestamp	Detected stop timestamp, if this visit was during a stop, this value indicates the start of that stop. If this visit was not during a stop (ie, the driver clicked while driving), this value is blank. Does not equal the driver click timestamp (formatted as YYYY-MM-DD HH:MM:SS)
P	Visit Duration Seconds	Detected stop duration, if this visit was during a stop, this value indicates the start of that stop. If this visit was not during a stop (ie, the driver clicked while driving), this value is blank. Does not equal the driver click timestamp (formatted as YYYY-MM-DD HH:MM:SS)
Q	Visit Meters from Customer	Distance in meters from the stop centroid or immediate click location to the customer or best knowledge of the inferred customer location (if this customer location is not trusted yet and it does not have any previous clicks, this value will be blank)
R	Driver Click Timestamp	The timestamp the driver clicked that customer was serviced or attempted to be serviced (formatted as YYYY-MM-DD HH:MM:SS)
S	Aggregate Visit Status	A visit to a customer can have one or many service statuses: 1) SUCCESSFUL: the customer was fully serviced, 2) FAILED: the customer was not serviced at all. See Visit Status Codes and Messages for more details, 3) VISIT_LATER: the customer was not able to be serviced and the driver wanted to come back later, 4) MIXED: the customer was partially serviced or rejected the services, or the driver wanted to visit the customer later for some of the services they ordered
T	Sequence Adherence Status	The status of this visit in regards to adhering to Foxtrot Systems' live sequencing suggestions. This can be: 1) ADHERED: This is a customer the driver was directed to or nearby enough to adhere to Foxtrot Systems' sequencing, 2) NOT_ADHERED: This is a customer the driver was not directed to or not nearby enough to adhere to Foxtrot Systems' sequencing, 3) NO_DECISION: This is a visit that we could not determine whether the driver adhered to the sequence or not. This can be because the route did not have real-time routing enabled, or they failed the customer before leaving the route start location geofence, 4) FORGIVEN: This is a special forgiveness case, if your operation allows to forgive the first attempt, whether it was adhered or not, this will show up as forgiven
U	Imported Waypoint Time Window	START and END times: imported ranges in which the customer must be visited (imported at the time of route creation or imported for visit re-attempt). SOURCE: indicates the origin of the time window considered for the visit. Possible values include: NOT_APPLICABLE: No imported time window for that customer. IMPORTED: The time window was supplied at route import. REATTEMPT_AUTHORIZATION: The time window comes from an authorized re-attempt. VISIT_LATER_AUTO: The time window comes from an automatic calculation from a previous visit by the driver with a "visit later" status. Foxtrot Systems creates the best possible option to visit that customer later.
V	Visit Timeliness	Timeliness status of the visit considering the imported time window (imported at the time of route creation or imputed for visit re-attempt). Possible values: 1) Not applicable: No imported time window for that customer. 2) On Time: The visit attempt was made during one of the imported time windows. 3) Early: the visit attempt was made before the start of the nearest time window. 4) Late: the visit attempt was made after the end of the nearest time window.
W	Beta: Suspicious Drive By Attempt Flag	Drive By is defined as the sequence of events in which a driver performs the service on a customer outside the sequence suggested by Foxtrot Systems, does not record the visit in the application, and later returns to that location only to make the click on the customer location. That way he manages to increase the following indicators: a) Sequence Adherence b) Driver Click Score This is a behavior that should be AVOIDED, as it can impact: 1) Service level: estimated time of arrival (ETA) accuracy for customers 2) Route productivity: increase of distance traveled 3) Foxtrot Systems' learning capabilities: learning about the best time to visit a customer and the time required per visit is inconsistent with reality, thus decreasing the speed and effectiveness of Foxtrot Systems' machine learning mechanism. Drive-by details
X	Beta: Inferred Service Duration Seconds	The duration in seconds of the service time that occurred on this customer. If the delivery was failed, the value will be blank.