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.
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.
