Report an issue
Back to plugin list
facebookmarketing
Official
Premium

Facebook Marketing

The Facebook Marketing source plugin for CloudQuery extracts information from the Facebook marketing API

Publisher

cloudquery

Latest version

v4.1.2

Type

Source

Platforms
Date Published

Feb 27, 2024

Price per 1M rows

$100

free quota

1M rows

  • facebookmarketing_adaccounts
  • facebookmarketing_adaccount_users
  • facebookmarketing_adcloudplayables
  • facebookmarketing_adcreatives
  • facebookmarketing_adimages
  • facebookmarketing_adlabels
  • facebookmarketing_ad_place_page_sets
  • facebookmarketing_adplayables
  • facebookmarketing_adrules
  • facebookmarketing_ads
  • facebookmarketing_adsets
  • facebookmarketing_adspixels
  • facebookmarketing_ad_studies
  • facebookmarketing_advideos
  • facebookmarketing_applications
  • facebookmarketing_broad_targeting_categories
  • facebookmarketing_businesses
  • facebookmarketing_campaigns
  • facebookmarketing_connected_instagram_accounts
  • facebookmarketing_customaudiences
  • facebookmarketing_customconversions
  • facebookmarketing_max_bids
  • facebookmarketing_offline_conversion_data_sets
  • facebookmarketing_promote_pages
  • facebookmarketing_publisher_block_lists
  • facebookmarketing_reach_frequency_predictions
  • facebookmarketing_saved_audiences

Facebook Marketing Ad Accounts

The facebookmarketing_adaccounts table shows data for Facebook Marketing Ad Accounts.

https://developers.facebook.com/docs/marketing-api/reference/ad-account#Reading

The primary key for this table is id.

Columns
NameType
account_idutf8
account_statusint64
agefloat64
agency_client_declarationjson
amount_spentutf8
attribution_specjson
balanceutf8
businessjson
business_cityutf8
business_country_codeutf8
business_nameutf8
business_stateutf8
business_streetutf8
business_street2utf8
business_ziputf8
can_create_brand_lift_studybool
capabilitieslist<item: utf8, nullable>
_cq_iduuid
_cq_parent_iduuid
created_timetimestamp[us, tz=UTC]
currencyutf8
disable_reasonint64
end_advertiserutf8
end_advertiser_nameutf8
extended_credit_invoice_groupjson
failed_delivery_checksjson
fb_entityint64
funding_sourceutf8
funding_source_detailsjson
has_advertiser_opted_in_odaxbool
has_migrated_permissionsbool
idutf8
io_numberutf8
is_attribution_spec_system_defaultbool
is_direct_deals_enabledbool
is_in_3ds_authorization_enabled_marketbool
is_notifications_enabledbool
is_personalint64
is_prepay_accountbool
is_tax_id_requiredbool
line_numberslist<item: int64, nullable>
media_agencyutf8
min_campaign_group_spend_caputf8
min_daily_budgetint64
nameutf8
offsite_pixels_tos_acceptedbool
ownerutf8
partnerutf8
rf_specjson
spend_caputf8
tax_idutf8
tax_id_statusint64
tax_id_typeutf8
timezone_idint64
timezone_nameutf8
timezone_offset_hours_utcfloat64
tos_acceptedjson
user_taskslist<item: utf8, nullable>
user_tos_acceptedjson
Subscribe to product updates

Be the first to know about new features.