Sonar Meta EMQ Table

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 shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
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`.
App Parameter Coverage	`app_parameter_coverage`	JSON	An array of parameter coverage metrics for app-based custom attribution events. Each entry contains: `identifier` (e.g., "user_agent", "ip_address") and `percentage` (coverage percentage) out of 1. Only populated for custom attribution events with app parameter coverage data.
Data Freshness	`data_freshness`	string	Data freshness indicates the delay between the time the event occurred and when we received it. Values can be "real_time", "hourly", "daily", etc. Events sent with a delay may impact how effectively your ads can be delivered to the right audiences. Stored as LowCardinality(String) with default empty string.
Diagnostics	`diagnostics`	JSON	An array of diagnostic issues identified for custom attribution (passback) events. Each diagnostic contains: `diagnostics_type`, `name`, `description`, `solution`, and `first_detection_time`. Only populated for events that have custom attribution diagnostics. Example diagnostics_type values: `s2s_passback_attribution_insufficient_event_coverage`, `s2s_passback_attribution_event_missing_visit_time`
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.
Web Parameter Coverage	`web_parameter_coverage`	JSON	An array of parameter coverage metrics for web-based custom attribution events. Each entry contains: `identifier` (e.g., "user_agent", "ip_address") and `percentage` (coverage percentage) out of 1. Only populated for custom attribution events with web parameter coverage data.

Measures

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

Title	ID	Type	Description
Additional Conversions Reported (ACR)	`acr`	numeric	Additional Conversions Reported (ACR) is a metric that helps you understand how much your business benefits from using the Conversions API alongside the Meta Pixel. It can help you determine if you can improve your Conversions API setup to measure more reported conversions. More reported conversions can help you decrease your cost per result and show your ads to people that find them relevant.
Event Coverage	`event_coverage`	numeric	Event Coverage indicates the percentage of events that are successfully tracked and attributed. This metric helps evaluate how effectively events are being captured and processed through the Conversions API integration.
Event Potential ACR Increase	`event_potential_aly_acr_increase`	numeric	Additional Conversions Reported (ACR) for Conversions API Event is a metric that estimates how many conversions (for example, purchases or link clicks) are measured as a result of an advertiser's Conversions API setup. For Meta Pixels not connected to the Conversions API, this metric estimates the impact a Conversions API integration may have. Higher values indicate greater potential for conversion rate improvement through better data quality.
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 3 months ago

Did this page help you?