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.

FieldType
account IDText
account nameText
account currencyText
account timezoneText
metadata provenanceText

Ad insights#

Base ad performance.

FieldType
dateDate
ad IDText
ad nameText
campaign IDText
campaign nameText
adset IDText
adset nameText
account IDText
account nameText
account currencyText
account timezoneText
objectiveText
impressionsInteger
spendNumber
clicksInteger
CPCNumber
CPMNumber
CTRNumber
reachInteger
frequencyNumber
purchasesNumber
purchase valueNumber
add to cartsNumber
add to cart valueNumber
landing page viewsNumber
link clicksNumber
leadsNumber
lead valueNumber
complete registrationsNumber
initiate checkoutsNumber
page engagementsNumber
post engagementsNumber
video viewsNumber
commentsNumber
sharesNumber
post reactionsNumber
likesNumber
total conversionsNumber
total conversion valueNumber
actionsText
action valuesText
conversionsText
conversion valuesText
actions jsonText
action values jsonText
conversions jsonText
conversion values jsonText
video playsNumber
video p25 watchedNumber
video p50 watchedNumber
video p75 watchedNumber
video p95 watchedNumber
video p100 watchedNumber
video thruplaysNumber
video 30 sec watchedNumber

Conversion report coverage daily#

Successful native Meta conversion-report coverage, including account-days with zero returned rows.

FieldType
dateDate
account IDText
report nameText
requested grainText
reported grainText
report statusText
row countInteger
is partialTrue/false

Ad insights campaign#

Campaign-enabled daily ad performance retained for breakdown parity.

FieldType
dateDate
account IDText
account nameText
ad IDText
ad nameText
campaign IDText
campaign nameText
adset IDText
adset nameText
objectiveText
impressionsInteger
spendNumber
clicksInteger
reachInteger
frequencyNumber
purchasesNumber
purchase valueNumber
add to cartsNumber
add to cart valueNumber
landing page viewsNumber
link clicksNumber
leadsNumber
lead valueNumber
complete registrationsNumber
initiate checkoutsNumber
page engagementsNumber
post engagementsNumber
video viewsNumber
commentsNumber
sharesNumber
post reactionsNumber
likesNumber
total conversionsNumber
total conversion valueNumber
actions jsonText
action values jsonText
conversions jsonText
conversion values jsonText
video playsNumber
video p25 watchedNumber
video p50 watchedNumber
video p75 watchedNumber
video p95 watchedNumber
video p100 watchedNumber
video thruplaysNumber
video 30 sec watchedNumber
account currencyText
account timezoneText

Custom conversions#

Facebook custom conversion definitions used to label conversion action metrics.

FieldType
account IDText
account nameText
account currencyText
account timezoneText
custom conversion IDText
custom conversion nameText
custom event typeText
event source typeText
pixel IDText
pixel nameText
rule jsonText
creation timeTimestamp
last fired timeTimestamp

Pixels#

Meta ad pixel catalog for the ad account (pixel id, code, last fired, availability).

FieldType
account IDText
account nameText
account currencyText
account timezoneText
pixel IDText
pixel nameText
pixel codeText
creation timeTimestamp
last fired timeTimestamp
is created by businessTrue/false
is unavailableTrue/false
owner business IDText
owner business nameText

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).

FieldType
account IDText
pixel IDText
event nameText
snapshot dateDate
permission statusText
emq composite scoreNumber
acr percentageNumber
event coverage percentageNumber
event coverage goal percentageNumber
dedupe best keyText
dedupe browser coverage percentageNumber
dedupe server coverage percentageNumber
data freshness upload frequencyText
potential acr increase percentageNumber
match key feedback jsonText
diagnostics jsonText
dedupe key feedback jsonText

Campaigns#

Facebook campaign entities — raw campaign settings and lifecycle metadata.

FieldType
campaign IDText
campaign nameText
account IDText
account nameText
account currencyText
account timezoneText
objectiveText
statusText
effective statusText
daily budgetNumber
lifetime budgetNumber
start timeText
stop timeText
created timeText
updated timeText
campaign objectiveText
campaign statusText
campaign typeText
end dateText
start dateText

Ad sets#

Facebook ad-set entities incl. optimization target and bid.

FieldType
adset IDText
adset nameText
account IDText
account nameText
account currencyText
account timezoneText
campaign IDText
statusText
effective statusText
daily budgetNumber
lifetime budgetNumber
billing eventText
optimization goalText
bid strategyText
bid amountNumber
promoted object jsonText
promoted pixel IDText
promoted custom event typeText
promoted custom conversion IDText
promoted page IDText
promoted application IDText
attribution spec jsonText
targeting jsonText
start timeText
end timeText
created timeText
updated timeText

