Transferring your Facebook Ads data into Google Big Query is quick and hassle-free. To make analyzing easy in Data Studio the data is broken down into entities in a single table. Each entity represents a type of data.

The process of moving your data into Big Query begins by fetching your historic data, with the timeframes of each entity shown below. After this a daily update is performed, some entities have a delay to when new data is available and is also shown in the table below.

Entity date ranges for syncing

Entity Historic Data Period Daily Update Schedule

Ad

From 37 months ago up to 1 day ago 1 day ago

AdSet

From 37 months ago up to 1 day ago 1 day ago

Campaign

From 37 months ago up to 1 day ago 1 day ago

Insight

From 37 months ago up to 1 day ago 1 day ago


jepto_fb_ad

Field Type Description

ad_id

TextString The ID of the ad account that this ad belongs to.

account_id

TextString The ID of the ad account that this ad belongs to.

adset_id

TextString ID of the ad set that contains the ad

bid_amount

NumericInteger Bid amount for this ad which will be used in auction instead of the ad set bid_amount, if specified. Any updates to the ad set bid_amount will overwrite this value with the new ad set value.

campaign_id

TextString ID of the ad campaign that contains this ad

configured_status

TextString The configured status of the ad. Use status instead of this field.

conversion_domain

TextString The domain where conversions happen. Required to create or update an ad in a campaign that shares data with a pixel. This field will be auto-populated for existing ads by inferring from destination URLs. Note that this field should contain only the first and second level domains, and not the full URL. For example facebook.com.

created_time

CalendarTimestamp Time when the ad was created.

date

CalendarDate Date when the ad was created.

effective_status

TextString The effective status of the ad. The status could be effective either because of its own status, or the status of its parent units. WITH_ISSUES is available for version 3.2 or higher. IN_PROCESS is available for version 4.0 or higher

last_updated_by_app_id

TextString Indicates the app used for the most recent update of the ad.

name

TextString Name of the ad.

preview_shareable_link

TextString A link that enables users to preview ads in different placements

source_ad_id

TextString The source ad id that this ad is copied from

status

TextString The configured status of the ad. The field returns the same value as configured_status. Use this field, instead of configured_status.

updated_time

CalendarTimestamp Time when this ad was updated.

tracking_specs

TextString With tracking specs, you log actions taken by people on your ad. This field takes arguments identical to action spec

insert_id

TextString For Jepto Use only

jepto_fb_adset

Field Type Description

insert_id

TextString For Jepto use only

date

CalendarDate Date when Ad Set is created.

adset_id

TextString AdSet ID

account_id

TextString ID for the Ad Account associated with this Ad Set

asset_feed_id

TextString The ID of the asset feed that constains a content to create ads

attribution_spec

TextString Conversion attribution spec used for attributing conversions for optimization.

bid_adjustments

TextString Map of bid adjustment types to values

bid_amount

NumericInteger Bid cap or target cost for this ad set.

bid_constraints

TextString Choose bid constraints for ad set to suit your specific business goals. It usually works together with bid_strategy field.

bid_info

TextString Map of bid objective to bid value.

bid_strategy

TextString Bid strategy for this ad set when you use AUCTION as your buying type.

billing_event

TextString The billing event for this ad set.

budget_remaining

NumericInteger Remaining budget of this Ad Set

campaign_id

TextString The ID of the campaign that contains this ad set

configured_status

TextString The status set at the ad set level. It can be different from the effective status due to its parent campaign. Prefer using 'status' instead of this.

contextual_bundling_spec

TextString specs of contextual bundling Ad Set setup, including signal of opt-in/out the feature

created_time

CalendarTimestamp Time when this Ad Set was created

creative_sequence

TextString Order of the adgroup sequence to be shown to users

daily_budget

NumericInteger The daily budget of the set defined in your account currency.

daily_min_spend_target

NumericInteger Daily minimum spend target of the ad set defined in your account currency. To use this field, daily budget must be specified in the Campaign. This target is not a guarantee but our best effort.

daily_spend_cap

NumericInteger Daily spend cap of the ad set defined in your account currency. To use this field, daily budget must be specified in the Campaign.

destination_type

TextString Destination of ads in this Ad Set.

effective_status

TextString The effective status of the adset. The status could be effective either because of its own status, or the status of its parent campaign. WITH_ISSUES is available for version 3.2 or higher. IN_PROCESS is available for version 4.0 or higher.

end_time

