Motive Analytics Data Fields

The Motive Analytics data model organizes key reporting fields into categories. Each data field includes a description of its purpose and how it can be used to analyze fleet performance and compliance.

Compliance

Maintenance

Safety

Telematics

Face Match

Data Field	Description
Driver Identification Method	The method used to identify the driver for the trip.
Face Match Action Performed	The specific face match action executed for the trip.
Face Match Request Status	The current status of the face match request.
Face Match Suggestion Status	The status of the face match suggestion generated for the trip.
Face Match Profile ID	The unique identifier of the fleet user profile associated with the trip.
Face Match Profile Status	The current status of the associated fleet user profile.
Camera Connection Status	The connection state of the camera during the trip.
Camera Obstruction Status	Indicates if the camera view was obstructed during the trip.
Driver ID Feature Status	The enablement status of the driver identification feature.
Identification Familiarity	Whether the driver was identified as a familiar or unfamiliar profile.
Face Match Eligible Trip	The eligibility status of the trip for face match processing.
Trip Assigned via Face Match	Indicates successful identification via face match technology.
Trip Assigned via Driver App	Indicates successful identification via the connected Driver App.
Image Recall Pending	The pending state of the image recall process for the trip.
Identification Confidence	The statistical confidence level of the driver identification result.
New Face Match Request	Indicates the creation of a new face match request for the trip.
Face Match Location Data	The availability of location data specifically for the face match trip.
Non-Company Driver	Classifies the identified driver as a non-company fleet user.
Face Match Registered	The registration status of the trip within the face match system.
Unfamiliar Profile Created	Confirms if a new "unfamiliar" profile was created due to no match.
Face Match Failure Reason	The specific reason a face match attempt failed for an eligible trip.

AI Coach

Data Field	Description
AI Coached Behaviors	The list of driving behaviors highlighted in the AI recap.
AI Recap Review Status	The current review status of the AI recap.
Generated AI Recaps	The total number of AI recap videos generated.
Shared AI Recaps	Total AI recap videos shared via in-app or SMS notifications.
Reviewed AI Recaps	Total AI recap videos officially marked as reviewed by drivers.
Time to Review Recap (hours)	The duration (in hours) between sharing the recap and driver review.
AI Recap Review Rate	The percentage of generated recaps that have been reviewed.
AI Recap Created At	The timestamp indicating when the AI recap video was generated.
AI Recap Shared Time	The timestamp indicating when the recap was sent to the driver.
AI Recap Reviewed Time	The timestamp indicating when the driver reviewed the recap.

Assets

Note: Assets data is currently only available in the United States and Canada. 

