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 Videos

The facebookmarketing_advideos table shows data for Facebook Marketing Ad Videos.

https://developers.facebook.com/docs/graph-api/reference/video#Reading

The composite primary key for this table is account_id, id.

Columns
NameType
account_idutf8
ad_breakslist<item: int64, nullable>
backdated_timetimestamp[us, tz=UTC]
backdated_time_granularityutf8
content_categoryutf8
content_tagslist<item: utf8, nullable>
_cq_iduuid
_cq_parent_iduuid
created_timetimestamp[us, tz=UTC]
custom_labelslist<item: utf8, nullable>
descriptionutf8
embeddablebool
embed_htmlutf8
eventjson
iconutf8
idutf8
is_crossposting_eligiblebool
is_crosspost_videobool
is_episodebool
is_instagram_eligiblebool
lengthfloat64
live_audience_countint64
live_statusutf8
permalink_urlutf8
pictureutf8
placejson
post_viewsint64
premiere_living_room_statusutf8
privacyjson
publishedbool
scheduled_publish_timetimestamp[us, tz=UTC]
sourceutf8
sphericalbool
statusjson
titleutf8
universal_video_idutf8
updated_timetimestamp[us, tz=UTC]
viewsint64
Subscribe to product updates

Be the first to know about new features.