Skip to main content

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.

FieldDescription
date_startReporting period start date.
date_endReporting period end date (same as date_start for daily reports).
ad_account_idAd account identifier.
ad_account_nameAd account display name.
campaign_idCampaign identifier.
campaign_nameCampaign display name.
campaign_objectiveCampaign objective.
ad_squad_idAd squad identifier.
ad_squad_nameAd squad display name.
optimization_goalAd squad optimization goal.
ad_idAd identifier.
ad_nameAd display name.
ad_formatAd format; values align with the labels shown in Ads Manager.
impressions_totalAll impressions (paid plus earned).
impressions_paidPaid impressions only.
clicksSwipe-up / click events.
spendSpend in the account's currency (not micros).
currencyISO currency code.
countryPopulated when geo_dimension is COUNTRY; blank otherwise.
regionPopulated when geo_dimension is REGION; blank otherwise.
dmaPopulated 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?
Yes
No