customer_journey_table
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
event_date
is a required field for queries on this table.
Dimensions
Dimensions are immutable properties that can be used for grouping data.
Name | Type | Description |
---|---|---|
event_date | date | The date the customer journey event occurred. Based on the time zone of the shop at the moment of the event. |
event_date.day | date | The day on which the customer journey event occurred. Derived from event_date . |
event_date.week | date | The Sunday of the week during which the customer journey event occurred. Derived from event_date . |
event_date.month | date | The month during which the customer journey event occurred. Derived from event_date . |
event_date.quarter | date | The first month of the quarter during which the customer journey event occurred. Derived from event_date . |
event_date.year | date | The year during which the customer journey event occurred. Derived from event_date . |
ad_id | date | The ID of the ad associated with the customer journey event. Example value: 643742158069 |
ad_name | string | The name of the ad associated with the customer journey event. Example value: 3Pack-White |
ad_thumbnail | string | The thumbnail image URL of the ad associated with the customer journey event. Example value: https://storage.googleapis.com/file-hosting-bucket-shofifi/thumbnails/thumb1.jpg |
adset_name | string | The name of the adset associated with the customer journey event. Example value: Search | Caps | Golf | Pro |
campaign_name | string | The name of the campaign associated with the customer journey event. Example value: Youtube | Outerwear | 330 | New users US | 06.06.24 |
customer_id | string | The unique customer ID associated with the customer journey event. Assigned by the shop platform. Example value: 5209503793328 |
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 |
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 |
fulfillment_status | string | The status of order fulfillment for the order associated with the customer journey event. Example values: fulfilled , partial , restocked |
is_new_customer | boolean | Indicates whether the order is the customer's first. Example values: true , false |
items_purchased | record repeated | Information about items purchased by the customer in the order associated with the customer journey event. |
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 |
items_purchased.quantity | string | The quantity of items purchased in the order associated with the customer journey event. Example values: 1 , 5 , 200 |
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 |
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 |
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 |
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 |
lead_click_ts | timestamp | The time of the ad click that led to the customer journey event. Formatted according to the ISO 8601 international standard. Example value: 2024-10-26 20:03:48 |
order_id | string | The unique order ID associated with the customer journey event. Assigned by the shop platform. Example value: 4930225799243 |
order_name | string | The name of the order associated with the customer journey event. Assigned by the shop platform. Example value: #292017 , # LN6630675 |
page_type | string | The type of page the customer interacted with during the customer journey event. Example values: product , collection , cart |
product_id | string | The unique product ID of the product in the order associated with the customer journey event. Example value: 7760518986312 |
product_image | string | The image URL of the product in the order associated with the customer journey event. Example value: https://cdn.shopify.com/s/files/1/prod1 |
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 |
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"} |
questions | record repeated | Survey questions asked during the customer journey. |
questions.question | string | The question asked during the customer journey event. Example value: Which of the following led you to purchase today? |
questions.answer | string | The answer provided during the customer journey event. Example values: Exchange for a prior purchase , Youtube , QVC , Just decided to try them |
referrer | string | The referrer platform of the ad associated with the customer journey event. Example values: shop.example.com , tiktok , google |
session_id | string | The unique session ID associated with the customer journey event. Assigned by Triple Pixel. Example value: cltlok4y634IRw62AZ_1710700966152 |
source | string | The source of the customer journey event. Example values: snapchat-ads , klaviyo , google-ads , Direct |
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 , Paid with Credits , Exchange |
triple_id | string | The unique ID assigned by Triple Pixel event to track visitors across sessions, for the visitor associated with the customer journey event. Example value: cltlok4y634IRw62AZ |
type | string | The type of event in the customer journey. Example values: viewed_page , added_to_cart , placed_order |
url | string | The URL the customer interacted with during the customer journey event. Example values: myshop.com/cart , myshop.com/products/my_product_07 |
Measures
Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.
Name | Type | Description |
---|---|---|
discount | numeric | The total discount applied to the order associated with the customer journey event. Example values: 41.99 , 7.49 , 71042.30 |
order_revenue | numeric | The revenue from orders associated with the customer journey event. Example values: 25 , 253850.59 |
orders_quantity | numeric | The quantity of orders associated with the customer journey event. Example values: 1 , 3 , 11 |
quantity | numeric | The quantity of items purchased in the order associated with the customer journey event. Example values: 1 , 2 , 40 |
total_price | numeric | The total price of the order associated with the customer journey event. Example value: 247.22 |
Derived
Derived fields are metrics that are pre-calculated using multiple measures or advanced formulas.
Name | Type | Description |
---|---|---|
event_count | formula | The total number of customer journey events within the selected timeframe. Example values: 13 , 452 , 225,897 |