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

event_date

date

The date the Sonar event occurred. Based on the timezone 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.

Event ID

event_id

string

The unique ID assigned by Triple Pixel to the Sonar event.

Example value: 0m77gcrz68kVwt3L8g

Event Name

event_name

string

The name of the Sonar event.

Example values: viewContent, pageLoad, addToCart

Source

source

string

The connected platform or service where the Sonar event was delivered.

Example values: snapchat, meta, tiktok

Source Event ID

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: sh-08c8d5d3-588B-4204-70C7-186BDC44A15C, 0m72q9rfg2vnFXo3TN, pv-0m723m4xb3gocNA1Sw-6106705166510 - 1739376106537

HTTP Status Code

status

string

HTTP response status code for the send event request.

Example values: 200, 500

Event Timestamp

timestamp

timestamp

The time the Sonar event occurred. Formatted according to the ISO 8601 international standard.

Example value: 2022-06-15T19:26:30.000Z

Triple Pixel ID

triple_id

string

The unique ID assigned by Triple Pixel to track visitors across sessions.

Example value: eltlok4y634IRw62AZ