Back to source list
Official
Premium
Facebook Marketing
The Facebook Marketing source plugin for CloudQuery extracts information from the Facebook marketing API
Publisher
cloudquery
Latest version
v4.9.0
Type
Source
Platforms
Date Published
Price per 1M rows
Starting from $17
monthly free quota
1M rows
Facebook Marketing Campaigns
The facebookmarketing_campaigns table shows data for Facebook Marketing Campaigns.
Primary Keys #
| Name | Type |
|---|---|
| id | utf8 |
Columns #
| Name | Type |
|---|---|
| account_id | utf8 |
| adlabels | json |
| ad_strategy_group_id | utf8 |
| ad_strategy_id | utf8 |
| bid_strategy | utf8 |
| boosted_object_id | utf8 |
| brand_lift_studies | json |
| budget_rebalance_flag | bool |
| budget_remaining | utf8 |
| buying_type | utf8 |
| can_create_brand_lift_study | bool |
| can_use_spend_cap | bool |
| configured_status | utf8 |
| _cq_id | uuid |
| _cq_parent_id | uuid |
| created_time | timestamp[us, tz=UTC] |
| daily_budget | utf8 |
| effective_status | utf8 |
| has_secondary_skadnetwork_reporting | bool |
| id | utf8 |
| is_skadnetwork_attribution | bool |
| issues_info | json |
| last_budget_toggling_time | timestamp[us, tz=UTC] |
| lifetime_budget | utf8 |
| name | utf8 |
| objective | utf8 |
| pacing_type | list<item: utf8, nullable> |
| primary_attribution | utf8 |
| promoted_object | json |
| recommendations | json |
| smart_promotion_type | utf8 |
| source_campaign_id | utf8 |
| special_ad_categories | list<item: utf8, nullable> |
| special_ad_category | utf8 |
| special_ad_category_country | list<item: utf8, nullable> |
| spend_cap | utf8 |
| start_time | timestamp[us, tz=UTC] |
| status | utf8 |
| stop_time | timestamp[us, tz=UTC] |
| topline_id | utf8 |
| updated_time | timestamp[us, tz=UTC] |