Shipment Mode Distribution
Also known as: Transport Mode Distribution, Logistics Mode Split
Shipment Mode Distribution measures the proportion of shipments handled through various transportation modes such as air, sea, and land. It provides insights into logistics efficiency and cost management.
Business Use Case
Executives can optimize logistics strategies by analyzing the distribution of shipment modes to reduce costs and improve delivery times.
Business Criticality
High
Journey / Navigation Area
Generic
Owning Function
Data Architecture Team
Scope
Event
Calculation Notes
1️⃣ Exclude shipments with incomplete mode data. 2️⃣ Implement real-time updates for accuracy. 3️⃣ Ensure current distribution is reflected. 4️⃣ Monitor data completeness regularly. 5️⃣ Adjust processes based on real-time insights.
Technical Details
Events
Data Mappings
W3 Data Layer
{}GA4 Data Layer
{}Adobe Client Data Layer
{}XDM Mapping
{}SQL Queries
Google Analytics 4 (BigQuery)
-- ==========================================
-- 1. GOOGLE BIGQUERY SQL (GA4 Export)
-- ==========================================
SELECT shipment_mode, COUNT(*) AS shipment_count
FROM `your-project.erp.shipment_data`
GROUP BY shipment_mode
ORDER BY shipment_count DESC;Adobe Experience Platform (AEP Query Service)
-- ==========================================
-- 2. ADOBE AEP QUERY SERVICE SQL
-- ==========================================
SELECT shipment_mode, COUNT(*) AS shipment_count
FROM aep_backend_dataset.shipment_data
GROUP BY shipment_mode
ORDER BY shipment_count DESC;Source Data
ERP
Dependencies
[ "Shipment Event", "Mode Assignment" ]
Report Attributes
Region Time Period Carrier
Segment Eligibility
true
Governance
Governance
GitHub
catalog/dimensions/shipment-mode-distribution.yml