Integrations
Facebook Ads datasets and fields
The 28 datasets Maven lands from Facebook Ads, every field in them, and how the connection syncs.
Maven lands 28 datasets from Facebook Ads in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the Facebook Ads integration page.
Connection and sync#
You connect Facebook Ads by signing in to it and approving access, so nobody shares a password.
The first Facebook Ads sync pulls the most recent 30 days so the workspace fills quickly. A follow-up backfill then adds older history, up to 3 years in total. After that, each scheduled sync re-reads the last 7 days, so late changes are picked up.
Datasets#
Ad account settings#
Authoritative Meta ad-account currency and reporting timezone snapshot.
| Field | Type |
|---|---|
| account ID | Text |
| account name | Text |
| account currency | Text |
| account timezone | Text |
| metadata provenance | Text |
Ad insights#
Base ad performance.
| Field | Type |
|---|---|
| date | Date |
| ad ID | Text |
| ad name | Text |
| campaign ID | Text |
| campaign name | Text |
| adset ID | Text |
| adset name | Text |
| account ID | Text |
| account name | Text |
| account currency | Text |
| account timezone | Text |
| objective | Text |
| impressions | Integer |
| spend | Number |
| clicks | Integer |
| CPC | Number |
| CPM | Number |
| CTR | Number |
| reach | Integer |
| frequency | Number |
| purchases | Number |
| purchase value | Number |
| add to carts | Number |
| add to cart value | Number |
| landing page views | Number |
| link clicks | Number |
| leads | Number |
| lead value | Number |
| complete registrations | Number |
| initiate checkouts | Number |
| page engagements | Number |
| post engagements | Number |
| video views | Number |
| comments | Number |
| shares | Number |
| post reactions | Number |
| likes | Number |
| total conversions | Number |
| total conversion value | Number |
| actions | Text |
| action values | Text |
| conversions | Text |
| conversion values | Text |
| actions json | Text |
| action values json | Text |
| conversions json | Text |
| conversion values json | Text |
| video plays | Number |
| video p25 watched | Number |
| video p50 watched | Number |
| video p75 watched | Number |
| video p95 watched | Number |
| video p100 watched | Number |
| video thruplays | Number |
| video 30 sec watched | Number |
Conversion report coverage daily#
Successful native Meta conversion-report coverage, including account-days with zero returned rows.
| Field | Type |
|---|---|
| date | Date |
| account ID | Text |
| report name | Text |
| requested grain | Text |
| reported grain | Text |
| report status | Text |
| row count | Integer |
| is partial | True/false |
Ad insights campaign#
Campaign-enabled daily ad performance retained for breakdown parity.
| Field | Type |
|---|---|
| date | Date |
| account ID | Text |
| account name | Text |
| ad ID | Text |
| ad name | Text |
| campaign ID | Text |
| campaign name | Text |
| adset ID | Text |
| adset name | Text |
| objective | Text |
| impressions | Integer |
| spend | Number |
| clicks | Integer |
| reach | Integer |
| frequency | Number |
| purchases | Number |
| purchase value | Number |
| add to carts | Number |
| add to cart value | Number |
| landing page views | Number |
| link clicks | Number |
| leads | Number |
| lead value | Number |
| complete registrations | Number |
| initiate checkouts | Number |
| page engagements | Number |
| post engagements | Number |
| video views | Number |
| comments | Number |
| shares | Number |
| post reactions | Number |
| likes | Number |
| total conversions | Number |
| total conversion value | Number |
| actions json | Text |
| action values json | Text |
| conversions json | Text |
| conversion values json | Text |
| video plays | Number |
| video p25 watched | Number |
| video p50 watched | Number |
| video p75 watched | Number |
| video p95 watched | Number |
| video p100 watched | Number |
| video thruplays | Number |
| video 30 sec watched | Number |
| account currency | Text |
| account timezone | Text |
Custom conversions#
Facebook custom conversion definitions used to label conversion action metrics.
| Field | Type |
|---|---|
| account ID | Text |
| account name | Text |
| account currency | Text |
| account timezone | Text |
| custom conversion ID | Text |
| custom conversion name | Text |
| custom event type | Text |
| event source type | Text |
| pixel ID | Text |
| pixel name | Text |
| rule json | Text |
| creation time | Timestamp |
| last fired time | Timestamp |
Pixels#
Meta ad pixel catalog for the ad account (pixel id, code, last fired, availability).
| Field | Type |
|---|---|
| account ID | Text |
| account name | Text |
| account currency | Text |
| account timezone | Text |
| pixel ID | Text |
| pixel name | Text |
| pixel code | Text |
| creation time | Timestamp |
| last fired time | Timestamp |
| is created by business | True/false |
| is unavailable | True/false |
| owner business ID | Text |
| owner business name | Text |
Dataset quality#
Meta Conversions API dataset quality snapshot per pixel/event -- EMQ, dedup, coverage, freshness (daily snapshot, current-state only; no historical backfill from Meta).
| Field | Type |
|---|---|
| account ID | Text |
| pixel ID | Text |
| event name | Text |
| snapshot date | Date |
| permission status | Text |
| emq composite score | Number |
| acr percentage | Number |
| event coverage percentage | Number |
| event coverage goal percentage | Number |
| dedupe best key | Text |
| dedupe browser coverage percentage | Number |
| dedupe server coverage percentage | Number |
| data freshness upload frequency | Text |
| potential acr increase percentage | Number |
| match key feedback json | Text |
| diagnostics json | Text |
| dedupe key feedback json | Text |
Campaigns#
Facebook campaign entities — raw campaign settings and lifecycle metadata.
| Field | Type |
|---|---|
| campaign ID | Text |
| campaign name | Text |
| account ID | Text |
| account name | Text |
| account currency | Text |
| account timezone | Text |
| objective | Text |
| status | Text |
| effective status | Text |
| daily budget | Number |
| lifetime budget | Number |
| start time | Text |
| stop time | Text |
| created time | Text |
| updated time | Text |
| campaign objective | Text |
| campaign status | Text |
| campaign type | Text |
| end date | Text |
| start date | Text |
Ad sets#
Facebook ad-set entities incl. optimization target and bid.
| Field | Type |
|---|---|
| adset ID | Text |
| adset name | Text |
| account ID | Text |
| account name | Text |
| account currency | Text |
| account timezone | Text |
| campaign ID | Text |
| status | Text |
| effective status | Text |
| daily budget | Number |
| lifetime budget | Number |
| billing event | Text |
| optimization goal | Text |
| bid strategy | Text |
| bid amount | Number |
| promoted object json | Text |
| promoted pixel ID | Text |
| promoted custom event type | Text |
| promoted custom conversion ID | Text |
| promoted page ID | Text |
| promoted application ID | Text |
| attribution spec json | Text |
| targeting json | Text |
| start time | Text |
| end time | Text |
| created time | Text |
| updated time | Text |
Configured target coverage#
Current completeness status for Meta ad-set promoted conversion-target collection.
| Field | Type |
|---|---|
| coverage key | Text |
| account ID | Text |
| scope level | Text |
| collection status | Text |
| source entity count | Integer |
| configured target count | Integer |
| capability reason | Text |
| collected at | Timestamp |
Ads#
Facebook ad entities — raw ad status and creative linkage.
| Field | Type |
|---|---|
| ad ID | Text |
| ad name | Text |
| account ID | Text |
| account name | Text |
| account currency | Text |
| account timezone | Text |
| campaign ID | Text |
| adset ID | Text |
| status | Text |
| effective status | Text |
| creative ID | Text |
| created time | Text |
| updated time | Text |
| ad status | Text |
| destination URL | Text |
| display URL | Text |
Ad insights demographic#
Age + gender demographic breakdown.
| Field | Type |
|---|---|
| date | Date |
| account ID | Text |
| account name | Text |
| account currency | Text |
| account timezone | Text |
| ad ID | Text |
| ad name | Text |
| campaign ID | Text |
| campaign name | Text |
| adset ID | Text |
| adset name | Text |
| objective | Text |
| age | Text |
| gender | Text |
| impressions | Text |
| clicks | Text |
| spend | Text |
| reach | Integer |
| frequency | Number |
| purchases | Text |
| purchase value | Text |
| link clicks | Text |
| landing page views | Text |
| add to carts | Text |
| add to cart value | Number |
| leads | Text |
| lead value | Number |
| complete registrations | Number |
| initiate checkouts | Number |
| page engagements | Number |
| post engagements | Number |
| video views | Text |
| comments | Number |
| shares | Number |
| post reactions | Number |
| likes | Number |
| total conversions | Text |
| total conversion value | Text |
| actions json | Text |
| action values json | Text |
| conversions json | Text |
| conversion values json | Text |
Ad insights geo#
Geographic breakdown by country and region (country is ISO alpha-2 from Meta; NULL on rows loaded before the country,region breakdown).
| Field | Type |
|---|---|
| date | Date |
| account ID | Text |
| account name | Text |
| ad ID | Text |
| ad name | Text |
| campaign ID | Text |
| campaign name | Text |
| adset ID | Text |
| adset name | Text |
| objective | Text |
| region | Text |
| country | Text |
| impressions | Text |
| clicks | Text |
| spend | Text |
| reach | Integer |
| frequency | Number |
| purchases | Text |
| purchase value | Text |
| add to carts | Text |
| add to cart value | Number |
| link clicks | Text |
| landing page views | Text |
| leads | Text |
| lead value | Number |
| complete registrations | Number |
| initiate checkouts | Number |
| page engagements | Number |
| post engagements | Number |
| video views | Text |
| comments | Number |
| shares | Number |
| post reactions | Number |
| likes | Number |
| total conversions | Text |
| total conversion value | Text |
| actions json | Text |
| action values json | Text |
| conversions json | Text |
| conversion values json | Text |
| account currency | Text |
| account timezone | Text |
Ad insights dma#
Geographic breakdown by DMA.
| Field | Type |
|---|---|
| date | Date |
| account ID | Text |
| account name | Text |
| ad ID | Text |
| ad name | Text |
| campaign ID | Text |
| campaign name | Text |
| adset ID | Text |
| adset name | Text |
| objective | Text |
| impressions | Text |
| clicks | Text |
| spend | Text |
| reach | Text |
| frequency | Text |
| purchases | Text |
| purchase value | Text |
| add to carts | Number |
| add to cart value | Number |
| landing page views | Number |
| link clicks | Number |
| leads | Number |
| lead value | Number |
| complete registrations | Number |
| initiate checkouts | Number |
| page engagements | Number |
| post engagements | Number |
| video views | Number |
| comments | Number |
| shares | Number |
| post reactions | Number |
| likes | Number |
| total conversions | Number |
| total conversion value | Number |
| actions json | Text |
| action values json | Text |
| conversions json | Text |
| conversion values json | Text |
| dma | Text |
| account currency | Text |
| account timezone | Text |
Ad insights placement#
Placement breakdown — publisher + position.
| Field | Type |
|---|---|
| date | Date |
| account ID | Text |
| account name | Text |
| ad ID | Text |
| ad name | Text |
| campaign ID | Text |
| campaign name | Text |
| adset ID | Text |
| adset name | Text |
| publisher platform | Text |
| platform position | Text |
| objective | Text |
| impressions | Text |
| clicks | Text |
| spend | Text |
| reach | Text |
| frequency | Text |
| purchases | Text |
| purchase value | Text |
| link clicks | Text |
| landing page views | Text |
| add to carts | Text |
| add to cart value | Number |
| leads | Text |
| lead value | Number |
| complete registrations | Number |
| initiate checkouts | Number |
| video views | Text |
| page engagements | Text |
| post engagements | Number |
| comments | Number |
| shares | Number |
| post reactions | Number |
| likes | Number |
| total conversions | Text |
| total conversion value | Text |
| actions json | Text |
| action values json | Text |
| conversions json | Text |
| conversion values json | Text |
| account currency | Text |
| account timezone | Text |
Ad insights device#
Device platform breakdown.
| Field | Type |
|---|---|
| date | Date |
| account ID | Text |
| account name | Text |
| account currency | Text |
| account timezone | Text |
| ad ID | Text |
| ad name | Text |
| campaign ID | Text |
| campaign name | Text |
| adset ID | Text |
| adset name | Text |
| objective | Text |
| device platform | Text |
| impressions | Text |
| clicks | Text |
| spend | Text |
| reach | Integer |
| frequency | Number |
| purchases | Text |
| purchase value | Text |
| link clicks | Text |
| landing page views | Text |
| add to carts | Text |
| add to cart value | Number |
| leads | Text |
| lead value | Number |
| complete registrations | Number |
| initiate checkouts | Number |
| page engagements | Number |
| post engagements | Number |
| video views | Text |
| comments | Number |
| shares | Number |
| post reactions | Number |
| likes | Number |
| total conversions | Text |
| total conversion value | Text |
| actions json | Text |
| action values json | Text |
| conversions json | Text |
| conversion values json | Text |
Ad insights weekly#
Ad-grain weekly performance with API-deduped reach.
| Field | Type |
|---|---|
| ad ID | Text |
| ad name | Text |
| account ID | Text |
| account name | Text |
| campaign ID | Text |
| campaign name | Text |
| adset ID | Text |
| adset name | Text |
| week start date | Date |
| week end date | Date |
| impressions | Integer |
| spend | Number |
| clicks | Integer |
| reach | Integer |
| frequency | Number |
| effective status | Text |
| configured status | Text |
| delivery info | Text |
Campaign insights weekly#
Campaign-grain weekly performance with API-deduped reach.
| Field | Type |
|---|---|
| campaign ID | Text |
| campaign name | Text |
| account ID | Text |
| account name | Text |
| week start date | Date |
| week end date | Date |
| impressions | Integer |
| spend | Number |
| clicks | Integer |
| reach | Integer |
| frequency | Number |
| effective status | Text |
| configured status | Text |
| delivery info | Text |
Account insights weekly#
Account-grain weekly performance with API-deduped reach.
| Field | Type |
|---|---|
| account ID | Text |
| account name | Text |
| week start date | Date |
| week end date | Date |
| impressions | Integer |
| spend | Number |
| clicks | Integer |
| reach | Integer |
| frequency | Number |
| configured status | Text |
| delivery info | Text |
| effective status | Text |
Ad insights demographic weekly#
Ad-grain weekly performance broken down by age + gender.
| Field | Type |
|---|---|
| ad ID | Text |
| ad name | Text |
| campaign ID | Text |
| campaign name | Text |
| adset ID | Text |
| adset name | Text |
| account ID | Text |
| account name | Text |
| week start date | Date |
| week end date | Date |
| impressions | Integer |
| spend | Number |
| clicks | Integer |
| reach | Integer |
| frequency | Number |
| age | Text |
| gender | Text |
| effective status | Text |
| configured status | Text |
| delivery info | Text |
Ad insights geo weekly#
Ad-grain weekly performance broken down by region.
| Field | Type |
|---|---|
| ad ID | Text |
| ad name | Text |
| campaign ID | Text |
| campaign name | Text |
| adset ID | Text |
| adset name | Text |
| account ID | Text |
| account name | Text |
| week start date | Date |
| week end date | Date |
| impressions | Integer |
| spend | Number |
| clicks | Integer |
| reach | Integer |
| frequency | Number |
| region | Text |
| effective status | Text |
| configured status | Text |
| delivery info | Text |
Ad insights dma weekly#
Ad-grain weekly performance broken down by DMA.
| Field | Type |
|---|---|
| ad ID | Text |
| ad name | Text |
| campaign ID | Text |
| campaign name | Text |
| adset ID | Text |
| adset name | Text |
| account ID | Text |
| account name | Text |
| week start date | Date |
| week end date | Date |
| impressions | Integer |
| spend | Number |
| clicks | Integer |
| reach | Integer |
| frequency | Number |
| dma | Text |
| effective status | Text |
| configured status | Text |
| delivery info | Text |
Ad insights placement weekly#
Ad-grain weekly performance broken down by publisher platform + position.
| Field | Type |
|---|---|
| ad ID | Text |
| ad name | Text |
| campaign ID | Text |
| campaign name | Text |
| adset ID | Text |
| adset name | Text |
| account ID | Text |
| account name | Text |
| week start date | Date |
| week end date | Date |
| impressions | Integer |
| spend | Number |
| clicks | Integer |
| reach | Integer |
| frequency | Number |
| publisher platform | Text |
| platform position | Text |
| effective status | Text |
| configured status | Text |
| delivery info | Text |
Ad insights device platform weekly#
Ad-grain weekly performance broken down by device platform.
| Field | Type |
|---|---|
| ad ID | Text |
| ad name | Text |
| campaign ID | Text |
| campaign name | Text |
| adset ID | Text |
| adset name | Text |
| account ID | Text |
| account name | Text |
| week start date | Date |
| week end date | Date |
| impressions | Integer |
| spend | Number |
| clicks | Integer |
| reach | Integer |
| frequency | Number |
| device platform | Text |
| effective status | Text |
| configured status | Text |
| delivery info | Text |
Ad creatives#
Ad creative metadata — image/video URLs, copy, CTAs.
| Field | Type |
|---|---|
| ad ID | Text |
| ad name | Text |
| account ID | Text |
| account name | Text |
| campaign ID | Text |
| campaign name | Text |
| adset ID | Text |
| adset name | Text |
| creative ID | Text |
| creative name | Text |
| title | Text |
| body | Text |
| link URL | Text |
| display URL | Text |
| call to action | Text |
| thumbnail URL | Text |
| image URL | Text |
| preview asset ID | Text |
| preview storage path | Text |
| preview source URL | Text |
| preview status | Text |
| preview failure code | Text |
| preview verified at | Timestamp |
| preview content type | Text |
| preview width | Integer |
| preview height | Integer |
| video ID | Text |
| object type | Text |
| effective object story ID | Text |
| URL tags | Text |
| effective status | Text |
Ad insights asset#
Per-asset daily delivery (docs/engineering/meta-asset-baseline.md). Only dynamic (asset feed) ads return rows. Rows may sum to less than the ad total.
| Field | Type |
|---|---|
| date | Date |
| account ID | Text |
| account name | Text |
| account currency | Text |
| account timezone | Text |
| campaign ID | Text |
| campaign name | Text |
| adset ID | Text |
| adset name | Text |
| ad ID | Text |
| ad name | Text |
| asset type | Text |
| asset slot ID | Text |
| image hash | Text |
| video ID | Text |
| asset name | Text |
| asset URL | Text |
| asset thumbnail URL | Text |
| asset text | Text |
| asset value | Text |
| asset display value | Text |
| spend | Number |
| impressions | Integer |
| clicks | Integer |
| inline link clicks | Integer |
| actions json | Text |
| action values json | Text |
| conversions json | Text |
| conversion values json | Text |
| video plays | Number |
| video thruplays | Number |
Ad creative versions#
| Field | Type |
|---|---|
| account ID | Text |
| ad ID | Text |
| creative ID | Text |
| version hash | Text |
| valid from | Timestamp |
| first seen at | Timestamp |
| last seen at | Timestamp |
| object type | Text |
| asset feed spec json | Text |
| object story spec json | Text |
| URL tags | Text |
| image hashes json | Text |
| video IDs json | Text |
| media count | Integer |
Ad assets#
| Field | Type |
|---|---|
| account ID | Text |
| asset type | Text |
| asset ID | Text |
| asset name | Text |
| width | Integer |
| height | Integer |
| original width | Integer |
| original height | Integer |
| duration seconds | Number |
| created time | Timestamp |
| meta source URL | Text |
| poster source URL | Text |
| stored preview asset ID | Text |
| stored preview path | Text |
| stored preview width | Integer |
| stored preview height | Integer |
| stored at | Timestamp |