The Customer Journey table tracks each step a customer takes on their path through your website, from viewing pages to making purchases. Querying this table helps identify patterns and key touchpoints in the customer journey, enabling targeted improvements to enhance the shopping experience and conversion rates.
Note
customer_idis a required field for queries on this table.
select
*
from
customer_journey_table
where
customer_id = '0000123456789'
Dimensions
Dimensions are immutable properties that can be used for grouping data.
| Name | Type | Description | Source |
|---|---|---|---|
type | string | The type of event in the customer journey. Example values: viewed_page, added_to_cart, placed_order | Triple Pixel |
event_date | date | The date the customer journey event occurred. Based on the time zone of the shop at the moment of the event. | Triple Pixel |
event_date.day | date | The day on which the customer journey event occurred. Derived from event_date. | Triple Pixel |
event_date.week | date | The Sunday of the week during which the customer journey event occurred. Derived from event_date. | Triple Pixel |
event_date.month | date | The month during which the customer journey event occurred. Derived from event_date. | Triple Pixel |
event_date.quarter | date | The first month of the quarter during which the customer journey event occurred. Derived from event_date. | Triple Pixel |
event_date.year | date | The year during which the customer journey event occurred. Derived from event_date. | Triple Pixel |
event_time | timestamp | The exact timestamp when the customer journey event occurred. Formatted according to the ISO 8601 international standard. Example value: 2024-03-16T00:13:03 | Triple Pixel |
triple_id | string | The unique ID assigned by Triple Pixel event to track visitors across sessions. Example value: cltlok4y634IRw62AZ | Triple Pixel |
session_id | string | The unique session ID associated with the customer journey event. Assigned by Triple Pixel. Example value: cltlok4y634IRw62AZ_1710700966152 | Triple Pixel |
order_id | string | The unique order ID associated with the customer journey event (when the event type is placed_order). Assigned by the shop platform.Example value: 4930225799243 | Shopify/Amazon |
customer_id | string | The unique customer ID. Assigned by the shop platform. Example value: 5209503793328 | Shopify/Amazon |
order_name | string | The name of the order associated with the customer journey event. Assigned by the shop platform. Example value: #292017 | Shopify/Amazon |
total_price | string | The total price of the order associated with the customer journey event. Example value: 247.22 | Shopify/Amazon |
discount | string | The total discount applied to the order associated with the customer journey event. Example values: 41.99, 7.49, 0 | Shopify/Amazon |
fulfillment_status | string | The status of order fulfillment for the order associated with the customer journey event. | Shopify/Amazon |
tags | repeated string | Tags for the order associated with the customer journey event. Assigned by the seller in the shop platform. Example values: Upsell, Subscription, Shipped by Seller | Shopify/Amazon |
discount_code | string | The discount code for the order associated with the customer journey event. Assigned by the seller in the shop platform. Example values: WELCOME10, Replacement for defective item, 807QRWMNK2 | Shopify/Amazon |
items_purchased | record repeated | Information about items purchased by the customer in the order associated with the customer journey event. | Shopify/Amazon |
items_purchased.price | string | The price of the purchased item in the order associated with the customer journey event. Example values: 40.59, 10.99, 24.50 | Shopify/Amazon |
items_purchased.quantity | string | The quantity of items purchased in the order associated with the customer journey event. Example values: 1, 5, 200 | Shopify/Amazon |
items_purchased.product_title | string | The title of the product purchased in the order associated with the customer journey event. Example values: $20 USD Gift Card, Unisex Hoodie | Shopify/Amazon |
items_purchased.variant_title | string | The title of the product variant purchased in the order associated with the customer journey event. Example values: Forest Green, M, iPhone 14 Pro | Shopify/Amazon |
items_purchased.sku | string | The stock keeping unit of the product or variant purchased in the order associated with the customer journey event. Example values: SIL-RING-4445, NVDPROTECTION03 | Shopify/Amazon |
items_purchased.product_image | string | The image URL of the product purchased in the order associated with the customer journey event. Example value: https://cdn.myshop.com/files/prod-01.jpg | Shopify/Amazon |
quantity | string | The quantity of items purchased in the order associated with the customer journey event. Example value: 1, 2, 40 | Shopify/Amazon |
product_title | string | The title of the product in the order associated with the customer journey event. Example values: $20 USD Gift Card, Unisex Hoodie | Shopify/Amazon |
product_image | string | The image URL of the product in the order associated with the customer journey event. | Shopify/Amazon |
page_type | string | The type of page the customer interacted with during the customer journey event. Example values: product, collection, cart | Triple Pixel |
url | string | The URL the customer interacted with during the customer journey event. Example values: myshop.com/cart, myshop.com/products/my_product_07 | Triple Pixel |
referrer | string | The referrer platform of the ad associated with the customer journey event. Example value: reddit | Triple Pixel |
source | string | The source of the customer journey event. Example value: klaviyo, google-ads, Direct | Triple Pixel |
ad_name | string | The name of the ad associated with the customer journey event. | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Klaviyo, Taboola, Outbrain |
adset_name | string | The name of the adset associated with the customer journey event. | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Klaviyo, Taboola, Outbrain |
campaign_name | string | The name of the campaign associated with the customer journey event. | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Klaviyo, Yotpo Email and SMS, Taboola, Outbrain |
query_params | string | The query parameters contained in the URL associated with the customer journey event. Example values: {"tw_adid":"83906898178855", "tw_campaign":"103306890", "tw_source":"bing"," utm_campaign":"Bing Shopping", "utm_content":"HERO SKU Summer Book Run", "utm_medium":"cpc", "utm_source":"bing", "utm_term":"1342506080190763", "variant":"44042133111001"} | Triple Pixel |
ad_thumbnail | string | The thumbnail image URL of the ad associated with the customer journey event. | Triple Pixel |
questions | record repeated | Survey questions asked during the customer journey. | Triple Whale PPS, Fairing, Kno |
questions.question | string | The question asked during the customer journey event. | Triple Whale PPS, Fairing, Kno |
questions.answer | string | The answer provided during the customer journey event. | Triple Whale PPS, Fairing, Kno |
Derived
Derived fields are metrics that are pre-calculated using multiple measures or advanced formulas.
| Name | Type | Description | Source |
|---|---|---|---|
event_count | formula | The total number of events. Formula: count(1) as events | Triple Pixel |