Data Field	Description
Asset Alias	The name or alias of the asset.
Assets Only	Use it to just filter on all the assets in a company.
Date	The universal date for the recorded event or activity. For date and time, include the keyword "detailed" in your data search. All times are localized to your time zone. Default to this unless minute or second level precision is needed.
Geofence Entry Time	The timestamp indicating when the asset detention period started within a geofence.
Geofence Exit Time	The timestamp indicating when the asset detention period ended within a geofence.
Asset Length	The length of the asset in meters/ft.
Asset GAWR	The gross vehicle weight rating of the asset in kilograms/lbs.
Asset GVWR	The gross axle weight rating of the asset in kilograms/lbs.
Asset Motion Distance	The distance traveled by the asset while in motion, displayed in miles or kilometers based on the selected Distance Unit parameter.
Asset Detention Duration (minutes)	The total time in minutes an asset spent within a geofence, calculated from geofence entry to exit time (or current time if still inside).
Geofence Visits	The number of distinct geofence detention periods recorded for an asset i.e., how many times an asset entered and was tracked within a geofence.
AG Assigned At	The timestamp when an Asset Gateway was assigned to an asset, localized to the selected time zone.
AG Unassigned At	The timestamp when an Asset Gateway was unassigned from an asset, localized to the selected time zone.
Total Asset Gateways	The total count of unique Asset Gateways across all assignment states (both assigned and unassigned).
Assigned Gateways	The count of unique Asset Gateways that are currently assigned to an asset.
Current Assigned Asset	Current asset assigned to the gateway.
Last Assigned Asset	Last assigned asset to the gateway.
Asset Lifetime Distance Moved	Total distance moved till now by an asset.
Asset Engine Hours	The number of engine hours of the asset at the time of recording.
Asset Lifetime Engine Hours	The lifetime engine hours of the asset till now.
Asset Gateways Only	Use it to just filter on all the assets gateways in a company.
Total Assets	Total number of assets in a fleet.
Asset with Gateways	Total number of assets attached to gateways.
Asset without Gateways	Total number of assets not attached to gateways.
Asset Group Name	The name of the group to which the asset belongs. Each asset assigned to a sub-group is also a member of the parent groups within the group hierarchy. If you want to only view assets that have been assigned to a specific sub-group, include the keyword "is explicit group member" in your data search.
Explicit Asset Group Member	Indicates whether the asset was explicitly assigned to this group (otherwise we consider an asset to be a member of all of the parent groups they were assigned to, even if they were not explicitly assigned to those parent groups).
Asset Group Depth	The number of levels down in the hierarchy that the Asset Group Name is located. For example, in the Asset Group Path "North America -> California -> Los Angeles", the Asset Group Name, Los Angeles, is at a Asset Group Depth of 3.
Asset Parent Group Name	The name of the parent group that's one hierarchical level above the selected Asset Group Name. For example, Asset Group Name is Los Angeles and Parent Group Name is California.
Asset Group Path	A flattened view of the group hierarchy between the highest-level Asset Parent Group Name and the lowest-level Asset Group Name. For example: "North America -> California -> Los Angeles".
Fleet Asset Member Group Ids	Array of groups the asset is a member of. Using the cascading model of group membership, where the asset is also a member of all parent groups to the groups it has been explicitly assigned to.
Geofence Address	Physical address of the geofence, based on centroid coordinates of the polygon.
Geofence Description	Description of the geofence entered by the Motive customer.
Geofence Category	Category name assigned to the geofence.
Geofence Name	Name of the geofence.
Geofence Status	Status of the geofence, if it is activated/deactivated.
Fleet Account Id	Unique identifier (primary key) for an motive customer account.
Fleet Account Name	Name of the company.
Asset Make	The manufacturer of the asset.
Asset Model	The model of the asset.
Asset Model Year	The model year of the asset.
Asset Status	The current status of the asset.
Asset Ownership	The ownership status of the asset (Leased/Purchased).
Asset Subtype	The subtype of asset.
Asset Type	The type of asset.
Asset Vin	Vehicle Identification Number (VIN) of the asset.
Asset License	License plate information of the asset.
Asset Axles	The number of axles on the asset.
Asset Battery Percentage	The battery percentage of the asset at the time of recording.
Asset Motion Duration (seconds)	The duration in seconds that the asset was in motion during the recorded hour.
Firmware Version	The firmware version of the Asset Gateway device.
Asset Gateway Model	The hardware model of the Asset Gateway device.
Asset Gateway Name	Name of the Asset Gateway device.
Software Version	The current software package version of the Asset Gateway device.

Devices

Note: Devices data is currently only available in the United States and Canada. 

