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. |
Updated 8 days ago