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

NameType
_cq_source_nameutf8
_cq_sync_timetimestamp[us, tz=UTC]
_cq_iduuid
_cq_parent_iduuid
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]
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
id (PK)utf8
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