Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Facebook API Data Model

Navigation: Catalog: V32 > Schemas > Schema: Marketing > Tables

ReachFrequencyPredictionsByAdAccount

Contents Previous Home Next More

Name: ReachFrequencyPredictionsByAdAccount

Catalog: V32

Schema: Marketing

Parameters: ad_account_id

Parameters

Name

Data Type

Required

Default Value

Documentation

ad_account_id

string

☑

 

Facebook ads account ID including prefix 'act_'.

 

Table Columns

Name

Data Type

Label

Required

Documentation

account_id

decimal

itgen_facebook_account_id

☐

The ID of the Ad Account this reach frequency prediction belongs to.

campaign_group_id

decimal

itgen_facebook_campaign_group_id

☐

The id of the campaign which this prediction belongs to.

campaign_id

decimal

itgen_facebook_campaign_id

☐

The ID of the ad set to which this reach frequency prediction is assigned.

campaign_time_start

datetime

itgen_facebook_campaign_time_start

☐

Unix timestamp of the ad set start time.

campaign_time_stop

datetime

itgen_facebook_campaign_time_stop

☐

Unix timestamp of the ad set stop time.

curve_budget_reach

string

itgen_facebook_curve_budget_reach

☐

The curve for budget and reach. It is a string in JSON format representing a JSON object with these fields.num_points: the number of data points within the object.reach: Data contained at corresponding indices of each array form a single data point.The 'reach' values are presented in ascending order with the final value containing the maximum available reach.In video view buying, this is the number of unique users with viewsraw_reach: Data contained at corresponding indices of each array form a single data point.In video view buying, reach representsunique view throughs and raw_reach represents unique viewsbudget: Data contained at corresponding indices of each array form a single data point.Cent of accounts currency.impression: Data contained at corresponding indices of each array form a single data point.In video view buying, this is the number of view throughs(aka impression by conversion)interpolated_reach: Interpolated reach which is the original.value of reach without truncationraw_impression: Data contained at corresponding indices of each array form a single data point.In video view buying, impressions represents view throughs and raw_impressions representstotal number of views.

daily_impression_curve

string

itgen_facebook_daily_impression_curve

☐

List of daily Impression fields represents a vector of predicted daily impressions for every single day. Measured from midnight to midnight in the advertiser timezone during the campaign duration.

destination_id

decimal

itgen_facebook_destination_id

☐

The ID of the Page or the ID of the app which the ad promotes.

expiration_time

datetime

itgen_facebook_expiration_time

☐

Unix timestamp of the expiration time of prediction, if applicable.

external_budget

int32

itgen_facebook_external_budget

☐

Predicted budget in cents for the ad set, relevant if prediction mode is 0.

external_impression

int32

itgen_facebook_external_impression

☐

Predicted impressions for the ad set.

external_maximum_budget

int32

itgen_facebook_external_maximum_budget

☐

Maximum budget given the target, in cents.

external_maximum_impression

int32

itgen_facebook_external_maximum_impression

☐

Maximum number of impressions given the target.

external_maximum_reach

int32

itgen_facebook_external_maximum_reach

☐

Maximum reach given the target.

external_minimum_budget

int32

itgen_facebook_external_minimum_budget

☐

Minimum budget given the target, in cents.

external_minimum_impression

int32

itgen_facebook_external_minimum_impression

☐

Minimum impressions given the target.

external_minimum_reach

int32

itgen_facebook_external_minimum_reach

☐

Minimum reach given the target.

external_reach

int32

itgen_facebook_external_reach

☐

Predicted reach for the ad set, relevant if prediction mode is 1.

frequency_cap

int32

itgen_facebook_frequency_cap

☐

Lifetime frequency cap per user, always relevant, 0 means no frequncy cap.

frequency_distribution

string

itgen_facebook_frequency_distribution

☐

List of predicted percentages. The first value in the list represents the predicted percentage of people that will be reached once. The second value is the predicted percentage of people reached twice, and so on.

frequency_distribution_map

string

itgen_facebook_frequency_distribution_map

☐

List of key-value pairs. Each key is a predicted number of people reached by your ad and each value is a frequency_distribution associated with that reach.

frequency_distribution_map_agg

string

itgen_facebook_frequency_distribution_map_agg

☐

List of key-value pairs. Each key is a predicted number of people reached by your ad and each value is a list of 10 numbers associated with that reach. The first number represents the number of people reached which is greater than or equal to 1 time, 2 times and so on. The last number represents the number of people reached which is greater than or equal to 10 times.

grp_dmas_audience_size

double

itgen_facebook_grp_dmas_audience_size

☐

GRP: Audience size within DMAs based on Nielsen definition.

holdout_percentage

int32

itgen_facebook_holdout_percentage

☐

Percent of users in hold-out.

id

decimal

ID

☐

ID.

instagram_destination_id

decimal

itgen_facebook_instagram_destination_id

☐

The Instagram account id if instagramstream placement is used, except in the case of Mobile App Installs ads.

interval_frequency_cap

int32

itgen_facebook_interval_frequency_cap

☐

Interval frequency cap which is set for a custom period.

interval_frequency_cap_reset_period

int32

itgen_facebook_interval_frequency_cap_reset_period

☐

