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

Type

Source

Platforms
Date Published

Price per 1M rows

Starting from $15

monthly 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 Promote Pages

The facebookmarketing_promote_pages table shows data for Facebook Marketing Promote Pages.

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

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

Columns
NameType
aboututf8
access_tokenutf8
account_idutf8
ad_campaignjson
affiliationutf8
app_idutf8
artists_we_likeutf8
attireutf8
awardsutf8
band_interestsutf8
band_membersutf8
best_pagejson
bioutf8
birthdayutf8
booking_agentutf8
builtutf8
can_checkinbool
can_postbool
categoryutf8
category_listjson
checkinsint64
company_overviewutf8
connected_instagram_accountjson
connected_page_backed_instagram_accountjson
contact_addressjson
copyright_whitelisted_ig_partnerslist<item: utf8, nullable>
country_page_likesint64
coverjson
_cq_iduuid
_cq_parent_iduuid
culinary_teamutf8
current_locationutf8
delivery_and_pickup_option_infolist<item: utf8, nullable>
descriptionutf8
description_htmlutf8
differently_open_offeringsjson
directed_byutf8
displayed_message_response_timeutf8
display_subtextutf8
emailslist<item: utf8, nullable>
engagementjson
fan_countint64
featured_videojson
featuresutf8
followers_countint64
food_styleslist<item: utf8, nullable>
foundedutf8
general_infoutf8
general_managerutf8
genreutf8
global_brand_page_nameutf8
global_brand_root_idutf8
has_added_appbool
has_transitioned_to_new_page_experiencebool
has_whatsapp_business_numberbool
has_whatsapp_numberbool
hometownutf8
hoursjson
idutf8
impressumutf8
influencesutf8
instagram_business_accountjson
instant_articles_review_statusutf8
is_always_openbool
is_chainbool
is_community_pagebool
is_eligible_for_branded_contentbool
is_messenger_bot_get_started_enabledbool
is_messenger_platform_botbool
is_ownedbool
is_permanently_closedbool
is_publishedbool
is_unclaimedbool
is_verifiedbool
is_webhooks_subscribedbool
leadgen_tos_acceptance_timetimestamp[us, tz=UTC]
leadgen_tos_acceptedbool
leadgen_tos_accepting_userjson
linkutf8
locationjson
membersutf8
merchant_idutf8
merchant_review_statusutf8
messaging_feature_statusjson
messenger_ads_default_icebreakerslist<item: utf8, nullable>
messenger_ads_default_page_welcome_messagejson
messenger_ads_default_quick_replieslist<item: utf8, nullable>
messenger_ads_quick_replies_typeutf8
mini_shop_storefrontjson
missionutf8
mpgutf8
nameutf8
name_with_location_descriptorutf8
networkutf8
new_like_countint64
offer_eligiblebool
overall_star_ratingfloat64
owner_businessjson
page_tokenutf8
parent_pagejson
parkingjson
payment_optionsjson
personal_infoutf8
personal_interestsutf8
pharma_safety_infoutf8
phoneutf8
pickup_optionslist<item: utf8, nullable>
place_typeutf8
plot_outlineutf8
preferred_audiencejson
press_contactutf8
price_rangeutf8
privacy_info_urlutf8
produced_byutf8
productsutf8
promotion_eligiblebool
promotion_ineligible_reasonutf8
public_transitutf8
rating_countint64
recipientutf8
record_labelutf8
release_dateutf8
restaurant_servicesjson
restaurant_specialtiesjson
scheduleutf8
screenplay_byutf8
seasonutf8
single_line_addressutf8
starringutf8
start_infojson
store_codeutf8
store_location_descriptorutf8
store_numberint64
studioutf8
supports_donate_button_in_live_videobool
supports_instant_articlesbool
talking_about_countint64
temporary_statusutf8
unread_message_countint64
unread_notif_countint64
unseen_message_countint64
usernameutf8
verification_statusutf8
voip_infojson
websiteutf8
were_here_countint64
whatsapp_numberutf8
written_byutf8
Subscribe to product updates

Be the first to know about new features.