Advertising

combined

ads_attributes

name	type	description	values
campaign_x_id	INT64	The universal ID of the campaign.
ad_x_id	INT64	The universal ID of the ad.
ad_group_x_id	INT64	The universal ID of the adgroup.
account_x_id	INT64	The universal ID of the account_id.
video_id	STRING	URL for a thumbnail image for this ad creative.
place_page_set_id	STRING	The ID of the page set for this creative.
object_story_id	STRING	ID of a Facebook Page post to use in an ad.
instagram_story_id	STRING	Used for Instagram Stories as Ads. Specifies the Instagram story you want to run as an ad.
branded_content_sponsor_page_id	STRING	ID for page representing business which runs Branded Content ads.
ad_id	STRING	The ID of the ad.
actor_id	STRING	The actor ID (Page ID) of the creative
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
tracking_template	STRING	The current tracking template for the campaign.
title	STRING	URL for a thumbnail image for this ad creative.
thumbnail_url	STRING	URL for a thumbnail image for this ad creative.
text_ad_description2	STRING	The second line of the ad's description.
text_ad_description1	STRING	The first line of the ad's description.
template_url	STRING	Used for Dynamic Ads when you want to use third-party click tracking.
report_level	STRING	The report level (account, campaign, ad_group, ad, keyword, search_term or placement).
reach	FLOAT64	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.
objective	STRING	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.
object_type	STRING	The type of Facebook object you want to advertise.
link_url	STRING	Identify a specific landing tab on your Facebook page by the Page tab's URL.
instagram_permalink_url	STRING	URL for a post on Instagram you want to run as an ad. Also known as Instagram media.
image_url	STRING	A URL for the image for this creative. We save the image at this URL to the ad account's image library.
image_ad_preview_image_url	STRING	URL of the preview size image.
headline	STRING	The shorter of two possible responsive ad headlines for Audience campaigns.
frequency	FLOAT64	The average number of times each person saw your ad. This metric is estimated.
final_url	STRING	The Final URL of the ad, keyword, or criterion.
expanded_text_ad_description2	STRING	The second description of the ad.
expanded_text_ad_description	STRING	The description of the ad.
effective_authorization_category	STRING	Specifies whether ad is a political ad or not.
display_url	STRING	The URL that appears in the ad description for some ad formats.
destination_url	STRING	The destination URL attribute of the ad, keyword, or ad group criterion.
category_media_source	STRING	The Dynamic Ad's rendering mode for category ads
categorization_criteria	STRING	The Dynamic Category Ad's categorization field.
call_to_action_type	STRING	Type of call to action button in your ad. This determines the button text and header text for your ad.
body	STRING	The body of the ad.
average_position	FLOAT64	The average position of the ad on a webpage.
ad_type	STRING	The type of the ad.
ad_strength	STRING	Overall ad strength for this ad group ad.
ad_status	STRING	The status of the ad.
ad_distribution	STRING	The network where you want your ads to show.
ad_description2	STRING	The second ad description that appears below the path in your ad. Ad description 2 might not appear in your ad.
ad_description	STRING	The first ad description that appears below the path in your ad.
ad	STRING	The name of the ad.

ad_group_attributes

