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_dateis 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 Date | event_date | date | The date the custom 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 custom event occurred. Derived from event_date. |
| Event Week | event_date.week | date | The Sunday of the week during which the custom event occurred. Derived from event_date. |
| Event Month | event_date.month | date | The month during which the custom event occurred. Derived from event_date. |
| Event Quarter | event_date.quarter | date | The first month of the quarter during which the custom event occurred. Derived from event_date. |
| Event Year | event_date.year | date | The year during which the custom event occurred. Derived from event_date. |
| Data | data | json | The full data payload in raw JSON format, including all event properties defined for the custom event. |
| 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 |
| Triple ID | triple_id | string | The unique ID assigned by Triple Pixel to track visitors across sessions. Example value: eltlok4y634IRw62AZ |
| Session ID | session_id | string | The unique ID for the session during which the custom event occurred. Assigned by Triple Pixel. Example value: eltlok4y634IRw62AZ_1710700966152 |
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. |