Loading...

GPS Map Queries and Custom Reports in Excel

Reviewing a vehicle's history on a map is more useful when each team can see exactly the data it needs. This update connected Secure GPS map queries with custom GPS reports: users can select a report type, apply its filters and columns to the chosen period, inspect the result on screen, and download it to Excel.

We also adjusted the route calculation used by the activity summary to provide a more accurate and reliable reading of recorded distance. Together, these improvements help turn GPS positions into operational information that teams can analyze, share, and use to make decisions about routes, time, and performance.

Custom GPS queries directly from the map

The Secure GPS map lets users select devices and a time range to review their activity. With this improvement, the query is no longer limited to a fixed presentation: the user can select the report that best answers the operational question and use its configuration with the selected vehicles and dates.

This reduces the need to open multiple areas or prepare the same query several times. For example, a coordinator can review only the events relevant to an investigation, while another user can focus on speed, location, time, or variables available from their trackers.

Filters and columns for each operational need

Secure GPS custom reports organize information through columns and filters. Columns determine which data appears, while filters limit the result to relevant conditions. When a report is selected from the map, that configuration is applied to the chosen query.

  • Less noise: teams can focus on positions or events that meet the defined criteria.
  • Clearer reading: each result displays the columns useful for the current analysis.
  • Repeatable processes: a saved configuration can be reused for other devices or periods.
  • Greater consistency: the on-screen view and export start from the same dates, devices, filters, and columns.

Download map queries to Excel

The query prepared on the map can be downloaded as an Excel file. The export includes the selected report columns and respects its configured filters, so the file preserves the focus of the analysis performed in Secure GPS.

This is useful when information must be shared with operations, security, maintenance, customer service, or administrative teams. It also helps users sort data, build tables, document exceptions, and retain a record of a period without manually transcribing every entry.

A faster workflow for investigating an exception

When a delivery is late, a stop is unexpected, or a customer asks about an asset's route, the person in charge can select the device, define the time range, choose the appropriate report, and review only the relevant information. The same result can then be downloaded for the team responsible for follow-up.

The practical benefit is a shorter, traceable investigation: the search, visualization, and shared file retain the same operational context.

Map details with the report the user needs

The map details area also lets users select the report type. Instead of relying on one table for every situation, the user can view the columns defined in the chosen report and adapt the display to the task at hand.

A fleet supervisor can prioritize movement data, a security team can focus on events and locations, and an analyst can prepare a view for comparing devices. Data availability depends on the information transmitted by the tracker and the account configuration.

Custom reports for fleet operations

Custom GPS reports turn location history into a working view. Combined with the map, Secure GPS helps answer questions such as where a vehicle was, what happened during a period, which records meet a condition, and what information should be delivered to another team.

In real operations, this flexibility can support route control, visit verification, asset monitoring, shift review, incident investigation, and evidence prepared for customers. The value is not only in collecting positions, but in presenting the right data for each decision.

More accurate distance in the activity summary

This version also corrected the route calculation used in the activity summary. The adjustment improves the accuracy and reliability of the distance shown for the selected period, helping teams compare activity and prepare reports from a more consistent baseline.

GPS distance is an estimate built from received positions. Its quality can vary with reporting frequency, coverage, installation, and device accuracy. The improvement optimizes the calculation within the available data, but it does not replace a review of signal quality when there are jumps or transmission gaps.

Benefits for fleet and tracking teams

  • More relevant queries: users select the appropriate report before analyzing map history.
  • Less manual preparation: filters and columns follow the query into the export.
  • Easier collaboration: Excel makes results easier to share, archive, and extend.
  • Better operational context: map details display the information defined for the task.
  • More reliable indicators: the activity summary uses the corrected route calculation.

How to use these functions in Secure GPS

  1. Open the map and select the devices you want to review.
  2. Define the period that corresponds to the operation or exception.
  3. Select the report whose columns and filters fit your analysis.
  4. Review the results on the map and in its details panel.
  5. Download the information to Excel when you need to share it or continue working outside the platform.
  6. Open the activity summary to review the distance calculated for the interval.

Visible options depend on user permissions, plan, report configuration, and compatible data transmitted by each device.

Functional summary for users and integrators

The update connected the map's device and date selection with the definition of the chosen report. The result can apply its filters and columns to both the details view and the Excel export. The activity summary distance calculation was also adjusted. For integrators and technical teams, this establishes more consistent functional behavior across querying, presentation, and export without changing the actual availability of variables supplied by each tracker.

Explore Secure GPS plans and features to centralize GPS tracking, analyze routes, and create reports adapted to your operation.