Reporting: Evaluating Progress and Impact
By completing this reporting training program for RideAmigos site administrators, you will be able to perform all major functions related to viewing and editing report data using RideAmigos.
- Understand the basics of RideAmigos data structure as it pertains to reporting
- Learn how to access the different types of reports available to administrators
- Edit, filter, and sort report fields
- Bookmark favorite reports for future reference
Estimated Time for Completion: 45 minutes
(Each lesson will open in a new window so you can easily return to this module.)
Lesson 1: Understanding RideAmigos Data Structure (~ 10 minutes)
To understand your reporting options it will help to first understand how data is stored within the RideAmigos system.
- Browse through your site with an eye toward data objects and how different objects are created and connected.
- Visit the edit pages for an example user and network and note how the object IDs appear in the corresponding page URLs.
- If you haven’t already, create some additional data by setting up your commute (trip plan) in the My Commute widget and logging some trips via the trip logging widget.
Lesson 2: Reporting 101 (~ 20 minutes)
RideAmigos offers a multitude of system-wide and program-specific reporting options for site administrators. Here’s where to start.
- Visit Manage > System Reports | Users.
- Add the created column and click to sort your report by created date.
- Add a filter to the created column to only view users created in the past week.
- Bookmark this New Users report using your web browser for quick future access.
- Visit Manage > System Reports | Triplogs.
- Click the “Updated X ago” text to refresh the report results.
- Add the origin, destination, and source columns.
- Remove the CO2 savings column.
- Sort by the Date Time column then filter to dates from the past month.
- Click the Mode Breakdown button to see your report’s mode stats.
- Export your report to an Excel file.
- Visit some report pages from your example (or real-life) programs and practice accessing sub-reports, downloading reports, adding and removing columns, and familiarizing yourself with what information is available where.
Lesson 3: Trip Plan Reports and Heatmaps (~ 10 minutes)
System Trip Plan and Trip Search reports offer additional visual reporting tools, such as heatmaps.
- Visit Manage > System Reports | Trip Plans.
- Use the map view to find and zoom in on an area with data.
- Try out the different data visualization options
- Test the ability to filter results by coordinate by defining origin or destination areas on the map.
Lesson 4: The Reporting Lexicon (~ 5 minutes)
Sometimes it can be difficult to remember which fields appear on which objects and what they mean. Don’t feel like you have to read each line of the lexicon, just review it and make note of its availability as a reference document.
- Re-visit Manage > System Reports | Users.
- Explore some of the additional columns available, such as Apps Used, Carpool Messages Sent, Updated, etc.
- Edit the report’s date range to only view trips logged for the past week.
- Add the Alternative Miles and Dollars Savings columns.
- The resulting report will show you the Alternative Miles logged and the Dollar and CO2 savings for the past week for each user who has logged trips.
After completing all of the assignments for this module you should have created the following:
- Bookmarked New Users report
Double-check that you have successfully created all of the above objects and associations, they may be referenced in future modules.