Sonar Event Logs Table
The Sonar Event Logs table contains a record of all events enriched and transmitted by Sonar to connected platforms like Meta and Klaviyo. Querying this table can help analyze the effectiveness of data enrichment, track event transmission status, and troubleshoot discrepancies in data reporting.
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 Date |
| date | The date the Sonar event occurred. Based on the timezone 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 ID |
| string | The unique ID assigned by Triple Pixel to the Sonar event. Example value: |
Event Name |
| string | The name of the Sonar event. Example values: |
Source |
| string | The connected platform or service where the Sonar event was delivered. Example values: |
Source Event ID |
| string | The event ID assigned by Sonar and sent in the payload of the event to the connected (source) destination. Example values: |
HTTP Status Code |
| string | HTTP response status code for the send event request. Example values: |
Event Timestamp |
| timestamp | The time the Sonar event occurred. Formatted according to the ISO 8601 international standard. Example value: |
Triple Pixel ID |
| string | The unique ID assigned by Triple Pixel to track visitors across sessions. Example value: |
Updated 11 days ago