name	type	description	values
campaign_x_id	INT64	The universal ID of the campaign.
ad_group_x_id	INT64	The universal ID of the adgroup.
account_x_id	INT64	The universal ID of the account_id.
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
top_impression_share_percent	FLOAT64	The percentage of impressions for your ad in the mainline, the top ad placements above the search results, out of the estimated number of mainline impressions you were eligible to receive.
report_level	STRING	The report level (account, campaign, ad_group, ad, keyword, search_term or placement).
reach	FLOAT64	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.
quality_score	FLOAT64	The numeric score shows you how competitive your ads are in the marketplace by measuring how relevant your keywords and landing pages are to customers' search terms.
objective	STRING	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.
landing_page_experience	FLOAT64	An aggregate quality assessment of all landing pages on your site. The landing page experience score measures whether your landing page is likely to provide a good experience to customers who click your ad and land on your website.
impression_share_percent	FLOAT64	The estimated percentage of impressions, out of the total available impressions in the market you were targeting.
historical_quality_score	FLOAT64	The historical quality score for each row is the value that was calculated for quality score on that date.
historical_landing_page_experience	FLOAT64	Historical average of landing page experience scores back as far as 18 months from the current date.
historical_ad_relevance	FLOAT64	Historical average of ad relevance scores back as far as 18 months from the current date.
frequency	FLOAT64	The average number of times each person saw your ad. This metric is estimated.
exact_match_impression_share_percent	FLOAT64	The estimated percentage of impressions that your account received for searches that exactly matched your keyword, out of the total available exact match impressions you were eligible to receive.
average_position	FLOAT64	The average position of the ad on a webpage.
ad_relevance	FLOAT64	How closely related your ads is to the customer's search query or other input. It tells you how relevant your ad and landing page are to potential customers.
ad_group_type	STRING	The type of the ad_group.
ad_group_status	STRING	The status of the ad_group.

campaigns

This report combines performance data from different digital marketing services in ad_group level.

name	type	description	values
device_x_id	INT64	The universal ID of the device type.
campaign_x_id	INT64	The universal ID of the campaign.
ad_group_x_id	INT64	The universal ID of the adgroup.
account_x_id	INT64	The universal ID of the account_id.
video_views	FLOAT64
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
unique_clicks	FLOAT64	The number of people who performed a click (all).
report_level	STRING	The report level (account, campaign, ad_group, ad, keyword, search_term or placement).
is_marketing_related	INT64	If expense is marketing related and should be used in marketing related metrics like CPA, CPC etc.
impressions	FLOAT64	The number of impressions.
date	TIMESTAMP	The date (yyyy-MM-dd).
currency_converted	STRING	Preferred currency (user settings)
currency	STRING	The currency of the account.
cost_converted	NUMERIC	The amount of money spend in preferred currency (user settings)
cost	FLOAT64	The amount of money spend.
conversions_value	FLOAT64	The value of conversions. This only includes conversions specified by the user in service platform.
conversions	FLOAT64	The number of conversions. This only includes conversions specified by the user in service platform.
clicks	FLOAT64	The number of clicks.
campaign	STRING	The name of the campaign.
all_conversions_value	FLOAT64	The value of all conversions.
all_conversions	FLOAT64	The total number of conversions.
ad_group_type	STRING	The type of the ad_group.

campaign_conversions

This report combines conversion data from different digital marketing services in ad_group level.

name	type	description	values
device_x_id	INT64	The universal ID of the device type.
conversion_x_id	INT64	The universal ID of the conversion name.
campaign_x_id	INT64	The universal ID of the campaign.
ad_group_x_id	INT64	The universal ID of the adgroup.
account_x_id	INT64	The universal ID of the account_id.
value	FLOAT64	The total value of all conversions attributed to the ads.
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
report_level	STRING	The report level (account, campaign, ad_group, ad, keyword, search_term or placement).
n_7d_view	FLOAT64	An attribution window for the actions. This window includes all actions that happened 7 days after someone viewed the ad.
n_7d_click	FLOAT64	An attribution window for the actions. This window includes all actions that happened 7 days after someone clicked on the ad.
n_28d_view	FLOAT64	An attribution window for the actions. This window includes all actions that happened 28 days after someone viewed the ad.
n_28d_click	FLOAT64	An attribution window for the actions. This window includes all actions that happened 28 days after someone clicked on the ad.
n_1d_view	FLOAT64	An attribution window for the actions. This window includes all actions that happened 1 day after someone viewed the ad.
n_1d_click	FLOAT64	An attribution window for the actions. This window includes all actions that happened 1 day after someone clicked on the ad.
external_website_post_view_conversions	FLOAT64	Total number of times users took a desired action after seeing your ad.
external_website_post_click_conversions	FLOAT64	Total number of times users took a desired action after clicking on your ad.
external_website_conversions	FLOAT64	Total number of times users took a desired action after clicking on or seeing your ad.
date	TIMESTAMP	The date (yyyy-MM-dd).
conversions_value	FLOAT64	The value of conversions. This only includes conversions specified by the user in service platform.
conversions	FLOAT64	The number of conversions. This only includes conversions specified by the user in service platform.
all_conversions_value	FLOAT64	The value of all conversions.
all_conversions	FLOAT64	The total number of conversions.

