Pixel Custom Events Table
pixel_custom_events_table
The Pixel Custom 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. Querying this table lets you understand nuanced website visitor behaviors, allowing for targeted analysis and optimization of your digital presence. 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 Hour |
| string | The hour of the day the pixel custom event occurred, according to a 24-hour clock. Based on the time zone of the shop at the moment of the event. Example values: |
Event Date |
| date | The date the pixel custom event occurred. Based on the time zone of the shop at the moment of the event. |
Event Day |
| date | The day on which the event occurred. Derived from |
Event Week |
| date | The Sunday of the week during which the event occurred. Derived from |
Event Month |
| date | The month during which the event occurred. Derived from |
Event Quarter |
| date | The first month of the quarter during which the event occurred. Derived from |
Event Year |
| date | The year during which the event occurred. Derived from |
Pixel Custom Event Data |
| JSON | The full data payload in raw JSON format, including all event properties defined for the custom event. Learn more about querying pixel custom event data |
Event Name |
| string | The name assigned to the custom event. Example values: |
Event Timestamp |
| timestamp | The time the custom event occurred. Formatted according to the ISO 8601 international standard. Example value: |
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: |
Triple Pixel ID |
| string | The unique ID assigned by Triple Pixel to track visitors across sessions. Example value: |
Derived
Derived fields are metrics that are pre-calculated using multiple measures or advanced formulas.
| Title | ID | Type | Description |
|---|---|---|---|
| Pixel Custom Events | count | formula | The total number of pixel custom events recorded within the selected timeframe. |
Updated 14 days ago