10. Daily Reports

📘

Note

Processed telematics data contains information about tracks, points, and events after road mapping, events detection and filtering, scoring and other ML enrichments

Example of extracted zip for a given date:

📘

Note

Processed telematics data also can be exported to Amazon S3 or Google Cloud in zip for a specific date; zip file contains csv files that are described below
Instruction on how to set up data export

CSV Tables Description

Table name

Short description

TripSummary
:point-right: Description
:page-facing-up: Dataset

A list of processed trips with statistics and safe scoring.
What's there?

  • Final track entity based on RichTrackPoints
  • Safe score
  • Trip metrics
  • Trip events metrics
  • Start address
  • End address

TrackPoints
:point-right: Description
:page-facing-up: Dataset

Processed track points (waypoints)
What's there?

  • Track matching to road graph
  • Speed limits
  • Events matched to points
  • Phone usage (ML)
  • Rotation calculated (ML)

TrackEvents
:point-right: Description
:page-facing-up: Dataset

Processed and filtered events
What's there?

  • Events JSON parsing
  • Mapping phone usage to events
  • Calculating the index - fitstresholds (ML)

ScoringSummary
:point-right: Description
:page-facing-up: Dataset

User safe driving score and fine points calculation that is used as a basis for the safe driving score calculation
What's there?

  • Aggregated scores for 2-weeks period

UserState
:point-right: Description
:page-facing-up: Dataset

UserState report contains information about active users:

  • Personal info
  • Sensor's status
  • OS versions

Fraud
:point-right: Description
:page-facing-up: Dataset

Fraud contains information about suspicious events like:

  • Low power mode
  • GPS switch off
  • Mobile data switch off

VehicleSummary
:point-right: Description
:page-facing-up: Dataset

Vehicle summary report contains information about vehicles connected to DeviceToken and mileage information for given period

CoinsSummary
:point-right: Description
:page-facing-up: Dataset

The CoinsSummary report contains data on the total amount of coins and bonuses to users for the reporting period.

Trips
:point-right: Description
:page-facing-up: Dataset

Trips data to create BI reports

Device status
:point-right: Description
:page-facing-up: Dataset


Trip Summary

Field

Short description

Additional information

DeviceToken

Unique user id

ClientId

Unique user id set up by client

Email

Email of the user

TripId

Unique id for enriched trip;
equals to tracktoken

TripStartUtc

Start date of the trip in UTC

TripEndUtc

End date of the trip in UTC

TripStartLocal

Start date of the trip

TripEndLocal

End date of the trip

LocalTimeOffset

Timezone of the user location

StartLatitude

Start point Latitude

StartLongitude

Start point Longitude

FinishLatitude

Finish point Latitude

FinishLongitude

Finish point Longitude

DistanceKm

Trip distance in km

DurationMinutes

Trip duration in minutes

AverageSpeedKmh

Average speed in km/h

TripMode

Type of trip

ClassificationConfidence

Probability of UserLabel model estimation

UserLabel

Role of user in trip

OverallPoints

Overall penalty points for trip

AccelerationPoints

Acceleration penalty points for trip

BrakingPoints

Braking penalty points for trip

CorneringPoints

Cornering penalty points for trip

SpeedingPoints

Speeding penalty points for trip

DistractionPoints

Distraction penalty points for trip

StartRatingOverall

5-star rating of the trip

StartRatingAcceleration

Acceleration 5-star rating of the trip

StartRatingBraking

Braking 5-star rating of the trip

StartRatingCornering

Cornering 5-star rating of the trip

StartRatingSpeeding

Speeding 5-star rating of the trip

StartRatingDistraction

Distraction 5-star rating of the trip

NightTimeDrivingMinutes

Night time driving during the trip

AddressStart

Address of start

AddressFinish

Address of finish

UserTags

User tags

InstanceId

5-star Safe Score rating

TrackPoints