ads

This report combines performance data from different digital marketing services in ad level.

name	type	description	values
device_x_id	INT64	The universal ID of the device type.
campaign_x_id	INT64	The universal ID of the campaign.
ad_x_id	INT64	The universal ID of the ad.
ad_group_x_id	INT64	The universal ID of the adgroup.
account_x_id	INT64	The universal ID of the account_id.
video_views	FLOAT64	The number of times your video ads were viewed.
video_quartile_p75_rate	FLOAT64	Percentage of impressions where the viewer watched 75% of your video.
video_quartile_p50_rate	FLOAT64	Percentage of impressions where the viewer watched 25% of your video.
video_quartile_p25_rate	FLOAT64	Percentage of impressions where the viewer watched 25% of your video.
video_quartile_p100_rate	FLOAT64	Percentage of impressions where the viewer watched all of your video.
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
unique_clicks	FLOAT64	The number of people who performed a click (all).
report_level	STRING	The report level (account, campaign, ad_group, ad, keyword, search_term or placement).
impressions	FLOAT64	The number of impressions.
date	TIMESTAMP	The date (yyyy-MM-dd).
currency_converted	STRING	Preferred currency (user settings)
currency	STRING	The currency of the account.
cost_converted	NUMERIC	The amount of money spend in preferred currency (user settings)
cost	FLOAT64	The amount of money spend.
clicks	FLOAT64	The number of clicks.
ad_strength	STRING	Overall ad strength for this ad group ad.

ads_conversions

name	type	description	values
device_x_id	INT64	The universal ID of the device type.
conversion_x_id	INT64	The universal ID of the conversion name.
campaign_x_id	INT64	The universal ID of the campaign.
ad_x_id	INT64	The universal ID of the ad.
ad_group_x_id	INT64	The universal ID of the adgroup.
account_x_id	INT64	The universal ID of the account_id.
value	FLOAT64	The total value of all conversions attributed to the ads.
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
report_level	STRING	The report level (account, campaign, ad_group, ad, keyword, search_term or placement).
n_7d_view	FLOAT64	An attribution window for the actions. This window includes all actions that happened 7 days after someone viewed the ad.
n_7d_click	FLOAT64	An attribution window for the actions. This window includes all actions that happened 7 days after someone clicked on the ad.
n_28d_view	FLOAT64	An attribution window for the actions. This window includes all actions that happened 28 days after someone viewed the ad.
n_28d_click	FLOAT64	An attribution window for the actions. This window includes all actions that happened 28 days after someone clicked on the ad.
n_1d_view	FLOAT64	An attribution window for the actions. This window includes all actions that happened 1 day after someone viewed the ad.
n_1d_click	FLOAT64	An attribution window for the actions. This window includes all actions that happened 1 day after someone clicked on the ad.
date	TIMESTAMP	The date (yyyy-MM-dd).
conversions_value	FLOAT64	The value of conversions. This only includes conversions specified by the user in service platform.
conversions	FLOAT64	The number of conversions. This only includes conversions specified by the user in service platform.
all_conversions_value	FLOAT64	The value of all conversions.
all_conversions	FLOAT64	The total number of conversions.

attributes

