Pixel Custom Conversions Table
The Pixel Custom Conversions table allows you to analyze and track specific user interactions that have been marked as conversion events, such as form submissions, demo bookings, or product upgrades. By querying this table, you can measure the total occurrences and conversion value of these events, gaining insights into nuanced website visitor behavior, and allowing for targeted analysis and optimization of your digital presence across key stages of the customer journey. Learn more about tracking custom conversion events with Triple Pixel.
Note
Use the Custom Events Builder to create custom conversion events. The custom events builder automatically flattens event properties into table columns for faster and more efficient querying.
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 |
| date | The date the pixel custom conversion 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 |
Event Hour |
| string | The hour of the day the pixel custom conversion event occurred, according to a 24-hour clock. Based on the time zone of the shop at the moment of the event. Example values: |
Ad ID |
| string | The unique ad ID. Assigned by the ad platform. Example value: |
Ad Set ID |
| string | The unique ID for the ad set associated with the ad click. Assigned by the ad platform. Example value: |
Attribution Window |
| string | The time frame for attributing conversions to the ad. By default Example values: |
Campaign ID |
| string | The unique ID for the marketing campaign associated with the ad. Assigned by the ad platform. Example values: |
Channel |
| string | The platform through which the ad was delivered. Example values: |
Customer Email |
| string | The customer's email address. Example value: |
Pixel Custom Conversion Event Data |
| JSON | The full data payload in raw JSON format, including all event properties defined for the custom conversion event. Learn more about querying pixel custom conversion event data |
Event ID |
| string | The unique ID assigned by Triple Pixel to the custom conversion event. Example value: |
Event Name |
| string | The name assigned to the custom conversion event. Example values: |
Event Timestamp |
| timestamp | The time the custom conversion event occurred. Formatted according to the ISO 8601 international standard. Example value: |
Attribution Model |
| string | The attribution model used. By default Example values: |
Triple Pixel ID |
| string | The unique ID assigned by Triple Pixel to track visitors across sessions. Example value: |
Measures
Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.
| Title | ID | Type | Description |
|---|---|---|---|
| Event Conversion Value | event_value | numeric | The monetary conversion value assigned to the custom conversion event. |
| Linear Weight | linear_weight | numeric | The weight assigned to the event when using linear attribution models. |
Updated 14 days ago