Facebook Ads report transformation

This document describes how your Facebook Ads reports are transformed when you run a Facebook Ads transfer to BigQuery .

Table mapping for Facebook Ads reports

When your Facebook Ads reports are transferred to BigQuery, the reports are transformed into the following BigQuery 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 actions people have taken in response to your ad. For a full list of action collections, see Action 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 at ad .
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.

The Facebook Ads plans to update this data type mapping. For more information, see July 25, 2026 .
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.

AdInsightsMMM report

Meta API field name Mapped BigQuery field name Type Description
Target String The ID of the Account to get insights for.
TimeIncrement String The number of days of data aggregation.
account_id
AccountId String The ID of the Ad Account associated with the row.
campaign_id
CampaignId String The ID of the Campaign associated with the row.
adset_id
AdSetId String The ID of the Ad Set associated with the row.
date_start
DateStart Date The starting date for insights retrieval.
date_stop
DateEnd Date The ending date for insights retrieval.
impressions
Impressions Long The number of times the ad was served.
spend
Spend Decimal The total amount spent.
country
Country String The country for the metrics.
region
Region String The region from which the ad was viewed.
dma
DMA String The Designated Market Area for the metrics.
device_platform
DevicePlatform String The platform of the device used.
platform_position
PlatformPosition String The position on the platform.
publisher_platform
PublisherPlatform String The publisher platform.
creative_media_type
CreativeMediaType String The type of media used in the creative.

Ads report

Meta API field name Mapped BigQuery field name Type Description
id
ID String The ID of the Ad.
Target String The target field used to retrieve the ad.
name
Name String The name of the Ad.
status
AdStatus String The status of the Ad.
bid_info
BidInfo String Bid information associated with the Ad.
bid_type
BidType String Bid type associated with the Ad.
campaign_id
CampaignId String The ID of the campaign.
adset_id
AdSetId String The ID of the ad set.
creative
AdCreativeId String The ID of the ad creative.
configured_status
ConfiguredStatus String The configured status of the Ad.
created_time
CreatedTime Datetime The creation time of the Ad.
updated_time
UpdatedTime Datetime The last update time of the Ad.
conversion_specs
ConversionSpecs String Conversion specifications.
failed_delivery_checks
FailedDeliveryChecks String Information regarding failed delivery checks.
recommendations
Recommendations String Recommendations for the Ad.
tracking_specs
TrackingSpecs JSON Tracking specifications.
ad_active_time
AdActiveTime String Active time parameters.
ad_schedule_end_time
AdScheduleEndTime Datetime Scheduled end time.
ad_schedule_start_time
AdScheduleStartTime Datetime Scheduled start time.
bid_amount
BidAmount Integer The bid amount.
last_updated_by_app_id
LastUpdatedByAppId String App ID that last updated the ad.
preview_shareable_link
PreviewShareableLink String Shareable preview link.
source_ad_id
SourceAdId String The source Ad ID.

AdCreatives report

Meta API field name Mapped BigQuery field name Type Description
id
ID String The ID of the ad creative.
Target String The target field.
name
Name String The name of the creative.
applink_treatment
ApplinkTreatment String Deep link treatment for the ad creative.
body
Body String The body text of the ad block.
call_to_action_type
CallToActionType String Type of call to action.
effective_instagram_media_id
EffectiveInstagramMediaId String Effective ID of the Instagram media.
image_hash
ImageHash String The hash of the associated image.
image_url
ImageUrl String The URL to the creative image.
instagram_permalink_url
InstagramPermalinkUrl String Permalink URL for Instagram.
instagram_user_id
InstagramUserId String Instagram user ID.
link_og_id
LinkOgId String Open Graph ID of the link.
link_url
LinkUrl String The landing page URL.
object_id
ObjectId String The associated object ID.
object_story_id
ObjectStoryId String Object story ID.
object_type
ObjectType String The type of the object.
object_url
ObjectUrl String URL of the object.
page_id
PageId String The associated Facebook Page ID.
product_set_id
ProductSetId String Product set ID.
run_status
RunStatus String The run status of the creative.
source_instagram_media_id
SourceInstagramMediaId String Source Instagram media ID.
template_url
TemplateUrl String Template URL.
thumbnail_url
ThumbnailUrl String Thumbnail URL.
title
Title String The title text of the ad creative.
url_tags
UrlTags String URL tags parameters.
adlabels
AdLabels String Labels associated with the creative.
object_story_spec.link_data
ObjectStorySpecLinkData JSON Link data specification.
object_story_spec.photo_data
ObjectStorySpecPhotoData JSON Photo data specification.
object_story_spec.video_data
ObjectStorySpecVideoData JSON Video data specification.
object_story_spec.text_data
ObjectStorySpecTextData JSON Text data specification.
object_story_spec.template_data
ObjectStorySpecTemplateData JSON Template data specification.

AdSets report

