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.6.3

Type

Source

Platforms
Date Published

Price per 1M rows

Starting from $15

monthly 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 Businesses

The facebookmarketing_businesses table shows data for Facebook Marketing Businesses.

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

The primary key for this table is id.

Columns
NameType
block_offline_analyticsbool
collaborative_ads_managed_partner_eligibilityjson
collaborative_ads_partner_premium_optionsjson
_cq_iduuid
_cq_parent_iduuid
created_timetimestamp[us, tz=UTC]
extended_updated_timetimestamp[us, tz=UTC]
idutf8
is_hiddenbool
linkutf8
nameutf8
payment_account_idutf8
primary_pagejson
profile_picture_uriutf8
timezone_idint64
two_factor_typeutf8
updated_timetimestamp[us, tz=UTC]
verification_statusutf8
verticalutf8
vertical_idint64