5 KPIs Every Logistics Director Should Track Weekly

Logistics directors are overwhelmed with data but starved for insight. Dozens of reports, hundreds of spreadsheet tabs, and thousands of rows — yet the fundamental question remains unanswered: "Are we performing well this week, and where do we need to act?"

The fix is fewer, sharper metrics, not another dashboard. Here are five KPIs worth a weekly look — each with a formula, a benchmark, and a reason it earns that cadence rather than a quarterly glance.

1. Gross Margin by Lane

Formula: (ShipperRevenue - CarrierCost) / ShipperRevenue × 100, segmented by RouteFrom→RouteTo pair.

Benchmark: 12-18% for ocean freight, 8-15% for road freight, 15-25% for air freight. Any lane below 5% is a candidate for repricing or discontinuation.

Why weekly: Lane margins can shift rapidly due to carrier rate changes, fuel surcharges, or volume mix changes. A lane that was profitable last month may have turned negative this week due to a single carrier rate increase. Weekly tracking catches these shifts before they compound into quarterly losses.

Most freight forwarders track overall margin but not lane-level margin. This is like a retailer knowing their total revenue but not knowing which products are selling at a loss. Lane-level margin is the most actionable financial metric in logistics — it tells you exactly where to reprice, renegotiate, or reallocate volume.

2. On-Time Delivery Rate

Formula: (Shipments delivered on or before DueDate) / (Total completed shipments) × 100.

Benchmark: 90%+ is good, 95%+ is excellent. Below 85% indicates systemic issues requiring immediate attention.

Why weekly: On-time delivery is the single most visible metric for customer satisfaction. A carrier or route that drops from 93% to 81% in a single week is an operational emergency — not something to discover in a monthly summary. Weekly OTD tracking by carrier and by route enables rapid intervention: escalation to the carrier, proactive customer communication, or temporary rerouting through alternative providers.

Track this metric both at the aggregate level and segmented by carrier. A 90% overall OTD may mask the fact that one carrier is at 65% while others are at 97%. The aggregate number hides the problem; the carrier-level breakdown reveals it.

3. Carrier Cost Variance

Formula: (Actual CarrierCost - Contracted/Expected CarrierCost) / Contracted CarrierCost × 100.

Benchmark: Within ±3% of contracted rates is normal. Consistent variance above 5% indicates rate creep, surcharge accumulation, or billing errors that need investigation.

Why weekly: Carrier costs are the single largest expense for freight forwarders. A 2% cost variance across 1,000 weekly shipments at €500 average cost equals €10,000 per week in unexpected expense. Over a quarter, that is €130,000 — enough to eliminate a mid-size forwarder's entire quarterly profit. Weekly variance tracking catches billing anomalies, unauthorized surcharges, and rate creep before they become material financial problems.

4. Revenue Concentration Index

Formula: Top customer revenue / Total revenue × 100. Also calculate for top 3 and top 5 customers.

Benchmark: No single customer should exceed 25% of total revenue. Top 5 customers should not exceed 60%. Higher concentration means higher churn risk.

Why weekly: Customer volume shifts happen gradually — a customer reducing volume by 10% per week is barely noticeable in weekly data but represents a 40% drop over a month. Weekly tracking of your top customer revenue shares detects churn signals early enough for your sales team to intervene. It also flags unhealthy dependency: if a single customer grows to represent 35% of your revenue, you have a concentration risk that threatens your entire business if they switch providers.

5. Data Completeness Score

Formula: (Non-NULL values in critical fields) / (Total expected values in critical fields) × 100. Critical fields include: ShipperRevenue, CarrierCost, DueDate, CompletionDate, CarrierName, RouteFrom, RouteTo.

Benchmark: 95%+ is acceptable, 99%+ is excellent. Below 90% means your reporting is unreliable — every metric above is compromised.

Why weekly: Data quality is the foundation of every other KPI. If 15% of your shipments are missing CarrierCost values, your margin calculations are wrong. If 20% are missing CompletionDate, your OTD rate is unreliable. Weekly data quality monitoring catches data entry degradation, system integration failures, and process breakdowns before they corrupt your decision-making for an entire month.

This is the meta-metric — the one that tells you whether you can trust all the others. Track it weekly, and fix issues immediately. A data quality score below 90% means you are flying blind, regardless of what your other dashboards say.

Running the Weekly Check

Together these five cover the health of the business from four angles: financial (margin by lane, cost variance), operational (OTD rate), strategic (revenue concentration), and the data itself (completeness score). Review them every Monday morning and act on anything that has moved more than 5% from the previous week. That one habit catches problems earlier than any quarterly review will.