Data Dictionary

    Sonar Event Logs Table

    sonar_event_log_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.

    TitleIDTypeDescription
    Event Dateevent_datedateThe date the Sonar event occurred. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
    Event Dayevent_date.daydateThe day on which the event occurred. Derived from event_date.
    Event Weekevent_date.weekdateThe Sunday of the week during which the event occurred. Derived from event_date.
    Event Monthevent_date.monthdateThe month during which the event occurred. Derived from event_date.
    Event Quarterevent_date.quarterdateThe first month of the quarter during which the event occurred. Derived from event_date.
    Event Yearevent_date.yeardateThe year during which the event occurred. Derived from event_date.
    Event IDevent_idstring

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

    Example value: 0m77gcrz68kVwt3L8g

    Event Nameevent_namestring

    The name of the Sonar event.

    Example values: viewContent, pageLoad, addToCart

    Sourcesourcestring

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

    Example values: snapchat, meta, tiktok

    Source Event IDsource_event_idstring

    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 Codestatusstring

    HTTP response status code for the send event request.

    Example values: 200, 500

    Event Timestamptimestamptimestamp

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

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

    Triple Pixel IDtriple_idstring

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

    Example value: eltlok4y634IRw62AZ

    Updated 7 months ago

    Did this page help you?