Facebook Marketing Plugin documentation | CloudQuery

Report an issue

Back to plugin list

Official

Premium

Facebook Marketing

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

Publisher

cloudquery

Latest version

v4.7.0

Type

Source

Platforms

Date Published

September 25, 2024

Price per 1M rows

Starting from $15

monthly free quota

1M rows

Documentation Tables Changelog Destinations

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

Primary Keys #

Name	Type
account_id	`utf8`
id	`utf8`

Columns #

Name	Type
account_id	`utf8`
ad_breaks	`list<item: int64, nullable>`
backdated_time	`timestamp[us, tz=UTC]`
backdated_time_granularity	`utf8`
content_category	`utf8`
content_tags	`list<item: utf8, nullable>`
_cq_id	`uuid`
_cq_parent_id	`uuid`
created_time	`timestamp[us, tz=UTC]`
custom_labels	`list<item: utf8, nullable>`
description	`utf8`
embeddable	`bool`
embed_html	`utf8`
event	`json`
icon	`utf8`
id	`utf8`
is_crossposting_eligible	`bool`
is_crosspost_video	`bool`
is_episode	`bool`
is_instagram_eligible	`bool`
length	`float64`
live_audience_count	`int64`
live_status	`utf8`
permalink_url	`utf8`
picture	`utf8`
place	`json`
post_views	`int64`
premiere_living_room_status	`utf8`
privacy	`json`
published	`bool`
scheduled_publish_time	`timestamp[us, tz=UTC]`
source	`utf8`
spherical	`bool`
status	`json`
title	`utf8`
universal_video_id	`utf8`
updated_time	`timestamp[us, tz=UTC]`
views	`int64`

© 2024 CloudQuery, Inc. All rights reserved.