name	type	description	values
campaign_x_id	INT64	The universal ID of the campaign.
ad_x_id	INT64	The universal ID of the ad.
ad_group_x_id	INT64	The universal ID of the adgroup.
account_x_id	INT64	The universal ID of the account_id.
video_id	STRING	URL for a thumbnail image for this ad creative.
place_page_set_id	STRING	The ID of the page set for this creative.
object_story_id	STRING	ID of a Facebook Page post to use in an ad.
instagram_story_id	STRING	Used for Instagram Stories as Ads. Specifies the Instagram story you want to run as an ad.
branded_content_sponsor_page_id	STRING	ID for page representing business which runs Branded Content ads.
ad_id	STRING	The ID of the ad.
actor_id	STRING	The actor ID (Page ID) of the creative
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
unit_cost_amount	STRING	Amount to bid (for manual bidding) or amount which is the target cost (for target cost bidding) per click, impression, or other event depending on the pricing model. The amount of money as a real number string.
tracking_url_template	STRING	The URL template for constructing a tracking URL.
tracking_template	STRING	The current tracking template for the campaign.
top_impression_share_percent	FLOAT64	The percentage of impressions for your ad in the mainline, the top ad placements above the search results, out of the estimated number of mainline impressions you were eligible to receive.
title	STRING	URL for a thumbnail image for this ad creative.
thumbnail_url	STRING	URL for a thumbnail image for this ad creative.
text_ad_description2	STRING	The second line of the ad's description.
text_ad_description1	STRING	The first line of the ad's description.
template_url	STRING	Used for Dynamic Ads when you want to use third-party click tracking.
start_date	TIMESTAMP	The date when campaign started.
serving_status	STRING	The ad serving status of the campaign
report_level	STRING	The report level (account, campaign, ad_group, ad, keyword, search_term or placement).
reach	FLOAT64	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.
quality_score	FLOAT64	The numeric score shows you how competitive your ads are in the marketplace by measuring how relevant your keywords and landing pages are to customers' search terms.
optimization_target_type	STRING	Determines how this campaign is optimized for spending. If this is not set, there is no optimization.
offsite_delivery_enabled	STRING	A flag which indicates whether or not the campaign is delivered off network.
objective_type	STRING	Campaign Objective type values.
objective	STRING	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.
object_type	STRING	The type of Facebook object you want to advertise.
locale_language	STRING	Locale of the campaign. A lowercase two-letter language code as defined by ISO-639.
locale_country	STRING	Locale of the campaign. An uppercase two-letter country code as defined by ISO-3166.
link_url	STRING	Identify a specific landing tab on your Facebook page by the Page tab's URL.
lifetime_budget	FLOAT64	Maximum amount to spend on this campaign.
last_modified_at	TIMESTAMP	The timestamp that record was last modified, in source_service.
landing_page_experience	FLOAT64	An aggregate quality assessment of all landing pages on your site. The landing page experience score measures whether your landing page is likely to provide a good experience to customers who click your ad and land on your website.
instagram_permalink_url	STRING	URL for a post on Instagram you want to run as an ad. Also known as Instagram media.
impression_share_percent	FLOAT64	The estimated percentage of impressions, out of the total available impressions in the market you were targeting.
image_url	STRING	A URL for the image for this creative. We save the image at this URL to the ad account's image library.
image_ad_preview_image_url	STRING	URL of the preview size image.
historical_quality_score	FLOAT64	The historical quality score for each row is the value that was calculated for quality score on that date.
historical_landing_page_experience	FLOAT64	Historical average of landing page experience scores back as far as 18 months from the current date.
historical_ad_relevance	FLOAT64	Historical average of ad relevance scores back as far as 18 months from the current date.
headline	STRING	The shorter of two possible responsive ad headlines for Audience campaigns.
frequency	FLOAT64	The average number of times each person saw your ad. This metric is estimated.
format	STRING	The ad format on campaign level.
form_completion_rate	FLOAT64	The number of leads generated divided by form impressions
final_url	STRING	The Final URL of the ad, keyword, or criterion.
expanded_text_ad_description2	STRING	The second description of the ad.
expanded_text_ad_description	STRING	The description of the ad.
exact_match_impression_share_percent	FLOAT64	The estimated percentage of impressions that your account received for searches that exactly matched your keyword, out of the total available exact match impressions you were eligible to receive.
end_date	TIMESTAMP	The last day of the campaign.
effective_authorization_category	STRING	Specifies whether ad is a political ad or not.
display_url	STRING	The URL that appears in the ad description for some ad formats.
destination_url	STRING	The destination URL attribute of the ad, keyword, or ad group criterion.
daily_budget_currency_code	STRING	ISO currency code. The currency must match that of the parent account.
daily_budget_amount	FLOAT64	Maximum amount to spend per day UTC. The amount of money as a real number string.
daily_budget	FLOAT64	Maximum amount to spend per day.
custom_parameters	STRING	The current set of custom parameters for the campaign.
currency	STRING	The currency of the account.
creative_selection	STRING	Optimization strategy of ads/creatives in rotation that better deliver on the advertiser’s objective.
created_at	TIMESTAMP	The timestamp that record was created, in source_service.
cost_type	STRING	Pricing Model used for the ads/creatives.
category_media_source	STRING	The Dynamic Ad's rendering mode for category ads
categorization_criteria	STRING	The Dynamic Category Ad's categorization field.
campaign_type	STRING	The type of the campaign.
campaign_sub_type	STRING	Optional refinement to advertising_channel_type
campaign_status	STRING	The status of the campaign.
campaign_group	STRING	URN identifying the campaign group associated with the campaign.
call_to_action_type	STRING	Type of call to action button in your ad. This determines the button text and header text for your ad.
budget_name	STRING	The name of the budget. This column will be empty for unshared budgets.
budget_amount_micros	FLOAT64	The amount of the budget, in the local currency for the account.
budget_amount	FLOAT64	The amount of the budget, in the local currency for the campaign.
body	STRING	The body of the ad.
bidding_strategy_type	STRING	The type of bidding strategy
bid_match_type	STRING	The keyword bid match type.
average_position	FLOAT64	The average position of the ad on a webpage.
audience_expansion_enabled	STRING	Enable Audience Expansion for the campaign provides query expansion for certain targeting criteria.
associated_entity	STRING	An URN identifying the intended beneficiary of the advertising campaign such as a specific company or member
ad_type	STRING	The type of the ad.
ad_strength	STRING	Overall ad strength for this ad group ad.
ad_status	STRING	The status of the ad.
ad_relevance	FLOAT64	How closely related your ads is to the customer's search query or other input. It tells you how relevant your ad and landing page are to potential customers.
ad_group_type	STRING	The type of the ad_group.
ad_group_status	STRING	The status of the ad_group.
ad_distribution	STRING	The network where you want your ads to show.
ad_description2	STRING	The second ad description that appears below the path in your ad. Ad description 2 might not appear in your ad.
ad_description	STRING	The first ad description that appears below the path in your ad.
ad	STRING	The name of the ad.

