Delivery Accuracy Rate
Also known as: On-Time Delivery Percentage, Timely Delivery Rate
Measures the percentage of deliveries made on or before the scheduled delivery date. It reflects the efficiency and reliability of the logistics process.
Business Use Case
Logistics managers use this KPI to identify bottlenecks in the delivery process and improve customer satisfaction by ensuring timely deliveries.
Business Criticality
High
Journey / Navigation Area
Generic
Owning Function
Data Architecture Team
Scope
Global
Formula
(Number of On-Time Deliveries / Total Deliveries) × 100Calculation Notes
1️⃣ Exclude deliveries with customer-requested delays. 2️⃣ Account for timezone differences in international shipments. 3️⃣ Ensure accurate scheduling based on local times. 4️⃣ Communicate expected delivery times clearly. 5️⃣ Monitor and adjust for any potential delays.
Technical Details
Events
SQL Queries
Google Analytics 4 (BigQuery)
-- ==========================================
-- 1. GOOGLE BIGQUERY SQL
-- ==========================================
SELECT order_id,
COUNTIF(status = 'delivered') / COUNT(*) AS delivery_accuracy_rate
FROM `your-project.erp.delivery_logs`
GROUP BY order_idAdobe Experience Platform (AEP Query Service)
-- ==========================================
-- 2. ADOBE AEP QUERY SERVICE SQL
-- ==========================================
SELECT order_id,
COUNT(CASE WHEN status = 'delivered' THEN 1 END) / COUNT(*) AS delivery_accuracy_rate
FROM aep_backend_dataset.delivery_logs
GROUP BY order_idSource Data
ERP
Dependencies
[ "Total Deliveries", "On-Time Deliveries" ]
Report Attributes
Region Delivery Method Product Category
Recommended Reporting Views
Segment Eligibility
true
Governance
Governance
GitHub
catalog/kpis/delivery-accuracy-rate.yml