Official

Premium

Facebook Marketing

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

Publisher

cloudquery

Latest version

v4.9.5

Type

Source

Platforms

Date Published

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

Primary Keys #

Name	Type
id	`utf8`

Columns #

Name	Type
account_id	`int64`
activity_status	`json`
ad_formats	`json`
auction_entry_option_index	`int64`
audience_size_lower_bound	`int64`
audience_size_upper_bound	`int64`
business_id	`int64`
buying_type	`utf8`
campaign_group_id	`int64`
campaign_id	`utf8`
campaign_time_start	`timestamp[us, tz=UTC]`
campaign_time_stop	`timestamp[us, tz=UTC]`
_cq_id	`uuid`
_cq_parent_id	`uuid`
currency	`utf8`
curve_budget_reach	`json`
curve_reach	`list<item: int64, nullable>`
daily_grp_curve	`json`
daily_impression_curve	`json`
day_parting_schedule	`json`
destination_id	`utf8`
end_time	`timestamp[us, tz=UTC]`
expiration_time	`timestamp[us, tz=UTC]`
external_budget	`int64`
external_impression	`int64`
external_maximum_budget	`int64`
external_maximum_impression	`utf8`
external_maximum_reach	`int64`
external_minimum_budget	`int64`
external_minimum_impression	`int64`
external_minimum_reach	`int64`
external_reach	`int64`
feed_ratio_0000	`int64`
frequency_cap	`int64`
grp_audience_size	`float64`
grp_avg_probability_map	`utf8`
grp_country_audience_size	`float64`
grp_curve	`json`
grp_dmas_audience_size	`float64`
grp_filtering_threshold_00	`int64`
grp_points	`float64`
grp_ratio	`float64`
grp_reach_ratio	`float64`
grp_status	`utf8`
holdout_percentage	`int64`
id	`utf8`
impression_curve	`list<item: int64, nullable>`
instagram_destination_id	`utf8`
instream_packages	`list<item: utf8, nullable>`
interval_frequency_cap	`int64`
interval_frequency_cap_reset_period	`int64`
is_bonus_media	`int64`
is_conversion_goal	`int64`
is_higher_average_frequency	`bool`
is_io	`bool`
is_reserved_buying	`int64`
is_trp	`bool`
name	`utf8`
objective	`int64`
objective_name	`utf8`
odax_objective	`int64`
odax_objective_name	`utf8`
optimization_goal	`int64`
optimization_goal_name	`utf8`
placement_breakdown	`json`
plan_name	`utf8`
plan_type	`utf8`
prediction_mode	`int64`
prediction_progress	`int64`
reference_id	`utf8`
reservation_status	`int64`
start_time	`timestamp[us, tz=UTC]`
status	`int64`
story_event_type	`int64`
target_cpm	`int64`
target_spec	`json`
time_created	`timestamp[us, tz=UTC]`
time_updated	`timestamp[us, tz=UTC]`
timezone_id	`int64`
timezone_name	`utf8`
topline_id	`int64`
video_view_length_constraint	`int64`
viewtag	`utf8`