conversions

This report combines conversions data from different digital marketing services in ad_group,ad,keyword and search term levels.

name	type	description	values
query_x_id	INT64	The universal ID of the search_term.
landing_page_x_id	INT64	The universal ID of the landing page.
keyword_x_id	INT64	The universal ID of the keyword.
device_x_id	INT64	The universal ID of the device type.
conversion_x_id	INT64	The universal ID of the conversion name.
campaign_x_id	INT64	The universal ID of the campaign.
ad_x_id	INT64	The universal ID of the ad.
ad_group_x_id	INT64	The universal ID of the adgroup.
account_x_id	INT64	The universal ID of the account_id.
value	FLOAT64	The total value of all conversions attributed to the ads.
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
report_level	STRING	The report level (account, campaign, ad_group, ad, keyword, search_term or placement).
n_7d_view	FLOAT64	An attribution window for the actions. This window includes all actions that happened 7 days after someone viewed the ad.
n_7d_click	FLOAT64	An attribution window for the actions. This window includes all actions that happened 7 days after someone clicked on the ad.
n_28d_view	FLOAT64	An attribution window for the actions. This window includes all actions that happened 28 days after someone viewed the ad.
n_28d_click	FLOAT64	An attribution window for the actions. This window includes all actions that happened 28 days after someone clicked on the ad.
n_1d_view	FLOAT64	An attribution window for the actions. This window includes all actions that happened 1 day after someone viewed the ad.
n_1d_click	FLOAT64	An attribution window for the actions. This window includes all actions that happened 1 day after someone clicked on the ad.
impressions	FLOAT64	The number of impressions.
external_website_post_view_conversions	FLOAT64	Total number of times users took a desired action after seeing your ad.
external_website_post_click_conversions	FLOAT64	Total number of times users took a desired action after clicking on your ad.
external_website_conversions	FLOAT64	Total number of times users took a desired action after clicking on or seeing your ad.
date	TIMESTAMP	The date (yyyy-MM-dd).
conversions_value	FLOAT64	The value of conversions. This only includes conversions specified by the user in service platform.
conversions	FLOAT64	The number of conversions. This only includes conversions specified by the user in service platform.
conversion_value_in_local_currency	FLOAT64	Non-demographic pivots only. Value of the conversions in the account's local currency based on rules defined by the advertiser. Conversion value is set by the advertiser at a per conversion level, and aggregated across the query time range.
all_conversions_value	FLOAT64	The value of all conversions.
all_conversions	FLOAT64	The total number of conversions.

