Table: facebookmarketing_campaigns
This table shows data for Facebook Marketing Campaigns.
https://developers.facebook.com/docs/marketing-api/reference/ad-campaign-group/ (opens in a new tab)
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 |
| ad_strategy_group_id | String |
| ad_strategy_id | String |
| adlabels | JSON |
| bid_strategy | String |
| boosted_object_id | String |
| brand_lift_studies | JSON |
| budget_rebalance_flag | Bool |
| budget_remaining | String |
| buying_type | String |
| can_create_brand_lift_study | Bool |
| can_use_spend_cap | Bool |
| configured_status | String |
| created_time | Timestamp |
| daily_budget | String |
| effective_status | String |
| has_secondary_skadnetwork_reporting | Bool |
| id (PK) | String |
| is_skadnetwork_attribution | Bool |
| issues_info | JSON |
| last_budget_toggling_time | Timestamp |
| lifetime_budget | String |
| name | String |
| objective | String |
| pacing_type | StringArray |
| primary_attribution | String |
| promoted_object | JSON |
| recommendations | JSON |
| smart_promotion_type | String |
| source_campaign_id | String |
| special_ad_categories | StringArray |
| special_ad_category | String |
| special_ad_category_country | StringArray |
| spend_cap | String |
| start_time | Timestamp |
| status | String |
| stop_time | Timestamp |
| topline_id | String |
| updated_time | Timestamp |