CalendarTimestamp End time, in UTC UNIX timestamp

frequency_control_specs

TextString An array of frequency control specs for this ad set. As there is only one event type currently supported, this array has no more than one element. Writes to this field are only available in ad sets where REACH is the objective.

instagram_actor_id

TextString Represents your Instagram account id, used for ads, including dynamic creative ads on Instagram.

is_dynamic_creative

BooleanBoolean Whether this ad set is a dynamic creative ad set. dynamic creative ad can be created only under ad set with this field set to be true.

issues_info

TextString Issues for this ad set that prevented it from deliverying

learning_stage_info

TextString Info about whether the ranking or delivery system is still learning for this ad set. While the ad set is still in learning , we might unstablized delivery performances.

lifetime_budget

NumericInteger The lifetime budget of the set defined in your account currency.

lifetime_imps

NumericInteger Lifetime impressions. Available only for campaigns with buying_type=FIXED_CPM

lifetime_min_spend_target

NumericInteger Lifetime minimum spend target of the ad set defined in your account currency. To use this field, lifetime budget must be specified in the Campaign. This target is not a guarantee but our best effort.

lifetime_spend_cap

NumericInteger Lifetime spend cap of the ad set defined in your account currency. To use this field, lifetime budget must be specified in the Campaign.

multi_optimization_goal_weight

NumericInteger multi_optimization_goal_weight

name

TextString Name of the ad set

optimization_goal

TextString The optimization goal this ad set is using.

optimization_sub_event

TextString Optimization sub event for a specific optimization goal. For example: Sound-On event for Video-View-2s optimization goal.

pacing_type

TextString Defines the pacing type, standard or using ad scheduling

promoted_object

TextString The object this ad set is promoting across all its ads.

recommendations

TextString If there are recommendations for this ad set, this field includes them. Otherwise, will not be included in the response. This field is not included in redownload mode.

recurring_budget_semantics

BooleanBoolean If this field is true, your daily spend may be more than your daily budget while your weekly spend will not exceed 7 times your daily budget.

review_feedback

TextString Reviews for dynamic creative ad

rf_prediction_id

TextString Reach and frequency prediction ID

source_adset_id

TextString The source ad set id that this ad set was copied from

start_time

CalendarTimestamp Start time, in UTC UNIX timestamp

status

TextString The status set at the ad set level. It can be different from the effective status due to its parent campaign. The field returns the same value as configured_status, and is the suggested one to use.

targeting_optimization_types

TextString Targeting options that are relaxed and used as a signal for optimization

time_based_ad_rotation_id_blocks

TextString Specify ad creative that displays at custom date ranges in a campaign as an array.

time_based_ad_rotation_intervals

TextString Date range when specific ad creative displays during a campaign.

updated_time

CalendarTimestamp Time when the Ad Set was updated

use_new_app_click

BooleanBoolean If set, allows Mobile App Engagement ads to optimize for LINK_CLICKS

jepto_fb_campaign

Field Type Description

campaign_id

TextString Campaign ID

account_id

TextString ID of the ad account that owns this campaign

ad_strategy_group_id

TextString Ad Strategy Group ID

ad_strategy_id

TextString Ad Strategy ID

bid_strategy

TextString Bid strategy for this campaign when you enable campaign budget optimization and when you use AUCTION as your buying type

boosted_object_id

TextString The Boosted Object this campaign has associated, if any

budget_rebalance_flag

BooleanBoolean Whether to automatically rebalance budgets daily for all the adsets under this campaign. This has been deprecated on Marketing API V7.0.

budget_remaining

NumericInteger Remaining budget

buying_type

TextString Buying type, possible values are: AUCTION: default RESERVED: for reach and frequency ads. Reach and Frequency is disabled for housing, employment and credit ads.

can_create_brand_lift_study

BooleanBoolean If we can create a new automated brand lift study for the ad set.

can_use_spend_cap

BooleanBoolean Whether the campaign can set the spend cap

configured_status

TextString If this status is PAUSED, all its active ad sets and ads will be paused and have an effective status CAMPAIGN_PAUSED. Prefer using 'status' instead of this.

created_time

CalendarTimestamp Created Time

date

CalendarDate Created Date

daily_budget

NumericInteger The daily budget of the campaign

effective_status

TextString IN_PROCESS is available for version 4.0 or higher

is_skadnetwork_attribution

BooleanBoolean When set to true Indicates that the campaign will include SKAdNetwork, iOS 14+.

