Customer Journey Table

The Customer Journey table tracks each step a visitor takes on your website, from page views through add-to-cart and purchase. One row per event.

📋

Table Guide

What You Can Answer With This Table

  • What steps do visitors take before purchasing? — filter by type and order by event_time per triple_id
  • Where do users drop off in the funnel? — compare counts by type
  • Which pages or products appear most in purchase paths? — group by url or product_id

Before You Query

  • Required field: event_date
  • Use type to filter by event type: viewed_page, added_to_cart, placed_order, signed_up, conversion, subscription, and others.
  • Each row is a single event. Build sequences by ordering events per triple_id or session_id.

Key Relationships

TableJoin KeyUse This Join To
Sessionssession_idExplain behavior steps with session device, source, and timing context
Ordersorder_idAdd order revenue, products, and fulfillment context to purchase events
Customerscustomer_idAdd customer profile and lifecycle context for identified visitors
ID Graphtriple_id (array match on ID Graph)Connect behavior paths across sessions and platforms through unified identity

When to Use a Different Table

  • Use Sessions table when you need individual session records without individual on-site events. The Customer Journey table is for event paths through the customer journey.
  • Use Web Analytics table when you need aggregated web metrics such as conversion rate or bounce rate by landing page. The Customer Journey table is for event-level behavior paths.
  • Use Pixel Joined table when you need attributed revenue by channel, campaign, ad set, or ad. The Customer Journey table is for behavior paths, not attribution-level performance.

View the full Triple Whale Data Ontology →


Dimensions

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

TitleIDTypeDescription
Event Dateevent_datedateThe date the customer journey event occurred. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Event Dayevent_date.daydateThe day on which the event occurred. Derived from event_date.
Event Weekevent_date.weekdateThe Sunday of the week during which the event occurred. Derived from event_date.
Event Monthevent_date.monthdateThe month during which the event occurred. Derived from event_date.
Event Quarterevent_date.quarterdateThe first month of the quarter during which the event occurred. Derived from event_date.
Event Yearevent_date.yeardateThe year during which the event occurred. Derived from event_date.
Ad IDad_iddate

The ID of the ad associated with the customer journey event.

Example value: 643742158069

Ad Image URLad_image_urlstring

The thumbnail image URL of the ad associated with the customer journey event.

Example value: https://www.example.com/ad-image.jpg

Ad Namead_namestring

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 Nameadset_namestring

The name of the ad set associated with the customer journey event.

Example values: Broad Audience, Bracelets, Wellness

Attribution Windowattribution_windowstring

The time frame for attributing conversions to the ad. By default lifetime.

Example values: 1_day, 7_days, 14_days, 28_days, lifetime

Web Browserbrowserstring

The web browser of the session where the customer journey event originated.

Example values: Chrome, Firefox, Safari

Campaign IDcampaign_idstring

The unique ID of the campaign associated with the customer journey event.

Example value: 1234567890

Campaign Namecampaign_namestring

The name of the campaign associated with the customer journey event.

Example values: Catalog Retargeting, US Generic Search, Breakfast of Champions Campaign

Checkout Event Typecheckout_event_typestring

The event type recorded by Triple Pixel, corresponding to the step of the checkout funnel.

Example values: payment, address, checkout, contact, shipping

Customer Countrycountrystring

The country associated with the customer journey event. For orders and subscriptions, this is the shipping address country. For page visits, add-to-carts, and conversions, this is the visitor's country based on geolocation. See list of countries.

Example values: United States, Canada, United Kingdom

Customer IDcustomer_idstring

The unique customer ID associated with the customer journey event. Assigned by the main sales platform.

Example value: 5209503793328

Devicedevicestring

The type of device used by the customer during their website session.

Example values: mobile, desktop, tablet, wearable

Discount Codediscount_codestring

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 Emailemailstring

The customer’s email address.

Example value: [email protected]

Event Nameevent_namestring

The name assigned to the custom conversion event.

Example values: form_fill, start_quiz, quiz_complete, order_sample, answer_question, request_consultation

Event Timestampevent_timetimestamp

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 Statusfulfillment_statusstring

