Facebook Ads
Your Facebook/Instagram ad campaign data: impressions, clicks, spend, conversions, ROAS.
The Facebook Ads connector brings your Meta ad campaign data into the sheet: impressions, clicks, spend, conversions, video and ROAS. The report level (campaign, ad set or individual ad) is chosen automatically based on the selected dimensions: choosing Ad Name/ID makes the report ad-level, choosing Ad Set Name/ID makes it ad-set-level, otherwise it stays campaign-level.
Full official reference for metrics and fields: Marketing API - Ads Insights.
Permessi richiesti
ads_read: Needed to read performance data (Insights) for the ad accounts you have access to.pages_read_engagement: Needed to read the content and metadata of Pages linked to the ad accounts.pages_show_list: Needed to discover which Facebook Pages you manage.
Metriche disponibili
| Metrica | Periodo | Aggregazione | Note |
|---|---|---|---|
| Impressions | |||
| Clicks (All) | |||
| Spend | |||
| Reach | |||
| Frequency | |||
| CPM | Weighted average (not a direct sum of the row values). | ||
| CPC | Weighted average (not a direct sum of the row values). | ||
| CTR | Weighted average (not a direct sum of the row values). | ||
| CPP | Weighted average (not a direct sum of the row values). | ||
| Unique Clicks | |||
| Unique CTR | Weighted average (not a direct sum of the row values). | ||
| Link Clicks | |||
| Link Click CTR | Weighted average (not a direct sum of the row values). | ||
| Post Engagement | |||
| Conversions | |||
| Cost per Conversion | Weighted average (not a direct sum of the row values). | ||
| Video Plays | |||
| Video 25% Watched | |||
| Video 50% Watched | |||
| Video 75% Watched | |||
| Video 100% Watched | |||
| ThruPlay | |||
| Cost per ThruPlay | Weighted average (not a direct sum of the row values). | ||
| Website Purchase ROAS | Weighted average (not a direct sum of the row values). | ||
| Purchase ROAS | Weighted average (not a direct sum of the row values). | ||
| Social Spend |
Dimensioni disponibili
| Dimensione | Note |
|---|---|
| Campaign Name | |
| Campaign ID | |
| Ad Set Name | |
| Ad Set ID | |
| Ad Name | |
| Ad ID | |
| Date Start | |
| Date Stop | |
| Account Name | |
| Account ID | |
| Objective | |
| Buying Type | |
| Status | |
| Publisher Platform | Limited filtering: only exact-match ("is") is supported, not exclusion nor "contains"/"begins with"/"ends with". See Filters and sorting. |
Limiti noti
- Sorting: slower generation when activeFacebook Insights doesn't offer server-side sorting natively: our system compensates for this by downloading and sorting the data internally. When you set a sort order on a report with many campaigns/ads, generation may therefore take longer than a report without sorting.
- Filters: AND only, no OR on Meta's sideUnlike other connectors, filters here are sent natively to Meta's Insights API, which only supports AND combination server-side: a filter set as OR is still treated as AND. This is a constraint of Meta's API, not the connector, so it will not be resolved by the upcoming real AND/OR precedence support for other connectors (see also the Filters and sorting section below).
Filtri e ordinamento
- AND only: no OR filtering on this connectorUnlike other connectors, filters here are sent natively to Meta's Insights API, which only supports AND combination server-side: a filter set as OR is still treated as AND. This is a constraint of Meta's API, not the connector, so it will not be resolved by the upcoming real AND/OR precedence support for other connectors.