---
updatedAt: 2026-05-14T14:52:26.000Z
agentTools:
  projectIndex: https://triplewhale.readme.io/llms.txt
---

# Customer Journey Table

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**
>
> | Table                                                           | Join Key                              | Use This Join To                                                              |
> | :-------------------------------------------------------------- | :------------------------------------ | :---------------------------------------------------------------------------- |
> | [Sessions](https://triplewhale.readme.io/docs/sessions-table)   | `session_id`                          | Explain behavior steps with session device, source, and timing context        |
> | [Orders](https://triplewhale.readme.io/docs/orders-table)       | `order_id`                            | Add order revenue, products, and fulfillment context to purchase events       |
> | [Customers](https://triplewhale.readme.io/docs/customers-table) | `customer_id`                         | Add customer profile and lifecycle context for identified visitors            |
> | [ID Graph](https://triplewhale.readme.io/docs/id-graph-table)   | `triple_id` (array match on ID Graph) | Connect behavior paths across sessions and platforms through unified identity |
>
> <br />
>
> **When to Use a Different Table**
>
> * Use [Sessions table](https://triplewhale.readme.io/docs/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](https://triplewhale.readme.io/docs/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](https://triplewhale.readme.io/docs/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 →](https://triplewhale.readme.io/docs/triple-whale-data-ontology)*

***

# Dimensions

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

<Table align={["left","left","left","left"]}>
  <thead>
    <tr>
      <th>
        Title
      </th>

      <th>
        ID
      </th>

      <th>
        Type
      </th>

      <th>
        Description
      </th>
    </tr>
  </thead>

  <tbody>
    <tr>
      <td>
        Event Date
      </td>

      <td>
        `event_date`
      </td>

      <td>
        date
      </td>

      <td>
        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).
      </td>
    </tr>

    <tr>
      <td>
        Event Day
      </td>

      <td>
        `event_date.day`
      </td>

      <td>
        date
      </td>

      <td>
        The day on which the event occurred. Derived from `event_date`.
      </td>
    </tr>

    <tr>
      <td>
        Event Week
      </td>

      <td>
        `event_date.week`
      </td>

      <td>
        date
      </td>

      <td>
        The Sunday of the week during which the event occurred. Derived from `event_date`.
      </td>
    </tr>

    <tr>
      <td>
        Event Month
      </td>

      <td>
        `event_date.month`
      </td>

      <td>
        date
      </td>

      <td>
        The month during which the event occurred. Derived from `event_date`.
      </td>
    </tr>

    <tr>
      <td>
        Event Quarter
      </td>

      <td>
        `event_date.quarter`
      </td>

      <td>
        date
      </td>

      <td>
        The first month of the quarter during which the event occurred. Derived from `event_date`.
      </td>
    </tr>

    <tr>
      <td>
        Event Year
      </td>

      <td>
        `event_date.year`
      </td>

      <td>
        date
      </td>

      <td>
        The year during which the event occurred. Derived from `event_date`.
      </td>
    </tr>

    <tr>
      <td>
        Ad ID
      </td>

      <td>
        `ad_id`
      </td>

      <td>
        date
      </td>

      <td>
        The ID of the ad associated with the customer journey event.

        Example value: `643742158069`
      </td>
    </tr>

    <tr>
      <td>
        Ad Image URL
      </td>

      <td>
        `ad_image_url`
      </td>

      <td>
        string
      </td>

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

        Example value: `https://www.example.com/ad-image.jpg`
      </td>
    </tr>

    <tr>
      <td>
        Ad Name
      </td>

      <td>
        `ad_name`
      </td>

      <td>
        string
      </td>

      <td>
        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`
      </td>
    </tr>

    <tr>
      <td>
        Ad Set Name
      </td>

      <td>
        `adset_name`
      </td>

      <td>
        string
      </td>

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

        Example values: `Broad Audience`, `Bracelets`, `Wellness`
      </td>
    </tr>

    <tr>
      <td>
        Attribution Window
      </td>

      <td>
        `attribution_window`
      </td>

      <td>
        string
      </td>

      <td>
        The time frame for attributing conversions to the ad. By default `lifetime`.

        Example values: `1_day`, `7_days`, `14_days`, `28_days`, `lifetime`
      </td>
    </tr>

    <tr>
      <td>
        Web Browser
      </td>

      <td>
        `browser`
      </td>

      <td>
        string
      </td>

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

        Example values: `Chrome`, `Firefox`, `Safari`
      </td>
    </tr>

    <tr>
      <td>
        Campaign ID
      </td>

      <td>
        `campaign_id`
      </td>

      <td>
        string
      </td>

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

        Example value: `1234567890`
      </td>
    </tr>

    <tr>
      <td>
        Campaign Name
      </td>

      <td>
        `campaign_name`
      </td>

      <td>
        string
      </td>

      <td>
        The name of the campaign associated with the customer journey event.

        Example values: `Catalog Retargeting`, `US Generic Search`, `Breakfast of Champions Campaign`
      </td>
    </tr>

    <tr>
      <td>
        Checkout Event Type
      </td>

      <td>
        `checkout_event_type`
      </td>

      <td>
        string
      </td>

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

        Example values: `payment`, `address`, `checkout`, `contact`, `shipping`
      </td>
    </tr>

    <tr>
      <td>
        Customer Country
      </td>

      <td>
        `country`
      </td>

      <td>
        string
      </td>

      <td>
        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](https://shopify.dev/docs/api/storefront/latest/enums/CountryCode).

        Example values: `United States`, `Canada`, `United Kingdom`
      </td>
    </tr>

    <tr>
      <td>
        Customer ID
      </td>

      <td>
        `customer_id`
      </td>

      <td>
        string
      </td>

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

        Example value: `5209503793328`
      </td>
    </tr>

    <tr>
      <td>
        Device
      </td>

      <td>
        `device`
      </td>

      <td>
        string
      </td>

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

        Example values: `mobile`, `desktop`, `tablet`, `wearable`
      </td>
    </tr>

    <tr>
      <td>
        Discount Code
      </td>

      <td>
        `discount_code`
      </td>

      <td>
        string
      </td>

      <td>
        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`
      </td>
    </tr>

    <tr>
      <td>
        Customer Email
      </td>

      <td>
        `email`
      </td>

      <td>
        string
      </td>

      <td>
        The customer’s email address.

        Example value: `customer@example.com`
      </td>
    </tr>

    <tr>
      <td>
        Event Name
      </td>

      <td>
        `event_name`
      </td>

      <td>
        string
      </td>

      <td>
        The name assigned to the custom conversion event.

        Example values: `form_fill`, `start_quiz`, `quiz_complete`, `order_sample`, `answer_question`, `request_consultation`
      </td>
    </tr>

    <tr>
      <td>
        Event Timestamp
      </td>

      <td>
        `event_time`
      </td>

      <td>
        timestamp
      </td>

      <td>
        The exact timestamp when the customer journey event occurred. Formatted according to the [ISO 8601 international standard](https://www.iso.org/iso-8601-date-and-time-format.html).

        Example value: `2024-03-16T00:13:03`
      </td>
    </tr>

    <tr>
      <td>
        Fulfillment Status
      </td>

      <td>
        `fulfillment_status`
      </td>

      <td>
        string
      </td>

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

        Example values: `fulfilled`, `partial`, `restocked`
      </td>
    </tr>

    <tr>
      <td>
        Is New Customer
      </td>

      <td>
        `is_new_customer`
      </td>

      <td>
        boolean
      </td>

      <td>
        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](https://triplewhale.readme.io/docs/is-new-customer#/).
      </td>
    </tr>

    <tr>
      <td>
        Items Purchased
      </td>

      <td>
        `items_purchased`
      </td>

      <td>
        record repeated
      </td>

      <td>
        Information about items purchased by the customer in the order associated with the customer journey event.
      </td>
    </tr>

    <tr>
      <td>
        Price
      </td>

      <td>
        `items_purchased.price`
      </td>

      <td>
        string
      </td>

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

        Example values: `40.59`, `10.99`, `24.50`
      </td>
    </tr>

    <tr>
      <td>
        Product Name
      </td>

      <td>
        `items_purchased.product_name`
      </td>

      <td>
        string
      </td>

      <td>
        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`
      </td>
    </tr>

    <tr>
      <td>
        Variant Name
      </td>

      <td>
        `items_purchased.variant_name`
      </td>

      <td>
        string
      </td>

      <td>
        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`
      </td>
    </tr>

    <tr>
      <td>
        Stock Keeping Unit (SKU)
      </td>

      <td>
        `items_purchased.sku`
      </td>

      <td>
        string
      </td>

      <td>
        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`
      </td>
    </tr>

    <tr>
      <td>
        Quantity
      </td>

      <td>
        `items_purchased.quantity`
      </td>

      <td>
        string
      </td>

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

        Example values: `1`, `5`, `200`
      </td>
    </tr>

    <tr>
      <td>
        Lead Click Timestamp
      </td>

      <td>
        `lead_click_ts`
      </td>

      <td>
        timestamp
      </td>

      <td>
        The time of the ad click that led to the customer journey event. Formatted according to the [ISO 8601 international standard](https://www.iso.org/iso-8601-date-and-time-format.html).

        Example value: `2024-10-26 20:03:48`
      </td>
    </tr>

    <tr>
      <td>
        Attribution Model
      </td>

      <td>
        `model`
      </td>

      <td>
        string
      </td>

      <td>
        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`
      </td>
    </tr>

    <tr>
      <td>
        Order ID
      </td>

      <td>
        `order_id`
      </td>

      <td>
        string
      </td>

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

        Example value: `4930225799243`
      </td>
    </tr>

    <tr>
      <td>
        Order Name
      </td>

      <td>
        `order_name`
      </td>

      <td>
        string
      </td>

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

        Example values: `#2188464`, `Ex-2163819-9`
      </td>
    </tr>

    <tr>
      <td>
        Page Type
      </td>

      <td>
        `page_type`
      </td>

      <td>
        string
      </td>

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

        Example values: `product`, `collection`, `cart`
      </td>
    </tr>

    <tr>
      <td>
        Page View Event ID
      </td>

      <td>
        `page_view_event_id`
      </td>

      <td>
        string
      </td>

      <td>
        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`
      </td>
    </tr>

    <tr>
      <td>
        Customer Phone
      </td>

      <td>
        `phone`
      </td>

      <td>
        string
      </td>

      <td>
        The customer's phone number.

        Example value: `18005550199`
      </td>
    </tr>

    <tr>
      <td>
        Product ID
      </td>

      <td>
        `product_id`
      </td>

      <td>
        string
      </td>

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

        Example value: `7760518986312`
      </td>
    </tr>

    <tr>
      <td>
        Product Image URL
      </td>

      <td>
        `product_image`
      </td>

      <td>
        string
      </td>

      <td>
        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`
      </td>
    </tr>

    <tr>
      <td>
        Product Name
      </td>

      <td>
        `product_name`
      </td>

      <td>
        string
      </td>

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

        Example values: `$20 USD Gift Card`, `Unisex Hoodie`
      </td>
    </tr>

    <tr>
      <td>
        URL Query Parameters
      </td>

      <td>
        `query_params`
      </td>

      <td>
        string
      </td>

      <td>
        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"}`
      </td>
    </tr>

    <tr>
      <td>
        Survey Questions
      </td>

      <td>
        `questions`
      </td>

      <td>
        record repeated
      </td>

      <td>
        Survey questions asked during the customer journey.
      </td>
    </tr>

    <tr>
      <td>
        Survey Question
      </td>

      <td>
        `questions.question`
      </td>

      <td>
        string
      </td>

      <td>
        The question asked during the customer journey event.

        Example value: `Which of the following led you to purchase today?`
      </td>
    </tr>

    <tr>
      <td>
        Survey Answer
      </td>

      <td>
        `questions.answer`
      </td>

      <td>
        string
      </td>

      <td>
        The answer provided during the customer journey event.

        Example values: `Exchange for a prior purchase`, `Youtube`, `QVC`, `Just decided to try them`
      </td>
    </tr>

    <tr>
      <td>
        Referrer
      </td>

      <td>
        `referrer`
      </td>

      <td>
        string
      </td>

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

        Example values: `shop.example.com`, `tiktok`, `google`
      </td>
    </tr>

    <tr>
      <td>
        Session ID
      </td>

      <td>
        `session_id`
      </td>

      <td>
        string
      </td>

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

        Example value: `cltlok4y634IRw62AZ_1710700966152`
      </td>
    </tr>

    <tr>
      <td>
        Shop ID
      </td>

      <td>
        `shop_id`
      </td>

      <td>
        string
      </td>

      <td>
        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`
      </td>
    </tr>

    <tr>
      <td>
        Shop Name
      </td>

      <td>
        `shop_name`
      </td>

      <td>
        string
      </td>

      <td>
        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`
      </td>
    </tr>

    <tr>
      <td>
        Source
      </td>

      <td>
        `source`
      </td>

      <td>
        string
      </td>

      <td>
        The source of the customer journey event.

        Example values: `snapchat-ads`, `klaviyo`, `google-ads`, `Direct`
      </td>
    </tr>

    <tr>
      <td>
        Subscription ID
      </td>

      <td>
        `subscription_id`
      </td>

      <td>
        string
      </td>

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

        Example value: `3521068`
      </td>
    </tr>

    <tr>
      <td>
        Tags
      </td>

      <td>
        `tags`
      </td>

      <td>
        repeated string
      </td>

      <td>
        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`
      </td>
    </tr>

    <tr>
      <td>
        Triple Pixel ID
      </td>

      <td>
        `triple_id`
      </td>

      <td>
        string
      </td>

      <td>
        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`
      </td>
    </tr>

    <tr>
      <td>
        Customer Journey Event Type
      </td>

      <td>
        `type`
      </td>

      <td>
        string
      </td>

      <td>
        The customer journey event type.

        Example values: `viewed_page`, `added_to_cart`, `placed_order`, `post_purchase_survey_submitted`
      </td>
    </tr>

    <tr>
      <td>
        URL
      </td>

      <td>
        `url`
      </td>

      <td>
        string
      </td>

      <td>
        The URL the customer interacted with during the customer journey event.

        Example values: `myshop.com/cart`, `myshop.com/products/my_product_07`
      </td>
    </tr>
  </tbody>
</Table>

# Measures

Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.

<Table align={["left","left","left","left"]}>
  <thead>
    <tr>
      <th>
        Title
      </th>

      <th>
        ID
      </th>

      <th>
        Type
      </th>

      <th>
        Description
      </th>
    </tr>
  </thead>

  <tbody>
    <tr>
      <td>
        Discount
      </td>

      <td>
        `discount`
      </td>

      <td>
        numeric
      </td>

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

        Example values: `41.99`, `7.49`, `71042.30`
      </td>
    </tr>

    <tr>
      <td>
        Order Revenue
      </td>

      <td>
        `order_revenue`
      </td>

      <td>
        numeric
      </td>

      <td>
        The revenue from the order associated with the customer journey event.

        Example values: `25`, `253850.59`
      </td>
    </tr>

    <tr>
      <td>
        Page Views
      </td>

      <td>
        `page_view_number`
      </td>

      <td>
        numeric
      </td>

      <td>
        The number of pages viewed during the customer journey event.

        Example values: `1`, `5`, `12`
      </td>
    </tr>

    <tr>
      <td>
        Quantity
      </td>

      <td>
        `quantity`
      </td>

      <td>
        numeric
      </td>

      <td>
        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`
      </td>
    </tr>

    <tr>
      <td>
        Total Price
      </td>

      <td>
        `total_price`
      </td>

      <td>
        numeric
      </td>

      <td>
        The total price of the order associated with the customer journey event.

        Example value: `247.22`
      </td>
    </tr>
  </tbody>
</Table>

# Derived

Derived fields are metrics that are pre-calculated using multiple measures or advanced formulas.

<Table align={["left","left","left","left"]}>
  <thead>
    <tr>
      <th>
        Title
      </th>

      <th>
        ID
      </th>

      <th>
        Type
      </th>

      <th>
        Description
      </th>
    </tr>
  </thead>

  <tbody>
    <tr>
      <td>
        Customer Journey Events
      </td>

      <td>
        `event_count`
      </td>

      <td>
        formula
      </td>

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

        Example values: `13`, `452`, `225,897`
      </td>
    </tr>
  </tbody>
</Table>

<HTMLBlock>{`
<style>
  .content-toc {
    flex: 0 0 220px !important;
}
  .rm-Guides .content-body {
    max-width: calc(100% - 220px) !important;
    width: 880px !important;
}
</style>
`}</HTMLBlock>