---
title: "A Daily Tracker for Parcels That Stopped Moving"
description: "One shared sheet for every parcel with no scan, a failed delivery or a return to sender, so problems were caught before customers called."
canonical_url: "https://aljen.bynery.app/portfolio/daily-delivery-exception-tracker"
meta:
  "og:description": "One shared sheet for every parcel with no scan, a failed delivery or a return to sender, so problems were caught before customers called."
  "og:image": "https://aljen.bynery.app/_og/s/o_eb2e6ccd05ddf100.png"
  "og:image:height": "630"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "A Daily Tracker for Parcels That Stopped Moving"
  "twitter:description": "One shared sheet for every parcel with no scan, a failed delivery or a return to sender, so problems were caught before customers called."
  "twitter:image": "https://aljen.bynery.app/_og/s/o_eb2e6ccd05ddf100.png"
  "twitter:title": "A Daily Tracker for Parcels That Stopped Moving"
---

> Index of every page on this site: [llms.txt](https://aljen.bynery.app/llms.txt)

# **A Daily Tracker for Parcels That Stopped Moving**

One shared sheet for every parcel with no scan, a failed delivery or a return to sender, so problems were caught before customers called.

**ABM Global · Online orders across Australia**

**Daily**

**Exception check, before customers call**

**1 sheet**

**Shared by logistics and CS**

**Fewer**

**Repeat “where is my order?” tickets**

## **The Challenge**

Parcels with no tracking scan for several days were usually found only when the customer contacted us. Notes were spread across emails and chats, so the logistics and customer service teams sometimes chased the same order twice.

## **My Role**

Logistics Coordinator. I built the tracker and checked it every morning.

## **What I Did **

1. **1**

   Listed every parcel with no scan for 3+ business days, a failed delivery or a return to sender
2. **2**

   Added columns for courier, next action, owner and “customer updated?”
3. **3**

   Followed up each courier in one batch instead of one email per parcel
4. **4**

   Shared the tracker with customer service so they could give customers the latest status

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://aljen.bynery.app/#website","@type":"WebSite","description":"Logistics Coordinator & Customer Service Specialist with 5 years in e-commerce: order dispatch, courier coordination, shipment tracking and customer support.","inLanguage":"en","name":"Aljen Joyce Paglinawan","url":"https://aljen.bynery.app/","publisher":{"@id":"https://aljen.bynery.app/#identity"}},{"@id":"https://aljen.bynery.app/portfolio/daily-delivery-exception-tracker#webpage","@type":"WebPage","description":"One shared sheet for every parcel with no scan, a failed delivery or a return to sender, so problems were caught before customers called.","name":"A Daily Tracker for Parcels That Stopped Moving","url":"https://aljen.bynery.app/portfolio/daily-delivery-exception-tracker","breadcrumb":{"@id":"https://aljen.bynery.app/portfolio/daily-delivery-exception-tracker#breadcrumb"},"isPartOf":{"@id":"https://aljen.bynery.app/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://aljen.bynery.app/portfolio/daily-delivery-exception-tracker"]}]},{"@id":"https://aljen.bynery.app/#identity","@type":"Person","description":"Logistics Coordinator & Customer Service Specialist with 5 years in e-commerce: order dispatch, courier coordination, shipment tracking and customer support.","email":"aljenjoycepaglinawan@gmail.com","jobTitle":"Logistics Coordinator & Customer Service Specialist","name":"Aljen Joyce Paglinawan","url":"https://aljen.bynery.app","address":{"streetAddress":"Carmen","addressLocality":"Cagayan de Oro City","postalCode":"9004","addressRegion":"Misamis Oriental","addressCountry":"PH"},"image":{"@id":"https://aljen.bynery.app/#/schema/image/1"},"knowsAbout":["Logistics Coordination","Order Fulfilment","Courier Coordination","Shipment Tracking","Customer Service","E-commerce Support","Returns Management","Returns and Warranty Claims","E-commerce Operations"],"knowsLanguage":["English","Filipino","Cebuano"],"sameAs":["https://www.linkedin.com/in/aljen-joyce-paglinawan-41009622a/"]},{"@id":"https://aljen.bynery.app/portfolio/daily-delivery-exception-tracker#article","@type":"Article","description":"One shared sheet for every parcel with no scan, a failed delivery or a return to sender, so problems were caught before customers called.","headline":"A Daily Tracker for Parcels That Stopped Moving","inLanguage":"en","thumbnailUrl":"https://aljen.bynery.app/_og/s/o_eb2e6ccd05ddf100.png","author":{"@id":"https://aljen.bynery.app/#/schema/person/1"},"image":{"@id":"https://aljen.bynery.app/#/schema/image/2"},"isPartOf":{"@id":"https://aljen.bynery.app/portfolio/daily-delivery-exception-tracker#webpage"},"keywords":["Logistics","Google Sheets","Courier Portals","Shopify"],"mainEntityOfPage":{"@id":"https://aljen.bynery.app/portfolio/daily-delivery-exception-tracker#webpage"},"publisher":{"@id":"https://aljen.bynery.app/#identity"}},{"@id":"https://aljen.bynery.app/portfolio/daily-delivery-exception-tracker#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://aljen.bynery.app","position":1},{"@type":"ListItem","name":"Portfolio","item":"https://aljen.bynery.app/portfolio","position":2},{"@type":"ListItem","name":"A Daily Tracker for Parcels That Stopped Moving","item":"https://aljen.bynery.app/portfolio/daily-delivery-exception-tracker","position":3}]},{"@id":"https://aljen.bynery.app/#/schema/person/1","@type":"Person","name":"Aljen Joyce Paglinawan","url":"https://aljen.bynery.app"},{"@id":"https://aljen.bynery.app/#/schema/image/1","@type":"ImageObject","contentUrl":"https://aljen.bynery.app/images/aljen/aljen-960.webp","inLanguage":"en","url":"https://aljen.bynery.app/images/aljen/aljen-960.webp"},{"@id":"https://aljen.bynery.app/#/schema/image/2","@type":"ImageObject","contentUrl":"https://aljen.bynery.app/_og/s/o_eb2e6ccd05ddf100.png","inLanguage":"en","url":"https://aljen.bynery.app/_og/s/o_eb2e6ccd05ddf100.png"}]}
```

## Sitemap

See the full [sitemap](https://aljen.bynery.app/sitemap.md) for all pages.