Table: facebookmarketing_reach_frequency_predictions

This table shows data for Facebook Marketing Reach Frequency Predictions.

https://developers.facebook.com/docs/marketing-api/reference/reach-frequency-prediction/#Reading (opens in a new tab)

The primary key for this table is id.

Columns

Name	Type
_cq_source_name	String
_cq_sync_time	Timestamp
_cq_id	UUID
_cq_parent_id	UUID
account_id	Int
activity_status	JSON
ad_formats	JSON
auction_entry_option_index	Int
audience_size_lower_bound	Int
audience_size_upper_bound	Int
business_id	Int
buying_type	String
campaign_group_id	Int
campaign_id	String
campaign_time_start	Timestamp
campaign_time_stop	Timestamp
currency	String
curve_budget_reach	JSON
curve_reach	IntArray
daily_grp_curve	JSON
daily_impression_curve	JSON
day_parting_schedule	JSON
destination_id	String
end_time	Timestamp
expiration_time	Timestamp
external_budget	Int
external_impression	Int
external_maximum_budget	Int
external_maximum_impression	String
external_maximum_reach	Int
external_minimum_budget	Int
external_minimum_impression	Int
external_minimum_reach	Int
external_reach	Int
feed_ratio_0000	Int
frequency_cap	Int
grp_audience_size	Float
grp_avg_probability_map	String
grp_country_audience_size	Float
grp_curve	JSON
grp_dmas_audience_size	Float
grp_filtering_threshold_00	Int
grp_points	Float
grp_ratio	Float
grp_reach_ratio	Float
grp_status	String
holdout_percentage	Int
id (PK)	String
impression_curve	IntArray
instagram_destination_id	String
instream_packages	StringArray
interval_frequency_cap	Int
interval_frequency_cap_reset_period	Int
is_bonus_media	Int
is_conversion_goal	Int
is_higher_average_frequency	Bool
is_io	Bool
is_reserved_buying	Int
is_trp	Bool
name	String
objective	Int
objective_name	String
odax_objective	Int
odax_objective_name	String
optimization_goal	Int
optimization_goal_name	String
placement_breakdown	JSON
plan_name	String
plan_type	String
prediction_mode	Int
prediction_progress	Int
reference_id	String
reservation_status	Int
start_time	Timestamp
status	Int
story_event_type	Int
target_cpm	Int
target_spec	JSON
time_created	Timestamp
time_updated	Timestamp
timezone_id	Int
timezone_name	String
topline_id	Int
video_view_length_constraint	Int
viewtag	String

macOS