(Drive -> 1 file = 1 track's points)

Field

Short description

Additional information

PointDate

Point time

Latitude

Latitude (processed)

Longitude

Longitude (processed)

MidrouteGPS

Distance between previous and current point

Speed

Speed at point, in km/h

SpeedLimit

Speed limit at point, km/h

Distraction

1 - Phone usage
0 - No Phone usage

TrackToken

Unique identifier of trip

you can join with Trip Summary on this field

TrackEvents

(Events -> 1 file = 1 track's events)

Field

Short description

Additional information

PointDate

Datetime of event

Latitude

Latitude of event

Longitude

Longitude of event

AlertType

Type of event

  • Acc
  • Deacc

AlertValue

Force of event

m/s2

TrackToken

Unique identifier of trip

Scoring Summary

Field

Short description

Additional information

Devicetoken

Unique user id

ClientId

Unique user id set up by client

Email

Email of the user

Date

Date of calculation

scoreacceleration

2-week acceleration score

Part of safe score

scoredeceleration

2-week braking score

Part of safe score

scorespeeding

2-week speeding score

Part of safe score

scoredistraction

2-week phone usage score

Part of safe score

scoreturn

2-week cornering score

Part of safe score

ScoreOverall

2-week total safe score

calculation of 5 scores above

DistanceKm

Distance for 2-weeks period

km

TripAmount

Number of trips for 2-weeks period

DurationMinutes

Duration of trips for 2-weeks period

min

AccelerationPoints

Acceleration penalty points for 2-week period

Part of total points

BrakingPoints

Braking penalty points for 2-week period

Part of total points

SpeedPoints

Speed penalty points for 2-week period

Part of total points

DistractionPoints

Phone usage penalty points for 2-week period

Part of total points

TurnPoints

Cornering penalty points for 2-week period

Part of total points

TotalPoints

total penalty points for 2-weeks period

Total number of fine points from the 5 rows above

InstanceId

Unique id for instance

UserState

Field

Short description

Additional information

DeviceToken

User's ID

Email

Email of the user if registered

ClientId

Client's user id

FirstName

First Name

LastName

Last Name

NickName

Nickname

Wifi

Is wi-fi switched on?

On/off

GPS

Is gps switched on?

On/off

DataTransfer

Is datatransfer switched on?

On/off

DeviceOS

OS version of user's mobile phone

InstanceId

Instance Id

Fraud

Field

Short description

Additional information

DeviceToken

User's ID

ClientId

Client's user id

Email

Email of the user if registered

EventDate

Date of event

EventType

Type of event

Example:
'low battery'

InstanceId

Instance Id

VehicleSummary

Field

Short description

Additional information

DeviceToken

User's ID

ClientId

Client's user id

Email

Email of the user if registered

VehicleToken

Vehicle token if registered

VehicleId

Vehicle id if registered

Mileage

Mileage for a given period

km

MileageTotal

Total mileage to MileageDate

MileageDate

Date of last mileage total update

MileageInitial

Initial mileage for a given period

InstanceId

Instance Id

CoinsSummary

Field

Short description

Additional information

Date

Accrual date

DeviceToken

Unique id of user

Balance

Total Coins at the beginning of reporting period

Coins

Coins earned at reporting period

TotalCoins

Total Coins at the end of reporting period

LimitReached

Is limit reached?

Yes/no

InstanceId

Instance Id

Trips

Field

Short description

Additional information

TrackToken

unique track id

InstanceId

id of instance

InstanceName

name of instance

CompanyId

id of company

CompanyName

name of company

StartCountry

Country of track start point

FinishCountry

Country of track end point

StartCity

City of track start point

FinishCity

City of track end point

StartDistrict

District of track start point

FinishDistrict

District of track end point

StartPostalCode

Postal Code of track start point

FinishPostalCode

Postal Code of track end point

DeviceToken

User id

Rating100Bucket

Bucket of track's rating 40-60-80-100

Rating100

Rating of trip in 100-scale

RatingPhoneUsage100

Phone usage rating of trip in 100-scale

RatingOverSpeed100

Overspeed rating of trip in 100-scale

RatingAcceleration100

Acceleration rating of trip in 100-scale

RatingDeceleration100

Deceleration rating of trip in 100-scale

RatingCornering100

Cornering rating of trip in 100-scale

EcoScoring

Ecoscoring in 100-scale

EcoScoringDepreciation

Depreciation scoring in 100-scale

EcoScoringBrakes

Brakes scoring in 100-scale

EcoScoringFuel

Fuel scoring in 100-scale

EcoScoringTyres

Tyres scoring in 100-scale

DistanceGPSBucket

Bucket of trip's distance
0-10-30-50-70-100+ km

DistanceGPS

Distance of trip in km

StartDateDate

Date of trip's start

YearWeek

Week number of trip's start

StartDateHour

Hour of trip's start

HasOverspeed

Flag for overspending existence in trip

OverSpeedMileage

Low overspeed mileage

MidOverSpeedMileage

Mid overspeed mileage

HighOverSpeedMileage

High overspeed mileage

TotalOverspeed

Total overspeed mileage

Duration

Duration of trips in minutes

HasAcceleration

Flag for trip has accelerations

HasBraking

Flag for trip has braking

HasCornering

Flag for trip has cornering

AccelerationCount

Number of accelerations

DecelerationCount

Number of decelerations

CorneringCount

Number of cornerings

HasPhoneUsage

Flag for trips has phone usage

PhoneUsage

Phone usage in minutes

TripType

Intracity or between cities

Devicestatus

DEVICE TOKEN

Field

Short description

Additional information

UserID

DeviceTokenDeviceToken - It is a unique User ID that is generated by Damoov telematics platform and used by Telematics SDK as a user identifier. SDK connects all telematics data to the DeviceToken and transfers to Damoov platform. Then the DeviceToken is used across all our APIs and services as a unique app user ID.

Client ID

Custom field that can be added via user update API

Email

DateReceived

TotalStatus

Overall permissions status

OK - all permissions granted and the SDK can record trips
ISSUE - there is an issue with permissions and trips can't be recorded

PermissionsStatus

UpdateStatus

NetworkStatus

DeviceStatus

GPSPermissionsGranted

App level. GPS permissions

LowPreciseLocation

Low precise location.

The tracking can't work with low precise location enabled

MotionPermission

Motion sensor permissions

LowPowerMode

Low battery level or low battery mode

both items reduce tracking accuracy.

DeviceRooted

status on whether the device has been rooted or jailbraked

NotUploadedTripsCount

number of trips that were recorded but not uploaded to the server

NotUploadedLogsCount

number of log files that were recorded but not uploaded to the server

WifiEnabled

Status of WiFi

WiFi enabled significantly increase GPS accuracy

GpsEnabled

Smartphone level. GPS permissions

RealTimeDataEnabled

Status of product feature

Enabled - SDK broadcasts real time GPS data to 3rd party platform
Disabled - realtime data disabled

MobileDataEnabled

Latitude

Latest location

Longitude

Latest location

Accuracy

Latest level of GPS accuracy

SdkVersion

SDK version

OsVersion

smartphone OS version

Application

Application registered on Damoov platform

DeviceModel

Smartphone device model

ChargeLevel

Level of battery

BluetoothEnabled

Bluetooth status

TrackingEnabledByUser

InstanceId

user instance ID


Did this page help you?