Configured target coverage#

Current completeness status for Meta ad-set promoted conversion-target collection.

FieldType
coverage keyText
account IDText
scope levelText
collection statusText
source entity countInteger
configured target countInteger
capability reasonText
collected atTimestamp

Ads#

Facebook ad entities — raw ad status and creative linkage.

FieldType
ad IDText
ad nameText
account IDText
account nameText
account currencyText
account timezoneText
campaign IDText
adset IDText
statusText
effective statusText
creative IDText
created timeText
updated timeText
ad statusText
destination URLText
display URLText

Ad insights demographic#

Age + gender demographic breakdown.

FieldType
dateDate
account IDText
account nameText
account currencyText
account timezoneText
ad IDText
ad nameText
campaign IDText
campaign nameText
adset IDText
adset nameText
objectiveText
ageText
genderText
impressionsText
clicksText
spendText
reachInteger
frequencyNumber
purchasesText
purchase valueText
link clicksText
landing page viewsText
add to cartsText
add to cart valueNumber
leadsText
lead valueNumber
complete registrationsNumber
initiate checkoutsNumber
page engagementsNumber
post engagementsNumber
video viewsText
commentsNumber
sharesNumber
post reactionsNumber
likesNumber
total conversionsText
total conversion valueText
actions jsonText
action values jsonText
conversions jsonText
conversion values jsonText

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).

FieldType
dateDate
account IDText
account nameText
ad IDText
ad nameText
campaign IDText
campaign nameText
adset IDText
adset nameText
objectiveText
regionText
countryText
impressionsText
clicksText
spendText
reachInteger
frequencyNumber
purchasesText
purchase valueText
add to cartsText
add to cart valueNumber
link clicksText
landing page viewsText
leadsText
lead valueNumber
complete registrationsNumber
initiate checkoutsNumber
page engagementsNumber
post engagementsNumber
video viewsText
commentsNumber
sharesNumber
post reactionsNumber
likesNumber
total conversionsText
total conversion valueText
actions jsonText
action values jsonText
conversions jsonText
conversion values jsonText
account currencyText
account timezoneText

Ad insights dma#

Geographic breakdown by DMA.

FieldType
dateDate
account IDText
account nameText
ad IDText
ad nameText
campaign IDText
campaign nameText
adset IDText
adset nameText
objectiveText
impressionsText
clicksText
spendText
reachText
frequencyText
purchasesText
purchase valueText
add to cartsNumber
add to cart valueNumber
landing page viewsNumber
link clicksNumber
leadsNumber
lead valueNumber
complete registrationsNumber
initiate checkoutsNumber
page engagementsNumber
post engagementsNumber
video viewsNumber
commentsNumber
sharesNumber
post reactionsNumber
likesNumber
total conversionsNumber
total conversion valueNumber
actions jsonText
action values jsonText
conversions jsonText
conversion values jsonText
dmaText
account currencyText
account timezoneText

Ad insights placement#

Placement breakdown — publisher + position.

FieldType
dateDate
account IDText
account nameText
ad IDText
ad nameText
campaign IDText
campaign nameText
adset IDText
adset nameText
publisher platformText
platform positionText
objectiveText
impressionsText
clicksText
spendText
reachText
frequencyText
purchasesText
purchase valueText
link clicksText
landing page viewsText
add to cartsText
add to cart valueNumber
leadsText
lead valueNumber
complete registrationsNumber
initiate checkoutsNumber
video viewsText
page engagementsText
post engagementsNumber
commentsNumber
sharesNumber
post reactionsNumber
likesNumber
total conversionsText
total conversion valueText
actions jsonText
action values jsonText
conversions jsonText
conversion values jsonText
account currencyText
account timezoneText

Ad insights device#

Device platform breakdown.

FieldType
dateDate
account IDText
account nameText
account currencyText
account timezoneText
ad IDText
ad nameText
campaign IDText
campaign nameText
adset IDText
adset nameText
objectiveText
device platformText
impressionsText
clicksText
spendText
reachInteger
frequencyNumber
purchasesText
purchase valueText
link clicksText
landing page viewsText
add to cartsText
add to cart valueNumber
leadsText
lead valueNumber
complete registrationsNumber
initiate checkoutsNumber
page engagementsNumber
post engagementsNumber
video viewsText
commentsNumber
sharesNumber
post reactionsNumber
likesNumber
total conversionsText
total conversion valueText
actions jsonText
action values jsonText
conversions jsonText
conversion values jsonText

Ad insights weekly#

Ad-grain weekly performance with API-deduped reach.

