Identify frequently problematic addresses
Export failed stops from Upper's Route Plan Detailed Report and group them by address in a spreadsheet to find the locations that fail again and again.
Some addresses fail once because of a bad day. Others fail every time — a missing gate code, a business that's closed when you arrive, an address that doesn't pinpoint correctly. Upper's Route Plan Detailed Report records every stop, including the ones that failed, so you can export those rows and group them by address in a spreadsheet to see which locations keep causing trouble.
Default labels in this article use driver and delivery. Your workspace may instead show Technician and Service — the wording is configurable, but the steps are identical.
Why this matters
When you catch a repeat-fail address and fix the underlying record — adding the gate code, correcting the location pin, noting the right delivery window — you stop the same problem from recurring on every future visit. One spreadsheet review can prevent dozens of wasted reattempts.
Build the address-failure report
The Route Plan Detailed Report has one row per stop and includes a Stop Status and a Reason. Filter it to failed stops, export, then group by address in your spreadsheet.
Open Analytics
In the left sidebar, open Track → Analytics.
Choose the Route Plan Detailed Report
From the View by dropdown at the top, select Route Plan Detailed Report.
Filter to failed stops over a wide date range
Open the Filter panel and set:
- Date Range — pick a wide window so patterns have room to appear (for example, the last 30, 60, or 90 days).
- Stop Status — set to Fail.
Then click Apply.
Export the report
Click Export (top-right). In the Export window, set a file name, choose CSV or XLS for the format, and click Start Export. You can also tick Send e-mail when Export is complete if you'd rather receive the file by email.
Group by address in a spreadsheet
Open the exported file in Excel or Google Sheets and sort or filter by Stop Address. Addresses with several failure rows are your repeat offenders.
Add the Reason and Notes From Driver columns when you export. Reading why each attempt failed — wrong address, no access, customer not available — usually points straight at the fix.
What to look for
- The same address across multiple dates — the clearest sign of a structural problem, not a one-off.
- A consistent failure reason at one location — repeated access issues or "wrong address" entries on the same stop.
- Time-of-day clustering — failures bunched around certain arrival times can mean the delivery window doesn't match when the location is reachable.
When you find a repeat-fail address, update the customer's contact record with the access notes a driver needs before they arrive, so the next route carries the fix forward.
A dedicated in-product view for problematic addresses is not currently available. Until one exists, exporting the Route Plan Detailed Report and grouping by address in a spreadsheet is the way to find them.
Frequently asked questions
Related
Identify delivery bottlenecks
Spot delivery bottlenecks in Upper using Dashboard KPIs and Analytics reports. Watch on-time rate, missed stops, service time, and per-driver results.
Measure driver productivity
Combine Upper Dashboard KPIs, the Route Plan Summary Report, and the Driver Timesheet Report to measure driver productivity fairly across your team.