Table: facebookmarketing_adaccounts
This table shows data for Facebook Marketing Ad Accounts.
https://developers.facebook.com/docs/marketing-api/reference/ad-account#Reading (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 |
| account_status | Int |
| age | Float |
| agency_client_declaration | JSON |
| amount_spent | String |
| attribution_spec | JSON |
| balance | String |
| business | JSON |
| business_city | String |
| business_country_code | String |
| business_name | String |
| business_state | String |
| business_street | String |
| business_street2 | String |
| business_zip | String |
| can_create_brand_lift_study | Bool |
| capabilities | StringArray |
| created_time | Timestamp |
| currency | String |
| disable_reason | Int |
| end_advertiser | String |
| end_advertiser_name | String |
| extended_credit_invoice_group | JSON |
| failed_delivery_checks | JSON |
| fb_entity | Int |
| funding_source | String |
| funding_source_details | JSON |
| has_advertiser_opted_in_odax | Bool |
| has_migrated_permissions | Bool |
| id (PK) | String |
| io_number | String |
| is_attribution_spec_system_default | Bool |
| is_direct_deals_enabled | Bool |
| is_in_3ds_authorization_enabled_market | Bool |
| is_notifications_enabled | Bool |
| is_personal | Int |
| is_prepay_account | Bool |
| is_tax_id_required | Bool |
| line_numbers | IntArray |
| media_agency | String |
| min_campaign_group_spend_cap | String |
| min_daily_budget | Int |
| name | String |
| offsite_pixels_tos_accepted | Bool |
| owner | String |
| partner | String |
| rf_spec | JSON |
| spend_cap | String |
| tax_id | String |
| tax_id_status | Int |
| tax_id_type | String |
| timezone_id | Int |
| timezone_name | String |
| timezone_offset_hours_utc | Float |
| tos_accepted | JSON |
| user_tasks | StringArray |
| user_tos_accepted | JSON |
