OpenKPIs
Leaderboard
Sign in
← Back to Dimensions

Delivery Location

Also known as: Shipping Address, Drop-off Location

EfficiencydimensionLogistics & Supply Chain

The specific geographic address or coordinates where goods are delivered to the customer. It is used to track and optimize delivery routes and logistics operations.

Business Use Case

Executives use delivery location data to optimize delivery routes, reduce transportation costs, and improve delivery times by analyzing geographic trends.

Business Criticality

High

Journey / Navigation Area

Generic

Owning Function

Data Architecture Team

Scope

Event

Calculation Notes

1️⃣ Standardize and validate addresses. 2️⃣ Avoid duplicates and errors. 3️⃣ Exclude locations marked as 'test'. 4️⃣ Exclude locations marked as 'invalid'. 5️⃣ Implement a consistent format for all addresses. 6️⃣ Regularly review and update address database. 7️⃣ Use automated tools for validation when possible.

Technical Details

Data Typestring
Lookback WindowEvent

Events

PlatformEvent
Google Analytics 4purchase
Adobepurchase

Data Mappings

W3 Data Layer
{
  "digitalData": {
    "transaction": {
      "delivery": {
        "location": {
          "address": "123 Main St, Anytown, USA",
          "coordinates": {
            "latitude": "37.7749",
            "longitude": "-122.4194"
          }
        }
      }
    }
  }
}
GA4 Data Layer
{
  "event": "purchase",
  "delivery_location": {
    "address": "123 Main St, Anytown, USA",
    "coordinates": {
      "latitude": "37.7749",
      "longitude": "-122.4194"
    }
  }
}
Adobe Client Data Layer
{
  "event": "purchase",
  "deliveryLocation": {
    "address": "123 Main St, Anytown, USA",
    "coordinates": {
      "latitude": "37.7749",
      "longitude": "-122.4194"
    }
  }
}
XDM Mapping
{
  "_experience": {
    "analytics": {
      "customDimensions": {
        "deliveryLocation": {
          "address": "123 Main St, Anytown, USA",
          "coordinates": {
            "latitude": "37.7749",
            "longitude": "-122.4194"
          }
        }
      }
    }
  }
}

SQL Queries

Google Analytics 4 (BigQuery)
-- ==========================================
-- 1. GOOGLE BIGQUERY SQL (GA4 Export)
-- ==========================================
SELECT
  event_params.value.string_value AS address,
  event_params.value.float_value AS latitude,
  event_params.value.float_value AS longitude
FROM
  `your-project.analytics_123456789.events_*`,
  UNNEST(event_params) AS event_params
WHERE
  event_name = 'purchase'
  AND event_params.key IN ('delivery_location.address', 'delivery_location.coordinates.latitude', 'delivery_location.coordinates.longitude')
Adobe Experience Platform (AEP Query Service)
-- ==========================================
-- 2. ADOBE AEP QUERY SERVICE SQL
-- ==========================================
SELECT
  xdm._experience.analytics.customDimensions.deliveryLocation.address AS address,
  xdm._experience.analytics.customDimensions.deliveryLocation.coordinates.latitude AS latitude,
  xdm._experience.analytics.customDimensions.deliveryLocation.coordinates.longitude AS longitude
FROM
  aep_backend_dataset
WHERE
  xdm.eventType = 'purchase'

Source Data

Digital Analytics

Dependencies

[ "Order Completion Event" ]

Report Attributes

Region City Postal Code

Segment Eligibility

true

Governance

Data Sensitivityinternal
Contains PIIYes - This Dimension contains Personally Identifiable Information

Governance

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

GitHub

View File on GitHubcatalog/dimensions/delivery-location.yml

Community Discussion