Facebook Marketing: Tables

Back to plugin list

Official

Premium

Facebook Marketing

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

Make sure to sign up and run cloudquery login before running your first sync.

Latest version

v4.0.0

Type

Source

Published

Nov 10, 2023

Category

sales-marketing

Documentation Tables Changelog

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

Name	Type
block_offline_analytics	`bool`
collaborative_ads_managed_partner_eligibility	`json`
collaborative_ads_partner_premium_options	`json`
_cq_id	`uuid`
_cq_parent_id	`uuid`
created_time	`timestamp[us, tz=UTC]`
extended_updated_time	`timestamp[us, tz=UTC]`
id	`utf8`
is_hidden	`bool`
link	`utf8`
name	`utf8`
payment_account_id	`utf8`
primary_page	`json`
profile_picture_uri	`utf8`
timezone_id	`int64`
two_factor_type	`utf8`
updated_time	`timestamp[us, tz=UTC]`
verification_status	`utf8`
vertical	`utf8`
vertical_id	`int64`

Product

Legal

Terms & Conditions

Social

© 2023 CloudQuery, Inc. All rights reserved.