facebook_reach

name	type	description	values
campaign_x_id	INT64	The universal ID of the campaign.
ad_group_x_id	INT64	The universal ID of the adgroup.
account_x_id	INT64	The universal ID of the account_id.
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
report_level	STRING	The report level (account, campaign, ad_group, ad, keyword, search_term or placement).
reach	FLOAT64	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.
frequency	FLOAT64	The average number of times each person saw your ad. This metric is estimated.
date_stop	TIMESTAMP	The end date for your data. This is controlled by the date range you've selected for your reporting view.
date	TIMESTAMP	The date (yyyy-MM-dd).

keywords

This report combines performance data from different digital marketing services in keyword level.

name	type	description	values
landing_page_x_id	INT64	The universal ID of the landing page.
keyword_x_id	INT64	The universal ID of the keyword.
device_x_id	INT64	The universal ID of the device type.
campaign_x_id	INT64	The universal ID of the campaign.
ad_x_id	INT64	The universal ID of the ad.
ad_group_x_id	INT64	The universal ID of the adgroup.
account_x_id	INT64	The universal ID of the account_id.
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
top_impression_percentage	FLOAT64	The percent of your ad impressions that are shown anywhere above the organic search results.
search_rank_lost_impression_share	FLOAT64	The estimated percentage of impressions on the Search Network that your ads didn't receive due to poor Ad Rank.
search_impression_share	FLOAT64	The impressions you've received on the Search Network divided by the estimated number of impressions you were eligible to receive.
search_exact_match_impression_share	FLOAT64	The impressions you've received divided by the estimated number of impressions you were eligible to receive on the Search Network for search terms that matched your keywords exactly (or were close variants of your keyword), regardless of your keyword match types.
search_click_share	FLOAT64	The number of clicks you've received on the Search Network divided by the estimated number of clicks you were eligible to receive.
report_level	STRING	The report level (account, campaign, ad_group, ad, keyword, search_term or placement).
impressions	FLOAT64	The number of impressions.
date	TIMESTAMP	The date (yyyy-MM-dd).
currency_converted	STRING	Preferred currency (user settings)
currency	STRING	The currency of the account.
cost_converted	NUMERIC	The amount of money spend in preferred currency (user settings)
cost	FLOAT64	The amount of money spend.
clicks	FLOAT64	The number of clicks.

performance

