Routeava data guide

Send the smallest dataset that can answer the operating question.

Routeava does not need a complete customer database to begin. A limited, anonymized period is safer and usually sufficient for qualification.

Minimum fields

FieldPurpose
DateGroups work into employee-days and comparable periods.
Anonymous stop IDTracks recurring locations without requiring customer names.
Service address or coordinatesSupports geographic and travel analysis.
Assigned technician or crewShows workload and territory assignments.
Job typePrevents unlike services from being treated as identical.
Planned order or timeShows the intended sequence or appointment constraint.
Completion statusSeparates completed, canceled, and rescheduled work.

Helpful additional fields

Actual arrival and departure, planned and actual service duration, recurrence frequency, customer time windows, employee start location, required skills or equipment, and approved job revenue.

Do not include

Payment-card data, bank records, Social Security numbers, medical records, government identification, passwords, or unrelated customer notes. Remove customer names when anonymous location IDs will work.

File rules

The Phase 0 intake accepts CSV, XLSX, PDF, PNG, and JPG. Structured CSV or XLSX data is strongly preferred. Screenshots and PDFs may be useful for discovery but are poor primary sources for repeated analysis.