Customer Journey Table

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
country	string	Customer's country. Example values: Canada, United States, Hong Kong
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
email	string	Customer’s email address. Example value: [email protected]
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
page_view_event_id	string	A unique ID that links to the parent page view associated with the customer journey event. This allows tracking of custom events as child actions within the context of the page they occurred on. Example value: 0m3uyt4g11owByF1cQ
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
page_view_number	numeric	The number of pages viewed during the customer journey event. Example values: 1, 5, 12
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