Facebook Ads report transformation
This document describes how your Facebook Ads reports aretransformed when yourun a Facebook Ads transfer to BigQuery.
Table mapping for Facebook Ads reports
When your Facebook Ads reports are transferredto BigQuery, the reports are transformed into the followingBigQuery tables and views.
AdAccounts report
| Meta API field name | Mapped BigQuery field name | Type | Description |
|---|---|---|---|
id | ID [KEY] | String | The Id of Ad Account. |
| Target | String | The target used to get ad accounts from. This value is `null` - to get all ad accounts. |
account_id | AccountId | String | The Id of the Ad Account when viewed directly in Facebook. |
account_status | AccountStatus | Integer | Status of the account. 1 = Active, 2 = Disabled, 3 = Unsettled, 7 = Pending Review, 9 = in Grace Period, 101 = temporarily unavailable, 100 = pending closure. |
age | Age | Double | Amount of time the ad account has been open, in days. |
amount_spent | AmountSpent | Integer | Current total amount spent by the account. This can be reset. |
balance | Balance | Integer | Bill amount due. |
business_city | BusinessCity | String | City for business address. |
business_country_code | BusinessCountryCode | String | Country code for the business address. |
business_name | BusinessName | String | The business name for the account. |
business_state | BusinessState | String | State abbreviation for business address. |
business_street | BusinessStreet | String | First line of the business street address for the account. |
business_street2 | BusinessStreet2 | String | Second line of the business street address for the account. |
business_zip | BusinessZip | String | Zip code for business address. |
capabilities | Capabilities | String | Capabilities allowed for this ad account. |
created_time | CreatedTime | Datetime | The time the account was created. |
currency | Currency | String | The currency used for the account, based on the corresponding value in the account settings. |
min_campaign_group_spend_cap | MinCampaignGroupSpendCap | String | The minimum campaign group spend limit. |
name | Name | String | Name of the account; note that many accounts are unnamed, so this field may be empty. |
offsite_pixels_tos_accepted | OffsitePixelsTosAccepted | String | Indicates whether the offsite pixel Terms Of Service contract was signed. |
owner | OwnerId | String | Facebook ID of the owner for the Ad Account. |
spend_cap | SpendCap | Integer | The maximum that can be spent by this account after which campaigns will be paused. A value of 0 signifies no spending-cap. |
timezone_id | TimezoneId | String | ID for the timezone. |
timezone_name | TimezoneName | String | Name for the timezone. |
timezone_offset_hours_utc | TimezoneOffsetHoursUTC | Double | Time Zone difference from UTC. |
AdInsights report
| Meta API field name | Mapped BigQuery field name | Type | Description |
|---|---|---|---|
| Target | String | The Id of the Account to get insights for. |
date_start | DateStart | Date | The starting date to retrieve insights. In the Facebook UI, this is the Report Start field. |
date_stop | DateEnd | Date | The ending date to retrieve insights. In the Facebook UI, this is the Report End field. |
| TimeIncrement | String | The number of days of data aggregation. This value is set to 1. |
| Level | String | The level to represent the results at. This value is set to `ad`. |
account_currency | AccountCurrency | String | The currency that is being used by the ad account. |
action_attribution_windows | ActionAttributionWindows | String | A comma separated list that determines what is the attribution window for the actions. For example, 28d_click means the API returns all actions that happened 28 days after someone clicked on the ad. This option is set at [1d_view,28d_click]. |
account_id | AdAccountId | String | The Id of the Ad Account that is associated with the report row. |
account_name | AdAccountName | String | The name of the Ad Account that is associated with the report row. |
campaign_id | CampaignId | String | The Id of the Campaign that is associated with the report row. |
campaign_name | CampaignName | String | The name of the Campaign that is associated with the report row. |
adset_id | AdSetId | String | The Id of the Ad Set that is associated with the report row. |
adset_name | AdSetName | String | The name of the Ad Set that is associated with the report row. |
ad_id | AdId | String | The Id of the Ad that is associated with the report row. |
ad_name | AdName | String | The name of the Ad that is associated with the report row. |
buying_type | BuyingType | String | The method by which target ads are paid for in your campaigns. |
clicks | Clicks | Long | The total number of clicks on your ad. Depending on what you're promoting, this can include Page likes, event responses or app installs. In the Facebook UI, this is the Clicks (All) field. |
conversion_rate_ranking | ConversionRateRanking | String | The conversion rate ranking. |
cost_per_estimated_ad_recallers | CostPerEstimatedAdRecallers | Decimal | The average cost per additional person that we estimate will recall seeing your ad if asked within 2 days. |
cost_per_inline_link_click | CostPerInlineLinkClick | Decimal | The average cost per click on links in the ad. |
cost_per_inline_post_engagement | CostPerInlinePostEngagement | Decimal | The average cost per engagement on the post. |
cost_per_unique_click | CostPerUniqueClick | Decimal | The average cost per unique click for these ads, calculated as the amount spent divided by the number of unique clicks received. |
cost_per_unique_inline_link_click | CostPerUniqueInlineLinkClick | Decimal | The average you paid for each unique inline link click. |
cpc | CPC | Decimal | The average cost per click for these ads, calculated as the amount spent divided by the number of clicks received. |
cpm | CPM | Decimal | The average cost that you've paid to have 1,000 impressions on your ad. |
cpp | CPP | Decimal | The average cost that you've paid to have your ad served to 1,000 unique people. |
ctr | CTR | Double | The number of clicks you received divided by the number of impressions. In the Facebook UI, this is the CTR (All) % field. |
estimated_ad_recall_rate | EstimatedAdRecallRate | Double | The estimated number of people who recall your ad divided by the number of people your ad reached. |
estimated_ad_recallers | EstimatedAdRecallers | Double | The additional number of people that we estimate will remember seeing your ads if asked within 2 days. |
frequency | Frequency | Double | The average number of times that your ad was served to each person. |
impressions | Impressions | Long | The number of times that your ad was served. On mobile apps an ad is counted as served the first time it's viewed. On all other Facebook interfaces, an ad is served the first time it's placed in a person's News Feed or each time it's placed in the right column. |
inline_link_clicks | InlineLinkClicks | Long | Total number of clicks on links in the ad. |
inline_link_click_ctr | InlineLinkClicksCounter | Double | The click-through rate for inline clicks to link. |
inline_post_engagement | InlinePostEngagement | Long | The total number of engagements on the post. |
instant_experience_clicks_to_open | InstantExperienceClicksToOpen | Long | Corresponds to the instant_experience_clicks_to_open field from the META API. |
instant_experience_clicks_to_start | InstantExperienceClicksToStart | Long | Corresponds to the instant_experience_clicks_to_start field from the META API. |
instant_experience_outbound_clicks | InstantExperienceOutboundClicks | Long | Corresponds to the instant_experience_outbound_clicks field from the META API. |
objective | Objective | String | The objective you selected for your campaign. Your objective reflects the goal you want to achieve with your advertising. |
quality_ranking | QualityRanking | String | The quality ranking. |
reach | Reach | Long | The number of people your ad was served to. |
spend | Spend | Decimal | The total amount you've spent so far. |
| UniqueClicks | Long | The total number of unique people who have clicked on your ad. For example, if 3 people click the same ad 5 times, it counts as 3 unique clicks. |
| UniqueCTR | Double | The number of people who clicked on your ad divided by the number of people you reached. For example, if you received 20 unique clicks and your ad was served to 1,000 unique people, your unique click-through rate would be 2%. |
inline_link_clicks | UniqueInlineLinkClicks | Long | The number of unique inline link clicks that your ad got. In the Facebook UI, this is the Unique Clicks to Link field. |
| UniqueInlineLinkClickCounter | Double | The click-through rate for unique inline clicks to link. |
| UniqueLinkClicksCounter | Double | The unique click-through rate for clicks to link. The number of people who clicked on the link in your ad that directs people off Facebook divided by the number of people you reached. For example, if you received 20 unique clicks to link and your ad was shown to 1,000 unique people, your unique click-through rate would be 2%. |
| Checkins | Int | The number of checkins attributed to the Ad. |
| EventResponses | Int | The number of event responses attributed to the Ad. |
inline_link_clicks | LinkClicks | Int | The number of link clicks attributed to the Ad. |
| OfferSaves | Int | The number of receive offers attributed to the Ad. |
outbound_clicks | OutboundClicks | Int | The number of outbound clicks attributed to the Ad. |
| PageEngagements | Int | The number of page engagements attributed to the Ad. |
| PageLikes | Int | The number of page likes attributed to the Ad. |
| PageMentions | Int | The number of page mentions attributed to the Ad. |
| PagePhotoViews | Int | The number of photo views attributed to the Ad. |
| PostComments | Int | The number of post comments attributed to the Ad. |
| PostEngagements | Int | The number of post engagements attributed to the Ad. |
| PostShares | Int | The number of post shares attributed to the Ad. |
| PostReactions | Int | The number of post reactions attributed to the Ad. |
| PageTabViews | Int | The number of tab views attributed to the Ad. |
| Region | String | The region someone viewed the Ad from. This is a breakdown field. |
| Video3SecondViews | Int | The number of video views attributed to the Ad. Views count if at least 3 seconds or the entire video (if the video is less than 3 seconds) were played. |
| Generic Breakdowns | |||
| Age | String | The age range for the metrics in this row. |
| Gender | String | The gender for the metrics in this row. |
| Country | String | The country for the metrics in this row. |
| Region | String | The region someone viewed the ad from. |
| FrequencyValue | String | The number of times an ad in your Reach and Frequency campaign was served to each person. |
| HStatsByAdvertiserTZ | String | Time period over which the stats were taken for the advertiser. |
| HStatsByAudienceTZ | String | Time period over which the stats were taken for the audience. |
| ImpressionDevice | String | The devices used to view the Ad. |
| PlatformPosition | String | The position on the platform. |
| PublisherPlatform | String | The platforms the ads were published on. |
| ProductId | String | The product Id advertised in the Ad. |
AdInsightsActions report
ACTION_COLLECTION refers to the types of actionspeople have taken in response to your ad. For a full list of action collections,seeAction collections.
| Meta API field name | Mapped BigQuery field name | Type | Description |
|---|---|---|---|
| Target | String | The Id of the Account to get insights for. |
date_start | DateStart | Date | The starting date to retrieve insights for. In the Facebook UI, this is the Report Start field. |
date_stop | DateEnd | Date | The ending date to retrieve insights for. In the Facebook UI, this is the Report End field. |
| TimeIncrement | String | The number of days of data aggregation. This value is set at 1. |
| Level | String | The level to represent the results at. The value is set atad. |
action_attribution_windows | ActionAttributionWindows | String | A comma separated list which determines what is the attribution window for the actions. For example, 28d_click means the API returns all actions that happened 28 days after someone clicked on the ad. The default option means [1d_view,7d_click]. Possible values include 1d_view, 7d_view, 28d_view, 1d_click, 7d_click, 28d_click, default. |
| ActionCollection | String | This comes from your choice of Action Collections in the transfer. |
account_id | AdAccountId | String | The Id of the Ad Account associated with the report row. |
account_name | AdAccountName | String | The name of the Ad Account associated with the report row. |
campaign_id | CampaignId | String | The Id of the Campaign associated with the report row. |
campaign_name | CampaignName | String | The name of the Campaign associated with the report row. |
adset_id | AdSetId | String | The Id of the Ad Set associated with the report row. |
adset_name | AdSetName | String | The name of the Ad Set associated with the report row. |
ad_id | AdId | String | The Id of the Ad associated with the report row. |
ad_name | AdName | String | The name of the Ad associated with the report row. |
ACTION_COLLECTION.value | ActionValue | Integer | Metric value of default attribution window. |
ACTION_COLLECTION.1d_click | Action1dClick | String | Metric value of attribution window 1 day after clicking the ad. |
ACTION_COLLECTION.1d_view | Action1dView | String | Metric value of attribution window 1 day after viewing the ad. |
ACTION_COLLECTION.7d_click | Action7dClick | String | Metric value of attribution window 7 days after clicking the ad. |
ACTION_COLLECTION.7d_view | Action7dView | String | Metric value of attribution window 7 days after viewing the ad. |
ACTION_COLLECTION.28d_click | Action28dClick | String | Metric value of attribution window 28 days after clicking the ad. |
ACTION_COLLECTION.28d_view | Action28dView | String | Metric value of attribution window 28 days after viewing the ad. |
ACTION_COLLECTION.dda | ActionDDA | String | Metric value of attribution window which is powered by data driven model. |
| Generic Breakdowns | |||
| Age | String | The age range for the metrics in this row. |
| Gender | String | The gender for the metrics in this row. |
| Country | String | The country for the metrics in this row. |
| Region | String | The region someone viewed the ad from. |
| FrequencyValue | String | The number of times an ad in your Reach and Frequency campaign was served to each person. |
| HStatsByAdvertiserTZ | String | Time period over which the stats were taken for the advertiser. |
| HStatsByAudienceTZ | String | Time period over which the stats were taken for the audience. |
| ImpressionDevice | String | The devices used to view the Ad. |
| PlatformPosition | String | The position on the platform. |
| PublisherPlatform | String | The platforms the ads were published on. |
| ProductId | String | The product Id advertised in the Ad. |
| Action Breakdowns | |||
| ActionType | String | The kind of actions taken on your ad after your ad was served to someone, even if they didn't click it. | |
| ActionCanvasComponentName | String | Name of a component within a Canvas ad. | |
| ActionCarouselCardId | String | The ID of the specific carousel card that people engaged with when they saw your ad. | |
| ActionCarouselCardName | String | The specific carousel card that people engaged with when they saw your ad. The cards are identified by their headlines. | |
| ActionDestination | String | The destination where people go after clicking on your ad. | |
| ActionDevice | String | The device on which the conversion event you are tracking occurred. | |
| ActionReaction | String | The number of reactions on your ads or boosted posts. | |
| ActionTargetId | String | The id of destination where people go after clicking on your ad. | |
| ActionVideoSound | String | The sound status (on/off) when user watches your video ad. | |
| ActionVideoType | String | Video metrics breakdown. | |
| ActionConvertedProductId | String | Converted product ids - for Collaborative Ads. | |
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2026-02-18 UTC.