Table: facebookmarketing_ads

This table shows data for Facebook Marketing Ads.

https://developers.facebook.com/docs/marketing-api/reference/adgroup (opens in a new tab)

The primary key for this table is id.

Columns

NameType
_cq_source_nameString
_cq_sync_timeTimestamp
_cq_idUUID
_cq_parent_idUUID
account_idString
ad_review_feedbackJSON
adlabelsJSON
adsetJSON
adset_idString
bid_amountInt
bid_infoJSON
bid_typeString
campaignJSON
campaign_idString
configured_statusString
conversion_domainString
conversion_specsJSON
created_timeTimestamp
creativeJSON
demolink_hashString
display_sequenceInt
effective_statusString
engagement_audienceBool
failed_delivery_checksJSON
id (PK)String
issues_infoJSON
last_updated_by_app_idString
nameString
preview_shareable_linkString
priorityInt
recommendationsJSON
source_ad_idString
statusString
targetingJSON
tracking_and_conversion_with_defaultsJSON
tracking_specsJSON
updated_timeTimestamp