Back to plugin list
Official
Premium
Facebook Marketing
The Facebook Marketing source plugin for CloudQuery extracts information from the Facebook marketing API
Publisher
cloudquery
Latest version
v4.1.11
Type
Source
Platforms
Date Published
Price per 1M rows
Starting from $15
monthly free quota
1M rows
Facebook Marketing Ad Creatives
The facebookmarketing_adcreatives table shows data for Facebook Marketing Ad Creatives.
https://developers.facebook.com/docs/marketing-api/reference/ad-creative#Reading
The primary key for this table is id.
Columns
Name | Type |
---|---|
account_id | utf8 |
actor_id | utf8 |
adlabels | json |
applink_treatment | utf8 |
asset_feed_spec | json |
authorization_category | utf8 |
auto_update | bool |
body | utf8 |
branded_content_sponsor_page_id | utf8 |
bundle_folder_id | utf8 |
call_to_action_type | utf8 |
categorization_criteria | utf8 |
category_media_source | utf8 |
collaborative_ads_lsb_image_bank_id | utf8 |
_cq_id | uuid |
_cq_parent_id | uuid |
degrees_of_freedom_spec | json |
destination_set_id | utf8 |
dynamic_ad_voice | utf8 |
effective_authorization_category | utf8 |
effective_instagram_media_id | utf8 |
effective_instagram_story_id | utf8 |
effective_object_story_id | utf8 |
enable_direct_install | bool |
enable_launch_instant_app | bool |
id | utf8 |
image_crops | json |
image_hash | utf8 |
image_url | utf8 |
instagram_actor_id | utf8 |
instagram_permalink_url | utf8 |
instagram_story_id | utf8 |
instagram_user_id | utf8 |
interactive_components_spec | json |
link_deep_link_url | utf8 |
link_destination_display_url | utf8 |
link_og_id | utf8 |
link_url | utf8 |
messenger_sponsored_message | utf8 |
name | utf8 |
object_id | utf8 |
object_store_url | utf8 |
object_story_id | utf8 |
object_story_spec | json |
object_type | utf8 |
object_url | utf8 |
omnichannel_link_spec | json |
place_page_set_id | utf8 |
platform_customizations | json |
playable_asset_id | utf8 |
portrait_customizations | json |
product_set_id | utf8 |
recommender_settings | json |
source_instagram_media_id | utf8 |
status | utf8 |
template_url | utf8 |
template_url_spec | json |
thumbnail_id | utf8 |
thumbnail_url | utf8 |
title | utf8 |
url_tags | utf8 |
use_page_actor_override | bool |
video_id | utf8 |