Data Field	Description
Date	The universal date for the recorded device status. For date and time, include the keyword "detailed" in your data search. All times are localized to your time zone.
Status From Time	Timestamp when the status/sub-status became active.
Status To Time	Timestamp when the status ended. For current record, it is current date/time.
User App Version	App version (and platform) the user is using.
User Last Activity	Most recent activity timestamp across mobile and web (localized to your time zone).
User License Number	Drivers license number prefixed with state.
Device Status	High-level device hub status.
Device Sub Status	Granular sub-status (e.g., "GPS Lost" under "Disconnected").
Device Last Activity Time	Last timestamp when device became active.
Device Status Last Update Time	Timestamp when status of devices was last updated.
Vehicle Availability Status	Current availability status of the vehicle.
Device	Type of the devices based on the model.
Device Firmware Version	Current firmware version of the device.
Device Power Sources	List of power-sources attached to device.
Recommended Action	Recommended action based on device sub status and status.
Current Vehicle Battery Status	'Low Vehicle Battery' when the connected Vehicle Gateway is healthy but inactive for more than 7 days and the vehicle's primary-source ignition voltage is below 10; otherwise NULL.
Is Current Status	Indicates whether this row represents the device's current (latest) status.
Device Type	Type of device (e.g. Vehicle Gateway, Dashcam).
Device Model	Hardware model of the device.
Device Serial Number	Serial number of the hardware device.
Last Recorded Vehicle Location	Nearest recorded vehicle location at or shortly before the status change.
Fleet Account Id	Unique identifier (primary key) for a motive customer account.
Fleet Account Name	Name of the company.
Vehicle ID	Alias assigned to the vehicle.
VIN	Vehicle identification number.
Vehicle Make	Make of the vehicle.
Vehicle Model	Model of the vehicle.
Vehicle Model Year	Model year of the vehicle.
License Plate Number	License plate number of the vehicle.
Driver Type	The driver type, such as 'ELD', 'Logs Not Required', or 'Electronic Logbook'.
Driver Full Name	Full name of the user.
User ID	Alias assigned to the user.
User Email Address	Email address of the user.
Username	Username of the user.
User Status	The current status of the user. One of either 'active' or 'deactivated'.
User Role	Role of the user.
User Cycle Rule	The Log cycle rule description that applies to the user.
User Time Zone	The time zone setting for the user.
User Joined At	Timestamp of when the user was created.
User Group Name	The name of the group to which the user belongs. Each user assigned to a sub-group is also a member of the parent groups within the group hierarchy. If you want to only view users that have been assigned to a specific sub-group, include the keyword "is explicit group member" in your data search.
Vehicle Group Name	The name of the group to which the vehicle belongs. Each vehicle assigned to a sub-group is also a member of the parent groups within the group hierarchy. If you want to only view vehicles that have been assigned to a specific sub-group, include the keyword "is explicit group member" in your data search.
Explicit User Group Member	Indicates whether the user was explicitly assigned to this group (otherwise we consider a user to be a member of all of the parent groups they were assigned to, even if they were not explicitly assigned to those parent groups).
Explicit Vehicle Group Member	Indicates whether the vehicle was explicitly assigned to this group (otherwise we consider a vehicle to be a member of all of the parent groups they were assigned to, even if they were not explicitly assigned to those parent groups).
User Group Depth	The number of levels down in the hierarchy that the User Group Name is located.
User Parent Group Name	The name of the parent group that's one hierarchical level above the selected User Group Name.
User Group Path	A flattened view of the group hierarchy between the highest-level User Parent Group Name and the lowest-level User Group Name.
Vehicle Group Depth	The number of levels down in the hierarchy that the Vehicle Group Name is located.
Vehicle Parent Group Name	The name of the parent group that's one hierarchical level above the selected Vehicle Group Name.
Vehicle Group Path	A flattened view of the group hierarchy between the highest-level Vehicle Parent Group Name and the lowest-level Vehicle Group Name.
Weight Class	Classification of a vehicle based on its weight.
Is Historical Record	True when device has history of changes in its status.
Geofence Name	Geofence name where device is currently present.

Cards

Note: Cards data is currently only available in the United States. 