last_budget_toggling_time

CalendarTimestamp Last budget toggling time

lifetime_budget

NumericInteger The lifetime budget of the campaign

name

TextString Campaign's name

objective

TextString Campaign's objective Some objectives are currently in limited beta testing. See the Outcome Ad-Driven Experience Objective Validation section below for more information.

smart_promotion_type

TextString Smart Promotion Type. guided_creation or smart_app_promotion(the choice under APP_INSTALLS objective).

source_campaign_id

TextString The source campaign id that this campaign is copied from

special_ad_category

TextString The campaign's Special Ad Category. One of HOUSING, EMPLOYMENT, CREDIT, or NONE.

spend_cap

NumericInteger A spend cap for the campaign, such that it will not spend more than this cap. Expressed as integer value of the subunit in your currency.

start_time

CalendarTimestamp Merging of start_times for the ad sets belonging to this campaign. At the campaign level, start_time is a read only field. You can setup start_time at the ad set level.

status

TextString If this status is PAUSED, all its active ad sets and ads will be paused and have an effective status CAMPAIGN_PAUSED. The field returns the same value as 'configured_status', and is the suggested one to use.

stop_time

CalendarTimestamp Merging of stop_times for the ad sets belonging to this campaign, if available. At the campaign level, stop_time is a read only field. You can setup stop_time at the ad set level.

topline_id

TextString Topline ID

updated_time

CalendarTimestamp Updated Time. If you update spend_cap or daily budget or lifetime budget, this will not automatically update this field.

insert_id

TextString For Jepto Use only

jepto_fb_insight

Field Type Description

insert_id

TextString For Jepto use only

insight_type

TextString Can be one of (ad, campaign, adset, adaccount)

breakdown

TextString Breakdown used for fetching the insight

age

TextString The age range of the people you've reached.

gender

TextString Gender of people you've reached. People who don't list their gender are shown as 'not specified'.

country

TextString The countries where the people you've reached are located. This is based on information such as a person's hometown, their current city and the geographical location where they tend to be when they visit Facebook.

region

TextString The regions where the people you've reached are located.

device_platform

TextString The type of device, mobile or desktop, used by people when they viewed or clicked on an ad, as shown in ads reporting.

account_currency

TextString Currency that is used by your ad account.

account_id

TextString The ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing.

account_name

TextString The name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing.

actions_post_reaction

NumericNumeric

actions_post_engagement

NumericNumeric

actions_page_engagement

NumericNumeric

ad_id

TextString The unique ID of the ad you're viewing in reporting.

ad_name

TextString The name of the ad you're viewing in reporting.

adset_id

TextString The unique ID of the ad set you're viewing in reporting. An ad set is a group of ads that share the same budget, schedule, delivery optimization and targeting.

adset_name

TextString The name of the ad set you're viewing in reporting. An ad set is a group of ads that share the same budget, schedule, delivery optimization and targeting.

attribution_setting

TextString The default attribution window to be used when the attribution result is calculated. Each ad set has its own attribution setting value. The attribution setting for a campaign or an account is calculated based on existing ad sets. Returns mixed, indicating multiple attribution settings, skan, indicating SKAdNetwork attribution of iOS 14 app install campaigns, and na, indicating no ad set in a campaign or account. Both 1-day and 7-day click attribution settings will include iOS14.5 modeled conversions (from opted out users) which will provide a more accurate view of ad performance and enable our delivery systems to optimize based on more comprehensive data. The attribution_setting field only returns values when use_unified_attribution_setting is set to true.

buying_type

TextString The method by which you pay for and target ads in your campaigns: through dynamic auction bidding, fixed-price bidding, or reach and frequency buying. This field is currently only visible at the campaign level.

campaign_id

TextString The unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads.

campaign_name

TextString The name of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads.

canvas_avg_view_percent

NumericNumeric The average percentage of the Instant Experience that people saw. An Instant Experience is a screen that opens after someone interacts with your ad on a mobile device. It may include a series of interactive or multimedia components, including video, images product catalog and more.

canvas_avg_view_time

NumericNumeric The average total time, in seconds, that people spent viewing an Instant Experience. An Instant Experience is a screen that opens after someone interacts with your ad on a mobile device. It may include a series of interactive or multimedia components, including video, images product catalog and more.

catalog_segment_value

TextString The total value of all conversions from your catalog segment attributed to your ads.

clicks

