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.

Title	ID	Type	Description
Match Quality Score	`match_quality_score`	numeric	A numeric score (out of 10) representing the overall quality of the match based on available user identifiers. Higher scores indicate better match confidence.

Updated about 1 month ago