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

Web Browser

browser

string

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

Example values: Chrome, Firefox, Safari

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

Device

device

string

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

Example values: mobile, desktop, tablet, wearable

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

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

Customer Journey Events

event_count

formula

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

Example values: 13, 452, 225,897