name	type	description	values
query_x_id	INT64	The universal ID of the search_term.
landing_page_x_id	INT64	The universal ID of the landing page.
keyword_x_id	INT64	The universal ID of the keyword.
device_x_id	INT64	The universal ID of the device type.
campaign_x_id	INT64	The universal ID of the campaign.
ad_x_id	INT64	The universal ID of the ad.
ad_group_x_id	INT64	The universal ID of the adgroup.
account_x_id	INT64	The universal ID of the account_id.
video_views	FLOAT64
video_quartile_p75_rate	FLOAT64	Percentage of impressions where the viewer watched 75% of your video.
video_quartile_p50_rate	FLOAT64	Percentage of impressions where the viewer watched 25% of your video.
video_quartile_p25_rate	FLOAT64	Percentage of impressions where the viewer watched 25% of your video.
video_quartile_p100_rate	FLOAT64	Percentage of impressions where the viewer watched all of your video.
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
unique_clicks	FLOAT64	The number of people who performed a click (all).
top_impression_percentage	FLOAT64	The percent of your ad impressions that are shown anywhere above the organic search results.
spend_micros	FLOAT64
search_rank_lost_impression_share	FLOAT64	The estimated percentage of impressions on the Search Network that your ads didn't receive due to poor Ad Rank.
search_impression_share	FLOAT64	The impressions you've received on the Search Network divided by the estimated number of impressions you were eligible to receive.
search_exact_match_impression_share	FLOAT64	The impressions you've received divided by the estimated number of impressions you were eligible to receive on the Search Network for search terms that matched your keywords exactly (or were close variants of your keyword), regardless of your keyword match types.
search_click_share	FLOAT64	The number of clicks you've received on the Search Network divided by the estimated number of clicks you were eligible to receive.
report_level	STRING	The report level (account, campaign, ad_group, ad, keyword, search_term or placement).
is_marketing_related	INT64	If expense is marketing related and should be used in marketing related metrics like CPA, CPC etc.
impressions	FLOAT64	The number of impressions.
date	TIMESTAMP	The date (yyyy-MM-dd).
currency_converted	STRING	Preferred currency (user settings)
currency	STRING	The currency of the account.
cost_in_usd	FLOAT64	Cost in USD based on the pivot and timeGranularity.
cost_converted	NUMERIC	The amount of money spend in preferred currency (user settings)
cost	FLOAT64	The amount of money spend.
conversions_value	FLOAT64	The value of conversions. This only includes conversions specified by the user in service platform.
conversions	FLOAT64	The number of conversions. This only includes conversions specified by the user in service platform.
clicks	FLOAT64	The number of clicks.
campaign	STRING	The name of the campaign.
all_conversions_value	FLOAT64	The value of all conversions.
all_conversions	FLOAT64	The total number of conversions.
ad_strength	STRING	Overall ad strength for this ad group ad.
ad_group_type	STRING	The type of the ad_group.

queries_paid

This report combines performance data from different digital marketing services in search term level.

name	type	description	values
query_x_id	INT64	The universal ID of the search_term.
landing_page_x_id	INT64	The universal ID of the landing page.
keyword_x_id	INT64	The universal ID of the keyword.
device_x_id	INT64	The universal ID of the device type.
campaign_x_id	INT64	The universal ID of the campaign.
ad_x_id	INT64	The universal ID of the ad.
ad_group_x_id	INT64	The universal ID of the adgroup.
account_x_id	INT64	The universal ID of the account_id.
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
report_level	STRING	The report level (account, campaign, ad_group, ad, keyword, search_term or placement).
impressions	FLOAT64	The number of impressions.
date	TIMESTAMP	The date (yyyy-MM-dd).
currency_converted	STRING	Preferred currency (user settings)
currency	STRING	The currency of the account.
cost_converted	NUMERIC	The amount of money spend in preferred currency (user settings)
cost	FLOAT64	The amount of money spend.
clicks	FLOAT64	The number of clicks.

facebook_ads

facebook_ads_account_reach_monthly

It contains facebook ads account reach, frequency metrics in monthly level. Learn more.

name	type	description	values
reach	NUMERIC	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.
frequency	NUMERIC	The average number of times each person saw your ad. This metric is estimated.
date_stop	DATE	The end date for your data. This is controlled by the date range you've selected for your reporting view.
date	DATE	The date (yyyy-MM-dd). The start date for your data. This is controlled by the date range you've selected for your reporting view.

facebook_ads_ad_set_reach_monthly

