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 |
| date | The date the Sonar event occurred. Based on the timezone of the shop at the moment of the event. |
Event Day |
| date | The day on which the event occurred. Derived from |
Event Week |
| date | The Sunday of the week during which the event occurred. Derived from |
Event Month |
| date | The month during which the event occurred. Derived from |
Event Quarter |
| date | The first month of the quarter during which the event occurred. Derived from |
Event Year |
| date | The year during which the event occurred. Derived from |
Event Name |
| string | The name of the Sonar event. Example values: |
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., |
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 19 days ago