Freight Cost per Unit
Also known as: Shipping Cost per Unit, Logistics Cost per Item
Measures the average cost incurred to ship a single unit of product. It helps in understanding the efficiency of logistics operations.
Business Use Case
Executives use this metric to identify cost-saving opportunities in shipping and negotiate better rates with carriers.
Business Criticality
High
Journey / Navigation Area
Generic
Owning Function
Data Architecture Team
Scope
Item
Formula
SUM(total_freight_cost) / SUM(total_units_shipped)Calculation Notes
1️⃣ Exclude shipments under minimum weight threshold. 2️⃣ Apply currency conversion for international shipments. 3️⃣ Ensure compliance with weight regulations. 4️⃣ Verify exchange rates before processing. 5️⃣ Document weight thresholds for reference. 6️⃣ Monitor currency fluctuations regularly. 7️⃣ Update conversion rates as needed.
Technical Details
Events
SQL Queries
Google Analytics 4 (BigQuery)
-- ==========================================
-- 1. GOOGLE BIGQUERY SQL
-- ==========================================
SELECT order_id,
SUM(freight_cost) / SUM(quantity) AS freight_cost_per_unit
FROM `your-project.erp.orders`
GROUP BY order_idAdobe Experience Platform (AEP Query Service)
-- ==========================================
-- 2. ADOBE AEP QUERY SERVICE SQL
-- ==========================================
SELECT order_id,
SUM(freight_cost) / SUM(quantity) AS freight_cost_per_unit
FROM aep_backend_dataset.orders
GROUP BY order_idSource Data
ERP
Dependencies
[ "total_freight_cost", "total_units_shipped" ]
Report Attributes
Region Carrier Product Category
Recommended Reporting Views
Segment Eligibility
true
Governance
Governance
GitHub
catalog/metrics/freight-cost-per-unit.yml