Table: facebookmarketing_adcreatives

This table shows data for Facebook Marketing Ad Creatives.

https://developers.facebook.com/docs/marketing-api/reference/ad-creative#Reading (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
actor_idString
adlabelsJSON
applink_treatmentString
asset_feed_specJSON
authorization_categoryString
auto_updateBool
bodyString
branded_content_sponsor_page_idString
bundle_folder_idString
call_to_action_typeString
categorization_criteriaString
category_media_sourceString
collaborative_ads_lsb_image_bank_idString
degrees_of_freedom_specJSON
destination_set_idString
dynamic_ad_voiceString
effective_authorization_categoryString
effective_instagram_media_idString
effective_instagram_story_idString
effective_object_story_idString
enable_direct_installBool
enable_launch_instant_appBool
id (PK)String
image_cropsJSON
image_hashString
image_urlString
instagram_actor_idString
instagram_permalink_urlString
instagram_story_idString
instagram_user_idString
interactive_components_specJSON
link_deep_link_urlString
link_destination_display_urlString
link_og_idString
link_urlString
messenger_sponsored_messageString
nameString
object_idString
object_store_urlString
object_story_idString
object_story_specJSON
object_typeString
object_urlString
omnichannel_link_specJSON
place_page_set_idString
platform_customizationsJSON
playable_asset_idString
portrait_customizationsJSON
product_set_idString
recommender_settingsJSON
source_instagram_media_idString
statusString
template_urlString
template_url_specJSON
thumbnail_idString
thumbnail_urlString
titleString
url_tagsString
use_page_actor_overrideBool
video_idString