Custom Pixel Events Table

custom_pixel_events_table

The Custom Pixel Events table allows you to track specific interactions visitors have with your website, based on the custom events you’ve defined, such as product customization interactions, A/B testing, scroll depth, and more. By querying this table, you can gain deep insights into visitor behavior. Learn more about tracking custom events with Triple Pixel.

📘

Note

We recommend using the Custom Events Builder to create custom events, as it automatically flattens event properties into table columns for faster and more efficient querying.

For events not created with the builder, you can still query the raw JSON data payload but the properties will not be flattened.

📘

Note

event_date is a required field for queries on this table.

Dimensions

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

Title	ID	Type	Description
Event Hour	event_hour	string	The hour of the day the custom pixel event occurred, according to a 24-hour clock. Based on the time zone of the shop at the moment of the event. Example values: 07, 16, 21
Event Date	event_date	date	The date the custom pixel 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.
Custom Pixel Event Data	data	JSON	The full data payload in raw JSON format, including all event properties defined for the custom event. Learn more about querying custom pixel event data
Event Name	event_name	string	The name assigned to the custom event. Example values: form_fill, start_quiz, quiz_complete, order_sample, answer_question, request_consultation
Event Timestamp	event_timestamp	timestamp	The time the custom event occurred. Formatted according to the ISO 8601 international standard. Example value: 2022-06-15T19:26:30.000Z
Page View Event ID	page_view_event_id	string	The unique ID for the page view event during which the custom event occurred. Assigned by Triple Pixel. Example value: 9m4rs48lg2elVB52xU
Triple Pixel ID	triple_id	string	The unique ID assigned by Triple Pixel to track visitors across sessions. Example value: eltlok4y634IRw62AZ

Derived

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

Title	ID	Type	Description
Custom Pixel Events	count	formula	The total number of custom pixel events recorded within the selected timeframe.