Product Name
A name or title assigned to an individual product SKU (Stock keeping unit) or product offering. It serves as the primary qualitative label used to aggregate performance metrics (like Revenue or Add to cart) across different platforms and reporting suites.
Business Use Case
1️⃣Identify merchandising driving the highest engagement and revenue, enabling data-driven decisions on stock levels and promotional discounts.
Business Criticality
High
Journey / Navigation Area
Digital Analytics
Scope
Event
Formula
TRIM(product_name)Calculation Notes
1️⃣Ensure case normalization (usually lowercase) in SQL to avoid duplication (e.g., "Yoga Mat" vs "yoga mat"). 2️⃣If names change in the PIM, use "Product ID or SKU ID" to lookup the latest productName (Saint Classifications for Adobe and Data Import for GA4)
Technical Details
Events
| Platform | Event |
|---|---|
| Google Analytics 4 | item_name |
| Adobe | s.products // 2nd parameter in s.products |
Data Mappings
W3 Data Layer
{
"product": [
{
"attributes": {
"productName": "Eco-Friendly Yoga Mat"
}
}
]
}GA4 Data Layer
{
"event": "view_item",
"ecommerce": {
"items": [
{
"item_name": "Eco-Friendly Yoga Mat"
}
]
}
}Adobe Client Data Layer
{
"product": [
{
"xdm:name": "Eco-Friendly Yoga Mat"
}
]
}XDM Mapping
xdm:productListItems[].nameSQL Queries
Google Analytics 4 (BigQuery)
SELECT LOWER(TRIM(item.item_name)) AS product_name, COUNT(DISTINCT event.transaction_id) AS orders, SUM(item.item_revenue) AS total_revenue FROM `your-project.analytics_12345.events_*`, UNNEST(items) AS item WHERE _TABLE_SUFFIX BETWEEN '20231001' AND '20231031' GROUP BY product_name ORDER BY total_revenue DESCAdobe Experience Platform (AEP Query Service)
SELECT LOWER(TRIM(item.productName)) AS product_name, COUNT(DISTINCT commerce.order.purchaseID) AS orders, SUM(commerce.purchases.value) AS total_revenue FROM your_dataset.your_table, LATERAL VIEW EXPLODE(commerce.products) AS item WHERE eventType = 'commerce.purchases' AND eventTimestamp BETWEEN '2023-10-01' AND '2023-10-31' GROUP BY product_name ORDER BY total_revenue DESCSource Data
Digital Analytics, Enterprise Resource Planning (ERP), Product Information Management (PIM)
Dependencies
Prerequisite: List the dependencies required for this Dimension
Events:
Report Attributes
GA4: Item Name Adobe: Product Name
Segment Eligibility
True
Governance
Governance
GitHub
catalog/dimensions/product-name.yml