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

Type

Source

Platforms
Date Published

Feb 20, 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 Ads

The facebookmarketing_ads table shows data for Facebook Marketing Ads.

https://developers.facebook.com/docs/marketing-api/reference/adgroup

The primary key for this table is id.

Columns
NameType
account_idutf8
adlabelsjson
ad_review_feedbackjson
adsetjson
adset_idutf8
bid_amountint64
bid_infojson
bid_typeutf8
campaignjson
campaign_idutf8
configured_statusutf8
conversion_domainutf8
conversion_specsjson
_cq_iduuid
_cq_parent_iduuid
created_timetimestamp[us, tz=UTC]
creativejson
demolink_hashutf8
display_sequenceint64
effective_statusutf8
engagement_audiencebool
failed_delivery_checksjson
idutf8
issues_infojson
last_updated_by_app_idutf8
nameutf8
preview_shareable_linkutf8
priorityint64
recommendationsjson
source_ad_idutf8
statusutf8
targetingjson
tracking_and_conversion_with_defaultsjson
tracking_specsjson
updated_timetimestamp[us, tz=UTC]
Subscribe to product updates

Be the first to know about new features.