Back to plugin list
Official
Premium
Facebook Marketing
This plugin is in preview.
The Facebook Marketing source plugin for CloudQuery extracts information from the Facebook marketing API
Publisher
cloudquery
Latest version
v4.0.0
Type
Source
Date Published
Nov 10, 2023
Category
Sales & Marketing
Price
Free while in preview
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 |
