OpenKPIs
Leaderboard
Sign in
← Back to KPIs

Warehouse Utilization Rate

Also known as: Warehouse Space Utilization, Storage Utilization Rate

EfficiencykpiLogistics & Supply Chain

Measures the percentage of warehouse space currently being used compared to the total available space, indicating the efficiency of warehouse capacity utilization.

Business Use Case

Executives use this KPI to optimize warehouse operations and make decisions about expanding or consolidating warehouse space.

Business Criticality

High

Journey / Navigation Area

Generic

Owning Function

Data Architecture Team

Scope

Global

Formula

(Occupied Warehouse Space / Total Warehouse Space) × 100

Calculation Notes

1️⃣ Exclude areas under maintenance. 2️⃣ Exclude temporarily unavailable spaces. 3️⃣ Ensure accurate space measurement. 4️⃣ Update measurements regularly.

Technical Details

Measure Typepercentage
Aggregation WindowTime based - Daily

Events

SQL Queries

Google Analytics 4 (BigQuery)
-- ==========================================
-- 1. GOOGLE BIGQUERY SQL
-- ==========================================
SELECT
  warehouse_id,
  SUM(used_space) / SUM(total_space) AS utilization_rate
FROM
  `your-project.erp.warehouse_logs`
WHERE
  event_date BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY) AND CURRENT_DATE()
GROUP BY
  warehouse_id
ORDER BY
  utilization_rate DESC;
Adobe Experience Platform (AEP Query Service)
-- ==========================================
-- 2. ADOBE AEP QUERY SERVICE SQL
-- ==========================================
SELECT
  warehouse_id,
  SUM(used_space) / SUM(total_space) AS utilization_rate
FROM
  aep_backend_dataset.warehouse_logs
WHERE
  event_date BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY) AND CURRENT_DATE()
GROUP BY
  warehouse_id
ORDER BY
  utilization_rate DESC;

Source Data

ERP

Dependencies

[ "Total Warehouse Space", "Occupied Warehouse Space" ]

Report Attributes

Region Warehouse Type

Recommended Reporting Views

Views
Operational Efficiency DashboardLogistics Performance Dashboard

Segment Eligibility

true

Governance

Data Sensitivityinternal

Governance

Created bydevyendarm
Created on8/19/2026
Last modified byPrimary EditorTeTest AuthorTest Authorst Author
StatusPUBLISHED

GitHub

View File on GitHubcatalog/kpis/warehouse-utilization-rate.yml

Community Discussion