Meta API field name Mapped BigQuery field name Type Description
id
ID String The ID of the Ad Set.
Target String The target field.
name
Name String The name of the Ad Set.
budget_remaining
BudgetRemaining Integer The remaining budget.
campaign_id
CampaignId String The associated Campaign ID.
status
AdSetStatus String The Ad Set status.
billing_event
BillingEvent String Billing event criteria.
created_time
CreatedTime Datetime Ad Set creation time.
daily_budget
DailyBudget Integer The daily budget limit.
lifetime_budget
LifetimeBudget Integer The lifetime budget limit.
end_time
EndTime Datetime Scheduled end time.
start_time
StartTime Datetime Scheduled start time.
updated_time
UpdatedTime Datetime Time when the Ad Set was last updated.
recommendations
Recommendations String Recommendations for the Ad Set.
targeting.genders
TargetingGenders String Targeted genders.
targeting.age_max
TargetingAgeMax Integer Targeted maximum age.
targeting.age_min
TargetingAgeMin Integer Targeted minimum age.
targeting.countries
TargetingCountries String Targeted countries.
targeting.location_types
TargetingLocationTypes String Targeted location types.
targeting.regions
TargetingRegions String Targeted regions or states.
targeting.cities
TargetingCities String Targeted cities.
targeting.zips
TargetingZips String Targeted zip codes.
targeting.custom_locations
TargetingCustomLocations String Targeted custom locations.
targeting.geo_markets
TargetingGeoMarkets String Targeted geographic markets.
targeting.interests
TargetingInterests String Targeted personal interests.
targeting.behaviors
TargetingBehaviors String Targeted user behaviors.
targeting.device_platforms
TargetingDevicePlatforms String Targeted platforms.
targeting.publisher_platforms
TargetingPublisherPlatforms String Targeted publisher platforms.
targeting.instagram_positions
TargetingInstagramPositions String Targeted Instagram placement positions.
targeting.page_types
TargetingPageTypes String Targeted page types.
learning_stage_info.status
LearningStageInfoStatus String Status of the learning stage.
learning_stage_info.conversions
LearningStageInfoConversions Integer Conversions during the learning stage.
learning_stage_info.attribution_windows
LearningStageInfoAttributionWindows String Attribution windows for learning stage.
learning_stage_info.last_sig_edit_time
LearningStageInfoLastSigEditTime Datetime Last significant edit time in learning phase.

Campaigns report

Meta API field name Mapped BigQuery field name Type Description
id
ID String The ID of the Campaign.
Target String The target field.
name
Name String The name of the Campaign.
buying_type
BuyingType String The buying type.
configured_status
ConfiguredStatus String The configured status.
effective_status
EffectiveStatus String The effective status.
status
Status String The current status of the Campaign.
created_time
CreatedTime Datetime Creation time.
objective
Objective String The selected campaign objective.
spend_cap
SpendCap Integer The maximum lifetime spending cap.
daily_budget
DailyBudget Integer The daily budget.
budget_remaining
BudgetRemaining Integer The remaining budget for the campaign.
lifetime_budget
LifetimeBudget Integer The total lifetime budget.
bid_strategy
BidStrategy String The strategy used for bidding.
start_time
StartTime Datetime Scheduled start time.
stop_time
StopTime Datetime Scheduled stop/end time.
updated_time
UpdatedTime Datetime Last updated time.
boosted_object_id
BoostedObjectId String The ID of any boosted object.

AdImages report

Meta API field name Mapped BigQuery field name Type Description
id
ID String The ID of the image.
Target String Target field.
account_id
AccountId String Ad account ID owning the image.
created_time
CreatedTime Datetime Creation time of the image.
hash
hash String Unique hash of the image content.
height
height Integer Height of the image in pixels.
width
width Integer Width of the image in pixels.
creatives
AssociatedWithCreatives String Associated creatives info.
name
name String Name identifier for the image.
original_height
OriginalHeight Integer Original uploaded height.
original_width
OriginalWidth Integer Original uploaded width.
status
Status String Validation status of the image.
permalink_url
PermalinkUrl String URL pointing to the image permalink.

AdLabels report

Meta API field name Mapped BigQuery field name Type Description
id
ID String The ID of the ad label.
Target String Target field.
name
Name String The display name of the label.
created_time
CreatedTime Datetime Time the label was created.
updated_time
UpdatedTime Datetime Time the label was last updated.

Businesses report

Meta API field name Mapped BigQuery field name Type Description
id
ID String The ID of the business.
name
Name String The name of the business.
primary_page
PrimaryPage String Primary page associated with the business.
timezone_id
TimezoneId String Timezone identifier for the business.
link
Link String Link to the business profile.
created_time
CreatedTime Datetime Business creation time.
updated_time
UpdatedTime Datetime Last updated time.

CustomAudiences report

Meta API field name Mapped BigQuery field name Type Description
id
ID String The ID of the custom audience.
Target String The target field.
account_id
AccountID String The ad account ID mapped from Account_ID.
name
Name String The name of the custom audience.
description
Description String Description of the audience.
subtype
Subtype String Subtype category of the audience.
time_created
TimeCreated Datetime Audience creation time.
time_updated
TimeUpdated Datetime Audience last updated time.
time_content_updated
TimeContentUpdated Datetime Time when audience content was last modified.
rule
Rule String Rules used to govern audience membership.
rule_aggregation
RuleAggregation String Aggregation setting for audience rules.
approximate_count_lower_bound
ApproximateCountLowerBound Integer Lower bound approximation for audience size.
approximate_count_upper_bound
ApproximateCountUpperBound Integer Upper bound approximation for audience size.
pixel_id
PixelID String Associated pixel ID.
retention_days
RetentionDays Integer Number of days members are retained.
customer_file_source
CustomerFileSource String The original source of the customer file.
data_source
DataSource JSON Primary data source.
delivery_status
DeliveryStatus JSON Current delivery status.
operation_status
OperationStatus JSON Status of recent operations.
permission_for_actions
PermissionForActions JSON Permissions for actions.
is_value_based
IsValueBased Boolean Flag indicating if audience is value based.
opt_out_link
OptOutLink String Opt out link.
Create a Mobile Website
View Site in Mobile | Classic
Share by: