We have nearly 200 different data fields available within our reporting structure. Curious what one of them means? Just search for it on this page (Ctrl + F for PC users, CMD + F for Mac users).

If you haven’t previously read Reporting 101 or  Understanding RideAmigos data structure it might be helpful to brush up your knowledge of how RideAmigos reports, objects and fields work and interact.

Note: Not all fields are actively used by all platforms, and some platforms may include custom fields not listed here. Management privilege can also reduce the amount of fields available for you to view.

User Object Fields

Name of ColumnLocation UsedDefinitionResponse Type
_id(users)Unique ID of specific userstring
[Mode] Calories(users)Total number of calories burned for a specific modenumber
[Mode] Co2 Reduction (grams)(users)Total amount of Co2 reduced compared to driving alone for a specific mode, given in grams.number
[Mode] Miles(users)Total count of miles for a specific modenumber
[Mode] Savings(users)Total count of money saved compared to driving alone for a specific modenumber
[Mode] Trips(users)Total count of trips for a specific modenumber
Achievements(users)Badges the user has earned by logging tripsarray
ActiveAccount(users)If a user has a password or single sign-on credential within the system, it is deemed an ‘active’ account.true/false
ActiveEventTrips(users)Number of active saved trips for an eventnumber
AlternativeCo2(users)Amount of Co2 expended by trips logged by alternative modes.number
AlternativeDollars(users)Total dollars spent for alternative mode trips loggednumber
AlternativeMiles(users)Total miles logged by use of alternative modesnumber
AlternativeTrips(users)Total number of alternative (non-sov) trips loggednumber
AlternativeVehicles(users)Total vehicle count for alternative mode trips logged (drive alone = 1 vehicle, carpool = .5, etc.)number
App trips(users)Number of trips logged via app integrationsnumber
Apps used(users)Apps and integrations the user has connected toarray
Calories(users)Amount of calories burned by all trips loggednumber
Carpool Messages Sent(users)Number of messages sent by this user to other usersnumber
Co2 Actual(users)Amount of Co2 expended over all the user’s trips and modes logged.number
Co2 Savings(users)Amount of Co2 reduced by not driving alone.number
Created(users)Date the user joined the system or was importeddate
DisplayName(users)User’s public display name, used for challenges, carpool cards, and leaderboardsstring
DollarsActual(users)Amount of money expended over all the users trips and modes logged.number
DollarsSavings(users)Amount of money saved by not driving alone.number
Email(users)Email address associated with accountstring
Email Bouncing(users)Has a system email to a user been rejected by their servertrue/false
EmployeeID(users)Field that states user’s employee IDnumber
EmployerName(users)Field that states user’s employerstring
ExpiredEventTrips(users)Number of expired saved trips for eventsnumber
FavoriteTrips(users)Number of favorite tripsnumber
FirstName(users)First name of account userstring
Has Commute Tracker App(users)User has connected their account to the CommuteTracker apptrue/false
HasPassword(users)If a user has a saved password within the system, this is marked as ‘true’.true/false
Home City(users)Home city of userstring
Home County(users)Home county/township/etc.string
Home Location(users)Home location of user (may be zip or full address)string
Home State(users)Home state of userstring
Home Street 1(users)First line of user’s street addressstring
Home Street 2(users)Second line of user’s street addressstring
HomeZip(users)Home zip code entered when user registerednumber
IsAdmin(users)States if the user has full admin capabilitiestrue/false
LastLoginDate(users)Last time the user logged in by any devicedate
LastName(users)Last name of account userstring
ManagedNetworkCount(users)Count of networks that user has management access tonumber
ManagedNetworks(users)Names of networks that user has management access toarray
Miles(users)Total miles loggednumber
Modes(users)Modes the user has logged trips ofarray
NetworkCount(users)Number of networks associated to user accountnumber
Networks(users)Names of networks associated to user accountarray
Notes(users)text
PhoneNumber(users)User’s phone numbernumber
PostRegistrationCapture(users)User’s answer to specific question posed immediately after registration.string
Source(users)When a user registers, this is set. Can be: Self-Registered, Challenge, Event, Importedstring
Tags(users)Tags applied to the user’s accountarray
TermsAcceptanceDate(users)Date user last accepted the terms of usedate
Trips(users)Number of trips loggednumber
Updated(users)Last date the user’s account was updated with new informationdate
Usual Mode(users)Expressed usual mode preference of userstring
VehiclesActual(users)Actual vehicles on the road due to their trips.number
VehiclesSavings(users)Amount of vehicles removed from the road due to the user’s mode choices.number
WantsTripUpdateEmails(users)Option that can be set for users by Administrators. Currently unused.true/false
Work City(users)Work city of userstring
Work County(users)Work county/township/etc.string
Work Location(users)Work location of user (may be zip or full address)string
Work State(users)Work state of userstring
Work Street 1(users)First line of user’s work street addressstring
Work Street 2(users)Second line of user’s work street addressstring
WorkZip(users)Work zip code entered when user registerednumber

Network Object Fields

Name of ColumnLocation UsedDefinitionResponse Type
_id(networks)Unique ID of specific networkstring
[Mode] Co2 Reduction(networks)Total amount of Co2 reduced compared to driving alone for a specific mode by members within the network, given in grams.number
[Mode] Miles(networks)Total count of miles for a specific mode by members within the networknumber
[Mode] Savings(networks)Total count of money saved compared to driving alone for a specific mode by members within the networknumber
[Mode] Trips(networks)Total count of trips for a specific mode by members within the networknumber
ActiveMemberCount(networks)Number of members who have logged trips within the specified time framenumber
AlternativeCalories(networks)Number of calories burned by users within the network using alternative modesnumber
AlternativeDollars(networks)Total dollars spent for alternative mode trips logged by members within the networknumber
AlternativeMiles(networks)Total miles logged by use of alternative modes by members within the networknumber
AlternativeTrips(networks)Total number of alternative (non-sov) trips logged by members within the networknumber
AlternativeVehicles(networks)Total vehicle count for alternative mode trips logged by members within the network (drive alone = 1 vehicle, carpool = .5, etc.)number
AncestorNetworkCount(networks)If network is a subnetwork, count of parent networksnumber
AncestorNetworkNames(networks)If network is a subnetwork, name of parent networksarray
Calories(networks)Total number of calories burned for a specific mode by members within the networknumber
Calories(networks)Amount of calories burned by all trips logged by all members within the networknumber
ChildNetworkCount(networks)Number of subnetworks associatednumber
ChildNetworkNames(networks)Names of subnetworks associatedarray
Co2Actual(networks)Amount of Co2 expended over all the network’s members trips and modes logged.number
Co2Savings(networks)Amount of Co2 reduced by not driving alone by members of the networknumber
Created(networks)Date the network was created in the system or was importeddate
Description(networks)Description of networkstring
DollarsActual(networks)Amount of money expended over all the users trips and modes logged by members of the networknumber
DollarsSavings(networks)Amount of money saved by not driving alone by members of the networknumber
JoinURL(networks)URL that can be sent to prospective members of the network so that they may join directlyurl
Location(networks)Address set for the network originationaddress
ManagerCount(networks)Number of managers associated with the networknumber
ManagerEmails(networks)Email addresses of network managersarray
MemberCount(networks)Number of system users associated with the networknumber
Miles(networks)Total miles logged by members of the networknumber
Modes(networks)Modes logged by users within the networkarray
Name(networks)Name of networkstring
NewMemberCount(networks)Number of members who have created their account within the specified time framenumber
PublicVisibility(networks)If public, can be searched for by all users. If private, joinURL must be given. Private networks are also hidden from challenge leaderboards.public/private
Source(networks)unusedstring
Tags(networks)Reporting metadata that can be added to your networkstring
Trips(networks)Total number of trips logged by users in the networknumber
Type(networks)Type of networkstring
Updated(networks)Last date the network’s account was updated with new informationdate
VehiclesActual(networks)Number of actual vehicles on the road for all the trips of the members within the networknumber
VehiclesSavings(networks)Number of vehicles taken off of the road by trips logged by members within the networknumber

Trip Log Object Fields

Name of ColumnLocation UsedDefinitionResponse Type
_id(triplogs)Unique ID of specific trip logstring
AlternativeDollars(triplogs)Total dollars spent for the specific trip lognumber
AlternativeMiles(triplogs)Total miles for the specific trip log if mode was alternativenumber
AlternativeTrips(triplogs)If an alternative mode was used for this specific trip, the count will be 1number
AlternativeVehicles(triplogs)Vehicle count for specific trip if alternative modenumber
Calories(triplogs)Amount of calories burned for this specific tripnumber
Carpool Name(triplogs)Name of the saved carpool as defined by the userstring
Carpool Occupancy(triplogs)Based on logs from mutiple members of the carpoolnumber
Carpool Verified(triplogs)Did multiple members the carpool log the same triptrue/false
Co2Actual(triplogs)Amount of Co2 expended for this specific tripnumber
Co2Savings(triplogs)Amount of Co2 reduced by not driving alone for this specific tripnumber
Created(triplogs)Date the trip was created in the system or was importeddate
DateTime(triplogs)Date and time the trip was logged fordate/time
DayOfWeek(triplogs)Day of week that trip was logged forday
DestinationAddress(triplogs)End point of the triplogstring
DollarsActual(triplogs)Amount of money expended for this specific tripnumber
DollarsSavings(triplogs)Amount of money saved by not driving alone for this specific tripnumber
Manual Trip(triplogs)Was this trip created manually (true) or syncronized from a trusted source (false)true/false
Miles(triplogs)Total miles logged for the specific trip lognumber
Mode(triplogs)Mode of the specific trip logstring
Networks(triplogs)Names of networks associated with a specific trip logarray
Origin(triplogs)Starting point of the triplogstring
Source(triplogs)How the trip was logged (web, astro, strava, scoop, waze, api, etc.)string
TimeOfDay(triplogs)Specific time of day trip was logged fortime
Trips(triplogs)Will always show as 1 for each specific trip plannumber
Type(triplogs)Type of trip (commute/errand/recreation/other)string
Updated(triplogs)Last date the triplog was updated with new informationdate
UserEmail(triplogs)Email of user who logged the specific tripstring
UserId(triplogs)Unique ID of user associated with the specific trip logstring
UserName(triplogs)Full name of user who logged the specific tripstring
VehiclesActual(triplogs)Number of actual vehicles on the road for the specific tripnumber
VehiclesSavings(triplogs)Number of vehicles taken off the road by the specific tripnumber

Trip Plan Object Fields

Name of ColumnLocation UsedDefinitionResponse Type
_id(tripplans)Unique ID of specific trip planstring
Created(tripplans)Date the trip plan was created in the system or was importeddate
Destination Address(tripplans)Address of destination for trip planaddress
Destination Coordinates(tripplans)Latitude and Longitude for destination for trip planlat/long
Details(tripplans)Extra details added to a trip plan by the userstring
Expires(tripplans)Date and time that the trip expires, if it was a trip for a specific eventdate
Match Count(tripplans)Number of users who see this trip as a potential matchnumber
MemberCount(tripplans)Number of users associated to a specific trip plan that are not the ownernumber
MemberEmails(tripplans)Members of a specific trip plan (carpool)array
MessageCount(tripplans)Number of messages that have been sent to the owner of the specific trip plancount
Origin Address(tripplans)Address of origin for trip planaddress
Origin Coordinates(tripplans)Latitude and Longitude for origin for trip planlat/long
Preferences(tripplans)Additional details about the carpool that user has entered (driver/ride preferences)string
RelatedEvent(tripplans)If trip plan is associated with a specific event, the name of the event will show herestring
RoundTrip(tripplans)Will show as true if it has a return trip timetrue/false
Schedule(tripplans)Days and times of a specific trip plandays
SharedNetworks(tripplans)Names of networks associated with a specific trip planarray
SharedPublic(tripplans)Will show as true if it is viewable by all users within the systemtrue/false
SharingId(tripplans)ID used if users want others to ‘join’ their carpool/trip planstring
Tags(tripplans)unusedarray
Type(tripplans)Can either be Event or Commute. If associated with a specific event, it will be marked accordinglystring
Updated(tripplans)Last date the trip plan was updated with new informationdate
UserDisplayName(tripplans)Display name of owner of specific trip planstring
UserEmail(tripplans)Email of user who owns the specific trip planstring
UserFirstName(tripplans)First name of user who owns the specific trip planstring
UserId(tripplans)Unique ID of user who owns the specific trip planstring
UserLastName(tripplans)Last name of user who owns the specific trip planstring
UserNetworks(tripplans)Networks the user is associated toarray