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

Type

Source

Platforms
Date Published

Feb 20, 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 Studies

The facebookmarketing_ad_studies table shows data for Facebook Marketing Ad Studies.

https://developers.facebook.com/docs/marketing-api/reference/ad-study/#Reading

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

Columns
NameType
account_idutf8
businessjson
canceled_timetimestamp[us, tz=UTC]
client_businessjson
cooldown_start_timetimestamp[us, tz=UTC]
_cq_iduuid
_cq_parent_iduuid
created_byjson
created_timetimestamp[us, tz=UTC]
descriptionutf8
end_timetimestamp[us, tz=UTC]
idutf8
measurement_contactjson
nameutf8
observation_end_timetimestamp[us, tz=UTC]
results_first_available_dateutf8
sales_contactjson
start_timetimestamp[us, tz=UTC]
typeutf8
updated_byjson
updated_timetimestamp[us, tz=UTC]
Subscribe to product updates

Be the first to know about new features.