Facebook Ads → Google BigQuery: data schema
Field Type Description date DATE All metrics are grouped by date, which is shown by this column. campaign_id INTEGER ID of the ad campaign that contains this ad ad_id INTEGER The ID of this a...
... object this ad set is promoting across all its ads. https://developers.facebook. com/docs/marketing-api/reference/ad-promoted-object/. adset.promoted_object.