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 GuideWhat You Can Answer With This Table
- What steps do visitors take before purchasing? — filter by
typeand order byevent_timepertriple_id- Where do users drop off in the funnel? — compare counts by
type- Which pages or products appear most in purchase paths? — group by
urlorproduct_idBefore You Query
- Required field:
event_date- Use
typeto 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_idorsession_id.Key Relationships
Table Join Key Use This Join To Sessions session_idExplain behavior steps with session device, source, and timing context Orders order_idAdd order revenue, products, and fulfillment context to purchase events Customers customer_idAdd customer profile and lifecycle context for identified visitors ID Graph triple_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.
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 shop time zone at the moment of the event (or the user time zone, if no sales platform is connected). |
| 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: |
| Ad Image URL | ad_image_url | string | The thumbnail image URL of the ad associated with the customer journey event. Example value: |
| Ad Name | ad_name | string | The name of the ad associated with the customer journey event. Example values: |
| Ad Set Name | adset_name | string | The name of the ad set associated with the customer journey event. Example values: |
| Attribution Window | attribution_window | string | The time frame for attributing conversions to the ad. By default Example values: |
| Web Browser | browser | string | The web browser of the session where the customer journey event originated. Example values: |
| Campaign ID | campaign_id | string | The unique ID of the campaign associated with the customer journey event. Example value: |
| Campaign Name | campaign_name | string | The name of the campaign associated with the customer journey event. Example values: |
| Checkout Event Type | checkout_event_type | string | The event type recorded by Triple Pixel, corresponding to the step of the checkout funnel. Example values: |
| Customer Country | country | string | 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: |
| Customer ID | customer_id | string | The unique customer ID associated with the customer journey event. Assigned by the main sales platform. Example value: |
| Device | device | string | The type of device used by the customer during their website session. Example values: |
| 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: |
| Customer Email | email | string | The customer’s email address. Example value: |
| Event Name | event_name | string | The name assigned to the custom conversion event. Example values: |
| Event Timestamp | event_time | timestamp | The exact timestamp when the customer journey event occurred. Formatted according to the ISO 8601 international standard. Example value: |
| Fulfillment Status | fulfillment_status | string | The order fulfillment status for the order associated with the customer journey event. Example values: |
| Is New Customer | is_new_customer | boolean | True if the order associated with the customer journey event is the customer's first. Possible values: |
| 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: |
| Product Name | items_purchased.product_name | string | The name (or title) of the product purchased in the order associated with the customer journey event. Example values: |
| Variant Name | items_purchased.variant_name | string | The name (or title) of the product variant purchased in the order associated with the customer journey event. Example values: |
| 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: |
| Quantity | items_purchased.quantity | string | The quantity of items purchased in the order associated with the customer journey event. Example values: |
| 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: |
| Attribution Model | model | string | The attribution model used. By default Possible values: |
| Order ID | order_id | string | The unique order ID associated with the customer journey event. Assigned by the main sales platform. Example value: |
| Order Name | order_name | string | The name of the order associated with the customer journey event. Assigned by the main sales platform. Example values: |
| Page Type | page_type | string | The type of page the customer interacted with during the customer journey event. Example values: |
| 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: |
| Customer Phone | phone | string | The customer's phone number. Example value: |
| Product ID | product_id | string | The unique ID of the product in the order associated with the customer journey event. Example value: |
| Product Image URL | product_image | string | The image URL of the product in the order associated with the customer journey event. Example value: |
| Product Name | product_name | string | The name (or title) of the product in the order associated with the customer journey event. Example values: |
| URL Query Parameters | query_params | string | The query parameters contained in the URL associated with the customer journey event. Example values: |
| 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: |
| Survey Answer | questions.answer | string | The answer provided during the customer journey event. Example values: |
| Referrer | referrer | string | The referrer platform of the ad associated with the customer journey event. Example values: |
| Session ID | session_id | string | The unique session ID associated with the customer journey event. Assigned by Triple Pixel. Example value: |
| Shop ID | shop_id | string | 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: |
| Shop Name | shop_name | string | The name of the shop. Can be used to group or filter data by shop in multi-store reports. Example values: |
| Source | source | string | The source of the customer journey event. Example values: |
| Subscription ID | subscription_id | string | The unique ID of the subscription associated with the customer journey event. Example value: |
| 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: |
| 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: |
| Customer Journey Event Type | type | string | The customer journey event type. Example values: |
| URL | url | string | The URL the customer interacted with during the customer journey event. Example values: |
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: |
| Order Revenue | order_revenue | numeric | The revenue from the order associated with the customer journey event. Example values: |
| Page Views | page_view_number | numeric | The number of pages viewed during the customer journey event. Example values: |
| Quantity | quantity | numeric | The number of products added to the cart (for Example values: |
| Total Price | total_price | numeric | The total price of the order associated with the customer journey event. Example value: |
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: |
Updated 12 days ago