Table: facebookmarketing_adcreatives
This table shows data for Facebook Marketing Ad Creatives.
The primary key for this table is id.
Columns
| Name | Type |
|---|---|
| _cq_source_name | String |
| _cq_sync_time | Timestamp |
| _cq_id | UUID |
| _cq_parent_id | UUID |
| account_id | String |
| actor_id | String |
| adlabels | JSON |
| applink_treatment | String |
| asset_feed_spec | JSON |
| authorization_category | String |
| auto_update | Bool |
| body | String |
| branded_content_sponsor_page_id | String |
| bundle_folder_id | String |
| call_to_action_type | String |
| categorization_criteria | String |
| category_media_source | String |
| collaborative_ads_lsb_image_bank_id | String |
| degrees_of_freedom_spec | JSON |
| destination_set_id | String |
| dynamic_ad_voice | String |
| effective_authorization_category | String |
| effective_instagram_media_id | String |
| effective_instagram_story_id | String |
| effective_object_story_id | String |
| enable_direct_install | Bool |
| enable_launch_instant_app | Bool |
| id (PK) | String |
| image_crops | JSON |
| image_hash | String |
| image_url | String |
| instagram_actor_id | String |
| instagram_permalink_url | String |
| instagram_story_id | String |
| instagram_user_id | String |
| interactive_components_spec | JSON |
| link_deep_link_url | String |
| link_destination_display_url | String |
| link_og_id | String |
| link_url | String |
| messenger_sponsored_message | String |
| name | String |
| object_id | String |
| object_store_url | String |
| object_story_id | String |
| object_story_spec | JSON |
| object_type | String |
| object_url | String |
| omnichannel_link_spec | JSON |
| place_page_set_id | String |
| platform_customizations | JSON |
| playable_asset_id | String |
| portrait_customizations | JSON |
| product_set_id | String |
| recommender_settings | JSON |
| source_instagram_media_id | String |
| status | String |
| template_url | String |
| template_url_spec | JSON |
| thumbnail_id | String |
| thumbnail_url | String |
| title | String |
| url_tags | String |
| use_page_actor_override | Bool |
| video_id | String |