The order fulfillment status for the order associated with the customer journey event.

Example values: fulfilled, partial, restocked

Is New Customeris_new_customerboolean

True if the order associated with the customer journey event is the customer's first.

Possible values: true, false

Learn how Triple Whale classifies new/returning customers.

Items Purchaseditems_purchasedrecord repeatedInformation about items purchased by the customer in the order associated with the customer journey event.
Priceitems_purchased.pricestring

The price of the purchased item in the order associated with the customer journey event.

Example values: 40.59, 10.99, 24.50

Product Nameitems_purchased.product_namestring

The name (or title) of the product purchased in the order associated with the customer journey event.

Example values: $20 USD Gift Card, Unisex Hoodie

Variant Nameitems_purchased.variant_namestring

The name (or 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.skustring

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

Quantityitems_purchased.quantitystring

The quantity of items purchased in the order associated with the customer journey event.

Example values: 1, 5, 200

Lead Click Timestamplead_click_tstimestamp

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

Attribution Modelmodelstring

The attribution model used. By default Triple Attribution.

Possible values: Total Impact, Triple Attribution, Triple Attribution + Views, Clicks & Views, Linear All, Linear Paid, First Click, Last Click

Order IDorder_idstring

The unique order ID associated with the customer journey event. Assigned by the main sales platform.

Example value: 4930225799243

Order Nameorder_namestring

The name of the order associated with the customer journey event. Assigned by the main sales platform.

Example values: #2188464, Ex-2163819-9

Page Typepage_typestring

The type of page the customer interacted with during the customer journey event.

Example values: product, collection, cart

Page View Event IDpage_view_event_idstring

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 Phonephonestring

The customer's phone number.

Example value: 18005550199

Product IDproduct_idstring

The unique ID of the product in the order associated with the customer journey event.

Example value: 7760518986312

Product Image URLproduct_imagestring

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 Nameproduct_namestring

The name (or title) of the product in the order associated with the customer journey event.

Example values: $20 USD Gift Card, Unisex Hoodie

URL Query Parametersquery_paramsstring

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 Questionsquestionsrecord repeatedSurvey questions asked during the customer journey.
Survey Questionquestions.questionstring

The question asked during the customer journey event.

Example value: Which of the following led you to purchase today?

Survey Answerquestions.answerstring

The answer provided during the customer journey event.

Example values: Exchange for a prior purchase, Youtube, QVC, Just decided to try them

Referrerreferrerstring

The referrer platform of the ad associated with the customer journey event.

Example values: shop.example.com, tiktok, google

Session IDsession_idstring

The unique session ID associated with the customer journey event. Assigned by Triple Pixel.

Example value: cltlok4y634IRw62AZ_1710700966152

Shop IDshop_idstring

The unique ID of the shop (often corresponds to the shop domain). Can be used to group or filter data by shop in multi-store reports.

Example values: example-US.myshopify.com, example-EU.myshopify.com

Shop Nameshop_namestring

The name of the shop. Can be used to group or filter data by shop in multi-store reports.

Example values: example-US, example-EU

Sourcesourcestring

The source of the customer journey event.

Example values: snapchat-ads, klaviyo, google-ads, Direct

Subscription IDsubscription_idstring

The unique ID of the subscription associated with the customer journey event.

Example value: 3521068

Tagstagsrepeated 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 IDtriple_idstring

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 Typetypestring

The customer journey event type.

Example values: viewed_page, added_to_cart, placed_order, post_purchase_survey_submitted

URLurlstring

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.

TitleIDTypeDescription
Discountdiscountnumeric

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

Example values: 41.99, 7.49, 71042.30

Order Revenueorder_revenuenumeric

The revenue from the order associated with the customer journey event.

Example values: 25, 253850.59

Page Viewspage_view_numbernumeric

The number of pages viewed during the customer journey event.

Example values: 1, 5, 12

Quantityquantitynumeric

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 Pricetotal_pricenumeric

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.

TitleIDTypeDescription
Customer Journey Eventsevent_countformula

The total number of customer journey events within the selected timeframe.

Example values: 13, 452, 225,897