It contains facebook ads adset reach, frequency metrics in monthly level. Learn more.

name	type	description	values
campaign_x_id	INT	The universal ID of the campaign.
ad_group_x_id	INT	The universal ID of the adgroup.
reach	NUMERIC	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.
frequency	NUMERIC	The average number of times each person saw your ad. This metric is estimated.
date_stop	DATE	The end date for your data. This is controlled by the date range you've selected for your reporting view.
date	DATE	The date (yyyy-MM-dd). The start date for your data. This is controlled by the date range you've selected for your reporting view.

facebook_ads_campaign_reach_monthly

It contains facebook ads campaign reach, frequency metrics in monthly level. Learn more.

name	type	description	values
campaign_x_id	INT	The universal ID of the campaign.
reach	NUMERIC	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.
frequency	NUMERIC	The average number of times each person saw your ad. This metric is estimated.
date_stop	DATE	The end date for your data. This is controlled by the date range you've selected for your reporting view.
date	DATE	The date (yyyy-MM-dd). The start date for your data. This is controlled by the date range you've selected for your reporting view.

facebook_ads_reach_frequency

This report contains facebook ads monthly reach and frequency metrics in account,ad_group and ad level. Learn more.

name	type	description	values
landing_page_x_id	INT	The universal ID of the landing page.
campaign_x_id	INT	The universal ID of the campaign.
ad_group_x_id	INT	The universal ID of the adgroup.
account_x_id	INT	The universal ID of the account_id.
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
report_level	STRING	The level of the report.	account, campaign, ad_group
reach	NUMERIC	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.
frequency	NUMERIC	The average number of times each person saw your ad. This metric is estimated.
date	DATE	The date (yyyy-MM-dd).

google_ads

google_ads_negatives

This report contains google ads negative keyword targets. Learn more.

name	type	description	values
keyword_x_id	INT	The universal ID of the keyword.
campaign_x_id	INT	The universal ID of the campaign.
ad_group_x_id	INT	The universal ID of the adgroup.
negative	STRING	The text of the negative keyword.

google_ads_keywords_quality

This report contains google ads keyword quality metrics. Learn more.

name	type	description	values
landing_page_x_id	INT	The universal ID of the landing page.
keyword_x_id	INT	The universal ID of the keyword.
campaign_x_id	INT	The universal ID of the campaign.
ad_group_x_id	INT	The universal ID of the adgroup.
top_impression_percentage	NUMERIC	The percent of your ad impressions that are shown anywhere above the organic search results.
search_rank_lost_impression_share	NUMERIC	The estimated percentage of impressions on the Search Network that your ads didn't receive due to poor Ad Rank.	0.1-1
search_impression_share	NUMERIC	The impressions you've received on the Search Network divided by the estimated number of impressions you were eligible to receive.	0.1-1
search_exact_match_impression_share	NUMERIC	The impressions you've received divided by the estimated number of impressions you were eligible to receive on the Search Network for search terms that matched your keywords exactly (or were close variants of your keyword), regardless of your keyword match types.	0.1-1
search_click_share	NUMERIC	The number of clicks you've received on the Search Network divided by the estimated number of clicks you were eligible to receive.
impressions	NUMERIC	The number of impressions. Count of how often your ad has appeared on a search results page or website on the Google Network.
historical_search_predicted_ctr	STRING	The historical search predicted click through rate (CTR).
historical_quality_score	NUMERIC	The historical quality score.
historical_landing_page_quality_score	STRING	The quality of historical landing page experience.
historical_creative_quality_score	STRING	The creative historical quality score.
date	DATE	The date (yyyy-MM-dd).
currency	STRING	The currency of the account.
cost	NUMERIC	The amount of money spend.
conversions_value	NUMERIC	The value of conversions. This only includes conversions specified by the user in service platform.
conversions	NUMERIC	The number of conversions. This only includes conversions specified by the user in service platform.
clicks	NUMERIC	The number of clicks.
all_conversions_value	NUMERIC	The value of all conversions.
all_conversions	NUMERIC	The total number of conversions.