NumericNumeric The number of clicks on your ads.

conversion_rate_ranking

TextString A ranking of your ad's expected conversion rate. Your ad is ranked against ads with your optimization goal that competed for the same audience. Possible values include BELOW_AVERAGE_10, BELOW_AVERAGE_20, BELOW_AVERAGE_35, AVERAGE, ABOVE_AVERAGE, or UNKNOWN if there's not enough information about the ad. This metric is an ad relevance diagnostic and does not apply to campaigns or ad sets, only ads.

conversion_values

TextString The total value of all conversions across all channels (i.e. website, mobile app, offline, and on-facebook) attributed to your ads.

conversions

TextString The total number of conversions across all channels (i.e. website, mobile app, offline, and on-facebook) attributed to your ads.

converted_product_quantity

TextString The number of products purchased which are recorded by your merchant partner's pixel or app SDK for a given product ID and driven by your ads. Has to be used together with converted product ID breakdown.

converted_product_value

TextString The value of purchases recorded by your merchant partner's pixel or app SDK for a given product ID and driven by your ads. Has to be used together with converted product ID breakdown.

cost_per_action_type

TextString The average cost of a relevant action.

cost_per_conversion

TextString The average cost of a conversion across all channels (i.e. website, mobile app, offline, and on-facebook). Conversions include contact, customize_product, donate, find_location, schedule, start_trial, submit_application, subscribe, recurring_subscription_payment, cancel_subscription, ad_click, ad_impression.

cost_per_estimated_ad_recallers

NumericNumeric The average cost for each estimated ad recall lift. This metric is only available for assets in the Brand awareness, Post engagement and Video views Objectives. This metric is estimated and in development.

cost_per_inline_link_click

NumericNumeric The average cost of each inline link click.

cost_per_inline_post_engagement

NumericNumeric The average cost of each inline post engagement.

cost_per_outbound_click

NumericNumeric The average cost for each outbound click.

cost_per_thruplay

TextString The average cost for each ThruPlay. This metric is in development.

cost_per_unique_post_engagement

NumericNumeric The average cost of each unique action. This metric is estimated.

cost_per_unique_page_engagement

TextString The average cost of each unique action. This metric is estimated.

cost_per_unique_click

NumericNumeric The average cost for each unique click (all). This metric is estimated.

cost_per_unique_inline_link_click

NumericNumeric The average cost of each unique inline link click. This metric is estimated.

cost_per_unique_outbound_click

NumericNumeric The average cost for each unique outbound click. This metric is estimated.

cpc

NumericNumeric The average cost for each click (all).

cpm

NumericNumeric The average cost for 1,000 impressions.

cpp

NumericNumeric The average cost to reach 1,000 people. This metric is estimated.

ctr

NumericNumeric The percentage of times people saw your ad and performed a click (all).

date_start

TextString The start date for your data. This is controlled by the date range you've selected for your reporting view.

date_stop

TextString The end date for your data. This is controlled by the date range you've selected for your reporting view.

engagement_rate_ranking

TextString A ranking of your ad's expected engagement rate. Engagement includes all clicks, likes, comments and shares. Your ad is ranked against ads that competed for the same audience. Possible values include BELOW_AVERAGE_10, BELOW_AVERAGE_20, BELOW_AVERAGE_35, AVERAGE, ABOVE_AVERAGE, or UNKNOWN if there's not enough information about the ad. This metric is an ad relevance diagnostic and does not apply to campaigns or ad sets, only ads.

estimated_ad_recall_rate

NumericNumeric The rate at which an estimated number of additional people, when asked, would remember seeing your ads within 2 days. This metric is only available for assets in the Brand awareness, Post engagement and Video views Objectives. This metric is estimated and in development.

estimated_ad_recallers

NumericNumeric An estimate of the number of additional people who may remember seeing your ads, if asked, within 2 days. This metric is only available for assets in the Brand awareness, Post engagement and Video views Objectives. This metric is estimated and in development.

frequency

NumericNumeric The average number of times each person saw your ad. This metric is estimated.

full_view_impressions

NumericNumeric The number of Full Views on your Page's posts as a result of your ad.

full_view_reach

NumericNumeric The number of people who performed a Full View on your Page's post as a result of your ad.

impressions

NumericNumeric The number of times your ads were on screen.

inline_link_click_ctr

NumericNumeric The percentage of time people saw your ads and performed an inline link click.

inline_link_clicks

