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 (event_date) is a required field for queries on this table.

Use Event Type (type) to categorize and analyze specific actions in the customer journey, such as page views, add-to-cart events, and completed purchases.

Dimensions

Dimensions are immutable properties that can be used for grouping data.

Title	ID	Type	Description
Event Date	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 Day	event_date.day	date	The day on which the event occurred. Derived from event_date.
Event Week	event_date.week	date	The Sunday of the week during which the event occurred. Derived from event_date.
Event Month	event_date.month	date	The month during which the event occurred. Derived from event_date.
Event Quarter	event_date.quarter	date	The first month of the quarter during which the event occurred. Derived from event_date.
Event Year	event_date.year	date	The year during which the event occurred. Derived from event_date.
Ad ID	ad_id	date	The ID of the ad associated with the customer journey event. Example value: 643742158069
Ad Image URL	ad_image_url	string	The thumbnail image URL of the ad associated with the customer journey event. Example value: https://www.example.com/ad-image.jpg
Ad Name	ad_name	string	The name of the ad associated with the customer journey event. Example values: Kids Ad 1, Read Our Latest Blog 03/12/2023, 8 best fall looks
Ad Set Name	adset_name	string	The name of the ad set associated with the customer journey event. Example values: Broad Audience, Bracelets, Wellness
Campaign Name	campaign_name	string	The name of the campaign associated with the customer journey event. Example values: Catalog Retargeting, US Generic Search, Breakfast of Champions Campaign
Customer Country	country	string	The country of the customer. Example values: Canada, United States, Hong Kong
Customer ID	customer_id	string	The unique customer ID associated with the customer journey event. Assigned by the main sales platform. Example value: 5209503793328
Discount Code	discount_code	string	The discount code for the order associated with the customer journey event. Assigned by the seller in the main sales platform. Example values: WELCOME10, Replacement for defective item, 807QRWMNK2
Customer Email	email	string	The customer’s email address. Example value: [email protected]
Event Timestamp	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	fulfillment_status	string	The order fulfillment status for the order associated with the customer journey event. Example values: fulfilled, partial, restocked
Is New Customer	is_new_customer	boolean	True if the order associated with the customer journey event is the customer's first. Possible values: true, false Note that Triple Whale classifies all customers as either new or returning, while the main sales platform may leave some unclassified, potentially leading to discrepancies.
Items Purchased	items_purchased	record repeated	Information about items purchased by the customer in the order associated with the customer journey event.
Price	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
Product Title	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
Variant Title	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
Stock Keeping Unit (SKU)	items_purchased.sku	string	The stock keeping unit (SKU) of the product or variant purchased in the order associated with the customer journey event. Example values: SIL-RING-4445, NVDPROTECTION03
Quantity	items_purchased.quantity	string	The quantity of items purchased in the order associated with the customer journey event. Example values: 1, 5, 200
Lead Click Timestamp	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	order_id	string	The unique order ID associated with the customer journey event. Assigned by the main sales platform. Example value: 4930225799243
Order Name	order_name	string	The name of the order associated with the customer journey event. Assigned by the main sales platform. Example values: #2188464, Ex-2163819-9
Page Type	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	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
Customer Phone	phone	string	The customer's phone number. Example value: 18005550199
Product ID	product_id	string	The unique ID of the product in the order associated with the customer journey event. Example value: 7760518986312
Product Image URL	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	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
URL Query Parameters	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"}
Survey Questions	questions	record repeated	Survey questions asked during the customer journey.
Survey Question	questions.question	string	The question asked during the customer journey event. Example value: Which of the following led you to purchase today?
Survey Answer	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	referrer	string	The referrer platform of the ad associated with the customer journey event. Example values: shop.example.com, tiktok, google
Session ID	session_id	string	The unique session ID associated with the customer journey event. Assigned by Triple Pixel. Example value: cltlok4y634IRw62AZ_1710700966152
Source	source	string	The source of the customer journey event. Example values: snapchat-ads, klaviyo, google-ads, Direct
Tags	tags	repeated string	Tags for the order associated with the customer journey event. Assigned by the seller in the main sales platform. Example values: Upsell, Order Credits, discount_eligible
Triple Pixel ID	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
Customer Journey Event Type	type	string	The customer journey event type. Example values: viewed_page, added_to_cart, placed_order, post_purchase_survey_submitted
URL	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.

Title	ID	Type	Description
Discount	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	order_revenue	numeric	The revenue from the order associated with the customer journey event. Example values: 25, 253850.59
Page Views	page_view_number	numeric	The number of pages viewed during the customer journey event. Example values: 1, 5, 12
Quantity	quantity	numeric	The number of products added to the cart (for added_to_cart events) or the number of orders (for placed_order events). Example values: 1, 3, 15
Total Price	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.

Title	ID	Type	Description
Customer Journey Events	event_count	formula	The total number of customer journey events within the selected timeframe. Example values: 13, 452, 225,897