Custom reset period (hours) for interval frequency cap.

is_io

boolean

itgen_facebook_is_io

☐

Flag to indicate whether prediction is tied to an IO.

name

string

Name

☐

Prediction name.

pause_periods

string

itgen_facebook_pause_periods

☐

List of time periods the associated campaign has been paused.

prediction_mode

int32

itgen_facebook_prediction_mode

☐

The prediction mode: 0 = given reach, predict budget, 1 = given budget, predict reach.

prediction_progress

int32

itgen_facebook_prediction_progress

☐

Percentage value indicating the prediction progress (values 0-100). When 100 check status to indicate whether the prediction was successful.

reservation_status

int32

itgen_facebook_reservation_status

☐

Reservation status: 0 = Cancelled prediction, 1 = Reserved prediction, 2 = Prediction has been attached to a campaign.

status

int32

itgen_facebook_status

☐

Represents the status of the prediction, refer to Response Status.

story_event_type

int32

itgen_facebook_story_event_type

☐

Used to indicated the prediction is for video ads or not. If it is for video, the prediction will not include devices that cannot play video.

target_audience_size

int32

itgen_facebook_target_audience_size

☐

Unique 30-day active users for given targetting specs. Used as tip to indicate the maximum possible audience size if campaign length is increased.

target_spec_app_install_state

string

itgen_facebook_target_spec_app_install_state

☐

JSON array.

target_spec_audience_network_positions

string

itgen_facebook_target_spec_audience_network_positions

☐

JSON array.

target_spec_behaviors

string

itgen_facebook_target_spec_behaviors

☐

JSON array.

target_spec_college_years

string

itgen_facebook_target_spec_college_years

☐

JSON array.

target_spec_connections

string

itgen_facebook_target_spec_connections

☐

JSON array.

target_spec_custom_audiences

string

itgen_facebook_target_spec_custom_audiences

☐

JSON array.

target_spec_device_platforms

string

itgen_facebook_target_spec_device_platforms

☐

JSON array.

target_spec_dynamic_audience_ids

string

itgen_facebook_target_spec_dynamic_audience_ids

☐

JSON array.

target_spec_education_majors

string

itgen_facebook_target_spec_education_majors

☐

JSON array.

target_spec_education_schools

string

itgen_facebook_target_spec_education_schools

☐

JSON array.

target_spec_education_statuses

string

itgen_facebook_target_spec_education_statuses

☐

JSON array.

target_spec_effective_audience_network_positions

string

itgen_facebook_target_spec_effective_audience_network_positions

☐

JSON array.

target_spec_effective_device_platforms

string

itgen_facebook_target_spec_effective_device_platforms

☐

JSON array.

target_spec_effective_facebook_positions

string

itgen_facebook_target_spec_effective_facebook_positions

☐

JSON array.

target_spec_effective_instagram_positions

string

itgen_facebook_target_spec_effective_instagram_positions

☐

JSON array.

target_spec_effective_publisher_platforms

string

itgen_facebook_target_spec_effective_publisher_platforms

☐

JSON array.

target_spec_excluded_connections

string

itgen_facebook_target_spec_excluded_connections

☐

JSON array.

target_spec_excluded_custom_audiences

string

itgen_facebook_target_spec_excluded_custom_audiences

☐

JSON array.

target_spec_excluded_user_device

string

itgen_facebook_target_spec_excluded_user_device

☐

JSON array.

target_spec_facebook_positions

string

itgen_facebook_target_spec_facebook_positions

☐

JSON array.

target_spec_flexible_spec

string

itgen_facebook_target_spec_flexible_spec

☐

JSON array.

target_spec_friends_of_connections

string

itgen_facebook_target_spec_friends_of_connections

☐

JSON array.

target_spec_geo_locations

string

itgen_facebook_target_spec_geo_locations

☐

JSON array.

target_spec_household_composition

string

itgen_facebook_target_spec_household_composition

☐

JSON array.

target_spec_instagram_positions

string

itgen_facebook_target_spec_instagram_positions

☐

JSON array.

target_spec_locales

string

itgen_facebook_target_spec_locales

☐

JSON array.

target_spec_product_audience_specs

string

itgen_facebook_target_spec_product_audience_specs

☐

JSON array.

target_spec_publisher_platforms

string

itgen_facebook_target_spec_publisher_platforms

☐

JSON array.

target_spec_user_adclusters

string

itgen_facebook_target_spec_user_adclusters

☐

JSON array.

target_spec_user_device

string

itgen_facebook_target_spec_user_device

☐

JSON array.

target_spec_user_os

string

itgen_facebook_target_spec_user_os

☐

JSON array.

target_spec_wireless_carrier

string

itgen_facebook_target_spec_wireless_carrier

☐

JSON array.

target_spec_work_employers

string

itgen_facebook_target_spec_work_employers

☐

JSON array.

target_spec_work_positions

string

itgen_facebook_target_spec_work_positions

☐

JSON array.

time_created

datetime

itgen_facebook_time_created

☐

The time when this reach frequency prediction was created.

time_updated

datetime

itgen_facebook_time_updated

☐

Unix timestamp when the row is updated.

 

Generated 11-01-2019 15:44 on version 17.30.0-PROD+1821.