On-time shipping rate
“show shipstation shipments by carrier and ship-by week, calculate on-time shipping rate as shipped on or before ship-by date divided by all shipped, status Agrees when 100%, otherwise Late”
Show ShipStation shipments export shipments by carrier and ship-by week, calculate on-time shipping rate as shipped on or before ship-by date divided by all shipped, status Agrees when 100%, otherwise Late.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
- FileShipStation shipments exportCSV export · 24 rows
- StepCalculate weekly on-time ratesStep 1
- ResultOn-time Shipping Rates21 rows · 3 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 21 rows came out.
- Download ShipStation shipments export sample (24 rows)ShipStation: Shipments > Shipments > Export
What you get back
The result of that run, the rows to look at first.
| Carrier | Ship-by week | On-time shipping rate (%) | Shipped on time | All shipped | Status |
|---|---|---|---|---|---|
| DHL | 2026-09-21 | 0 | 0 | 1 | Late |
| DHL | 2026-11-02 | 0 | 0 | 1 | Late |
| UPS | 2026-10-12 | 0 | 0 | 1 | Late |
| DHL | 2026-09-28 | 100 | 1 | 1 | Agrees |
| DHL | 2026-10-05 | 100 | 1 | 1 | Agrees |
| DHL | 2026-10-12 | 100 | 1 | 1 | Agrees |
| DHL | 2026-10-19 | 100 | 1 | 1 | Agrees |
| FedEx | 2026-09-21 | 100 | 1 | 1 | Agrees |
| FedEx | 2026-09-28 | 100 | 2 | 2 | Agrees |
| FedEx | 2026-10-05 | 100 | 1 | 1 | Agrees |
| FedEx | 2026-10-12 | 100 | 1 | 1 | Agrees |
| FedEx | 2026-10-26 | 100 | 1 | 1 | Agrees |
How do you calculate on-time shipping rate by carrier and week?
Export your shipments from ShipStation, then group them by carrier and ship-by week. Calculate the on-time rate as shipments shipped on or before the promised date divided by all shipped shipments. Mark a row Agrees when the rate is 100 percent, otherwise Late.
How it works
How to use the On-time Shipping Rates workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
On-time Shipping Rates: questions
Which export should you use?
What happens to rows that do not match?
How do you change the rule in words?
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Match payroll to time sheets, track headcount and hiring, and see what changed since last month.
- Resource capacity by weekCompare booked project hours to weekly availability in an Excel export and show who is over or under capacity.See the workflow Built by the agent
- Salary bands compa-ratioExport employees from BambooHR, pair them with salary bands, and work out each employee's compa-ratio against the band midpoint.See the workflow Built by the agent
- PTO balance reportShow each employee’s PTO accrued, taken, carryover, and remaining balance this year from BambooHR exports.See the workflow Built by the agent
- Billable utilization by employeeCalculate each employee's utilization rate by month from exported Harvest time entries and capacity files.See the workflow Built by the agent
- Employee turnover rateCalculate monthly employee turnover rate by department from a BambooHR employee export, with turnover, cleaned department names, and a status check.See the workflow Built by the agent
- Headcount reportBuild a monthly headcount report from a BambooHR employees export, grouped by department and location, with hires and leavers.See the workflow Built by the agent