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.

NameTypeDescription
event_datedateThe date the customer journey event occurred. Based on the time zone of the shop at the moment of the event.
event_date.daydateThe day on which the customer journey event occurred. Derived from event_date.
event_date.weekdateThe Sunday of the week during which the customer journey event occurred. Derived from event_date.
event_date.monthdateThe month during which the customer journey event occurred. Derived from event_date.
event_date.quarterdateThe first month of the quarter during which the customer journey event occurred. Derived from event_date.
event_date.yeardateThe year during which the customer journey event occurred. Derived from event_date.
ad_iddateThe ID of the ad associated with the customer journey event.

Example value: 643742158069
ad_namestringThe name of the ad associated with the customer journey event.

Example value: 3Pack-White
ad_thumbnailstringThe 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_namestringThe name of the adset associated with the customer journey event.

Example value: Search | Caps | Golf | Pro
campaign_namestringThe name of the campaign associated with the customer journey event.

Example value: Youtube | Outerwear | 330 | New users US | 06.06.24
customer_idstringThe unique customer ID associated with the customer journey event. Assigned by the shop platform.

Example value: 5209503793328
discount_codestringThe 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_timetimestampThe exact timestamp when the customer journey event occurred. Formatted according to the ISO 8601 international standard.

Example value: 2024-03-16T00:13:03
fulfillment_statusstringThe status of order fulfillment for the order associated with the customer journey event.

Example values: fulfilled, partial, restocked
is_new_customerbooleanIndicates whether the order is the customer's first.

Example values: true, false
items_purchasedrecord repeatedInformation about items purchased by the customer in the order associated with the customer journey event.
items_purchased.pricestringThe price of the purchased item in the order associated with the customer journey event.

Example values: 40.59, 10.99, 24.50
items_purchased.quantitystringThe quantity of items purchased in the order associated with the customer journey event.

Example values: 1, 5, 200
items_purchased.product_titlestringThe 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_titlestringThe 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.skustringThe 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_imagestringThe 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_tstimestampThe 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_idstringThe unique order ID associated with the customer journey event. Assigned by the shop platform.

Example value: 4930225799243
order_namestringThe name of the order associated with the customer journey event. Assigned by the shop platform.

Example value: #292017, # LN6630675
page_typestringThe type of page the customer interacted with during the customer journey event.

Example values: product, collection, cart
product_idstringThe unique product ID of the product in the order associated with the customer journey event.

Example value: 7760518986312
product_imagestringThe 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_titlestringThe title of the product in the order associated with the customer journey event.

Example values: $20 USD Gift Card, Unisex Hoodie
query_paramsstringThe 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"}
questionsrecord repeatedSurvey questions asked during the customer journey.
questions.questionstringThe question asked during the customer journey event.

Example value: Which of the following led you to purchase today?
questions.answerstringThe answer provided during the customer journey event.

Example values: Exchange for a prior purchase, Youtube, QVC, Just decided to try them
referrerstringThe referrer platform of the ad associated with the customer journey event.

Example values: shop.example.com, tiktok, google
session_idstringThe unique session ID associated with the customer journey event. Assigned by Triple Pixel.

Example value: cltlok4y634IRw62AZ_1710700966152
sourcestringThe source of the customer journey event.

Example values: snapchat-ads, klaviyo, google-ads, Direct
tagsrepeated stringTags 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_idstringThe unique ID assigned by Triple Pixel event to track visitors across sessions, for the visitor associated with the customer journey event.

Example value: cltlok4y634IRw62AZ
typestringThe type of event in the customer journey.

Example values: viewed_page, added_to_cart, placed_order
urlstringThe 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.

NameTypeDescription
discountnumericThe total discount applied to the order associated with the customer journey event.

Example values: 41.99, 7.49, 71042.30
order_revenuenumericThe revenue from orders associated with the customer journey event.

Example values: 25, 253850.59
orders_quantitynumericThe quantity of orders associated with the customer journey event.

Example values: 1, 3, 11
quantitynumericThe quantity of items purchased in the order associated with the customer journey event.

Example values: 1, 2, 40
total_pricenumericThe 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.

NameTypeDescription
event_countformulaThe total number of customer journey events within the selected timeframe.

Example values: 13, 452, 225,897