FieldType
ad IDText
ad nameText
account IDText
account nameText
campaign IDText
campaign nameText
adset IDText
adset nameText
week start dateDate
week end dateDate
impressionsInteger
spendNumber
clicksInteger
reachInteger
frequencyNumber
effective statusText
configured statusText
delivery infoText

Campaign insights weekly#

Campaign-grain weekly performance with API-deduped reach.

FieldType
campaign IDText
campaign nameText
account IDText
account nameText
week start dateDate
week end dateDate
impressionsInteger
spendNumber
clicksInteger
reachInteger
frequencyNumber
effective statusText
configured statusText
delivery infoText

Account insights weekly#

Account-grain weekly performance with API-deduped reach.

FieldType
account IDText
account nameText
week start dateDate
week end dateDate
impressionsInteger
spendNumber
clicksInteger
reachInteger
frequencyNumber
configured statusText
delivery infoText
effective statusText

Ad insights demographic weekly#

Ad-grain weekly performance broken down by age + gender.

FieldType
ad IDText
ad nameText
campaign IDText
campaign nameText
adset IDText
adset nameText
account IDText
account nameText
week start dateDate
week end dateDate
impressionsInteger
spendNumber
clicksInteger
reachInteger
frequencyNumber
ageText
genderText
effective statusText
configured statusText
delivery infoText

Ad insights geo weekly#

Ad-grain weekly performance broken down by region.

FieldType
ad IDText
ad nameText
campaign IDText
campaign nameText
adset IDText
adset nameText
account IDText
account nameText
week start dateDate
week end dateDate
impressionsInteger
spendNumber
clicksInteger
reachInteger
frequencyNumber
regionText
effective statusText
configured statusText
delivery infoText

Ad insights dma weekly#

Ad-grain weekly performance broken down by DMA.

FieldType
ad IDText
ad nameText
campaign IDText
campaign nameText
adset IDText
adset nameText
account IDText
account nameText
week start dateDate
week end dateDate
impressionsInteger
spendNumber
clicksInteger
reachInteger
frequencyNumber
dmaText
effective statusText
configured statusText
delivery infoText

Ad insights placement weekly#

Ad-grain weekly performance broken down by publisher platform + position.

FieldType
ad IDText
ad nameText
campaign IDText
campaign nameText
adset IDText
adset nameText
account IDText
account nameText
week start dateDate
week end dateDate
impressionsInteger
spendNumber
clicksInteger
reachInteger
frequencyNumber
publisher platformText
platform positionText
effective statusText
configured statusText
delivery infoText

Ad insights device platform weekly#

Ad-grain weekly performance broken down by device platform.

FieldType
ad IDText
ad nameText
campaign IDText
campaign nameText
adset IDText
adset nameText
account IDText
account nameText
week start dateDate
week end dateDate
impressionsInteger
spendNumber
clicksInteger
reachInteger
frequencyNumber
device platformText
effective statusText
configured statusText
delivery infoText

Ad creatives#

Ad creative metadata — image/video URLs, copy, CTAs.

FieldType
ad IDText
ad nameText
account IDText
account nameText
campaign IDText
campaign nameText
adset IDText
adset nameText
creative IDText
creative nameText
titleText
bodyText
link URLText
display URLText
call to actionText
thumbnail URLText
image URLText
preview asset IDText
preview storage pathText
preview source URLText
preview statusText
preview failure codeText
preview verified atTimestamp
preview content typeText
preview widthInteger
preview heightInteger
video IDText
object typeText
effective object story IDText
URL tagsText
effective statusText

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.

FieldType
dateDate
account IDText
account nameText
account currencyText
account timezoneText
campaign IDText
campaign nameText
adset IDText
adset nameText
ad IDText
ad nameText
asset typeText
asset slot IDText
image hashText
video IDText
asset nameText
asset URLText
asset thumbnail URLText
asset textText
asset valueText
asset display valueText
spendNumber
impressionsInteger
clicksInteger
inline link clicksInteger
actions jsonText
action values jsonText
conversions jsonText
conversion values jsonText
video playsNumber
video thruplaysNumber

Ad creative versions#

FieldType
account IDText
ad IDText
creative IDText
version hashText
valid fromTimestamp
first seen atTimestamp
last seen atTimestamp
object typeText
asset feed spec jsonText
object story spec jsonText
URL tagsText
image hashes jsonText
video IDs jsonText
media countInteger

Ad assets#

FieldType
account IDText
asset typeText
asset IDText
asset nameText
widthInteger
heightInteger
original widthInteger
original heightInteger
duration secondsNumber
created timeTimestamp
meta source URLText
poster source URLText
stored preview asset IDText
stored preview pathText
stored preview widthInteger
stored preview heightInteger
stored atTimestamp