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

NameType
_cq_source_nameString
_cq_sync_timeTimestamp
_cq_idUUID
_cq_parent_idUUID
account_idString
ad_strategy_group_idString
ad_strategy_idString
adlabelsJSON
bid_strategyString
boosted_object_idString
brand_lift_studiesJSON
budget_rebalance_flagBool
budget_remainingString
buying_typeString
can_create_brand_lift_studyBool
can_use_spend_capBool
configured_statusString
created_timeTimestamp
daily_budgetString
effective_statusString
has_secondary_skadnetwork_reportingBool
id (PK)String
is_skadnetwork_attributionBool
issues_infoJSON
last_budget_toggling_timeTimestamp
lifetime_budgetString
nameString
objectiveString
pacing_typeStringArray
primary_attributionString
promoted_objectJSON
recommendationsJSON
smart_promotion_typeString
source_campaign_idString
special_ad_categoriesStringArray
special_ad_categoryString
special_ad_category_countryStringArray
spend_capString
start_timeTimestamp
statusString
stop_timeTimestamp
topline_idString
updated_timeTimestamp