Back to plugin list
facebookmarketing
Official
Premium

Facebook Marketing

This plugin is in preview.

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

Publisher

cloudquery

Latest version

v4.0.0

Type

Source

Date Published

Nov 10, 2023

Category

Sales & Marketing

Price

Free while in preview

  • 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

© 2023 CloudQuery, Inc. All rights reserved.