Data Fields	Description
Transaction Time	The time the transaction occurred.
Vehicle ID	The unique identifier assigned to each vehicle.
User Email Address	The email address associated with the user.
Transaction Amount USD	The transaction amount in US dollars.
Transaction Rebate USD	The rebate amount earned for the transaction in US dollars.
Transaction Missed Savings USD	The estimated missed savings amount in US dollars when not using a preferred merchant.
Transaction Gasoline Purchase Volume	The gasoline fuel quantity for the transaction, in gallons or liters.
Transaction Fuel Purchase USD	The total fuel purchase amount in US dollars.
Transaction Diesel Purchase Volume	The diesel fuel quantity for the transaction, in gallons or liters.
Transaction Avg Fuel Price	The average fuel price per liter in US dollars.
Transaction Total Fuel Purchase Volume	The total fuel volume for the transaction, in gallons or liters.
Transactions	The number of transactions.
Declined Transactions	The number of declined transactions.
Percent Declined Transactions	The percentage of transactions that were declined.
In Network Transactions	The number of in-network transactions.
Percent In Network Transactions	The percentage of transactions that were in-network.
In Network Spend USD	The total in-network spend amount in US dollars.
Percent In Network Spend	The percentage of total spend that was in-network.
Trip Distance	The distance traveled during the trip.
Fuel Spend per Distance (mi/km)	The fuel spend per mile or kilometer traveled.
Date	The universal date for the recorded event or activity. All times are localized to your time zone. For date and time, include the keyword "detailed" in your data search.
Transaction Posted Time	The time the transaction was posted.
Transaction Cleared Time	The time the transaction was cleared.
Card Last Four Digits	The last four digits of the card number.
Invoice Number	The unique number assigned to the invoice.
Pre-Transaction Field Name	The name of the pre-transaction metadata field.
Pre-Transaction Field Source	The source system of the pre-transaction metadata.
Pre-Transaction Field Value	The value of the pre-transaction metadata field.
Vehicle Fuel Type	The type of fuel used by the vehicle.
Vehicle Model	The model of the vehicle.
Vehicle Make	The make of the vehicle.
Vehicle VIN	The unique Vehicle Identification Number (VIN) of the vehicle.
Vehicle Weight Class	The weight class of the vehicle.
User Full Name	The full name of the user.
User ID	The unique identifier assigned to the user.
User Role	The role assigned to the card user.
User Credit Limit USD	The credit limit assigned to the user in US dollars.
User Status	The current status of the card user.
Transaction Status	The current status of the transaction.
Transaction Has Receipt	Whether a receipt is attached to the transaction.
Transaction Irregularity Reasons	The reasons for any irregularities on the transaction.
Transaction Is In Network	Whether the merchant is in the accepted network.
Transaction Merchant Category Code Description	The description of the merchant category code.
Transaction Merchant Category Code Name	The name of the merchant category code.
Transaction Note	The note attached to the transaction.
Transaction Dispute Status	The dispute status of the transaction.
Transaction Decline Reason	The reason for the declined transaction.
Card ID	The user-provided alias for the card.
Cardholder Type	The type of cardholder.
Card Display Status	The current status of the card.
Cardholder Name	The name of the cardholder.
Merchant Name	The name of the merchant.
Merchant State	The location of the merchant.
Merchant Street	The street address of the merchant.
Merchant Zip	The zip code of the merchant location.
Merchant Latitude	The latitude coordinates of the merchant location.
Merchant Longitude	The longitude coordinates of the merchant location.
Merchant City	The location of the merchant.
Company Current Billing Cycle	The current billing cycle for the account.
Company Current Credit Limit USD	The credit limit for the account in US dollars.
Invoice Start Time	The start time of the invoice billing period.
Invoice Paid In Full Date	The date the invoice was paid in full.
Invoice Amount USD	The total invoice amount in US dollars.
Invoice Opening Balance USD	The opening balance for the invoice period in US dollars.
Invoice Payable Amount USD	The net payable amount on the invoice in US dollars.
Invoice Payment Due Date	The date payment for the invoice is due.
Invoice Purchase Amount USD	The total purchase amount billed on the invoice in US dollars.
Invoice Rebate Amount USD	The total rebate amount applied to the invoice in US dollars.
Fleet Account ID	The unique identifier of the fleet account.
Invoice End Time	The end time of the invoice billing period.
Transaction Irregularity Status	The irregularity review status of the transaction.
Transaction Irregularity Type	The type of irregularity detected in the transaction.
Transaction Product Types	The types of products purchased in the transaction.
Card Type	The type of card, indicating whether it's physical or virtual.
User Group Name	The name of the group to which the user belongs. Each user assigned to a sub-group is also a member of the parent groups within the group hierarchy. If you want to only view users that have been assigned to a specific sub-group, include the keyword "is explicit group member" in your data search.
Vehicle Group Name	The name of the group to which the vehicle belongs. Each vehicle assigned to a sub-group is also a member of the parent groups within the group hierarchy. If you want to only view vehicles that have been assigned to a specific sub-group, include the keyword "is explicit group member" in your data search.
Explicit User Group Member	Indicates whether the user was explicitly assigned to this group (otherwise we consider a user to be a member of all of the parent groups they were assigned to, even if they were not explicitly assigned to those parent groups).
Explicit Vehicle Group Member	Indicates whether the vehicle was explicitly assigned to this group (otherwise we consider a vehicle to be a member of all of the parent groups they were assigned to, even if they were not explicitly assigned to those parent groups).
User Group Depth	The number of levels down in the hierarchy that the User Group Name is located. For example, in the User Group Path "North America -> California -> Los Angeles", the User Group Name, Los Angeles, is at a User Group Depth of 3.
User Group Path	A flattened view of the group hierarchy between the highest-level User Parent Group Name and the lowest-level User Group Name. For example: "North America -> California -> Los Angeles".
User Parent Group Name	The name of the parent group that's one hierarchical level above the selected User Group Name. For example, User Group Name is Los Angeles and Parent Group Name is California.
Vehicle Group Depth	The number of levels down in the hierarchy that the Vehicle Group Name is located. For example, in the Vehicle Group Path "North America -> California -> Los Angeles", the Vehicle Group Name, Los Angeles, is at a Vehicle Group Depth of 3.
Vehicle Parent Group Name	The name of the parent group that's one hierarchical level above the selected Vehicle Group Name. For example, Vehicle Group Name is Los Angeles and Parent Group Name is California.
Vehicle Group Path	A flattened view of the group hierarchy between the highest-level Vehicle Parent Group Name and the lowest-level Vehicle Group Name. For example: "North America -> California -> Los Angeles".

 

Share this with others