Table: facebookmarketing_adcreatives
This table shows data for Facebook Marketing Ad Creatives.
The primary key for this table is id.
Columns
| Name | Type |
|---|---|
| _cq_id | uuid |
| _cq_parent_id | uuid |
| 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 |
| 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 (PK) | 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 |
