Report Schema
Every MMM report (CSV or JSON) has the same fixed set of columns, regardless of which geo_dimension you requested. Fields that don't apply to your chosen dimension (for example, region and dma when you requested COUNTRY) are included as blank columns so the schema never changes shape between requests.
| Field | Description |
|---|---|
date_start | Reporting period start date. |
date_end | Reporting period end date (same as date_start for daily reports). |
ad_account_id | Ad account identifier. |
ad_account_name | Ad account display name. |
campaign_id | Campaign identifier. |
campaign_name | Campaign display name. |
campaign_objective | Campaign objective. |
ad_squad_id | Ad squad identifier. |
ad_squad_name | Ad squad display name. |
optimization_goal | Ad squad optimization goal. |
ad_id | Ad identifier. |
ad_name | Ad display name. |
ad_format | Ad format; values align with the labels shown in Ads Manager. |
impressions_total | All impressions (paid plus earned). |
impressions_paid | Paid impressions only. |
clicks | Swipe-up / click events. |
spend | Spend in the account's currency (not micros). |
currency | ISO currency code. |
country | Populated when geo_dimension is COUNTRY; blank otherwise. |
region | Populated when geo_dimension is REGION; blank otherwise. |
dma | Populated when geo_dimension is DMA; blank otherwise. |
Only one of country, region, or dma is active per request: it's determined by the geo_dimension parameter you sent in the report request.
Snap may suppress or aggregate rows for small or highly granular segments so that only sufficiently scaled, privacy-safe results are returned.
Was this page helpful?