OpenKPIs
Leaderboard
Sign in
← Back to Dimensions

Carrier Performance

Also known as: Logistics Performance, Delivery Efficiency

PerformancedimensionLogistics & Supply Chain

Measures the efficiency and reliability of logistics carriers in delivering shipments on time and without damage.

Business Use Case

Executives use this to negotiate better terms with carriers or switch providers based on performance metrics.

Business Criticality

High

Journey / Navigation Area

Generic

Owning Function

Data Architecture Team

Scope

Event

Calculation Notes

Excludes shipments with incomplete tracking data. Considers only completed deliveries.

Technical Details

Data Typestring
Lookback WindowEvent

Events

PlatformEvent
Google Analytics 4view_item
Adobeview_item

Data Mappings

W3 Data Layer
{
  "digitalData": {
    "event": {
      "category": {
        "primaryCategory": "Carrier Performance"
      },
      "eventInfo": {
        "type": "view",
        "eventName": "Carrier Performance View"
      }
    }
  }
}
GA4 Data Layer
{
  "event": "view_item",
  "ecommerce": {
    "items": [
      {
        "item_name": "Carrier Performance",
        "item_category": "performance"
      }
    ]
  }
}
Adobe Client Data Layer
{
  "event": "view_item",
  "ecommerce": {
    "items": [
      {
        "item_name": "Carrier Performance",
        "item_category": "performance"
      }
    ]
  }
}
XDM Mapping
{
  "_experience": {
    "analytics": {
      "event1": {
        "name": "view_item",
        "details": {
          "item_name": "Carrier Performance",
          "item_category": "performance"
        }
      }
    }
  }
}

SQL Queries

Google Analytics 4 (BigQuery)
-- ==========================================
-- 1. GOOGLE BIGQUERY SQL (GA4 Export)
-- ==========================================
SELECT
  event_date,
  user_pseudo_id AS user_id,
  items.item_name AS carrier_name,
  COUNTIF(event_name = 'view_item') AS views,
  COUNTIF(event_name = 'add_to_cart') AS adds_to_cart,
  COUNTIF(event_name = 'purchase') AS purchases
FROM
  `your-project.analytics_123456789.events_*`,
  UNNEST(items) AS items
WHERE
  items.item_category = 'carrier'
GROUP BY
  event_date,
  user_id,
  carrier_name
Adobe Experience Platform (AEP Query Service)
-- ==========================================
-- 2. ADOBE AEP QUERY SERVICE SQL (XDM Dataset)
-- ==========================================
SELECT
  DATE(event.timestamp) AS event_date,
  identityMap.ecid[0].id AS user_id,
  e.commerce.productListItems.name AS carrier_name,
  SUM(CASE WHEN e.eventType = 'commerce.productViews' THEN 1 ELSE 0 END) AS views,
  SUM(CASE WHEN e.eventType = 'commerce.productListAdds' THEN 1 ELSE 0 END) AS adds_to_cart,
  SUM(CASE WHEN e.eventType = 'commerce.purchases' THEN 1 ELSE 0 END) AS purchases
FROM
  your_dataset.your_table e
WHERE
  e.commerce.productListItems.category = 'carrier'
GROUP BY
  event_date,
  user_id,
  carrier_name

Source Data

Digital Analytics

Dependencies

[ "Shipment Event", "Carrier Data" ]

Report Attributes

Region Carrier Name Time Period

Segment Eligibility

true

Governance

Data Sensitivityinternal

Governance

Created bydevyendarm
Created on8/19/2026
Last modified bydevyendarm
StatusPUBLISHED

GitHub

View File on GitHubcatalog/dimensions/carrier-performance.yml

Community Discussion