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_iduuid
_cq_parent_iduuid
account_idutf8
ad_review_feedbackjson
adlabelsjson
adsetjson
adset_idutf8
bid_amountint64
bid_infojson
bid_typeutf8
campaignjson
campaign_idutf8
configured_statusutf8
conversion_domainutf8
conversion_specsjson
created_timetimestamp[us, tz=UTC]
creativejson
demolink_hashutf8
display_sequenceint64
effective_statusutf8
engagement_audiencebool
failed_delivery_checksjson
id (PK)utf8
issues_infojson
last_updated_by_app_idutf8
nameutf8
preview_shareable_linkutf8
priorityint64
recommendationsjson
source_ad_idutf8
statusutf8
targetingjson
tracking_and_conversion_with_defaultsjson
tracking_specsjson
updated_timetimestamp[us, tz=UTC]