To help you manage and analyse your Road Ninja driver activity, you're able to export your job data for further manipulation in your favourite spreadsheet tools.
Viewing Your Job Data
Log into your Road Ninja account
Go to 'Jobs' in the sidebar navigation
View all data or use the filters to drill into specific data
The following filters can be applied to export specific job data, if no filters are selected, it will export all job data.
All dates - to filter the dates based on when a job occurred. Payments correspond with dates the job was done, not the date the job was paid
All statuses - to filter by job payment status, disputed jobs, faulty vehicles, expired and not expired jobs
All regions - to filter by region
All drivers - to filter by a specific driver, or leave set as "All drivers" to export all driver job data
All vehicles - to filter by a specific vehicle
Exporting Your Job Data
Click 'Export' to export the data that you're currently seeing in Road Ninja
Your job data will be exported as a .csv file - ready for importing into Excel or Google Sheets:
Your job data .csv file has a tonne of information. Here's what each column's header relates to:
# - row numbering that's independent from your spreadsheet row numbers
Title - the job name
Start date - the jobs start date
End date - the jobs end date
Repeat days - how many days this job was originally booked for
Duration - estimated job time in minutes
Overnight - whether the job ran overnight or not
Status - the status of the job
Regions - where the job start location was
Company - the name of the company for that specific job
Driver - the name of the driver related to this job
Vehicle - the vehicle that was assigned to the driver/job
Need vehicle replacement - whether the assigned vehicle needed replacement
Trailer - whether a trailer was used in this job (instead of a vehicle)
Need trailer - whether the assigned trailer needed replacement
Car type - what type of vehicle was used for this job
Assignment - any selected assignments for this job
Auto approved - whether the job was set to 'auto-approve' on driver acceptance
New message count - how many messages were sent between driver/company
Work time - the job time calculated by Road Ninja or logged by the driver
Work time price - the driver's hourly rate multiplied by the work time
Work time price GST - the GST amount for the work time price
Work time total - the total cost of this job based on work time
Work time total fee - the service fee that Road Ninja charged for the work time
Work time total fee GST - the GST component for the work time total fee
Hourly rate - the driver's hourly rate when the job was accepted
Fixed price - whether this job was a fixed price job
Estimate price - the original booking hours multiplied by the drivers hourly rate
Estimate price GST - the GST component of the estimated price
Estimate time - the original time booked
Estimate total - the estimated total cost of the job based on estimated time
Estimate total fee - the Road Ninja service fee component for the estimated total
Estimate total fee GST - the GST component for the estimated total
Final duration - the final job time (after disputes)
Final fee - the Road Ninja service fee for the final total
Final fee GST - the GST component for the final fee
Final payment - the GST-inclusive driver payment (based on final duration)
Final payment GST - the total GST component for the final payment
Final total - the total that a company pays, including fees and GST
Paid date - the date on which the payment for that job was made
Here's what your exported job data will look like 👇
