What does the geofence visit analyzer do?
A geofence is a boundary you draw on the map around a place that matters to your fleet: a depot, a warehouse, a customer site, a port gate, a fuel station or a workshop. Each time a tracked vehicle enters and leaves it, the tracking system records a visit with its entry and exit time.
This tool reads those visits from any tracking system's export and answers the questions fleet managers ask most: what is the most visited geofence, which vehicles visit most and stay longest, at what hours and on which days the sites are busiest, and which visits need a second look because they were very long or outside working hours.
Why look at geofence visits?
- Where the fleet's time goes: the geofence with the most time inside, not only the most visits, is often where waiting costs most, at a port gate, a loading bay or a customer that keeps trucks waiting.
- Which sites deserve attention: a few geofences usually take most of the visits. Those are the first places to improve loading, slots or access.
- When to staff and schedule: visits by hour and day show the peak at a warehouse or depot, so loaders, gates and fuel stops can be planned around it.
- What to check: very long stays and arrivals outside working hours point to breakdowns, waiting, private use or a site left open.
What data do you need?
One row per visit, from your tracking system's geofence entry and exit report, exported to Excel or CSV. Copy the rows (with the header row if there is one) and paste them in the tool.
| Column | Needed? | Examples the tool reads |
|---|---|---|
| Vehicle | Yes | Plate, unit name or asset code |
| Geofence | Yes | Geofence, zone, site or location name |
| Entry time | Yes, for the time and flag tabs | 2026-10-05 08:12, 05/10/2026 08:12, 10/25/2026 8:12 PM, 5 Oct 2026 08:12, Hijri 1448/04/13 08:12 |
| Exit time | Exit time or duration | Same forms as the entry time; empty when the vehicle is still inside |
| Duration | Instead of the exit time | 1:25, 01:25:30, 85 (minutes), 1h 25m, 2d 03:10:00 |
| Date | Only if the times are in their own columns | A date column with entry and exit columns holding only the time |
The tool finds the columns from the header names in English or Arabic, or from what the cells hold. If it picks the wrong one, choose the right column under Columns the tool found. A date such as 05/10/2026 is read day first unless another row in the same column can only be month first (for example 10/25/2026).
How is it calculated?
- Short visits below the limit you set (2 minutes in the example) are left out: a vehicle driving past the edge of a geofence is not a visit.
- Open visits (an entry with no exit and no duration) count as visits, without a time inside.
- Visits to check are visits of at least your long-stay limit, and visits whose arrival falls on a day off or outside your working hours. A visit that starts in working hours and ends after them is not flagged. With a shift past midnight (for example 22:00 to 06:00), the hours after midnight belong to the working day on which the shift started.
- Times are read as written in your export, in the local time it uses; the tool does not convert time zones.
Worked example: one week of a distribution fleet
The example data is made up: a distribution company with three trucks and three vans, one week from Sunday 4 to Saturday 10 October 2026, seven geofences, working hours 06:00 to 18:00, Sunday to Thursday.
- The export has 132 rows. Two are drive-throughs of 1 minute and are left out, so 130 visits count; one van was still inside a customer site when the report was run.
- Central Warehouse is the most visited geofence: 44 visits, 34% of all visits, by all 6 vehicles, 39 minutes on average. The three most visited geofences take 71% of the visits.
- Ranked by time inside, the picture changes: Port Gate 2 has only 16 visits but 26 h 12 min inside, 98 minutes per visit on average, close to Central Warehouse's 28 h 22 min.
- VAN-201 and VAN-203 make the most visits, 25 each; TRK-102 spends the most time inside geofences, 20 h 42 min.
- The busiest hour is 07:00 to 08:00 with 23 arrivals, and the three busiest hours take 44% of the visits. Monday is the busiest day with 28 visits.
- 7 visits to check: 4 stays of 2 hours or more (two workshop visits and two waits at Port Gate 2) and 4 arrivals outside working hours (05:42 at the fuel station, 21:15 at the warehouse, and one visit each on Friday and Saturday); one Saturday port visit is both.
How to read the results
- Visits and time inside answer different questions. The most visited site is where the fleet goes most often; the site with the most time inside is where it waits or works longest.
- A high average visit at a customer or gate points to waiting; compare it with the time the work there should take.
- The busiest hour is when a site needs staff, a free bay or an open gate; spreading arrivals out of that hour cuts queues.
- A flagged visit is a question, not a finding: a long stay may be a planned repair and an early arrival may be an approved shift. Check each one with the driver or supervisor.
What to do with the results
- Agree on loading or delivery slots with the sites that take most of the visits and most of the waiting.
- Measure turnaround at ports and terminals with the Port Truck Turnaround & Waiting Cost Calculator, and site work time with the Field Service Visit Calculator.
- Review vehicle use with the Fleet Vehicle Utilization Calculator and report it every month with the Vehicle Utilization Report Template.
- Repeat the analysis every month with the same geofences and settings, so changes come from the fleet and not from the method.
Assumptions and limits
The results are only as good as the geofences and the export: a geofence drawn too small misses visits, one drawn too large counts vehicles on the road outside, and overlapping geofences count the same stop twice. The tool counts the rows it receives; it does not check GPS gaps or whether a geofence was changed during the period. Long-stay limits, working hours and the example data are examples, not standards. This is a planning aid, not legal, HR or safety advice.