Back to plugin list
Official
Premium
Facebook Marketing
The Facebook Marketing source plugin for CloudQuery extracts information from the Facebook marketing API
Latest version
v4.0.0
Type
Source
Published
Nov 10, 2023
Category
sales-marketing
Facebook Marketing Ad Sets
The facebookmarketing_adsets table shows data for Facebook Marketing Ad Sets.
The primary key for this table is id.
Columns
| Name | Type |
|---|---|
| account_id | utf8 |
| adlabels | json |
| adset_schedule | json |
| asset_feed_id | utf8 |
| attribution_spec | json |
| bid_adjustments | json |
| bid_amount | int64 |
| bid_constraints | json |
| bid_info | json |
| bid_strategy | utf8 |
| billing_event | utf8 |
| budget_remaining | utf8 |
| campaign | json |
| campaign_attribution | utf8 |
| campaign_id | utf8 |
| configured_status | utf8 |
| _cq_id | uuid |
| _cq_parent_id | uuid |
| created_time | timestamp[us, tz=UTC] |
| creative_sequence | list<item: utf8, nullable> |
| daily_budget | utf8 |
| daily_min_spend_target | utf8 |
| daily_spend_cap | utf8 |
| destination_type | utf8 |
| effective_status | utf8 |
| end_time | timestamp[us, tz=UTC] |
| frequency_control_specs | json |
| id | utf8 |
| is_dynamic_creative | bool |
| issues_info | json |
| learning_stage_info | json |
| lifetime_budget | utf8 |
| lifetime_imps | int64 |
| lifetime_min_spend_target | utf8 |
| lifetime_spend_cap | utf8 |
| multi_optimization_goal_weight | utf8 |
| name | utf8 |
| optimization_sub_event | utf8 |
| pacing_type | list<item: utf8, nullable> |
| promoted_object | json |
| recommendations | json |
| recurring_budget_semantics | bool |
| review_feedback | utf8 |
| rf_prediction_id | utf8 |
| source_adset_id | utf8 |
| start_time | timestamp[us, tz=UTC] |
| status | utf8 |
| targeting | json |
| time_based_ad_rotation_id_blocks | json |
| time_based_ad_rotation_intervals | list<item: int64, nullable> |
| updated_time | timestamp[us, tz=UTC] |
| use_new_app_click | bool |
