Table: facebookmarketing_ads
This table shows data for Facebook Marketing Ads.
https://developers.facebook.com/docs/marketing-api/reference/adgroup (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_review_feedback | JSON |
| adlabels | JSON |
| adset | JSON |
| adset_id | String |
| bid_amount | Int |
| bid_info | JSON |
| bid_type | String |
| campaign | JSON |
| campaign_id | String |
| configured_status | String |
| conversion_domain | String |
| conversion_specs | JSON |
| created_time | Timestamp |
| creative | JSON |
| demolink_hash | String |
| display_sequence | Int |
| effective_status | String |
| engagement_audience | Bool |
| failed_delivery_checks | JSON |
| id (PK) | String |
| issues_info | JSON |
| last_updated_by_app_id | String |
| name | String |
| preview_shareable_link | String |
| priority | Int |
| recommendations | JSON |
| source_ad_id | String |
| status | String |
| targeting | JSON |
| tracking_and_conversion_with_defaults | JSON |
| tracking_specs | JSON |
| updated_time | Timestamp |