NumericNumeric The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window.

inline_post_engagement

NumericNumeric The total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window.

instant_experience_clicks_to_open

NumericNumeric The number of clicks on your ad that open an Instant Experience. This metric is in development.

instant_experience_clicks_to_start

NumericNumeric The number of times an interactive component in an Instant Experience starts. This metric is in development.

instant_experience_outbound_clicks

TextString The number of clicks on links in an Instant Experience that take people off Facebook-owned properties. This metric is in development.

mobile_app_purchase_roas

TextString The total return on ad spend (ROAS) from mobile app purchases. This is based on the value that you assigned when you set up the app event.

objective

TextString The objective reflecting the goal you want to achieve with your advertising. It may be different from the selected objective of the campaign in some cases.

optimization_goal

TextString The optimization goal you selected for your ad or ad set. Your optimization goal reflects what you want to optimize for the ads.

outbound_click

NumericNumeric The number of clicks on links that take people off Facebook-owned properties.

ctr_outbound_click

NumericNumeric The percentage of times people saw your ad and performed an outbound click.

purchase_roas

TextString The total return on ad spend (ROAS) from purchases. This is based on information received from one or more of your connected Facebook Business Tools and attributed to your ads.

place_page_name

TextString The name of the place page involved in impression or click. Has to be used together with Business Locations breakdown.

qualifying_question_qualify_answer_rate

NumericNumeric qualifying_question_qualify_answer_rate

quality_ranking

TextString A ranking of your ad's perceived quality. Quality is measured using feedback on your ads and the post-click experience. Your ad is ranked against ads that competed for the same audience. Possible values include BELOW_AVERAGE_10, BELOW_AVERAGE_20, BELOW_AVERAGE_35, AVERAGE, ABOVE_AVERAGE, or UNKNOWN if there's not enough information about the ad. This metric is an ad relevance diagnostic (https://www.facebook.com/help/403110480493160) and does not apply to campaigns or ad sets, only ads.

reach

NumericNumeric The number of people who saw your ads at least once. Reach is different from impressions, which may include multiple views of your ads by the same people. This metric is estimated.

social_spend

NumericNumeric The total amount you've spent so far for your ads showed with social information. (ex: Jane Doe likes this).

spend

NumericNumeric The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. This metric is estimated.

total_postbacks

TextString The total number of postbacks received from Apple's SKAdNetwork API. Postbacks from SKAdNetwork provide visibility into the number of app installs and post-install events that occurred. This metric is reported by a third-party API. Note: total_postbacks should not be queried with other field values. Request this metric separately from others.

video_15_sec_watched_video_view

NumericNumeric The number of times your video played for at least 15 seconds, or for nearly its total length if it's shorter than 15 seconds. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video.

video_30_sec_watched_video_view

NumericNumeric The number of times your video played for at least 30 seconds, or for nearly its total length if it's shorter than 30 seconds. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video.

video_avg_time_watched_video_view

NumericNumeric The average time a video was played, including any time spent replaying the video for a single impression.

video_p100_watched_video_view

NumericNumeric The number of times your video was played at 100% of its length, including plays that skipped to this point.

video_p25_watched_video_view

NumericNumeric The number of times your video was played at 25% of its length, including plays that skipped to this point.

video_p50_watched_video_view

NumericNumeric The number of times your video was played at 75% of its length, including plays that skipped to this point.

video_p75_watched_video_view

NumericNumeric The number of times your video was played at 50% of its length, including plays that skipped to this point.

video_p95_watched_video_view

NumericNumeric The number of times your video was played at 95% of its length, including plays that skipped to this point.

video_play_video_view

TextString The number of times your video starts to play. This is counted for each impression of a video, and excludes replays. This metric is in development.

video_play_curve_actions

TextString A video-play based curve graph that illustrates the percentage of video plays that reached a given second. Entries 0 to 14 represent seconds 0 thru 14. Entries 15 to 17 represent second ranges [15 to 20), [20 to 25), and [25 to 30). Entries 18 to 20 represent second ranges [30 to 40), [40 to 50), and [50 to 60). Entry 21 represents plays over 60 seconds.

website_ctr_link_click

NumericNumeric The percentage of times people saw your ad and performed a link click.

website_purchase_roas

TextString The total return on ad spend (ROAS) from website purchases. This is based on the value of all conversions recorded by the Facebook pixel on your website and attributed to your ads.

date

CalendarDate Date when the ad insight was created.