Sonar Meta EMQ Table

The Sonar Meta EMQ table contains metadata about Sonar-enriched events sent to Meta via the Conversions API (CAPI), including event details and match quality indicators. Querying this table can help evaluate data enrichment effectiveness, track identifier coverage, and improve Event Match Quality scores.

📘

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 Name

event_name

string

The name of the Sonar event.

Example values: viewContent, pageLoad, addToCart

Match Quality Identifiers

match_quality_identifiers

JSON

A list of key-value pairs, where each pair represents an identifier used for match quality assessment.

Each identifier has a name (e.g., email, ip_address, zip) and a coverage value (e.g. 33.3, 19.6, 94.9), which represents the percentage of records containing that identifier.

Measures

Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.

TitleIDTypeDescription
Match Quality Scorematch_quality_scorenumericA numeric score (out of 10) representing the overall quality of the match based on available user identifiers. Higher scores indicate better match confidence.

Did this page help you?