# Weekly courier scorecard emailed to your ops team

> Every Monday at 9am, we grade last week's carriers by on-time rate, transit time, and exceptions, then email a narrative scorecard to your ops team.

- Workflow type: agent
- Services: AfterShip, Gmail
- Categories: Operations
- Published: 2026-07-17

## What it does

- Pulls every shipment delivered in the past seven days from your AfterShip account.
- Groups them by carrier and calculates on-time rate, average transit time, exception rate, and total volume.
- Writes a plain-English recap that names the week's best and worst performers with real tracking examples.
- Sends the scorecard as a formatted HTML email to your ops distribution list every Monday morning.

## What you'll need

- An AfterShip account that already tracks your shipments across your carriers.
- A Google account (Gmail) that is allowed to send from your ops address.
- The email address of the ops distribution list that should receive the weekly scorecard.

## Prompt

Every Monday at 9am, generate a weekly courier performance scorecard from AfterShip and email it as an HTML report to my ops distribution list via Gmail.

First, use AfterShip's List Trackings action to pull every shipment that was delivered in the past 7 days. Filter by delivered status and a delivery-date window covering the previous week, and paginate through the cursor until you have the full set of trackings.

Then use AfterShip's Get Couriers action to fetch the active courier list so you can enrich each tracking's slug/courier field with a human-readable display name (for example, the slug 'fedex' becomes 'FedEx').

Group the trackings by courier and compute per-courier metrics: on-time rate (delivered on or before the tracking's promised estimated delivery date versus after), average transit time in days (from pickup to delivered), exception rate (share of shipments that hit an exception subtag or checkpoint during the week), and total delivery volume.

Write a narrative report, not a bare table. Call out the best and worst performers with specific tracking examples using their tracking numbers and any exception context, in the style of 'FedEx: 94% on-time, 2.1 day average, best week yet' or 'DHL: 6 exceptions this week, including tracking #ABC123 stuck 5 days in customs'. Note carriers with very low weekly volume so a single delayed shipment does not dominate the story.

Format the report as a clean HTML email with a top-line summary, a per-carrier breakdown, and highlighted callouts for the standout stories. Then use Gmail's Send a Message action to send it to my ops distribution list with a subject line like 'Weekly courier scorecard, week of <start date>'.

## How to customize

- Change the schedule (Monday 9am is the default, any day and time works).
- Adjust the reporting window from 7 days to 14 or 30 for a broader view.
- Swap the recipient list or add a Slack copy of the recap.

## FAQ

### Which carriers does this cover?

Every carrier attached to your AfterShip account. AfterShip supports over 1,000 couriers, so it works whether you ship with a single national carrier or a dozen regional ones.

### How does it decide whether a shipment was on time?

It compares each shipment's actual delivery date to the promised estimated delivery date stored in AfterShip. Anything delivered on or before the promised date counts as on time.

### What if a carrier only shipped a handful of packages last week?

The report flags low-volume carriers so a single delayed package doesn't make them look terrible. The narrative focuses on carriers with meaningful weekly volume.

### Can we send it to more than one person?

Yes. Point it at your ops distribution list, or list multiple recipients directly. The email is sent through your Gmail account.

### Does the report include specific tracking numbers?

Yes. It calls out real examples like a package stuck in customs or a carrier's fastest week, so the story is concrete instead of a wall of percentages.

Use this prompt in General Input: https://www.generalinput.com/prompts/weekly-courier-scorecard-emailed-to-your-ops-team