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

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 Reach Frequency Predictions

The facebookmarketing_reach_frequency_predictions table shows data for Facebook Marketing Reach Frequency Predictions.

https://developers.facebook.com/docs/marketing-api/reference/reach-frequency-prediction/#Reading

The primary key for this table is id.

Columns
NameType
account_idint64
activity_statusjson
ad_formatsjson
auction_entry_option_indexint64
audience_size_lower_boundint64
audience_size_upper_boundint64
business_idint64
buying_typeutf8
campaign_group_idint64
campaign_idutf8
campaign_time_starttimestamp[us, tz=UTC]
campaign_time_stoptimestamp[us, tz=UTC]
_cq_iduuid
_cq_parent_iduuid
currencyutf8
curve_budget_reachjson
curve_reachlist<item: int64, nullable>
daily_grp_curvejson
daily_impression_curvejson
day_parting_schedulejson
destination_idutf8
end_timetimestamp[us, tz=UTC]
expiration_timetimestamp[us, tz=UTC]
external_budgetint64
external_impressionint64
external_maximum_budgetint64
external_maximum_impressionutf8
external_maximum_reachint64
external_minimum_budgetint64
external_minimum_impressionint64
external_minimum_reachint64
external_reachint64
feed_ratio_0000int64
frequency_capint64
grp_audience_sizefloat64
grp_avg_probability_maputf8
grp_country_audience_sizefloat64
grp_curvejson
grp_dmas_audience_sizefloat64
grp_filtering_threshold_00int64
grp_pointsfloat64
grp_ratiofloat64
grp_reach_ratiofloat64
grp_statusutf8
holdout_percentageint64
idutf8
impression_curvelist<item: int64, nullable>
instagram_destination_idutf8
instream_packageslist<item: utf8, nullable>
interval_frequency_capint64
interval_frequency_cap_reset_periodint64
is_bonus_mediaint64
is_conversion_goalint64
is_higher_average_frequencybool
is_iobool
is_reserved_buyingint64
is_trpbool
nameutf8
objectiveint64
objective_nameutf8
odax_objectiveint64
odax_objective_nameutf8
optimization_goalint64
optimization_goal_nameutf8
placement_breakdownjson
plan_nameutf8
plan_typeutf8
prediction_modeint64
prediction_progressint64
reference_idutf8
reservation_statusint64
start_timetimestamp[us, tz=UTC]
statusint64
story_event_typeint64
target_cpmint64
target_specjson
time_createdtimestamp[us, tz=UTC]
time_updatedtimestamp[us, tz=UTC]
timezone_idint64
timezone_nameutf8
topline_idint64
video_view_length_constraintint64
viewtagutf8
Subscribe to product updates

Be the first to know about new features.


© 2024 CloudQuery, Inc. All rights reserved.