---
title: "Tracking Courier Performance to Spot Problem Areas"
description: "A simple spreadsheet comparing late, lost and damaged parcels by courier and region, used when following up with couriers."
canonical_url: "https://aljen.bynery.app/portfolio/courier-performance-tracker"
meta:
  "og:description": "A simple spreadsheet comparing late, lost and damaged parcels by courier and region, used when following up with couriers."
  "og:image": "https://aljen.bynery.app/_og/s/o_2deb3f58bf935943.png"
  "og:image:height": "630"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "Tracking Courier Performance to Spot Problem Areas"
  "twitter:description": "A simple spreadsheet comparing late, lost and damaged parcels by courier and region, used when following up with couriers."
  "twitter:image": "https://aljen.bynery.app/_og/s/o_2deb3f58bf935943.png"
  "twitter:title": "Tracking Courier Performance to Spot Problem Areas"
---

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

# **Tracking Courier Performance to Spot Problem Areas**

A simple spreadsheet comparing late, lost and damaged parcels by courier and region, used when following up with couriers.

**ABM Global · Courier partners**

**Weekly**

**Courier performance summary**

**By state**

**Problem areas made visible**

**Data**

**Behind every courier escalation**

## **The Challenge**

Some regions and couriers had more late, lost or damaged parcels than others, but the pattern was hard to show clearly when escalating to courier account managers.

## **My Role**

Logistics Coordinator. I collected the data and kept the sheet updated.

## **What I Did **

1. **1**

   Logged delivery exceptions by courier, state and product type each week
2. **2**

   Used simple charts and colour coding so trends were easy to see
3. **3**

   Shared the summary with my lead before courier review meetings

```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/courier-performance-tracker#webpage","@type":"WebPage","description":"A simple spreadsheet comparing late, lost and damaged parcels by courier and region, used when following up with couriers.","name":"Tracking Courier Performance to Spot Problem Areas","url":"https://aljen.bynery.app/portfolio/courier-performance-tracker","breadcrumb":{"@id":"https://aljen.bynery.app/portfolio/courier-performance-tracker#breadcrumb"},"isPartOf":{"@id":"https://aljen.bynery.app/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://aljen.bynery.app/portfolio/courier-performance-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/courier-performance-tracker#article","@type":"Article","description":"A simple spreadsheet comparing late, lost and damaged parcels by courier and region, used when following up with couriers.","headline":"Tracking Courier Performance to Spot Problem Areas","inLanguage":"en","thumbnailUrl":"https://aljen.bynery.app/_og/s/o_2deb3f58bf935943.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/courier-performance-tracker#webpage"},"keywords":["Logistics","Google Sheets","Excel","Courier Portals"],"mainEntityOfPage":{"@id":"https://aljen.bynery.app/portfolio/courier-performance-tracker#webpage"},"publisher":{"@id":"https://aljen.bynery.app/#identity"}},{"@id":"https://aljen.bynery.app/portfolio/courier-performance-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":"Tracking Courier Performance to Spot Problem Areas","item":"https://aljen.bynery.app/portfolio/courier-performance-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_2deb3f58bf935943.png","inLanguage":"en","url":"https://aljen.bynery.app/_og/s/o_2deb3f58bf935943.png"}]}
```

## Sitemap

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