Google Ads report transformation

Stay organized with collections Save and categorize content based on your preferences.

This document describes how you can transform your reports for Google Ads (formerly known as Google AdWords).

Table mapping for Google Ads reports

When your Google Ads reports are transferred to BigQuery, the reports are transformed into the following BigQuery tables and views.

When you view the tables and views in BigQuery, the value for customer_id is your Google Ads customer ID.

AdWords reports (deprecated) BigQuery AdWords tables Google Ads tables Google Ads API resources (v11.0.0) BigQuery views
Account Performance Report p_Customer_customer_id
p_HourlyAccountConversionStats_customer_id
p_AccountConversionStats_customer_id
p_HourlyAccountStats_customer_id
p_AccountNonClickStats_customer_id
p_AccountBasicStats_customer_id
p_AccountStats_customer_id
p_ads_Customer_customer_id
p_ads_HourlyAccountConversionStats_customer_id
p_ads_AccountConversionStats_customer_id
p_ads_HourlyAccountStats_customer_id
p_ads_AccountNonClickStats_customer_id
p_ads_AccountBasicStats_customer_id
p_ads_AccountStats_customer_id
Customer Customer_customer_id
HourlyAccountConversionStats_customer_id
AccountConversionStats_customer_id
HourlyAccountStats_customer_id
AccountNonClickStats_customer_id
AccountBasicStats_customer_id
AccountStats_customer_id
Ad Performance Report p_AdBasicStats_customer_id
p_AdCrossDeviceStats_customer_id
p_AdConversionStats_customer_id
p_AdStats_customer_id
p_AdCrossDeviceConversionStats_customer_id
p_Ad_customer_id
p_ads_AdBasicStats_customer_id
p_ads_AdCrossDeviceStats_customer_id
p_ads_AdConversionStats_customer_id
p_ads_AdStats_customer_id
p_ads_AdCrossDeviceConversionStats_customer_id
p_ads_Ad_customer_id
Ad Group Ad AdBasicStats_customer_id
AdCrossDeviceStats_customer_id
AdConversionStats_customer_id
AdStats_customer_id
AdCrossDeviceConversionStats_customer_id
Ad_customer_id
Adgroup Performance Report p_AdGroupStats_customer_id
p_AdGroupBasicStats_customer_id
p_AdGroupCrossDeviceStats_customer_id
p_HourlyAdGroupConversionStats_customer_id
p_HourlyAdGroupStats_customer_id
p_AdGroupConversionStats_customer_id
p_AdGroupCrossDeviceConversionStats_customer_id
p_AdGroup_customer_id
p_ads_AdGroupStats_customer_id
p_ads_AdGroupBasicStats_customer_id
p_ads_AdGroupCrossDeviceStats_customer_id
p_ads_HourlyAdGroupConversionStats_customer_id
p_ads_HourlyAdGroupStats_customer_id
p_ads_AdGroupConversionStats_customer_id
p_ads_AdGroupCrossDeviceConversionStats_customer_id
p_ads_AdGroup_customer_id
Ad Group AdGroupStats_customer_id
AdGroupBasicStats_customer_id
AdGroupCrossDeviceStats_customer_id
HourlyAdGroupConversionStats_customer_id
HourlyAdGroupStats_customer_id
AdGroupConversionStats_customer_id
AdGroupCrossDeviceConversionStats_customer_id
AdGroup_customer_id
Age Range Performance Report p_AgeRange_customer_id
p_AgeRangeBasicStats_customer_id
p_AgeRangeStats_customer_id
p_AgeRangeConversionStats_customer_id
p_AgeRangeNonClickStats_customer_id
p_ads_AgeRange_customer_id
p_ads_AgeRangeBasicStats_customer_id
p_ads_AgeRangeStats_customer_id
p_ads_AgeRangeConversionStats_customer_id
p_ads_AgeRangeNonClickStats_customer_id
Age Range View AgeRange_customer_id
AgeRangeBasicStats_customer_id
AgeRangeStats_customer_id
AgeRangeConversionStats_customer_id
AgeRangeNonClickStats_customer_id
Audience Performance Report p_Audience_customer_id
p_AudienceConversionStats_customer_id
p_AudienceNonClickStats_customer_id
p_AudienceBasicStats_customer_id
p_AudienceStats_customer_id
NULL
NULL
NULL
NULL
NULL
Ad Group Audience View
Campaign Audience View
Audience_customer_id
AudienceConversionStats_customer_id
AudienceNonClickStats_customer_id
AudienceBasicStats_customer_id
AudienceStats_customer_id
Bid Goal Performance Report p_BidGoal_customer_id
p_BidGoalStats_customer_id
p_HourlyBidGoalStats_customer_id
p_BidGoalConversionStats_customer_id
p_ads_BidGoal_customer_id
p_ads_BidGoalStats_customer_id
p_ads_HourlyBidGoalStats_customer_id
p_ads_BidGoalConversionStats_customer_id
Bidding Strategy BidGoal_customer_id
BidGoalStats_customer_id
HourlyBidGoalStats_customer_id
BidGoalConversionStats_customer_id
Budget Performance Report p_Budget_customer_id
p_BudgetStats_customer_id
p_ads_Budget_customer_id
p_ads_BudgetStats_customer_id
Campaign Budget Budget_customer_id
BudgetStats_customer_id
Campaign Location Target Report p_CampaignLocationTargetStats_customer_id
p_LocationBasedCampaignCriterion_customer_id
p_ads_CampaignLocationTargetStats_customer_id
p_ads_LocationBasedCampaignCriterion_customer_id
Location View CampaignLocationTargetStats_customer_id
LocationBasedCampaignCriterion_customer_id
Campaign Performance Report p_Campaign_customer_id
p_CampaignBasicStats_customer_id
p_CampaignConversionStats_customer_id
p_CampaignCrossDeviceStats_customer_id
p_HourlyCampaignConversionStats_customer_id
p_CampaignStats_customer_id
p_HourlyCampaignStats_customer_id
p_CampaignCrossDeviceConversionStats_customer_id
p_CampaignCookieStats_customer_id
p_ads_Campaign_customer_id
p_ads_CampaignBasicStats_customer_id
p_ads_CampaignConversionStats_customer_id
p_ads_CampaignCrossDeviceStats_customer_id
p_ads_HourlyCampaignConversionStats_customer_id
p_ads_CampaignStats_customer_id
p_ads_HourlyCampaignStats_customer_id
p_ads_CampaignCrossDeviceConversionStats_customer_id
p_ads_CampaignCookieStats_customer_id
Campaign Campaign_customer_id
CampaignBasicStats_customer_id
CampaignConversionStats_customer_id
CampaignCrossDeviceStats_customer_id
HourlyCampaignConversionStats_customer_id
CampaignStats_customer_id
HourlyCampaignStats_customer_id
CampaignCrossDeviceConversionStats_customer_id
CampaignCookieStats_customer_id
Click Performance Report p_ClickStats_customer_id p_ads_ClickStats_customer_id Click View ClickStats_customer_id
Criteria Performance Report p_Criteria_customer_id
p_CriteriaBasicStats_customer_id
p_CriteriaStats_customer_id
p_CriteriaConversionStats_customer_id
p_CriteriaNonClickStats_customer_id
NULL
NULL
NULL
NULL
NULL
Criteria_customer_id
CriteriaBasicStats_customer_id
CriteriaStats_customer_id
CriteriaConversionStats_customer_id
CriteriaNonClickStats_customer_id
Gender Performance Report p_Gender_customer_id
p_GenderBasicStats_customer_id
p_GenderStats_customer_id
p_GenderConversionStats_customer_id
p_GenderNonClickStats_customer_id
p_ads_Gender_customer_id
p_ads_GenderBasicStats_customer_id
p_ads_GenderStats_customer_id
p_ads_GenderConversionStats_customer_id
p_ads_GenderNonClickStats_customer_id
Gender View Gender_customer_id
GenderBasicStats_customer_id
GenderStats_customer_id
GenderConversionStats_customer_id
GenderNonClickStats_customer_id
Geo Performance Report p_GeoConversionStats_customer_id
p_GeoStats_customer_id
p_ads_GeoConversionStats_customer_id
p_ads_GeoStats_customer_id
Geographic View GeoConversionStats_customer_id
GeoStats_customer_id
Keywords Performance Report p_Keyword_customer_id
p_KeywordBasicStats_customer_id
p_KeywordCrossDeviceStats_customer_id
p_KeywordStats_customer_id
p_KeywordCrossDeviceConversionStats_customer_id
p_KeywordConversionStats_customer_id
p_ads_Keyword_customer_id
p_ads_KeywordBasicStats_customer_id
p_ads_KeywordCrossDeviceStats_customer_id
p_ads_KeywordStats_customer_id
p_ads_KeywordCrossDeviceConversionStats_customer_id
p_ads_KeywordConversionStats_customer_id
Keyword View Keyword_customer_id
KeywordBasicStats_customer_id
KeywordCrossDeviceStats_customer_id
KeywordStats_customer_id
KeywordCrossDeviceConversionStats_customer_id
KeywordConversionStats_customer_id
Paid Organic Query Report p_PaidOrganicStats_customer_id p_ads_PaidOrganicStats_customer_id Paid Organic Search Term View PaidOrganicStats_customer_id
Parental Status Performance Report p_ParentalStatus_customer_id
p_ParentalStatusBasicStats_customer_id
p_ParentalStatusStats_customer_id
p_ParentalStatusConversionStats_customer_id
p_ParentalStatusNonClickStats_customer_id
p_ads_ParentalStatus_customer_id
p_ads_ParentalStatusBasicStats_customer_id
p_ads_ParentalStatusStats_customer_id
p_ads_ParentalStatusConversionStats_customer_id
p_ads_ParentalStatusNonClickStats_customer_id
Parental Status View ParentalStatus_customer_id
ParentalStatusBasicStats_customer_id
ParentalStatusStats_customer_id
ParentalStatusConversionStats_customer_id
ParentalStatusNonClickStats_customer_id
Placement Performance Report p_PlacementBasicStats_customer_id
p_PlacementNonClickStats_customer_id
p_PlacementStats_customer_id
p_Placement_customer_id
p_PlacementConversionStats_customer_id
p_ads_PlacementBasicStats_customer_id
p_ads_PlacementNonClickStats_customer_id
p_ads_PlacementStats_customer_id
p_ads_Placement_customer_id
p_ads_PlacementConversionStats_customer_id
Managed Placement View PlacementBasicStats_customer_id
PlacementNonClickStats_customer_id
PlacementStats_customer_id
Placement_customer_id
PlacementConversionStats_customer_id
Search Query Performance Report p_SearchQueryStats_customer_id
p_SearchQueryConversionStats_customer_id
p_ads_SearchQueryStats_customer_id
p_ads_SearchQueryConversionStats_customer_id
Search Term View SearchQueryStats_customer_id
SearchQueryConversionStats_customer_id
Shopping Performance Report p_ShoppingProductConversionStats_customer_id
p_ShoppingProductStats_customer_id
p_ads_ShoppingProductConversionStats_customer_id
p_ads_ShoppingProductStats_customer_id
Shopping Performance View ShoppingProductConversionStats_customer_id
ShoppingProductStats_customer_id
Video Performance Report p_VideoBasicStats_customer_id
p_VideoConversionStats_customer_id
p_VideoStats_customer_id
p_Video_customer_id
p_VideoNonClickStats_customer_id
p_ads_VideoBasicStats_customer_id
p_ads_VideoConversionStats_customer_id
p_ads_VideoStats_customer_id
p_ads_Video_customer_id
p_ads_VideoNonClickStats_customer_id
View VideoBasicStats_customer_id
VideoConversionStats_customer_id
VideoStats_customer_id
Video_customer_id
VideoNonClickStats_customer_id
AdGroupBidModifier Ad Group Bid Modifier
AdGroupAdLabel Ad Group Ad Label
CampaignLabel Campaign Label
CampaignCriterion Campaign Criterion
AdGroupLabel Ad Group Label
AdGroupAudience
AdGroupAudienceStats
AdGroupAudienceConversionStats
AdGroupAudienceNonClickStats
AdGroupAudienceBasicStats
Ad Group Audience View

Column mapping for Google Ads reports

The BigQuery tables created by an Google Ads transfer consist of the following columns (fields):

Table Name: Locations_Distance

Field Name Description
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_view_through_conversions The total number of view-through conversions. These happen when a customer sees an image or rich media ad, then later completes a conversion on your site without interacting with (e.g., clicking on) another ad.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
metrics_conversions_from_interactions_rate Conversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_clicks The number of clicks.
distance_view_distance_bucket Grouping of user distance from location extensions.
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
customer_id The ID of the customer.
metrics_average_cpc The total cost of all clicks divided by the total number of clicks received.
metrics_ctr The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
metrics_cost_per_conversion The cost of ad interactions divided by conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.

Table Name: AdGroupLabel

Field Name Description
ad_group_label_label The label assigned to the ad group.
label_name The name of the label. This field is required and should not be empty when creating a new label. The length of this string should be between 1 and 80, inclusive.
label_id Id of the label. Read only.
ad_group_name The name of the ad group. This field is required and should not be empty when creating new ad groups. It must contain fewer than 255 UTF-8 full-width characters. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters.
ad_group_label_ad_group The ad group to which the label is attached.
label_resource_name Name of the resource. Label resource names have the form: `customers/{customer_id}/labels/{label_id}`
ad_group_id The ID of the ad group.
ad_group_label_resource_name The resource name of the ad group label. Ad group label resource names have the form: `customers/{customer_id}/adGroupLabels/{ad_group_id}~{label_id}`

Table Name: AdConversionStats

Field Name Description
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
segments_day_of_week Day of the week, e.g., MONDAY.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
segments_slot Position of the ad.
customer_id The ID of the customer.
segments_keyword_ad_group_criterion The AdGroupCriterion resource name.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
segments_year Year, formatted as yyyy.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
segments_device Device to which metrics apply.
segments_conversion_action_category Conversion action category.
segments_click_type Click type.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_conversion_action Resource name of the conversion action.
ad_group_ad_ad_id The ID of the ad.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
ad_group_ad_ad_group The ad group to which the ad belongs.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
segments_ad_network_type Ad network type.
campaign_id The ID of the campaign.
segments_conversion_action_name Conversion action name.

Table Name: GeoConversionStats

Field Name Description
segments_conversion_action_category Conversion action category.
geographic_view_country_criterion_id Criterion Id for the country.
metrics_view_through_conversions The total number of view-through conversions. These happen when a customer sees an image or rich media ad, then later completes a conversion on your site without interacting with (e.g., clicking on) another ad.
segments_device Device to which metrics apply.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
ad_group_name The name of the ad group. This field is required and should not be empty when creating new ad groups. It must contain fewer than 255 UTF-8 full-width characters. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters.
segments_ad_network_type Ad network type.
segments_geo_target_most_specific_location Resource name of the geo target constant that represents the most specific location.
ad_group_status The status of the ad group.
geographic_view_location_type Type of the geo targeting of the campaign.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
campaign_id The ID of the campaign.
segments_year Year, formatted as yyyy.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
metrics_all_conversions_value The total value of all conversions.
segments_conversion_action_name Conversion action name.
segments_geo_target_metro Resource name of the geo target constant that represents a metro.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_conversion_action Resource name of the conversion action.
customer_id The ID of the customer.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_value_per_all_conversions The value of all conversions divided by the number of all conversions.
segments_day_of_week Day of the week, e.g., MONDAY.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
metrics_cross_device_conversions Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
segments_geo_target_region Resource name of the geo target constant that represents a region.
metrics_all_conversions The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
ad_group_id The ID of the ad group.
segments_geo_target_city Resource name of the geo target constant that represents a city.

Table Name: PlacementConversionStats

Field Name Description
metrics_all_conversions_value The total value of all conversions.
metrics_value_per_all_conversions The value of all conversions divided by the number of all conversions.
ad_group_criterion_criterion_id The ID of the criterion. This field is ignored for mutates.
customer_id The ID of the customer.
segments_conversion_action_category Conversion action category.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
segments_day_of_week Day of the week, e.g., MONDAY.
campaign_id The ID of the campaign.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
segments_conversion_action Resource name of the conversion action.
segments_year Year, formatted as yyyy.
ad_group_id The ID of the ad group.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_cross_device_conversions Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_click_type Click type.
segments_conversion_action_name Conversion action name.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_ad_network_type Ad network type.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
segments_device Device to which metrics apply.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
metrics_all_conversions The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.

Table Name: AdBasicStats

Field Name Description
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
segments_keyword_ad_group_criterion The AdGroupCriterion resource name.
metrics_interaction_event_types The types of payable and free interactions.
segments_device Device to which metrics apply.
segments_ad_network_type Ad network type.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_view_through_conversions The total number of view-through conversions. These happen when a customer sees an image or rich media ad, then later completes a conversion on your site without interacting with (e.g., clicking on) another ad.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
ad_group_ad_ad_id The ID of the ad.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
segments_slot Position of the ad.
metrics_clicks The number of clicks.
metrics_interactions The number of interactions. An interaction is the main user action associated with an ad format-clicks for text and shopping ads, views for video ads, and so on.
customer_id The ID of the customer.
ad_group_ad_ad_group The ad group to which the ad belongs.
campaign_id The ID of the campaign.

Table Name: PlacementStats

Field Name Description
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
metrics_active_view_measurable_cost_micros The cost of the impressions you received that were measurable by Active View.
segments_day_of_week Day of the week, e.g., MONDAY.
metrics_gmail_secondary_clicks The number of clicks to the landing page on the expanded state of Gmail ads.
metrics_value_per_all_conversions The value of all conversions divided by the number of all conversions.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_all_conversions_from_interactions_rate All conversions from interactions (as oppose to view through conversions) divided by the number of ad interactions.
segments_click_type Click type.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
campaign_id The ID of the campaign.
metrics_gmail_saves The number of times someone has saved your Gmail ad to their inbox as a message.
segments_year Year, formatted as yyyy.
metrics_active_view_ctr Active view measurable clicks divided by active view viewable impressions. This metric is reported only for display network.
metrics_cost_per_conversion The cost of ad interactions divided by conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
ad_group_id The ID of the ad group.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
metrics_active_view_measurability The ratio of impressions that could be measured by Active View over the number of served impressions.
metrics_cross_device_conversions Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
metrics_interaction_rate How often people interact with your ad after it is shown to them. This is the number of interactions divided by the number of times your ad is shown.
metrics_interaction_event_types The types of payable and free interactions.
metrics_interactions The number of interactions. An interaction is the main user action associated with an ad format-clicks for text and shopping ads, views for video ads, and so on.
metrics_all_conversions The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_active_view_impressions A measurement of how often your ad has become viewable on a Display Network site.
metrics_cost_per_all_conversions The cost of ad interactions divided by all conversions.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_ad_network_type Ad network type.
metrics_average_cpm Average cost-per-thousand impressions (CPM).
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
metrics_active_view_viewability The percentage of time when your ad appeared on an Active View enabled site (measurable impressions) and was viewable (viewable impressions).
metrics_ctr The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
metrics_average_cpc The total cost of all clicks divided by the total number of clicks received.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
metrics_all_conversions_value The total value of all conversions.
customer_id The ID of the customer.
metrics_gmail_forwards The number of times the ad was forwarded to someone else as a message.
segments_device Device to which metrics apply.
metrics_active_view_cpm Average cost of viewable impressions (`active_view_impressions`).
metrics_average_cost The average amount you pay per interaction. This amount is the total cost of your ads divided by the total number of interactions.
metrics_clicks The number of clicks.
ad_group_criterion_criterion_id The ID of the criterion. This field is ignored for mutates.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
metrics_active_view_measurable_impressions The number of times your ads are appearing on placements in positions where they can be seen.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.

Table Name: AdGroupCriterionLabel

Field Name Description
label_name The name of the label. This field is required and should not be empty when creating a new label. The length of this string should be between 1 and 80, inclusive.
ad_group_criterion_label_ad_group_criterion The ad group criterion to which the label is attached.
ad_group_criterion_label_resource_name The resource name of the ad group criterion label. Ad group criterion label resource names have the form: `customers/{customer_id}/adGroupCriterionLabels/{ad_group_id}~{criterion_id}~{label_id}`
label_id Id of the label. Read only.
label_resource_name Name of the resource. Label resource names have the form: `customers/{customer_id}/labels/{label_id}`
ad_group_criterion_label_label The label assigned to the ad group criterion.
ad_group_criterion_criterion_id The ID of the criterion. This field is ignored for mutates.

Table Name: CampaignCookieStats

Field Name Description
metrics_search_rank_lost_absolute_top_impression_share The number estimating how often your ad wasn't the very first ad above the organic search results due to poor Ad Rank. Note: Search rank lost absolute top impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
metrics_search_rank_lost_top_impression_share The number estimating how often your ad didn't show anywhere above the organic search results due to poor Ad Rank. Note: Search rank lost top impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
metrics_absolute_top_impression_percentage The percent of your ad impressions that are shown as the very first ad above the organic search results.
segments_ad_network_type Ad network type.
metrics_search_budget_lost_top_impression_share The number estimating how often your ad didn't show anywhere above the organic search results due to a low budget. Note: Search budget lost top impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
metrics_search_top_impression_share The impressions you've received in the top location (anywhere above the organic search results) compared to the estimated number of impressions you were eligible to receive in the top location. Note: Search top impression share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999.
campaign_id The ID of the campaign.
metrics_top_impression_percentage The percent of your ad impressions that are shown anywhere above the organic search results.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
customer_id The ID of the customer.
metrics_search_budget_lost_absolute_top_impression_share The number estimating how often your ad wasn't the very first ad above the organic search results due to a low budget. Note: Search budget lost absolute top impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.

Table Name: Campaign

Field Name Description
campaign_start_date The date when campaign started. This field must not be used in WHERE clauses.
campaign_budget_has_recommended_budget Indicates whether there is a recommended budget for this campaign budget. This field is read-only.
campaign_budget_period Period over which to spend the budget. Defaults to DAILY if not specified.
campaign_budget_recommended_budget_amount_micros The recommended budget amount. If no recommendation is available, this will be set to the budget amount. Amount is specified in micros, where one million is equivalent to one currency unit. This field is read-only.
campaign_maximize_conversion_value_target_roas The target return on ad spend (ROAS) option. If set, the bid strategy will maximize revenue while averaging the target return on ad spend. If the target ROAS is high, the bid strategy may not be able to spend the full budget. If the target ROAS is not set, the bid strategy will aim to achieve the highest possible ROAS for the budget.
campaign_status The status of the campaign. When a new campaign is added, the status defaults to ENABLED.
campaign_experiment_type The type of campaign: normal, draft, or experiment.
campaign_manual_cpc_enhanced_cpc_enabled Whether bids are to be enhanced based on conversion optimizer data.
campaign_url_custom_parameters The list of mappings used to substitute custom parameter tags in a `tracking_url_template`, `final_urls`, or `mobile_final_urls`.
campaign_advertising_channel_sub_type Optional refinement to `advertising_channel_type`. Must be a valid sub-type of the parent channel type. Can be set only when creating campaigns. After campaign is created, the field can not be changed.
customer_id The ID of the customer.
campaign_serving_status The ad serving status of the campaign.
campaign_budget_amount_micros The amount of the budget, in the local currency for the account. Amount is specified in micros, where one million is equivalent to one currency unit. Monthly spend is capped at 30.4 times this amount.
campaign_name The name of the campaign. This field is required and should not be empty when creating new campaigns. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters.
campaign_budget_explicitly_shared Specifies whether the budget is explicitly shared. Defaults to true if unspecified in a create operation. If true, the budget was created with the purpose of sharing across one or more campaigns. If false, the budget was created with the intention of only being used with a single campaign. The budget's name and status will stay in sync with the campaign's name and status. Attempting to share the budget with a second campaign will result in an error. A non-shared budget can become an explicitly shared. The same operation must also assign the budget a name. A shared campaign budget can never become non-shared.
bidding_strategy_name The name of the bidding strategy. All bidding strategies within an account must be named distinctly. The length of this string should be between 1 and 255, inclusive, in UTF-8 bytes, (trimmed).
campaign_campaign_budget The budget of the campaign.
campaign_advertising_channel_type The primary serving target for ads within the campaign. The targeting options can be refined in `network_settings`. This field is required and should not be empty when creating new campaigns. Can be set only when creating campaigns. After the campaign is created, the field can not be changed.
campaign_bidding_strategy_type The type of bidding strategy. A bidding strategy can be created by setting either the bidding scheme to create a standard bidding strategy or the `bidding_strategy` field to create a portfolio bidding strategy. This field is read-only.
campaign_end_date The date when campaign ended. This field must not be used in WHERE clauses.
campaign_percent_cpc_enhanced_cpc_enabled Adjusts the bid for each auction upward or downward, depending on the likelihood of a conversion. Individual bids may exceed cpc_bid_ceiling_micros, but the average bid amount for a campaign should not.
campaign_bidding_strategy Portfolio bidding strategy used by campaign.
campaign_budget_total_amount_micros The lifetime amount of the budget, in the local currency for the account. Amount is specified in micros, where one million is equivalent to one currency unit.
campaign_tracking_url_template The URL template for constructing a tracking URL.
campaign_id The ID of the campaign.

Table Name: DisplayVideo_AutomaticPlacements

Field Name Description
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
campaign_id The ID of the campaign.
ad_group_name The name of the ad group. This field is required and should not be empty when creating new ad groups. It must contain fewer than 255 UTF-8 full-width characters. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters.
metrics_average_cpc The total cost of all clicks divided by the total number of clicks received.
group_placement_view_placement_type Type of the placement, e.g. Website, YouTube Channel, Mobile Application.
metrics_video_views The number of times your video ads were viewed.
metrics_ctr The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
metrics_clicks The number of clicks.
metrics_average_cpv The average amount you pay each time someone views your ad. The average CPV is defined by the total cost of all ad views divided by the number of views.
ad_group_id The ID of the ad group.
metrics_video_view_rate The number of views your TrueView video ad receives divided by its number of impressions, including thumbnail impressions for TrueView in-display ads.
customer_id The ID of the customer.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
group_placement_view_placement The automatic placement string at group level, e. g. web domain, mobile app ID, or a YouTube channel ID.
metrics_average_cpm Average cost-per-thousand impressions (CPM).
campaign_name The name of the campaign. This field is required and should not be empty when creating new campaigns. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters.

Table Name: AdGroupAudienceStats

Field Name Description
segments_ad_network_type Ad network type.
metrics_active_view_measurable_cost_micros The cost of the impressions you received that were measurable by Active View.
metrics_average_cpm Average cost-per-thousand impressions (CPM).
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
metrics_interaction_event_types The types of payable and free interactions.
metrics_average_cpc The total cost of all clicks divided by the total number of clicks received.
metrics_gmail_secondary_clicks The number of clicks to the landing page on the expanded state of Gmail ads.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_interaction_rate How often people interact with your ad after it is shown to them. This is the number of interactions divided by the number of times your ad is shown.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
segments_device Device to which metrics apply.
ad_group_id The ID of the ad group.
metrics_cost_per_all_conversions The cost of ad interactions divided by all conversions.
metrics_active_view_ctr Active view measurable clicks divided by active view viewable impressions. This metric is reported only for display network.
metrics_gmail_saves The number of times someone has saved your Gmail ad to their inbox as a message.
metrics_conversions_from_interactions_rate Conversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_click_type Click type.
metrics_ctr The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
customer_id The ID of the customer.
metrics_interactions The number of interactions. An interaction is the main user action associated with an ad format-clicks for text and shopping ads, views for video ads, and so on.
metrics_average_cost The average amount you pay per interaction. This amount is the total cost of your ads divided by the total number of interactions.
ad_group_criterion_criterion_id The ID of the criterion. This field is ignored for mutates.
ad_group_campaign The campaign to which the ad group belongs.
metrics_gmail_forwards The number of times the ad was forwarded to someone else as a message.
metrics_active_view_cpm Average cost of viewable impressions (`active_view_impressions`).
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
metrics_all_conversions_from_interactions_rate All conversions from interactions (as oppose to view through conversions) divided by the number of ad interactions.
metrics_active_view_measurability The ratio of impressions that could be measured by Active View over the number of served impressions.
segments_day_of_week Day of the week, e.g., MONDAY.
metrics_active_view_measurable_impressions The number of times your ads are appearing on placements in positions where they can be seen.
metrics_active_view_viewability The percentage of time when your ad appeared on an Active View enabled site (measurable impressions) and was viewable (viewable impressions).
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_cost_per_conversion The cost of ad interactions divided by conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
segments_year Year, formatted as yyyy.
metrics_active_view_impressions A measurement of how often your ad has become viewable on a Display Network site.
metrics_clicks The number of clicks.

Table Name: AdGroupAdLabel

Field Name Description
ad_group_ad_label_label The label assigned to the ad group ad.
ad_group_name The name of the ad group. This field is required and should not be empty when creating new ad groups. It must contain fewer than 255 UTF-8 full-width characters. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters.
label_id Id of the label. Read only.
label_name The name of the label. This field is required and should not be empty when creating a new label. The length of this string should be between 1 and 80, inclusive.
ad_group_id The ID of the ad group.
ad_group_ad_label_ad_group_ad The ad group ad to which the label is attached.
label_resource_name Name of the resource. Label resource names have the form: `customers/{customer_id}/labels/{label_id}`
ad_group_ad_label_resource_name The resource name of the ad group ad label. Ad group ad label resource names have the form: `customers/{customer_id}/adGroupAdLabels/{ad_group_id}~{ad_id}~{label_id}`

Table Name: CampaignCrossDeviceStats

Field Name Description
segments_year Year, formatted as yyyy.
metrics_search_rank_lost_top_impression_share The number estimating how often your ad didn't show anywhere above the organic search results due to poor Ad Rank. Note: Search rank lost top impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
metrics_search_absolute_top_impression_share The percentage of the customer's Shopping or Search ad impressions that are shown in the most prominent Shopping position. See https://support.google.com/google-ads/answer/7501826 for details. Any value below 0.1 is reported as 0.0999.
metrics_average_page_views Average number of pages viewed per session.
metrics_search_exact_match_impression_share 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. Note: Search exact match impression share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999.
metrics_phone_impressions Number of offline phone impressions.
metrics_video_quartile_p75_rate Percentage of impressions where the viewer watched 75% of your video.
metrics_average_time_on_site Total duration of all sessions (in seconds) / number of sessions. Imported from Google Analytics.
segments_ad_network_type Ad network type.
metrics_video_quartile_p100_rate Percentage of impressions where the viewer watched all of your video.
metrics_all_conversions_from_interactions_rate All conversions from interactions (as oppose to view through conversions) divided by the number of ad interactions.
metrics_average_cpv The average amount you pay each time someone views your ad. The average CPV is defined by the total cost of all ad views divided by the number of views.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
metrics_phone_through_rate Number of phone calls received (phone_calls) divided by the number of times your phone number is shown (phone_impressions).
metrics_value_per_all_conversions The value of all conversions divided by the number of all conversions.
metrics_cross_device_conversions Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
campaign_id The ID of the campaign.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
metrics_search_rank_lost_impression_share The estimated percentage of impressions on the Search Network that your ads didn't receive due to poor Ad Rank. Note: Search rank lost impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
metrics_video_views The number of times your video ads were viewed.
segments_day_of_week Day of the week, e.g., MONDAY.
metrics_content_impression_share The impressions you've received on the Display Network divided by the estimated number of impressions you were eligible to receive. Note: Content impression share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999.
metrics_search_top_impression_share The impressions you've received in the top location (anywhere above the organic search results) compared to the estimated number of impressions you were eligible to receive in the top location. Note: Search top impression share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999.
metrics_search_budget_lost_absolute_top_impression_share The number estimating how often your ad wasn't the very first ad above the organic search results due to a low budget. Note: Search budget lost absolute top impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
metrics_search_rank_lost_absolute_top_impression_share The number estimating how often your ad wasn't the very first ad above the organic search results due to poor Ad Rank. Note: Search rank lost absolute top impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
metrics_invalid_clicks Number of clicks Google considers illegitimate and doesn't charge you for.
metrics_invalid_click_rate The percentage of clicks filtered out of your total number of clicks (filtered + non-filtered clicks) during the reporting period.
metrics_engagement_rate How often people engage with your ad after it's shown to them. This is the number of ad expansions divided by the number of times your ad is shown.
metrics_engagements The number of engagements. An engagement occurs when a viewer expands your Lightbox ad. Also, in the future, other ad types may support engagement metrics.
metrics_video_quartile_p50_rate Percentage of impressions where the viewer watched 50% of your video.
metrics_search_click_share The number of clicks you've received on the Search Network divided by the estimated number of clicks you were eligible to receive. Note: Search click share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
metrics_absolute_top_impression_percentage The percent of your ad impressions that are shown as the very first ad above the organic search results.
metrics_content_budget_lost_impression_share The estimated percent of times that your ad was eligible to show on the Display Network but didn't because your budget was too low. Note: Content budget lost impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
metrics_average_cpe The average amount that you've been charged for an ad engagement. This amount is the total cost of all ad engagements divided by the total number of ad engagements.
metrics_cost_per_all_conversions The cost of ad interactions divided by all conversions.
metrics_relative_ctr Your clickthrough rate (Ctr) divided by the average clickthrough rate of all advertisers on the websites that show your ads. Measures how your ads perform on Display Network sites compared to other ads on the same sites.
metrics_percent_new_visitors Percentage of first-time sessions (from people who had never visited your site before). Imported from Google Analytics.
metrics_all_conversions The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_video_quartile_p25_rate Percentage of impressions where the viewer watched 25% of your video.
metrics_phone_calls Number of offline phone calls.
metrics_search_impression_share The impressions you've received on the Search Network divided by the estimated number of impressions you were eligible to receive. Note: Search impression share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999.
metrics_all_conversions_value The total value of all conversions.
metrics_search_budget_lost_top_impression_share The number estimating how often your ad didn't show anywhere above the organic search results due to a low budget. Note: Search budget lost top impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
metrics_video_view_rate The number of views your TrueView video ad receives divided by its number of impressions, including thumbnail impressions for TrueView in-display ads.
metrics_search_budget_lost_impression_share The estimated percent of times that your ad was eligible to show on the Search Network but didn't because your budget was too low. Note: Search budget lost impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
metrics_top_impression_percentage The percent of your ad impressions that are shown anywhere above the organic search results.
metrics_bounce_rate Percentage of clicks where the user only visited a single page on your site. Imported from Google Analytics.
customer_id The ID of the customer.
metrics_content_rank_lost_impression_share The estimated percentage of impressions on the Display Network that your ads didn't receive due to poor Ad Rank. Note: Content rank lost impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.

Table Name: GeoStats

Field Name Description
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
metrics_video_views The number of times your video ads were viewed.
metrics_average_cpc The total cost of all clicks divided by the total number of clicks received.
metrics_interaction_rate How often people interact with your ad after it is shown to them. This is the number of interactions divided by the number of times your ad is shown.
segments_ad_network_type Ad network type.
campaign_id The ID of the campaign.
metrics_value_per_all_conversions The value of all conversions divided by the number of all conversions.
ad_group_status The status of the ad group.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_day_of_week Day of the week, e.g., MONDAY.
metrics_interactions The number of interactions. An interaction is the main user action associated with an ad format-clicks for text and shopping ads, views for video ads, and so on.
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
ad_group_name The name of the ad group. This field is required and should not be empty when creating new ad groups. It must contain fewer than 255 UTF-8 full-width characters. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters.
metrics_interaction_event_types The types of payable and free interactions.
metrics_view_through_conversions The total number of view-through conversions. These happen when a customer sees an image or rich media ad, then later completes a conversion on your site without interacting with (e.g., clicking on) another ad.
metrics_video_view_rate The number of views your TrueView video ad receives divided by its number of impressions, including thumbnail impressions for TrueView in-display ads.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
geographic_view_location_type Type of the geo targeting of the campaign.
metrics_average_cpm Average cost-per-thousand impressions (CPM).
metrics_cross_device_conversions Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
metrics_ctr The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
metrics_average_cost The average amount you pay per interaction. This amount is the total cost of your ads divided by the total number of interactions.
metrics_all_conversions The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
customer_id The ID of the customer.
segments_geo_target_metro Resource name of the geo target constant that represents a metro.
geographic_view_country_criterion_id Criterion Id for the country.
segments_geo_target_city Resource name of the geo target constant that represents a city.
metrics_average_cpv The average amount you pay each time someone views your ad. The average CPV is defined by the total cost of all ad views divided by the number of views.
metrics_all_conversions_from_interactions_rate All conversions from interactions (as oppose to view through conversions) divided by the number of ad interactions.
metrics_cost_per_conversion The cost of ad interactions divided by conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_cost_per_all_conversions The cost of ad interactions divided by all conversions.
segments_year Year, formatted as yyyy.
segments_device Device to which metrics apply.
metrics_all_conversions_value The total value of all conversions.
metrics_conversions_from_interactions_rate Conversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_geo_target_region Resource name of the geo target constant that represents a region.
segments_geo_target_most_specific_location Resource name of the geo target constant that represents the most specific location.
metrics_clicks The number of clicks.
ad_group_id The ID of the ad group.

Table Name: AdGroup

Field Name Description
ad_group_effective_target_roas_source Source of the effective target ROAS. This field is read-only.
ad_group_cpc_bid_micros The maximum CPC (cost-per-click) bid.
ad_group_effective_target_roas The effective target ROAS (return-on-ad-spend). This field is read-only.
ad_group_url_custom_parameters The list of mappings used to substitute custom parameter tags in a `tracking_url_template`, `final_urls`, or `mobile_final_urls`.
campaign_manual_cpc_enhanced_cpc_enabled Whether bids are to be enhanced based on conversion optimizer data.
customer_id The ID of the customer.
ad_group_display_custom_bid_dimension Allows advertisers to specify a targeting dimension on which to place absolute bids. This is only applicable for campaigns that target only the display network and not search.
campaign_id The ID of the campaign.
ad_group_effective_target_cpa_source Source of the effective target CPA. This field is read-only.
ad_group_id The ID of the ad group.
ad_group_effective_target_cpa_micros The effective target CPA (cost-per-acquisition). This field is read-only.
ad_group_type The type of the ad group.
ad_group_status The status of the ad group.
campaign_bidding_strategy Portfolio bidding strategy used by campaign.
ad_group_cpv_bid_micros The CPV (cost-per-view) bid.
ad_group_tracking_url_template The URL template for constructing a tracking URL.
ad_group_ad_rotation_mode The ad rotation mode of the ad group.
campaign_bidding_strategy_type The type of bidding strategy. A bidding strategy can be created by setting either the bidding scheme to create a standard bidding strategy or the `bidding_strategy` field to create a portfolio bidding strategy. This field is read-only.
ad_group_name The name of the ad group. This field is required and should not be empty when creating new ad groups. It must contain fewer than 255 UTF-8 full-width characters. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters.
campaign_percent_cpc_enhanced_cpc_enabled Adjusts the bid for each auction upward or downward, depending on the likelihood of a conversion. Individual bids may exceed cpc_bid_ceiling_micros, but the average bid amount for a campaign should not.
ad_group_cpm_bid_micros The maximum CPM (cost-per-thousand viewable impressions) bid.

Table Name: AgeRangeNonClickStats

Field Name Description
segments_ad_network_type Ad network type.
metrics_video_view_rate The number of views your TrueView video ad receives divided by its number of impressions, including thumbnail impressions for TrueView in-display ads.
metrics_average_cpv The average amount you pay each time someone views your ad. The average CPV is defined by the total cost of all ad views divided by the number of views.
metrics_video_quartile_p100_rate Percentage of impressions where the viewer watched all of your video.
metrics_video_views The number of times your video ads were viewed.
metrics_video_quartile_p25_rate Percentage of impressions where the viewer watched 25% of your video.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
metrics_video_quartile_p75_rate Percentage of impressions where the viewer watched 75% of your video.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
ad_group_id The ID of the ad group.
ad_group_criterion_criterion_id The ID of the criterion. This field is ignored for mutates.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
campaign_id The ID of the campaign.
segments_year Year, formatted as yyyy.
metrics_video_quartile_p50_rate Percentage of impressions where the viewer watched 50% of your video.
metrics_engagements The number of engagements. An engagement occurs when a viewer expands your Lightbox ad. Also, in the future, other ad types may support engagement metrics.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
customer_id The ID of the customer.
metrics_engagement_rate How often people engage with your ad after it's shown to them. This is the number of ad expansions divided by the number of times your ad is shown.
segments_device Device to which metrics apply.
metrics_average_cpe The average amount that you've been charged for an ad engagement. This amount is the total cost of all ad engagements divided by the total number of ad engagements.
segments_day_of_week Day of the week, e.g., MONDAY.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.

Table Name: Basic_PaidAndOrganic

Field Name Description
metrics_clicks The number of clicks.
metrics_combined_queries The number of searches that returned pages from your site in the unpaid results or showed one of your text ads. See the help page at https://support.google.com/google-ads/answer/3097241 for details.
customer_id The ID of the customer.
paid_organic_search_term_view_search_term The search term.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
metrics_organic_impressions The number of listings for your site in the unpaid search results. See the help page at https://support.google.com/google-ads/answer/3097241 for details.
ad_group_name The name of the ad group. This field is required and should not be empty when creating new ad groups. It must contain fewer than 255 UTF-8 full-width characters. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters.
metrics_combined_clicks_per_query The number of times your ad or your site's listing in the unpaid results was clicked (combined_clicks) divided by combined_queries. See the help page at https://support.google.com/google-ads/answer/3097241 for details.
metrics_organic_clicks The number of times someone clicked your site's listing in the unpaid results for a particular query. See the help page at https://support.google.com/google-ads/answer/3097241 for details.
metrics_ctr The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
campaign_id The ID of the campaign.
ad_group_id The ID of the ad group.
metrics_organic_clicks_per_query The number of times someone clicked your site's listing in the unpaid results (organic_clicks) divided by the total number of searches that returned pages from your site (organic_queries). See the help page at https://support.google.com/google-ads/answer/3097241 for details.
metrics_organic_impressions_per_query The number of times a page from your site was listed in the unpaid search results (organic_impressions) divided by the number of searches returning your site's listing in the unpaid results (organic_queries). See the help page at https://support.google.com/google-ads/answer/3097241 for details.
metrics_average_cpc The total cost of all clicks divided by the total number of clicks received.
metrics_organic_queries The total number of searches that returned your site's listing in the unpaid results. See the help page at https://support.google.com/google-ads/answer/3097241 for details.
metrics_combined_clicks The number of times your ad or your site's listing in the unpaid results was clicked. See the help page at https://support.google.com/google-ads/answer/3097241 for details.
segments_search_engine_results_page_type Type of the search engine results page.
campaign_name The name of the campaign. This field is required and should not be empty when creating new campaigns. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters.

Table Name: Ad

Field Name Description
ad_group_ad_ad_gmail_ad_teaser_business_name Business name of the advertiser.
ad_group_ad_ad_legacy_responsive_display_ad_call_to_action_text The call-to-action text for the ad.
ad_group_ad_ad_gmail_ad_marketing_image_description Description of the marketing image.
ad_group_ad_ad_responsive_search_ad_headlines List of text assets for headlines. When the ad serves the headlines will be selected from this list.
ad_group_ad_ad_expanded_text_ad_headline_part2 The second part of the ad's headline.
ad_group_ad_ad_gmail_ad_marketing_image_display_call_to_action_text Text for the display-call-to-action.
ad_group_ad_ad_app_ad_images List of image assets that may be displayed with the ad.
ad_group_ad_ad_gmail_ad_marketing_image The MediaFile resource name of the marketing image. Valid image types are GIF, JPEG and PNG. The image must either be landscape with a minimum size of 600x314 pixels and aspect ratio of 600:314 (+-1%) or square with a minimum size of 300x300 pixels and aspect ratio of 1:1 (+-1%)
ad_group_ad_ad_legacy_responsive_display_ad_format_setting Specifies which format the ad will be served in. Default is ALL_FORMATS.
ad_group_ad_ad_app_ad_html5_media_bundles List of media bundle assets that may be used with the ad.
customer_id The ID of the customer.
ad_group_ad_ad_legacy_responsive_display_ad_square_logo_image The MediaFile resource name of the square logo image used in the ad.
ad_group_ad_ad_text_ad_description1 The first line of the ad's description.
ad_group_ad_ad_responsive_search_ad_descriptions List of text assets for descriptions. When the ad serves the descriptions will be selected from this list.
ad_group_ad_ad_legacy_responsive_display_ad_promo_text Promotion text used for dynamic formats of responsive ads. For example 'Free two-day shipping'.
ad_group_ad_ad_image_ad_pixel_width Width in pixels of the full size image.
ad_group_ad_ad_legacy_responsive_display_ad_logo_image The MediaFile resource name of the logo image used in the ad.
ad_group_ad_ad_responsive_display_ad_headlines Short format headlines for the ad. The maximum length is 30 characters. At least 1 and max 5 headlines can be specified.
ad_group_ad_ad_responsive_search_ad_path2 Second part of text that may appear appended to the url displayed in the ad. This field can only be set when path1 is also set.
ad_group_ad_ad_final_mobile_urls The list of possible final mobile URLs after all cross-domain redirects for the ad.
ad_group_ad_ad_expanded_dynamic_search_ad_description The description of the ad.
ad_group_ad_ad_added_by_google_ads Indicates if this ad was automatically added by Google Ads and not by a user. For example, this could happen when ads are automatically created as suggestions for new ads based on knowledge of how existing ads are performing.
ad_group_ad_ad_responsive_display_ad_format_setting Specifies which format the ad will be served in. Default is ALL_FORMATS.
ad_group_ad_ad_responsive_display_ad_logo_images Logo images to be used in the ad. Valid image types are GIF, JPEG, and PNG. The minimum size is 512x128 and the aspect ratio must be 4:1 (+-1%). Combined with square_logo_images the maximum is 5.
ad_group_ad_ad_device_preference The device preference for the ad. You can only specify a preference for mobile devices. When this preference is set the ad will be preferred over other ads when being displayed on a mobile device. The ad can still be displayed on other device types, e.g. if no other ads are available. If unspecified (no device preference), all devices are targeted. This is only supported by some ad types.
ad_group_ad_ad_strength Overall ad strength for this ad group ad.
ad_group_ad_ad_text_ad_headline The headline of the ad.
ad_group_ad_ad_legacy_responsive_display_ad_short_headline The short version of the ad's headline.
ad_group_ad_ad_image_ad_pixel_height Height in pixels of the full size image.
ad_group_ad_ad_responsive_display_ad_call_to_action_text The call-to-action text for the ad. Maximum display width is 30.
ad_group_ad_ad_id The ID of the ad.
ad_group_ad_ad_gmail_ad_teaser_description Description of the teaser.
ad_group_ad_ad_expanded_text_ad_path1 The text that can appear alongside the ad's displayed URL.
ad_group_ad_ad_responsive_display_ad_accent_color The accent color of the ad in hexadecimal, e.g. #ffffff for white. If one of main_color and accent_color is set, the other is required as well.
ad_group_ad_ad_responsive_display_ad_long_headline A required long format headline. The maximum length is 90 characters.
ad_group_ad_ad_url_custom_parameters The list of mappings that can be used to substitute custom parameter tags in a `tracking_url_template`, `final_urls`, or `mobile_final_urls`. For mutates, please use url custom parameter operations.
ad_group_ad_ad_call_ad_phone_number The phone number in the ad.
ad_group_ad_ad_legacy_responsive_display_ad_marketing_image The MediaFile resource name of the marketing image used in the ad.
ad_group_ad_ad_app_ad_headlines List of text assets for headlines. When the ad serves the headlines will be selected from this list.
ad_group_ad_ad_responsive_display_ad_descriptions Descriptive texts for the ad. The maximum length is 90 characters. At least 1 and max 5 headlines can be specified.
ad_group_ad_ad_app_ad_descriptions List of text assets for descriptions. When the ad serves the descriptions will be selected from this list.
ad_group_ad_ad_final_app_urls A list of final app URLs that will be used on mobile if the user has the specific app installed.
ad_group_ad_status The status of the ad.
ad_group_ad_ad_gmail_ad_teaser_logo_image The MediaFile resource name of the logo image. Valid image types are GIF, JPEG and PNG. The minimum size is 144x144 pixels and the aspect ratio must be 1:1 (+-1%).
ad_group_ad_ad_image_ad_mime_type The mime type of the image.
ad_group_ad_ad_responsive_display_ad_promo_text Promotion text used for dynamic formats of responsive ads. For example 'Free two-day shipping'.
ad_group_ad_ad_responsive_display_ad_price_prefix Prefix before price. E.g. 'as low as'.
ad_group_ad_ad_legacy_responsive_display_ad_long_headline The long version of the ad's headline.
ad_group_ad_ad_expanded_text_ad_headline_part3 The third part of the ad's headline.
ad_group_ad_ad_legacy_responsive_display_ad_square_marketing_image The MediaFile resource name of the square marketing image used in the ad.
ad_group_ad_ad_legacy_responsive_display_ad_price_prefix Prefix before price. E.g. 'as low as'.
ad_group_ad_ad_tracking_url_template The URL template for constructing a tracking URL.
ad_group_ad_ad_type The type of ad.
ad_group_ad_ad_display_url The URL that appears in the ad description for some ad formats.
ad_group_ad_ad_gmail_ad_marketing_image_display_call_to_action_text_color Text color for the display-call-to-action in hexadecimal, e.g. #ffffff for white.
ad_group_ad_ad_responsive_display_ad_square_marketing_images Square marketing images to be used in the ad. Valid image types are GIF, JPEG, and PNG. The minimum size is 300x300 and the aspect ratio must be 1:1 (+-1%). At least one square marketing_image is required. Combined with marketing_images the maximum is 15.
ad_group_ad_ad_responsive_display_ad_main_color The main color of the ad in hexadecimal, e.g. #ffffff for white. If one of main_color and accent_color is set, the other is required as well.
ad_group_ad_ad_app_ad_mandatory_ad_text An optional text asset that, if specified, must always be displayed when the ad is served.
ad_group_ad_ad_gmail_ad_marketing_image_headline Headline of the marketing image.
ad_group_ad_ad_final_urls The list of possible final URLs after all cross-domain redirects for the ad.
ad_group_ad_ad_expanded_text_ad_headline_part1 The first part of the ad's headline.
ad_group_ad_ad_text_ad_description2 The second line of the ad's description.
ad_group_ad_ad_legacy_responsive_display_ad_description The description of the ad.
ad_group_ad_ad_legacy_responsive_display_ad_main_color The main color of the ad in hexadecimal, e.g. #ffffff for white. If one of main_color and accent_color is set, the other is required as well.
ad_group_ad_ad_responsive_display_ad_square_logo_images Square logo images to be used in the ad. Valid image types are GIF, JPEG, and PNG. The minimum size is 128x128 and the aspect ratio must be 1:1 (+-1%). Combined with square_logo_images the maximum is 5.
ad_group_ad_ad_group The ad group to which the ad belongs.
ad_group_ad_ad_responsive_display_ad_business_name The advertiser/brand name. Maximum display width is 25.
ad_group_ad_ad_responsive_search_ad_path1 First part of text that may appear appended to the url displayed in the ad.
ad_group_ad_ad_image_ad_name The name of the image. If the image was created from a MediaFile, this is the MediaFile's name. If the image was created from bytes, this is empty.
ad_group_ad_ad_responsive_display_ad_marketing_images Marketing images to be used in the ad. Valid image types are GIF, JPEG, and PNG. The minimum size is 600x314 and the aspect ratio must be 1.91:1 (+-1%). At least one marketing_image is required. Combined with square_marketing_images the maximum is 15.
campaign_id The ID of the campaign.
ad_group_ad_ad_app_ad_youtube_videos List of YouTube video assets that may be displayed with the ad.
ad_group_ad_ad_legacy_responsive_display_ad_accent_color The accent color of the ad in hexadecimal, e.g. #ffffff for white. If one of main_color and accent_color is set, the other is required as well.
ad_group_ad_ad_expanded_text_ad_description2 The second description of the ad.
ad_group_ad_ad_image_ad_image_url URL of the full size image.
ad_group_ad_ad_responsive_display_ad_youtube_videos Optional YouTube videos for the ad. A maximum of 5 videos can be specified.
ad_group_ad_ad_gmail_ad_header_image The MediaFile resource name of the header image. Valid image types are GIF, JPEG and PNG. The minimum size is 300x100 pixels and the aspect ratio must be between 3:1 and 5:1 (+-1%).
ad_group_ad_ad_expanded_text_ad_path2 Additional text that can appear alongside the ad's displayed URL.
ad_group_ad_ad_legacy_responsive_display_ad_business_name The business name in the ad.
ad_group_ad_ad_gmail_ad_teaser_headline Headline of the teaser.
ad_group_ad_ad_legacy_responsive_display_ad_allow_flexible_color Advertiser's consent to allow flexible color. When true, the ad may be served with different color if necessary. When false, the ad will be served with the specified colors or a neutral color. The default value is true. Must be true if main_color and accent_color are not set.
ad_group_ad_ad_system_managed_resource_source If this ad is system managed, then this field will indicate the source. This field is read-only.

Table Name: Basic_LandingPage

Field Name Description
customer_id The ID of the customer.
ad_group_status The status of the ad group.
metrics_mobile_friendly_clicks_percentage The percentage of mobile clicks that go to a mobile-friendly page.
metrics_speed_score A measure of how quickly your page loads after clicks on your mobile ads. The score is a range from 1 to 10, 10 being the fastest.
metrics_clicks The number of clicks.
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
landing_page_view_unexpanded_final_url The advertiser-specified final URL.
metrics_average_cpc The total cost of all clicks divided by the total number of clicks received.
metrics_ctr The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
metrics_valid_accelerated_mobile_pages_clicks_percentage The percentage of ad clicks to Accelerated Mobile Pages (AMP) landing pages that reach a valid AMP page.
campaign_name The name of the campaign. This field is required and should not be empty when creating new campaigns. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
ad_group_name The name of the ad group. This field is required and should not be empty when creating new ad groups. It must contain fewer than 255 UTF-8 full-width characters. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters.

Table Name: HourlyCampaignConversionStats

Field Name Description
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
segments_ad_network_type Ad network type.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
segments_conversion_action_name Conversion action name.
segments_conversion_action Resource name of the conversion action.
segments_device Device to which metrics apply.
campaign_id The ID of the campaign.
segments_year Year, formatted as yyyy.
customer_id The ID of the customer.
segments_day_of_week Day of the week, e.g., MONDAY.
segments_hour Hour of day as a number between 0 and 23, inclusive.
segments_click_type Click type.
segments_conversion_action_category Conversion action category.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.

Table Name: Basic_FinalUrl

Field Name Description
campaign_name The name of the campaign. This field is required and should not be empty when creating new campaigns. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters.
campaign_id The ID of the campaign.
metrics_conversions_from_interactions_rate Conversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_average_cpc The total cost of all clicks divided by the total number of clicks received.
metrics_view_through_conversions The total number of view-through conversions. These happen when a customer sees an image or rich media ad, then later completes a conversion on your site without interacting with (e.g., clicking on) another ad.
metrics_ctr The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
ad_group_ad_ad_final_urls The list of possible final URLs after all cross-domain redirects for the ad.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
metrics_clicks The number of clicks.
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
ad_group_name The name of the ad group. This field is required and should not be empty when creating new ad groups. It must contain fewer than 255 UTF-8 full-width characters. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters.
customer_id The ID of the customer.
metrics_cost_per_conversion The cost of ad interactions divided by conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
ad_group_id The ID of the ad group.
metrics_average_cpm Average cost-per-thousand impressions (CPM).
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.

Table Name: AccountNonClickStats

Field Name Description
metrics_all_conversions_from_interactions_rate All conversions from interactions (as oppose to view through conversions) divided by the number of ad interactions.
metrics_content_impression_share The impressions you've received on the Display Network divided by the estimated number of impressions you were eligible to receive. Note: Content impression share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999.
metrics_engagement_rate How often people engage with your ad after it's shown to them. This is the number of ad expansions divided by the number of times your ad is shown.
metrics_all_conversions_value The total value of all conversions.
metrics_content_rank_lost_impression_share The estimated percentage of impressions on the Display Network that your ads didn't receive due to poor Ad Rank. Note: Content rank lost impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
metrics_cross_device_conversions Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
metrics_all_conversions The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_average_cpe The average amount that you've been charged for an ad engagement. This amount is the total cost of all ad engagements divided by the total number of ad engagements.
metrics_cost_per_all_conversions The cost of ad interactions divided by all conversions.
segments_day_of_week Day of the week, e.g., MONDAY.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
segments_ad_network_type Ad network type.
metrics_video_view_rate The number of views your TrueView video ad receives divided by its number of impressions, including thumbnail impressions for TrueView in-display ads.
metrics_average_cpv The average amount you pay each time someone views your ad. The average CPV is defined by the total cost of all ad views divided by the number of views.
customer_id The ID of the customer.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
metrics_video_views The number of times your video ads were viewed.
metrics_search_exact_match_impression_share 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. Note: Search exact match impression share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999.
metrics_engagements The number of engagements. An engagement occurs when a viewer expands your Lightbox ad. Also, in the future, other ad types may support engagement metrics.
metrics_search_budget_lost_impression_share The estimated percent of times that your ad was eligible to show on the Search Network but didn't because your budget was too low. Note: Search budget lost impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
metrics_value_per_all_conversions The value of all conversions divided by the number of all conversions.
metrics_search_rank_lost_impression_share The estimated percentage of impressions on the Search Network that your ads didn't receive due to poor Ad Rank. Note: Search rank lost impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
metrics_content_budget_lost_impression_share The estimated percent of times that your ad was eligible to show on the Display Network but didn't because your budget was too low. Note: Content budget lost impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
metrics_search_impression_share The impressions you've received on the Search Network divided by the estimated number of impressions you were eligible to receive. Note: Search impression share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
metrics_invalid_click_rate The percentage of clicks filtered out of your total number of clicks (filtered + non-filtered clicks) during the reporting period.
metrics_invalid_clicks Number of clicks Google considers illegitimate and doesn't charge you for.
segments_year Year, formatted as yyyy.

Table Name: AdGroupCriterion

Field Name Description
ad_group_criterion_status The status of the criterion.
ad_group_criterion_ad_group The ad group to which the criterion belongs.
ad_group_criterion_criterion_id The ID of the criterion. This field is ignored for mutates.
ad_group_criterion_negative Whether to target (`false`) or exclude (`true`) the criterion.
ad_group_criterion_display_name The display name of the criterion. This field is ignored for mutates.
ad_group_criterion_bid_modifier The modifier for the bid when the criterion matches. The modifier must be in the range: 0.1 - 10.0. Most targetable criteria types support modifiers.
ad_group_name The name of the ad group. This field is required and should not be empty when creating new ad groups. It must contain fewer than 255 UTF-8 full-width characters. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters.
ad_group_id The ID of the ad group.

Table Name: AgeRangeStats

Field Name Description
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
metrics_cost_per_all_conversions The cost of ad interactions divided by all conversions.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_active_view_viewability The percentage of time when your ad appeared on an Active View enabled site (measurable impressions) and was viewable (viewable impressions).
metrics_active_view_measurable_impressions The number of times your ads are appearing on placements in positions where they can be seen.
metrics_gmail_forwards The number of times the ad was forwarded to someone else as a message.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
customer_id The ID of the customer.
ad_group_id The ID of the ad group.
metrics_interactions The number of interactions. An interaction is the main user action associated with an ad format-clicks for text and shopping ads, views for video ads, and so on.
campaign_id The ID of the campaign.
segments_year Year, formatted as yyyy.
metrics_average_cpm Average cost-per-thousand impressions (CPM).
metrics_all_conversions_value The total value of all conversions.
metrics_active_view_measurability The ratio of impressions that could be measured by Active View over the number of served impressions.
metrics_active_view_ctr Active view measurable clicks divided by active view viewable impressions. This metric is reported only for display network.
metrics_clicks The number of clicks.
metrics_average_cost The average amount you pay per interaction. This amount is the total cost of your ads divided by the total number of interactions.
metrics_active_view_measurable_cost_micros The cost of the impressions you received that were measurable by Active View.
metrics_gmail_saves The number of times someone has saved your Gmail ad to their inbox as a message.
metrics_gmail_secondary_clicks The number of clicks to the landing page on the expanded state of Gmail ads.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
metrics_conversions_from_interactions_rate Conversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_cost_per_conversion The cost of ad interactions divided by conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_ad_network_type Ad network type.
segments_click_type Click type.
metrics_cross_device_conversions Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
metrics_all_conversions_from_interactions_rate All conversions from interactions (as oppose to view through conversions) divided by the number of ad interactions.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
metrics_interaction_rate How often people interact with your ad after it is shown to them. This is the number of interactions divided by the number of times your ad is shown.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_active_view_cpm Average cost of viewable impressions (`active_view_impressions`).
segments_day_of_week Day of the week, e.g., MONDAY.
segments_device Device to which metrics apply.
ad_group_criterion_criterion_id The ID of the criterion. This field is ignored for mutates.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_active_view_impressions A measurement of how often your ad has become viewable on a Display Network site.
metrics_average_cpc The total cost of all clicks divided by the total number of clicks received.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
metrics_interaction_event_types The types of payable and free interactions.
metrics_value_per_all_conversions The value of all conversions divided by the number of all conversions.
metrics_all_conversions The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_ctr The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.

Table Name: VideoNonClickStats

Field Name Description
metrics_video_quartile_p25_rate Percentage of impressions where the viewer watched 25% of your video.
metrics_engagements The number of engagements. An engagement occurs when a viewer expands your Lightbox ad. Also, in the future, other ad types may support engagement metrics.
metrics_all_conversions_value The total value of all conversions.
metrics_average_cpv The average amount you pay each time someone views your ad. The average CPV is defined by the total cost of all ad views divided by the number of views.
metrics_video_views The number of times your video ads were viewed.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
metrics_video_quartile_p75_rate Percentage of impressions where the viewer watched 75% of your video.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
metrics_video_quartile_p100_rate Percentage of impressions where the viewer watched all of your video.
campaign_id The ID of the campaign.
segments_device Device to which metrics apply.
ad_group_id The ID of the ad group.
ad_group_ad_ad_id The ID of the ad.
ad_group_ad_status The status of the ad.
metrics_all_conversions_from_interactions_rate All conversions from interactions (as oppose to view through conversions) divided by the number of ad interactions.
metrics_value_per_all_conversions The value of all conversions divided by the number of all conversions.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
metrics_all_conversions The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_ad_network_type Ad network type.
metrics_cross_device_conversions Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
customer_id The ID of the customer.
metrics_video_view_rate The number of views your TrueView video ad receives divided by its number of impressions, including thumbnail impressions for TrueView in-display ads.
video_channel_id The owner channel id of the video.
metrics_cost_per_all_conversions The cost of ad interactions divided by all conversions.
segments_day_of_week Day of the week, e.g., MONDAY.
video_id The ID of the video.
segments_year Year, formatted as yyyy.
metrics_video_quartile_p50_rate Percentage of impressions where the viewer watched 50% of your video.
metrics_engagement_rate How often people engage with your ad after it's shown to them. This is the number of ad expansions divided by the number of times your ad is shown.

Table Name: ShoppingProductStats

Field Name Description
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
segments_ad_network_type Ad network type.
segments_product_merchant_id Merchant ID of the product.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_value_per_all_conversions The value of all conversions divided by the number of all conversions.
segments_product_bidding_category_level4 Bidding category (level 4) of the product.
segments_product_custom_attribute1 Custom attribute 1 of the product.
customer_id The ID of the customer.
segments_product_type_l4 Type (level 4) of the product.
segments_product_aggregator_id Aggregator ID of the product.
segments_year Year, formatted as yyyy.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_all_conversions_value The total value of all conversions.
segments_day_of_week Day of the week, e.g., MONDAY.
segments_product_custom_attribute4 Custom attribute 4 of the product.
segments_product_condition Condition of the product.
metrics_all_conversions_from_interactions_rate All conversions from interactions (as oppose to view through conversions) divided by the number of ad interactions.
metrics_average_cpc The total cost of all clicks divided by the total number of clicks received.
segments_product_bidding_category_level5 Bidding category (level 5) of the product.
metrics_cost_per_all_conversions The cost of ad interactions divided by all conversions.
segments_product_custom_attribute3 Custom attribute 3 of the product.
metrics_search_impression_share The impressions you've received on the Search Network divided by the estimated number of impressions you were eligible to receive. Note: Search impression share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
campaign_status The status of the campaign. When a new campaign is added, the status defaults to ENABLED.
metrics_all_conversions The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_search_absolute_top_impression_share The percentage of the customer's Shopping or Search ad impressions that are shown in the most prominent Shopping position. See https://support.google.com/google-ads/answer/7501826 for details. Any value below 0.1 is reported as 0.0999.
segments_product_custom_attribute2 Custom attribute 2 of the product.
metrics_clicks The number of clicks.
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
segments_product_item_id Item ID of the product.
metrics_cross_device_conversions Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
segments_product_channel Channel of the product.
campaign_id The ID of the campaign.
segments_product_channel_exclusivity Channel exclusivity of the product.
segments_product_bidding_category_level3 Bidding category (level 3) of the product.
metrics_cost_per_conversion The cost of ad interactions divided by conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_product_language Resource name of the language constant for the language of the product.
segments_product_type_l3 Type (level 3) of the product.
segments_product_country Resource name of the geo target constant for the country of sale of the product.
segments_product_bidding_category_level1 Bidding category (level 1) of the product.
segments_product_bidding_category_level2 Bidding category (level 2) of the product.
metrics_conversions_from_interactions_rate Conversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_ctr The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
segments_product_type_l2 Type (level 2) of the product.
segments_product_custom_attribute0 Custom attribute 0 of the product.
segments_product_brand Brand of the product.
segments_device Device to which metrics apply.
metrics_search_click_share The number of clicks you've received on the Search Network divided by the estimated number of clicks you were eligible to receive. Note: Search click share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999.
segments_product_type_l5 Type (level 5) of the product.
segments_product_type_l1 Type (level 1) of the product.

Table Name: BidGoalStats

Field Name Description
segments_year Year, formatted as yyyy.
metrics_ctr The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
metrics_all_conversions_from_interactions_rate All conversions from interactions (as oppose to view through conversions) divided by the number of ad interactions.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
bidding_strategy_id The ID of the bidding strategy.
segments_day_of_week Day of the week, e.g., MONDAY.
bidding_strategy_campaign_count The number of campaigns attached to this bidding strategy. This field is read-only.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
metrics_cost_per_conversion The cost of ad interactions divided by conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_device Device to which metrics apply.
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
metrics_average_cpm Average cost-per-thousand impressions (CPM).
metrics_average_cpc The total cost of all clicks divided by the total number of clicks received.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_cost_per_all_conversions The cost of ad interactions divided by all conversions.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
metrics_clicks The number of clicks.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
bidding_strategy_non_removed_campaign_count The number of non-removed campaigns attached to this bidding strategy. This field is read-only.
customer_id The ID of the customer.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_conversions_from_interactions_rate Conversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). This only includes conversion actions which include_in_conversions_metric attribute is set to true.

Table Name: AgeRangeBasicStats

Field Name Description
metrics_cross_device_conversions Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
metrics_interactions The number of interactions. An interaction is the main user action associated with an ad format-clicks for text and shopping ads, views for video ads, and so on.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_active_view_measurable_cost_micros The cost of the impressions you received that were measurable by Active View.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
metrics_active_view_impressions A measurement of how often your ad has become viewable on a Display Network site.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_active_view_measurable_impressions The number of times your ads are appearing on placements in positions where they can be seen.
ad_group_id The ID of the ad group.
metrics_all_conversions_value The total value of all conversions.
metrics_active_view_measurability The ratio of impressions that could be measured by Active View over the number of served impressions.
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
campaign_id The ID of the campaign.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
segments_device Device to which metrics apply.
customer_id The ID of the customer.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
metrics_view_through_conversions The total number of view-through conversions. These happen when a customer sees an image or rich media ad, then later completes a conversion on your site without interacting with (e.g., clicking on) another ad.
metrics_interaction_event_types The types of payable and free interactions.
ad_group_criterion_criterion_id The ID of the criterion. This field is ignored for mutates.
segments_ad_network_type Ad network type.
metrics_clicks The number of clicks.
metrics_all_conversions The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_active_view_viewability The percentage of time when your ad appeared on an Active View enabled site (measurable impressions) and was viewable (viewable impressions).

Table Name: Locations_Geographic

Field Name Description
metrics_cost_per_conversion The cost of ad interactions divided by conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_geo_target_most_specific_location Resource name of the geo target constant that represents the most specific location.
segments_geo_target_city Resource name of the geo target constant that represents a city.
segments_geo_target_metro Resource name of the geo target constant that represents a metro.
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
customer_id The ID of the customer.
geographic_view_location_type Type of the geo targeting of the campaign.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_geo_target_region Resource name of the geo target constant that represents a region.
geographic_view_country_criterion_id Criterion Id for the country.
metrics_conversions_from_interactions_rate Conversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_average_cpc The total cost of all clicks divided by the total number of clicks received.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
metrics_clicks The number of clicks.
metrics_ctr The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
metrics_view_through_conversions The total number of view-through conversions. These happen when a customer sees an image or rich media ad, then later completes a conversion on your site without interacting with (e.g., clicking on) another ad.

Table Name: HourlyCampaignStats

Field Name Description
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_active_view_impressions A measurement of how often your ad has become viewable on a Display Network site.
segments_ad_network_type Ad network type.
metrics_active_view_measurability The ratio of impressions that could be measured by Active View over the number of served impressions.
metrics_clicks The number of clicks.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
metrics_cost_per_conversion The cost of ad interactions divided by conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_interaction_event_types The types of payable and free interactions.
metrics_active_view_ctr Active view measurable clicks divided by active view viewable impressions. This metric is reported only for display network.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
segments_year Year, formatted as yyyy.
metrics_active_view_viewability The percentage of time when your ad appeared on an Active View enabled site (measurable impressions) and was viewable (viewable impressions).
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
segments_hour Hour of day as a number between 0 and 23, inclusive.
metrics_average_cpm Average cost-per-thousand impressions (CPM).
metrics_ctr The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
metrics_average_cost The average amount you pay per interaction. This amount is the total cost of your ads divided by the total number of interactions.
customer_id The ID of the customer.
campaign_id The ID of the campaign.
metrics_interaction_rate How often people interact with your ad after it is shown to them. This is the number of interactions divided by the number of times your ad is shown.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
segments_day_of_week Day of the week, e.g., MONDAY.
metrics_active_view_measurable_cost_micros The cost of the impressions you received that were measurable by Active View.
metrics_active_view_measurable_impressions The number of times your ads are appearing on placements in positions where they can be seen.
segments_click_type Click type.
metrics_interactions The number of interactions. An interaction is the main user action associated with an ad format-clicks for text and shopping ads, views for video ads, and so on.
metrics_average_cpc The total cost of all clicks divided by the total number of clicks received.
metrics_conversions_from_interactions_rate Conversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
segments_device Device to which metrics apply.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_active_view_cpm Average cost of viewable impressions (`active_view_impressions`).

Table Name: AdCrossDeviceStats

Field Name Description
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
metrics_video_quartile_p50_rate Percentage of impressions where the viewer watched 50% of your video.
metrics_video_views The number of times your video ads were viewed.
customer_id The ID of the customer.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
metrics_top_impression_percentage The percent of your ad impressions that are shown anywhere above the organic search results.
metrics_cross_device_conversions Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
metrics_engagements The number of engagements. An engagement occurs when a viewer expands your Lightbox ad. Also, in the future, other ad types may support engagement metrics.
metrics_value_per_all_conversions The value of all conversions divided by the number of all conversions.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
metrics_video_quartile_p100_rate Percentage of impressions where the viewer watched all of your video.
metrics_average_time_on_site Total duration of all sessions (in seconds) / number of sessions. Imported from Google Analytics.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
metrics_video_quartile_p75_rate Percentage of impressions where the viewer watched 75% of your video.
metrics_average_cpv The average amount you pay each time someone views your ad. The average CPV is defined by the total cost of all ad views divided by the number of views.
segments_keyword_ad_group_criterion The AdGroupCriterion resource name.
metrics_percent_new_visitors Percentage of first-time sessions (from people who had never visited your site before). Imported from Google Analytics.
metrics_all_conversions_value The total value of all conversions.
metrics_bounce_rate Percentage of clicks where the user only visited a single page on your site. Imported from Google Analytics.
metrics_all_conversions The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
ad_group_ad_ad_id The ID of the ad.
metrics_video_quartile_p25_rate Percentage of impressions where the viewer watched 25% of your video.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
segments_ad_network_type Ad network type.
metrics_video_view_rate The number of views your TrueView video ad receives divided by its number of impressions, including thumbnail impressions for TrueView in-display ads.
segments_year Year, formatted as yyyy.
metrics_cost_per_all_conversions The cost of ad interactions divided by all conversions.
segments_day_of_week Day of the week, e.g., MONDAY.
metrics_all_conversions_from_interactions_rate All conversions from interactions (as oppose to view through conversions) divided by the number of ad interactions.
campaign_id The ID of the campaign.
metrics_engagement_rate How often people engage with your ad after it's shown to them. This is the number of ad expansions divided by the number of times your ad is shown.
metrics_absolute_top_impression_percentage The percent of your ad impressions that are shown as the very first ad above the organic search results.
ad_group_ad_ad_group The ad group to which the ad belongs.
metrics_average_page_views Average number of pages viewed per session.
metrics_average_cpe The average amount that you've been charged for an ad engagement. This amount is the total cost of all ad engagements divided by the total number of ad engagements.

Table Name: CampaignConversionStats

Field Name Description
segments_year Year, formatted as yyyy.
customer_id The ID of the customer.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
segments_conversion_action Resource name of the conversion action.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
segments_conversion_action_name Conversion action name.
segments_ad_network_type Ad network type.
segments_slot Position of the ad.
segments_day_of_week Day of the week, e.g., MONDAY.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
segments_conversion_action_category Conversion action category.
segments_conversion_attribution_event_type Conversion attribution event type.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
campaign_id The ID of the campaign.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.

Table Name: AdGroupBidModifier

Field Name Description
ad_group_bid_modifier_bid_modifier_source Bid modifier source.
ad_group_bid_modifier_resource_name The resource name of the ad group bid modifier. Ad group bid modifier resource names have the form: `customers/{customer_id}/adGroupBidModifiers/{ad_group_id}~{criterion_id}`
ad_group_bid_modifier_criterion_id The ID of the criterion to bid modify. This field is ignored for mutates.
ad_group_bid_modifier_ad_group The ad group to which this criterion belongs.
ad_group_id The ID of the ad group.
ad_group_name The name of the ad group. This field is required and should not be empty when creating new ad groups. It must contain fewer than 255 UTF-8 full-width characters. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters.
ad_group_bid_modifier_base_ad_group The base ad group from which this draft/trial adgroup bid modifier was created. If ad_group is a base ad group then this field will be equal to ad_group. If the ad group was created in the draft or trial and has no corresponding base ad group, then this field will be null. This field is readonly.
ad_group_bid_modifier_bid_modifier The modifier for the bid when the criterion matches. The modifier must be in the range: 0.1 - 10.0. The range is 1.0 - 6.0 for PreferredContent. Use 0 to opt out of a Device type.
ad_group_bid_modifier_device_type Type of the device.

Table Name: CampaignLabel

Field Name Description
campaign_label_campaign The campaign to which the label is attached.
campaign_label_resource_name Name of the resource. Campaign label resource names have the form: `customers/{customer_id}/campaignLabels/{campaign_id}~{label_id}`
label_resource_name Name of the resource. Label resource names have the form: `customers/{customer_id}/labels/{label_id}`
campaign_id The ID of the campaign.
label_id Id of the label. Read only.
label_name The name of the label. This field is required and should not be empty when creating a new label. The length of this string should be between 1 and 80, inclusive.
campaign_label_label The label assigned to the campaign.
campaign_name The name of the campaign. This field is required and should not be empty when creating new campaigns. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters.

Table Name: AdGroupCrossDeviceConversionStats

Field Name Description
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
campaign_id The ID of the campaign.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
segments_day_of_week Day of the week, e.g., MONDAY.
segments_conversion_action Resource name of the conversion action.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
metrics_all_conversions_value The total value of all conversions.
ad_group_id The ID of the ad group.
segments_conversion_action_name Conversion action name.
metrics_cross_device_conversions Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
customer_id The ID of the customer.
metrics_all_conversions The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
metrics_value_per_all_conversions The value of all conversions divided by the number of all conversions.
segments_year Year, formatted as yyyy.
segments_ad_network_type Ad network type.
segments_conversion_action_category Conversion action category.

Table Name: HourlyAccountConversionStats

Field Name Description
segments_conversion_action Resource name of the conversion action.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
customer_id The ID of the customer.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
segments_year Year, formatted as yyyy.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_hour Hour of day as a number between 0 and 23, inclusive.
segments_device Device to which metrics apply.
segments_ad_network_type Ad network type.
segments_conversion_action_name Conversion action name.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
segments_conversion_action_category Conversion action category.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
segments_day_of_week Day of the week, e.g., MONDAY.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
segments_click_type Click type.

Table Name: AdGroupAudienceNonClickStats

Field Name Description
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
metrics_video_views The number of times your video ads were viewed.
ad_group_campaign The campaign to which the ad group belongs.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
segments_ad_network_type Ad network type.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
metrics_video_view_rate The number of views your TrueView video ad receives divided by its number of impressions, including thumbnail impressions for TrueView in-display ads.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
segments_day_of_week Day of the week, e.g., MONDAY.
segments_year Year, formatted as yyyy.
metrics_average_cpe The average amount that you've been charged for an ad engagement. This amount is the total cost of all ad engagements divided by the total number of ad engagements.
ad_group_id The ID of the ad group.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
segments_device Device to which metrics apply.
metrics_average_cpv The average amount you pay each time someone views your ad. The average CPV is defined by the total cost of all ad views divided by the number of views.
metrics_engagements The number of engagements. An engagement occurs when a viewer expands your Lightbox ad. Also, in the future, other ad types may support engagement metrics.
customer_id The ID of the customer.
metrics_engagement_rate How often people engage with your ad after it's shown to them. This is the number of ad expansions divided by the number of times your ad is shown.

Table Name: Keyword

Field Name Description
ad_group_criterion_criterion_id The ID of the criterion. This field is ignored for mutates.
ad_group_criterion_status The status of the criterion.
ad_group_criterion_quality_info_creative_quality_score The performance of the ad compared to other advertisers.
ad_group_criterion_final_mobile_urls The list of possible final mobile URLs after all cross-domain redirects.
ad_group_criterion_effective_cpm_bid_micros The effective CPM (cost-per-thousand viewable impressions) bid.
ad_group_criterion_keyword_text The text of the keyword (at most 80 characters and 10 words).
ad_group_criterion_position_estimates_top_of_page_cpc_micros The estimate of the CPC bid required for ad to be displayed at the top of the first page of search results.
ad_group_criterion_tracking_url_template The URL template for constructing a tracking URL.
ad_group_criterion_quality_info_quality_score The quality score. This field may not be populated if Google does not have enough information to determine a value.
campaign_bidding_strategy Portfolio bidding strategy used by campaign.
ad_group_criterion_position_estimates_first_page_cpc_micros The estimate of the CPC bid required for ad to be shown on first page of search results.
campaign_bidding_strategy_type The type of bidding strategy. A bidding strategy can be created by setting either the bidding scheme to create a standard bidding strategy or the `bidding_strategy` field to create a portfolio bidding strategy. This field is read-only.
ad_group_criterion_quality_info_search_predicted_ctr The click-through rate compared to that of other advertisers.
ad_group_criterion_negative Whether to target (`false`) or exclude (`true`) the criterion. This field is immutable. To switch a criterion from positive to negative, remove then re-add it.
ad_group_criterion_effective_cpc_bid_micros The effective CPC (cost-per-click) bid.
ad_group_criterion_approval_status Approval status of the criterion.
campaign_percent_cpc_enhanced_cpc_enabled Adjusts the bid for each auction upward or downward, depending on the likelihood of a conversion. Individual bids may exceed cpc_bid_ceiling_micros, but the average bid amount for a campaign should not.
ad_group_criterion_system_serving_status Serving status of the criterion.
ad_group_criterion_topic_topic_constant The Topic Constant resource name.
ad_group_id The ID of the ad group.
ad_group_criterion_position_estimates_first_position_cpc_micros The estimate of the CPC bid required for ad to be displayed in first position, at the top of the first page of search results.
ad_group_criterion_position_estimates_estimated_add_clicks_at_first_position_cpc Estimate of how many clicks per week you might get by changing your keyword bid to the value in first_position_cpc_micros.
ad_group_criterion_keyword_match_type The match type of the keyword.
campaign_id The ID of the campaign.
ad_group_criterion_effective_cpc_bid_source Source of the effective CPC bid.
ad_group_criterion_quality_info_post_click_quality_score The quality score of the landing page.
ad_group_criterion_final_url_suffix URL template for appending params to final URL.
ad_group_criterion_url_custom_parameters The list of mappings used to substitute custom parameter tags in a `tracking_url_template`, `final_urls`, or `mobile_final_urls`.
campaign_manual_cpc_enhanced_cpc_enabled Whether bids are to be enhanced based on conversion optimizer data.
customer_id The ID of the customer.
ad_group_criterion_position_estimates_estimated_add_cost_at_first_position_cpc Estimate of how your cost per week might change when changing your keyword bid to the value in first_position_cpc_micros.
ad_group_criterion_final_urls The list of possible final URLs after all cross-domain redirects for the ad.

Table Name: AdGroupAudienceConversionStats

Field Name Description
metrics_cross_device_conversions Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
segments_year Year, formatted as yyyy.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
segments_day_of_week Day of the week, e.g., MONDAY.
ad_group_id The ID of the ad group.
segments_conversion_action Resource name of the conversion action.
metrics_all_conversions The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_view_through_conversions The total number of view-through conversions. These happen when a customer sees an image or rich media ad, then later completes a conversion on your site without interacting with (e.g., clicking on) another ad.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_conversion_action_name Conversion action name.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
ad_group_campaign The campaign to which the ad group belongs.
segments_conversion_action_category Conversion action category.
metrics_value_per_all_conversions The value of all conversions divided by the number of all conversions.
segments_ad_network_type Ad network type.
metrics_all_conversions_value The total value of all conversions.
customer_id The ID of the customer.
ad_group_criterion_criterion_id The ID of the criterion. This field is ignored for mutates.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_device Device to which metrics apply.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.

Table Name: AccountConversionStats

Field Name Description
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
segments_device Device to which metrics apply.
segments_day_of_week Day of the week, e.g., MONDAY.
segments_conversion_action_category Conversion action category.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
segments_year Year, formatted as yyyy.
segments_slot Position of the ad.
segments_conversion_action_name Conversion action name.
customer_id The ID of the customer.
segments_conversion_action Resource name of the conversion action.
segments_ad_network_type Ad network type.
segments_click_type Click type.

Table Name: CampaignStats

Field Name Description
metrics_average_cost The average amount you pay per interaction. This amount is the total cost of your ads divided by the total number of interactions.
metrics_gmail_saves The number of times someone has saved your Gmail ad to their inbox as a message.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_average_cpm Average cost-per-thousand impressions (CPM).
metrics_interaction_rate How often people interact with your ad after it is shown to them. This is the number of interactions divided by the number of times your ad is shown.
metrics_ctr The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
segments_day_of_week Day of the week, e.g., MONDAY.
metrics_active_view_measurable_impressions The number of times your ads are appearing on placements in positions where they can be seen.
metrics_interactions The number of interactions. An interaction is the main user action associated with an ad format-clicks for text and shopping ads, views for video ads, and so on.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
customer_id The ID of the customer.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
metrics_active_view_measurability The ratio of impressions that could be measured by Active View over the number of served impressions.
segments_device Device to which metrics apply.
metrics_conversions_from_interactions_rate Conversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_active_view_viewability The percentage of time when your ad appeared on an Active View enabled site (measurable impressions) and was viewable (viewable impressions).
segments_click_type Click type.
metrics_value_per_current_model_attributed_conversion The value of current model attributed conversions divided by the number of the conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_cost_per_conversion The cost of ad interactions divided by conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
metrics_gmail_forwards The number of times the ad was forwarded to someone else as a message.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_year Year, formatted as yyyy.
metrics_active_view_impressions A measurement of how often your ad has become viewable on a Display Network site.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_ad_network_type Ad network type.
metrics_cost_per_current_model_attributed_conversion The cost of ad interactions divided by current model attributed conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_active_view_measurable_cost_micros The cost of the impressions you received that were measurable by Active View.
metrics_active_view_cpm Average cost of viewable impressions (`active_view_impressions`).
metrics_gmail_secondary_clicks The number of clicks to the landing page on the expanded state of Gmail ads.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
metrics_active_view_ctr Active view measurable clicks divided by active view viewable impressions. This metric is reported only for display network.
metrics_average_cpc The total cost of all clicks divided by the total number of clicks received.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
campaign_id The ID of the campaign.
metrics_interaction_event_types The types of payable and free interactions.
metrics_current_model_attributed_conversions Shows how your historic conversions data would look under the attribution model you've currently selected. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_clicks The number of clicks.
metrics_current_model_attributed_conversions_value The total value of current model attributed conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.

Table Name: Placement

Field Name Description
ad_group_id The ID of the ad group.
ad_group_criterion_placement_url URL of the placement. For example, \"http://www.domain.com\".
ad_group_criterion_tracking_url_template The URL template for constructing a tracking URL.
ad_group_criterion_url_custom_parameters The list of mappings used to substitute custom parameter tags in a `tracking_url_template`, `final_urls`, or `mobile_final_urls`.
ad_group_criterion_bid_modifier The modifier for the bid when the criterion matches. The modifier must be in the range: 0.1 - 10.0. Most targetable criteria types support modifiers.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
ad_group_targeting_setting_target_restrictions The per-targeting-dimension setting to restrict the reach of your campaign or ad group.
ad_group_criterion_final_urls The list of possible final URLs after all cross-domain redirects for the ad.
ad_group_criterion_negative Whether to target (`false`) or exclude (`true`) the criterion. This field is immutable. To switch a criterion from positive to negative, remove then re-add it.
ad_group_criterion_effective_cpc_bid_source Source of the effective CPC bid.
campaign_bidding_strategy Portfolio bidding strategy used by campaign.
customer_id The ID of the customer.
bidding_strategy_name The name of the bidding strategy. All bidding strategies within an account must be named distinctly. The length of this string should be between 1 and 255, inclusive, in UTF-8 bytes, (trimmed).
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
ad_group_criterion_criterion_id The ID of the criterion. This field is ignored for mutates.
ad_group_criterion_effective_cpc_bid_micros The effective CPC (cost-per-click) bid.
bidding_strategy_type The type of the bidding strategy. Create a bidding strategy by setting the bidding scheme. This field is read-only.
ad_group_criterion_effective_cpm_bid_micros The effective CPM (cost-per-thousand viewable impressions) bid.
campaign_id The ID of the campaign.
ad_group_criterion_final_mobile_urls The list of possible final mobile URLs after all cross-domain redirects.
ad_group_criterion_status The status of the criterion.
ad_group_criterion_effective_cpm_bid_source Source of the effective CPM bid.

Table Name: BidGoal

Field Name Description
customer_descriptive_name Optional, non-unique descriptive name of the customer.
bidding_strategy_name The name of the bidding strategy. All bidding strategies within an account must be named distinctly. The length of this string should be between 1 and 255, inclusive, in UTF-8 bytes, (trimmed).
bidding_strategy_target_spend_cpc_bid_ceiling_micros Maximum bid limit that can be set by the bid strategy. The limit applies to all keywords managed by the strategy.
bidding_strategy_target_roas_cpc_bid_ceiling_micros Maximum bid limit that can be set by the bid strategy. The limit applies to all keywords managed by the strategy.
bidding_strategy_target_cpa_target_cpa_micros Average CPA target. This target should be greater than or equal to minimum billable unit based on the currency for the account.
bidding_strategy_target_roas_target_roas Required. The desired revenue (based on conversion data) per unit of spend. Value must be between 0.01 and 1000.0, inclusive.
bidding_strategy_target_spend_target_spend_micros The spend target under which to maximize clicks. A TargetSpend bidder will attempt to spend the smaller of this value or the natural throttling spend amount. If not specified, the budget is used as the spend target.
bidding_strategy_target_cpa_cpc_bid_ceiling_micros Maximum bid limit that can be set by the bid strategy. The limit applies to all keywords managed by the strategy.
bidding_strategy_id The ID of the bidding strategy.
bidding_strategy_target_roas_cpc_bid_floor_micros Minimum bid limit that can be set by the bid strategy. The limit applies to all keywords managed by the strategy.
bidding_strategy_status The status of the bidding strategy. This field is read-only.
customer_id The ID of the customer.
bidding_strategy_type The type of the bidding strategy. Create a bidding strategy by setting the bidding scheme. This field is read-only.
bidding_strategy_target_cpa_cpc_bid_floor_micros Minimum bid limit that can be set by the bid strategy. The limit applies to all keywords managed by the strategy.

Table Name: DisplayVideo_Keyword

Field Name Description
campaign_bidding_strategy_type The type of bidding strategy. A bidding strategy can be created by setting either the bidding scheme to create a standard bidding strategy or the `bidding_strategy` field to create a portfolio bidding strategy. This field is read-only.
campaign_name The name of the campaign. This field is required and should not be empty when creating new campaigns. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters.
metrics_view_through_conversions The total number of view-through conversions. These happen when a customer sees an image or rich media ad, then later completes a conversion on your site without interacting with (e.g., clicking on) another ad.
metrics_clicks The number of clicks.
ad_group_name The name of the ad group. This field is required and should not be empty when creating new ad groups. It must contain fewer than 255 UTF-8 full-width characters. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters.
metrics_conversions_from_interactions_rate Conversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). This only includes conversion actions which include_in_conversions_metric attribute is set to true.
ad_group_id The ID of the ad group.
metrics_average_cpm Average cost-per-thousand impressions (CPM).
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
ad_group_criterion_keyword_text The text of the keyword (at most 80 characters and 10 words).
metrics_average_cpv The average amount you pay each time someone views your ad. The average CPV is defined by the total cost of all ad views divided by the number of views.
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
metrics_interactions The number of interactions. An interaction is the main user action associated with an ad format-clicks for text and shopping ads, views for video ads, and so on.
metrics_cost_per_conversion The cost of ad interactions divided by conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
campaign_advertising_channel_sub_type Optional refinement to `advertising_channel_type`. Must be a valid sub-type of the parent channel type. Can be set only when creating campaigns. After campaign is created, the field can not be changed.
metrics_average_cpc The total cost of all clicks divided by the total number of clicks received.
campaign_id The ID of the campaign.
metrics_interaction_rate How often people interact with your ad after it is shown to them. This is the number of interactions divided by the number of times your ad is shown.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
customer_id The ID of the customer.

Table Name: ParentalStatus

Field Name Description
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
ad_group_criterion_final_mobile_urls The list of possible final mobile URLs after all cross-domain redirects.
ad_group_id The ID of the ad group.
ad_group_targeting_setting_target_restrictions The per-targeting-dimension setting to restrict the reach of your campaign or ad group.
ad_group_criterion_url_custom_parameters The list of mappings used to substitute custom parameter tags in a `tracking_url_template`, `final_urls`, or `mobile_final_urls`.
ad_group_criterion_status The status of the criterion.
ad_group_criterion_tracking_url_template The URL template for constructing a tracking URL.
customer_id The ID of the customer.
campaign_bidding_strategy Portfolio bidding strategy used by campaign.
ad_group_criterion_parental_status_type Type of the parental status.
ad_group_criterion_effective_cpc_bid_source Source of the effective CPC bid.
ad_group_criterion_effective_cpm_bid_source Source of the effective CPM bid.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
ad_group_criterion_criterion_id The ID of the criterion. This field is ignored for mutates.
ad_group_criterion_negative Whether to target (`false`) or exclude (`true`) the criterion. This field is immutable. To switch a criterion from positive to negative, remove then re-add it.
ad_group_criterion_effective_cpm_bid_micros The effective CPM (cost-per-thousand viewable impressions) bid.
ad_group_criterion_final_urls The list of possible final URLs after all cross-domain redirects for the ad.
campaign_id The ID of the campaign.
ad_group_criterion_effective_cpc_bid_micros The effective CPC (cost-per-click) bid.

Table Name: AdGroupConversionStats

Field Name Description
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
segments_device Device to which metrics apply.
customer_id The ID of the customer.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
campaign_id The ID of the campaign.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_ad_network_type Ad network type.
segments_year Year, formatted as yyyy.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
segments_slot Position of the ad.
segments_conversion_action_category Conversion action category.
segments_day_of_week Day of the week, e.g., MONDAY.
segments_conversion_action_name Conversion action name.
segments_conversion_action Resource name of the conversion action.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
segments_click_type Click type.
ad_group_id The ID of the ad group.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.

Table Name: BidGoalConversionStats

Field Name Description
bidding_strategy_campaign_count The number of campaigns attached to this bidding strategy. This field is read-only.
metrics_all_conversions_value The total value of all conversions.
metrics_value_per_all_conversions The value of all conversions divided by the number of all conversions.
bidding_strategy_id The ID of the bidding strategy.
customer_id The ID of the customer.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_all_conversions The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_conversion_action_name Conversion action name.
segments_year Year, formatted as yyyy.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_view_through_conversions The total number of view-through conversions. These happen when a customer sees an image or rich media ad, then later completes a conversion on your site without interacting with (e.g., clicking on) another ad.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
segments_device Device to which metrics apply.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
segments_day_of_week Day of the week, e.g., MONDAY.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
segments_conversion_action Resource name of the conversion action.
metrics_cross_device_conversions Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
bidding_strategy_non_removed_campaign_count The number of non-removed campaigns attached to this bidding strategy. This field is read-only.
segments_conversion_action_category Conversion action category.

Table Name: AgeRangeConversionStats

Field Name Description
campaign_id The ID of the campaign.
metrics_all_conversions_value The total value of all conversions.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_year Year, formatted as yyyy.
ad_group_criterion_criterion_id The ID of the criterion. This field is ignored for mutates.
metrics_cross_device_conversions Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
segments_device Device to which metrics apply.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_click_type Click type.
segments_conversion_action_name Conversion action name.
metrics_value_per_all_conversions The value of all conversions divided by the number of all conversions.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
metrics_all_conversions The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_ad_network_type Ad network type.
segments_day_of_week Day of the week, e.g., MONDAY.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
ad_group_id The ID of the ad group.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
segments_conversion_action Resource name of the conversion action.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
customer_id The ID of the customer.
segments_conversion_action_category Conversion action category.

Table Name: CampaignCriterion

Field Name Description
campaign_criterion_criterion_id The ID of the criterion. This field is ignored during mutate.
campaign_criterion_campaign The campaign to which the criterion belongs.
campaign_criterion_device_type Type of the device.
campaign_criterion_status The status of the criterion.
campaign_id The ID of the campaign.
campaign_criterion_negative Whether to target (`false`) or exclude (`true`) the criterion.
campaign_criterion_display_name The display name of the criterion. This field is ignored for mutates.
campaign_name The name of the campaign. This field is required and should not be empty when creating new campaigns. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters.
campaign_criterion_bid_modifier The modifier for the bids when the criterion matches. The modifier must be in the range: 0.1 - 10.0. Most targetable criteria types support modifiers. Use 0 to opt out of a Device type.

Table Name: PlacementNonClickStats

Field Name Description
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
campaign_id The ID of the campaign.
segments_ad_network_type Ad network type.
metrics_engagement_rate How often people engage with your ad after it's shown to them. This is the number of ad expansions divided by the number of times your ad is shown.
ad_group_id The ID of the ad group.
segments_device Device to which metrics apply.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
metrics_engagements The number of engagements. An engagement occurs when a viewer expands your Lightbox ad. Also, in the future, other ad types may support engagement metrics.
customer_id The ID of the customer.
metrics_video_quartile_p75_rate Percentage of impressions where the viewer watched 75% of your video.
metrics_average_cpe The average amount that you've been charged for an ad engagement. This amount is the total cost of all ad engagements divided by the total number of ad engagements.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
segments_year Year, formatted as yyyy.
metrics_video_quartile_p50_rate Percentage of impressions where the viewer watched 50% of your video.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
metrics_video_view_rate The number of views your TrueView video ad receives divided by its number of impressions, including thumbnail impressions for TrueView in-display ads.
metrics_video_quartile_p25_rate Percentage of impressions where the viewer watched 25% of your video.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
ad_group_criterion_criterion_id The ID of the criterion. This field is ignored for mutates.
segments_day_of_week Day of the week, e.g., MONDAY.
metrics_video_views The number of times your video ads were viewed.
metrics_average_cpv The average amount you pay each time someone views your ad. The average CPV is defined by the total cost of all ad views divided by the number of views.
metrics_video_quartile_p100_rate Percentage of impressions where the viewer watched all of your video.

Table Name: AccountBasicStats

Field Name Description
customer_id The ID of the customer.
segments_ad_network_type Ad network type.
segments_device Device to which metrics apply.
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
metrics_clicks The number of clicks.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
metrics_interactions The number of interactions. An interaction is the main user action associated with an ad format-clicks for text and shopping ads, views for video ads, and so on.
metrics_interaction_event_types The types of payable and free interactions.
segments_slot Position of the ad.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_view_through_conversions The total number of view-through conversions. These happen when a customer sees an image or rich media ad, then later completes a conversion on your site without interacting with (e.g., clicking on) another ad.

Table Name: LocationBasedCampaignCriterion

Field Name Description
campaign_criterion_bid_modifier The modifier for the bids when the criterion matches. The modifier must be in the range: 0.1 - 10.0. Most targetable criteria types support modifiers. Use 0 to opt out of a Device type.
campaign_id The ID of the campaign.
customer_id The ID of the customer.
campaign_criterion_criterion_id The ID of the criterion. This field is ignored during mutate.
campaign_criterion_negative Whether to target (`false`) or exclude (`true`) the criterion.

Table Name: Gender

Field Name Description
ad_group_criterion_url_custom_parameters The list of mappings used to substitute custom parameter tags in a `tracking_url_template`, `final_urls`, or `mobile_final_urls`.
customer_id The ID of the customer.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
campaign_bidding_strategy Portfolio bidding strategy used by campaign.
ad_group_criterion_final_mobile_urls The list of possible final mobile URLs after all cross-domain redirects.
ad_group_criterion_effective_cpc_bid_source Source of the effective CPC bid.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
ad_group_criterion_tracking_url_template The URL template for constructing a tracking URL.
ad_group_id The ID of the ad group.
bidding_strategy_type The type of the bidding strategy. Create a bidding strategy by setting the bidding scheme. This field is read-only.
bidding_strategy_name The name of the bidding strategy. All bidding strategies within an account must be named distinctly. The length of this string should be between 1 and 255, inclusive, in UTF-8 bytes, (trimmed).
ad_group_criterion_effective_cpm_bid_source Source of the effective CPM bid.
ad_group_criterion_bid_modifier The modifier for the bid when the criterion matches. The modifier must be in the range: 0.1 - 10.0. Most targetable criteria types support modifiers.
campaign_id The ID of the campaign.
ad_group_criterion_final_urls The list of possible final URLs after all cross-domain redirects for the ad.
ad_group_criterion_criterion_id The ID of the criterion. This field is ignored for mutates.
ad_group_criterion_effective_cpm_bid_micros The effective CPM (cost-per-thousand viewable impressions) bid.
ad_group_criterion_negative Whether to target (`false`) or exclude (`true`) the criterion. This field is immutable. To switch a criterion from positive to negative, remove then re-add it.
ad_group_targeting_setting_target_restrictions The per-targeting-dimension setting to restrict the reach of your campaign or ad group.
ad_group_criterion_status The status of the criterion.
ad_group_criterion_gender_type Type of the gender.
ad_group_criterion_effective_cpc_bid_micros The effective CPC (cost-per-click) bid.

Table Name: AdStats

Field Name Description
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
metrics_interactions The number of interactions. An interaction is the main user action associated with an ad format-clicks for text and shopping ads, views for video ads, and so on.
metrics_active_view_ctr Active view measurable clicks divided by active view viewable impressions. This metric is reported only for display network.
ad_group_ad_ad_id The ID of the ad.
metrics_active_view_measurable_impressions The number of times your ads are appearing on placements in positions where they can be seen.
metrics_cost_per_conversion The cost of ad interactions divided by conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_gmail_saves The number of times someone has saved your Gmail ad to their inbox as a message.
segments_ad_network_type Ad network type.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
metrics_ctr The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
customer_id The ID of the customer.
metrics_active_view_impressions A measurement of how often your ad has become viewable on a Display Network site.
metrics_active_view_measurable_cost_micros The cost of the impressions you received that were measurable by Active View.
metrics_active_view_cpm Average cost of viewable impressions (`active_view_impressions`).
metrics_active_view_viewability The percentage of time when your ad appeared on an Active View enabled site (measurable impressions) and was viewable (viewable impressions).
metrics_current_model_attributed_conversions Shows how your historic conversions data would look under the attribution model you've currently selected. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_interaction_event_types The types of payable and free interactions.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
metrics_gmail_secondary_clicks The number of clicks to the landing page on the expanded state of Gmail ads.
segments_keyword_ad_group_criterion The AdGroupCriterion resource name.
segments_device Device to which metrics apply.
metrics_active_view_measurability The ratio of impressions that could be measured by Active View over the number of served impressions.
metrics_value_per_current_model_attributed_conversion The value of current model attributed conversions divided by the number of the conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
metrics_interaction_rate How often people interact with your ad after it is shown to them. This is the number of interactions divided by the number of times your ad is shown.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
segments_day_of_week Day of the week, e.g., MONDAY.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_clicks The number of clicks.
metrics_cost_per_current_model_attributed_conversion The cost of ad interactions divided by current model attributed conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
ad_group_ad_ad_group The ad group to which the ad belongs.
segments_year Year, formatted as yyyy.
metrics_average_cpc The total cost of all clicks divided by the total number of clicks received.
campaign_id The ID of the campaign.
metrics_gmail_forwards The number of times the ad was forwarded to someone else as a message.
segments_click_type Click type.
metrics_average_cost The average amount you pay per interaction. This amount is the total cost of your ads divided by the total number of interactions.
metrics_conversions_from_interactions_rate Conversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_average_cpm Average cost-per-thousand impressions (CPM).

Table Name: ParentalStatusNonClickStats

Field Name Description
customer_id The ID of the customer.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
metrics_video_quartile_p25_rate Percentage of impressions where the viewer watched 25% of your video.
segments_day_of_week Day of the week, e.g., MONDAY.
metrics_video_quartile_p75_rate Percentage of impressions where the viewer watched 75% of your video.
metrics_engagements The number of engagements. An engagement occurs when a viewer expands your Lightbox ad. Also, in the future, other ad types may support engagement metrics.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
ad_group_id The ID of the ad group.
metrics_video_quartile_p100_rate Percentage of impressions where the viewer watched all of your video.
metrics_engagement_rate How often people engage with your ad after it's shown to them. This is the number of ad expansions divided by the number of times your ad is shown.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
segments_year Year, formatted as yyyy.
campaign_id The ID of the campaign.
segments_ad_network_type Ad network type.
metrics_video_quartile_p50_rate Percentage of impressions where the viewer watched 50% of your video.
metrics_video_views The number of times your video ads were viewed.
metrics_video_view_rate The number of views your TrueView video ad receives divided by its number of impressions, including thumbnail impressions for TrueView in-display ads.
segments_device Device to which metrics apply.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
ad_group_criterion_criterion_id The ID of the criterion. This field is ignored for mutates.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
metrics_average_cpv The average amount you pay each time someone views your ad. The average CPV is defined by the total cost of all ad views divided by the number of views.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
metrics_average_cpe The average amount that you've been charged for an ad engagement. This amount is the total cost of all ad engagements divided by the total number of ad engagements.

Table Name: Customer

Field Name Description
customer_test_account Whether the customer is a test account.
customer_time_zone The local timezone ID of the customer.
customer_id The ID of the customer.
customer_currency_code The currency in which the account operates. A subset of the currency codes from the ISO 4217 standard is supported.
customer_descriptive_name Optional, non-unique descriptive name of the customer.
customer_auto_tagging_enabled Whether auto-tagging is enabled for the customer.
customer_manager Whether the customer is a manager.

Table Name: AdGroupCrossDeviceStats

Field Name Description
metrics_search_impression_share The impressions you've received on the Search Network divided by the estimated number of impressions you were eligible to receive. Note: Search impression share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999.
metrics_phone_impressions Number of offline phone impressions.
metrics_cost_per_all_conversions The cost of ad interactions divided by all conversions.
metrics_search_exact_match_impression_share 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. Note: Search exact match impression share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999.
segments_ad_network_type Ad network type.
metrics_absolute_top_impression_percentage The percent of your ad impressions that are shown as the very first ad above the organic search results.
metrics_video_quartile_p50_rate Percentage of impressions where the viewer watched 50% of your video.
metrics_search_rank_lost_top_impression_share The number estimating how often your ad didn't show anywhere above the organic search results due to poor Ad Rank. Note: Search rank lost top impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
metrics_phone_calls Number of offline phone calls.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
metrics_phone_through_rate Number of phone calls received (phone_calls) divided by the number of times your phone number is shown (phone_impressions).
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
metrics_average_cpe The average amount that you've been charged for an ad engagement. This amount is the total cost of all ad engagements divided by the total number of ad engagements.
metrics_all_conversions The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_search_top_impression_share The impressions you've received in the top location (anywhere above the organic search results) compared to the estimated number of impressions you were eligible to receive in the top location. Note: Search top impression share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999.
metrics_bounce_rate Percentage of clicks where the user only visited a single page on your site. Imported from Google Analytics.
metrics_search_budget_lost_absolute_top_impression_share The number estimating how often your ad wasn't the very first ad above the organic search results due to a low budget. Note: Search budget lost absolute top impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
metrics_top_impression_percentage The percent of your ad impressions that are shown anywhere above the organic search results.
metrics_video_views The number of times your video ads were viewed.
metrics_search_budget_lost_top_impression_share The number estimating how often your ad didn't show anywhere above the organic search results due to a low budget. Note: Search budget lost top impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
metrics_video_quartile_p100_rate Percentage of impressions where the viewer watched all of your video.
metrics_value_per_all_conversions The value of all conversions divided by the number of all conversions.
metrics_engagements The number of engagements. An engagement occurs when a viewer expands your Lightbox ad. Also, in the future, other ad types may support engagement metrics.
customer_id The ID of the customer.
metrics_all_conversions_value The total value of all conversions.
metrics_content_rank_lost_impression_share The estimated percentage of impressions on the Display Network that your ads didn't receive due to poor Ad Rank. Note: Content rank lost impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
metrics_all_conversions_from_interactions_rate All conversions from interactions (as oppose to view through conversions) divided by the number of ad interactions.
metrics_video_quartile_p75_rate Percentage of impressions where the viewer watched 75% of your video.
segments_year Year, formatted as yyyy.
metrics_percent_new_visitors Percentage of first-time sessions (from people who had never visited your site before). Imported from Google Analytics.
metrics_video_quartile_p25_rate Percentage of impressions where the viewer watched 25% of your video.
metrics_relative_ctr Your clickthrough rate (Ctr) divided by the average clickthrough rate of all advertisers on the websites that show your ads. Measures how your ads perform on Display Network sites compared to other ads on the same sites.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
metrics_search_rank_lost_absolute_top_impression_share The number estimating how often your ad wasn't the very first ad above the organic search results due to poor Ad Rank. Note: Search rank lost absolute top impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
metrics_search_rank_lost_impression_share The estimated percentage of impressions on the Search Network that your ads didn't receive due to poor Ad Rank. Note: Search rank lost impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
metrics_content_impression_share The impressions you've received on the Display Network divided by the estimated number of impressions you were eligible to receive. Note: Content impression share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999.
ad_group_id The ID of the ad group.
metrics_average_time_on_site Total duration of all sessions (in seconds) / number of sessions. Imported from Google Analytics.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
metrics_average_cpv The average amount you pay each time someone views your ad. The average CPV is defined by the total cost of all ad views divided by the number of views.
metrics_video_view_rate The number of views your TrueView video ad receives divided by its number of impressions, including thumbnail impressions for TrueView in-display ads.
campaign_id The ID of the campaign.
metrics_engagement_rate How often people engage with your ad after it's shown to them. This is the number of ad expansions divided by the number of times your ad is shown.
metrics_cross_device_conversions Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
segments_day_of_week Day of the week, e.g., MONDAY.
metrics_average_page_views Average number of pages viewed per session.
metrics_search_absolute_top_impression_share The percentage of the customer's Shopping or Search ad impressions that are shown in the most prominent Shopping position. See https://support.google.com/google-ads/answer/7501826 for details. Any value below 0.1 is reported as 0.0999.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.

Table Name: ParentalStatusBasicStats

Field Name Description
metrics_view_through_conversions The total number of view-through conversions. These happen when a customer sees an image or rich media ad, then later completes a conversion on your site without interacting with (e.g., clicking on) another ad.
ad_group_id The ID of the ad group.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
segments_device Device to which metrics apply.
metrics_cross_device_conversions Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_all_conversions The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
metrics_active_view_impressions A measurement of how often your ad has become viewable on a Display Network site.
customer_id The ID of the customer.
ad_group_criterion_criterion_id The ID of the criterion. This field is ignored for mutates.
metrics_all_conversions_value The total value of all conversions.
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
segments_ad_network_type Ad network type.
metrics_active_view_viewability The percentage of time when your ad appeared on an Active View enabled site (measurable impressions) and was viewable (viewable impressions).
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
metrics_clicks The number of clicks.
metrics_interactions The number of interactions. An interaction is the main user action associated with an ad format-clicks for text and shopping ads, views for video ads, and so on.
metrics_active_view_measurability The ratio of impressions that could be measured by Active View over the number of served impressions.
metrics_interaction_event_types The types of payable and free interactions.
campaign_id The ID of the campaign.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
metrics_active_view_measurable_cost_micros The cost of the impressions you received that were measurable by Active View.
metrics_active_view_measurable_impressions The number of times your ads are appearing on placements in positions where they can be seen.

Table Name: ShoppingProductConversionStats

Field Name Description
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_product_country Resource name of the geo target constant for the country of sale of the product.
segments_product_bidding_category_level3 Bidding category (level 3) of the product.
segments_product_bidding_category_level4 Bidding category (level 4) of the product.
segments_conversion_action Resource name of the conversion action.
customer_id The ID of the customer.
segments_product_custom_attribute3 Custom attribute 3 of the product.
segments_product_store_id Store ID of the product.
segments_product_brand Brand of the product.
segments_ad_network_type Ad network type.
segments_product_aggregator_id Aggregator ID of the product.
campaign_id The ID of the campaign.
segments_product_condition Condition of the product.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
segments_product_channel Channel of the product.
segments_year Year, formatted as yyyy.
segments_conversion_action_category Conversion action category.
segments_product_type_l5 Type (level 5) of the product.
segments_product_language Resource name of the language constant for the language of the product.
segments_product_bidding_category_level2 Bidding category (level 2) of the product.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_product_custom_attribute0 Custom attribute 0 of the product.
segments_device Device to which metrics apply.
metrics_all_conversions_value The total value of all conversions.
segments_product_bidding_category_level1 Bidding category (level 1) of the product.
metrics_value_per_all_conversions The value of all conversions divided by the number of all conversions.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
segments_product_type_l1 Type (level 1) of the product.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
metrics_all_conversions The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_product_bidding_category_level5 Bidding category (level 5) of the product.
segments_product_channel_exclusivity Channel exclusivity of the product.
segments_product_type_l2 Type (level 2) of the product.
segments_product_custom_attribute2 Custom attribute 2 of the product.
segments_day_of_week Day of the week, e.g., MONDAY.
segments_product_item_id Item ID of the product.
segments_product_type_l3 Type (level 3) of the product.
campaign_status The status of the campaign. When a new campaign is added, the status defaults to ENABLED.
segments_click_type Click type.
segments_product_merchant_id Merchant ID of the product.
segments_conversion_action_name Conversion action name.
segments_product_type_l4 Type (level 4) of the product.
segments_product_custom_attribute1 Custom attribute 1 of the product.
segments_product_custom_attribute4 Custom attribute 4 of the product.

Table Name: Budget

Field Name Description
campaign_budget_explicitly_shared Specifies whether the budget is explicitly shared. Defaults to true if unspecified in a create operation. If true, the budget was created with the purpose of sharing across one or more campaigns. If false, the budget was created with the intention of only being used with a single campaign. The budget's name and status will stay in sync with the campaign's name and status. Attempting to share the budget with a second campaign will result in an error. A non-shared budget can become an explicitly shared. The same operation must also assign the budget a name. A shared campaign budget can never become non-shared.
customer_descriptive_name Optional, non-unique descriptive name of the customer.
customer_id The ID of the customer.
campaign_budget_reference_count The number of campaigns actively using the budget. This field is read-only.
campaign_budget_id The ID of the campaign budget. A campaign budget is created using the CampaignBudgetService create operation and is assigned a budget ID. A budget ID can be shared across different campaigns; the system will then allocate the campaign budget among different campaigns to get optimum results.
campaign_budget_period Period over which to spend the budget. Defaults to DAILY if not specified.
campaign_budget_amount_micros The amount of the budget, in the local currency for the account. Amount is specified in micros, where one million is equivalent to one currency unit. Monthly spend is capped at 30.4 times this amount.
campaign_budget_name The name of the campaign budget. When creating a campaign budget through CampaignBudgetService, every explicitly shared campaign budget must have a non-null, non-empty name. Campaign budgets that are not explicitly shared derive their name from the attached campaign's name. The length of this string must be between 1 and 255, inclusive, in UTF-8 bytes, (trimmed).
campaign_budget_recommended_budget_amount_micros The recommended budget amount. If no recommendation is available, this will be set to the budget amount. Amount is specified in micros, where one million is equivalent to one currency unit. This field is read-only.
campaign_budget_has_recommended_budget Indicates whether there is a recommended budget for this campaign budget. This field is read-only.
campaign_budget_delivery_method The delivery method that determines the rate at which the campaign budget is spent. Defaults to STANDARD if unspecified in a create operation.
campaign_budget_status The status of this campaign budget. This field is read-only.
campaign_budget_total_amount_micros The lifetime amount of the budget, in the local currency for the account. Amount is specified in micros, where one million is equivalent to one currency unit.

Table Name: HourlyBidGoalStats

Field Name Description
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_day_of_week Day of the week, e.g., MONDAY.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
metrics_cost_per_conversion The cost of ad interactions divided by conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_average_cpm Average cost-per-thousand impressions (CPM).
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
bidding_strategy_non_removed_campaign_count The number of non-removed campaigns attached to this bidding strategy. This field is read-only.
bidding_strategy_campaign_count The number of campaigns attached to this bidding strategy. This field is read-only.
segments_year Year, formatted as yyyy.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
segments_device Device to which metrics apply.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_conversions_from_interactions_rate Conversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
segments_hour Hour of day as a number between 0 and 23, inclusive.
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
metrics_ctr The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
metrics_average_cpc The total cost of all clicks divided by the total number of clicks received.
bidding_strategy_id The ID of the bidding strategy.
customer_id The ID of the customer.
metrics_clicks The number of clicks.

Table Name: VideoConversionStats

Field Name Description
ad_group_ad_ad_id The ID of the ad.
ad_group_id The ID of the ad group.
segments_conversion_action_category Conversion action category.
segments_year Year, formatted as yyyy.
customer_id The ID of the customer.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
segments_click_type Click type.
segments_device Device to which metrics apply.
video_id The ID of the video.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
ad_group_ad_status The status of the ad.
video_channel_id The owner channel id of the video.
segments_conversion_action_name Conversion action name.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_conversion_action Resource name of the conversion action.
campaign_id The ID of the campaign.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
segments_ad_network_type Ad network type.
segments_day_of_week Day of the week, e.g., MONDAY.

Table Name: ParentalStatusConversionStats

Field Name Description
segments_click_type Click type.
segments_year Year, formatted as yyyy.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
ad_group_id The ID of the ad group.
segments_ad_network_type Ad network type.
campaign_id The ID of the campaign.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
segments_day_of_week Day of the week, e.g., MONDAY.
segments_conversion_action_category Conversion action category.
metrics_value_per_all_conversions The value of all conversions divided by the number of all conversions.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
segments_conversion_action_name Conversion action name.
segments_conversion_action Resource name of the conversion action.
metrics_all_conversions The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
customer_id The ID of the customer.
segments_device Device to which metrics apply.
metrics_cross_device_conversions Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
metrics_all_conversions_value The total value of all conversions.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
ad_group_criterion_criterion_id The ID of the criterion. This field is ignored for mutates.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.

Table Name: GenderConversionStats

Field Name Description
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
ad_group_id The ID of the ad group.
segments_conversion_action Resource name of the conversion action.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
customer_id The ID of the customer.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_cross_device_conversions Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
segments_conversion_action_name Conversion action name.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
segments_day_of_week Day of the week, e.g., MONDAY.
segments_ad_network_type Ad network type.
ad_group_criterion_criterion_id The ID of the criterion. This field is ignored for mutates.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
segments_conversion_action_category Conversion action category.
segments_device Device to which metrics apply.
metrics_value_per_all_conversions The value of all conversions divided by the number of all conversions.
metrics_all_conversions_value The total value of all conversions.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_click_type Click type.
segments_year Year, formatted as yyyy.
campaign_id The ID of the campaign.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_all_conversions The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.

Table Name: HourlyAdGroupStats

Field Name Description
segments_click_type Click type.
metrics_interaction_rate How often people interact with your ad after it is shown to them. This is the number of interactions divided by the number of times your ad is shown.
metrics_average_cpc The total cost of all clicks divided by the total number of clicks received.
metrics_active_view_measurable_cost_micros The cost of the impressions you received that were measurable by Active View.
segments_hour Hour of day as a number between 0 and 23, inclusive.
customer_id The ID of the customer.
metrics_active_view_impressions A measurement of how often your ad has become viewable on a Display Network site.
metrics_active_view_viewability The percentage of time when your ad appeared on an Active View enabled site (measurable impressions) and was viewable (viewable impressions).
metrics_active_view_measurable_impressions The number of times your ads are appearing on placements in positions where they can be seen.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
segments_year Year, formatted as yyyy.
campaign_id The ID of the campaign.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
metrics_average_cpm Average cost-per-thousand impressions (CPM).
metrics_cost_per_conversion The cost of ad interactions divided by conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_average_cost The average amount you pay per interaction. This amount is the total cost of your ads divided by the total number of interactions.
metrics_ctr The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
metrics_interaction_event_types The types of payable and free interactions.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
metrics_conversions_from_interactions_rate Conversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
ad_group_id The ID of the ad group.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
segments_day_of_week Day of the week, e.g., MONDAY.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
metrics_active_view_measurability The ratio of impressions that could be measured by Active View over the number of served impressions.
metrics_active_view_cpm Average cost of viewable impressions (`active_view_impressions`).
metrics_active_view_ctr Active view measurable clicks divided by active view viewable impressions. This metric is reported only for display network.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
metrics_clicks The number of clicks.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
metrics_interactions The number of interactions. An interaction is the main user action associated with an ad format-clicks for text and shopping ads, views for video ads, and so on.
segments_device Device to which metrics apply.
segments_ad_network_type Ad network type.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.

Table Name: AdCrossDeviceConversionStats

Field Name Description
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
campaign_id The ID of the campaign.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
metrics_value_per_all_conversions The value of all conversions divided by the number of all conversions.
segments_conversion_action_category Conversion action category.
customer_id The ID of the customer.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
segments_conversion_action_name Conversion action name.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
metrics_all_conversions_value The total value of all conversions.
segments_year Year, formatted as yyyy.
segments_ad_network_type Ad network type.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
metrics_cross_device_conversions Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
ad_group_ad_ad_group The ad group to which the ad belongs.
ad_group_ad_ad_id The ID of the ad.
metrics_all_conversions The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_conversion_action Resource name of the conversion action.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
segments_day_of_week Day of the week, e.g., MONDAY.
segments_keyword_ad_group_criterion The AdGroupCriterion resource name.

Table Name: AccountStats

Field Name Description
segments_ad_network_type Ad network type.
metrics_active_view_measurable_cost_micros The cost of the impressions you received that were measurable by Active View.
customer_id The ID of the customer.
metrics_interactions The number of interactions. An interaction is the main user action associated with an ad format-clicks for text and shopping ads, views for video ads, and so on.
segments_day_of_week Day of the week, e.g., MONDAY.
metrics_conversions_from_interactions_rate Conversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_interaction_event_types The types of payable and free interactions.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
metrics_average_cost The average amount you pay per interaction. This amount is the total cost of your ads divided by the total number of interactions.
segments_click_type Click type.
metrics_interaction_rate How often people interact with your ad after it is shown to them. This is the number of interactions divided by the number of times your ad is shown.
segments_year Year, formatted as yyyy.
metrics_ctr The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
metrics_active_view_ctr Active view measurable clicks divided by active view viewable impressions. This metric is reported only for display network.
metrics_clicks The number of clicks.
metrics_average_cpc The total cost of all clicks divided by the total number of clicks received.
metrics_cost_per_conversion The cost of ad interactions divided by conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_device Device to which metrics apply.
metrics_average_cpm Average cost-per-thousand impressions (CPM).
metrics_active_view_measurable_impressions The number of times your ads are appearing on placements in positions where they can be seen.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
metrics_active_view_impressions A measurement of how often your ad has become viewable on a Display Network site.
metrics_active_view_cpm Average cost of viewable impressions (`active_view_impressions`).
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_active_view_viewability The percentage of time when your ad appeared on an Active View enabled site (measurable impressions) and was viewable (viewable impressions).
metrics_active_view_measurability The ratio of impressions that could be measured by Active View over the number of served impressions.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.

Table Name: HourlyAccountStats

Field Name Description
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
metrics_active_view_measurable_cost_micros The cost of the impressions you received that were measurable by Active View.
metrics_clicks The number of clicks.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_hour Hour of day as a number between 0 and 23, inclusive.
metrics_conversions_from_interactions_rate Conversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_click_type Click type.
metrics_active_view_cpm Average cost of viewable impressions (`active_view_impressions`).
segments_device Device to which metrics apply.
metrics_active_view_ctr Active view measurable clicks divided by active view viewable impressions. This metric is reported only for display network.
metrics_active_view_impressions A measurement of how often your ad has become viewable on a Display Network site.
segments_ad_network_type Ad network type.
metrics_value_per_conversion The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
customer_id The ID of the customer.
metrics_active_view_viewability The percentage of time when your ad appeared on an Active View enabled site (measurable impressions) and was viewable (viewable impressions).
metrics_average_cost The average amount you pay per interaction. This amount is the total cost of your ads divided by the total number of interactions.
metrics_ctr The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
metrics_active_view_measurability The ratio of impressions that could be measured by Active View over the number of served impressions.
metrics_active_view_measurable_impressions The number of times your ads are appearing on placements in positions where they can be seen.
metrics_cost_per_conversion The cost of ad interactions divided by conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_interaction_event_types The types of payable and free interactions.
metrics_average_cpc The total cost of all clicks divided by the total number of clicks received.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
segments_day_of_week Day of the week, e.g., MONDAY.
metrics_interactions The number of interactions. An interaction is the main user action associated with an ad format-clicks for text and shopping ads, views for video ads, and so on.
metrics_interaction_rate How often people interact with your ad after it is shown to them. This is the number of interactions divided by the number of times your ad is shown.
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
metrics_average_cpm Average cost-per-thousand impressions (CPM).
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_year Year, formatted as yyyy.

Table Name: GenderBasicStats

Field Name Description
metrics_all_conversions The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_interaction_event_types The types of payable and free interactions.
ad_group_id The ID of the ad group.
metrics_view_through_conversions The total number of view-through conversions. These happen when a customer sees an image or rich media ad, then later completes a conversion on your site without interacting with (e.g., clicking on) another ad.
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
metrics_active_view_impressions A measurement of how often your ad has become viewable on a Display Network site.
metrics_active_view_viewability The percentage of time when your ad appeared on an Active View enabled site (measurable impressions) and was viewable (viewable impressions).
metrics_active_view_measurable_cost_micros The cost of the impressions you received that were measurable by Active View.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
customer_id The ID of the customer.
segments_ad_network_type Ad network type.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
metrics_active_view_measurability The ratio of impressions that could be measured by Active View over the number of served impressions.
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
campaign_base_campaign The resource name of the base campaign of a draft or experiment campaign. For base campaigns, this is equal to `resource_name`. This field is read-only.
campaign_id The ID of the campaign.
segments_device Device to which metrics apply.
metrics_clicks The number of clicks.
metrics_all_conversions_value The total value of all conversions.
metrics_cross_device_conversions Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
metrics_active_view_measurable_impressions The number of times your ads are appearing on placements in positions where they can be seen.
ad_group_criterion_criterion_id The ID of the criterion. This field is ignored for mutates.
ad_group_base_ad_group For draft or experiment ad groups, this field is the resource name of the base ad group from which this ad group was created. If a draft or experiment ad group does not have a base ad group, then this field is null. For base ad groups, this field equals the ad group resource name. This field is read-only.
metrics_interactions The number of interactions. An interaction is the main user action associated with an ad format-clicks for text and shopping ads, views for video ads, and so on.

Table Name: Video

Field Name Description
customer_id The ID of the customer.
ad_group_ad_status The status of the ad.
video_duration_millis The duration of the video in milliseconds.
video_title The title of the video.
video_id The ID of the video.
campaign_id The ID of the campaign.
ad_group_id The ID of the ad group.

Table Name: VideoStats

Field Name Description
metrics_impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
segments_date Date to which metrics apply. yyyy-MM-dd format, e.g., 2018-04-17.
customer_id The ID of the customer.
metrics_conversions The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_day_of_week Day of the week, e.g., MONDAY.
metrics_cost_per_conversion The cost of ad interactions divided by conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
segments_year Year, formatted as yyyy.
segments_device Device to which metrics apply.
metrics_conversions_value The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true.
metrics_cost_micros The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
video_channel_id The owner channel id of the video.
metrics_clicks The number of clicks.
ad_group_id The ID of the ad group.
ad_group_ad_ad_id The ID of the ad.
video_id The ID of the video.
segments_week Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
segments_click_type Click type.
metrics_average_cpm Average cost-per-thousand impressions (CPM).
metrics_ctr The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
campaign_id The ID of the campaign.
segments_month Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
ad_group_ad_status The status of the ad.
segments_ad_network_type Ad network type.
metrics_all_conversions_from_interactions_rate All conversions from interactions (as oppose to view through conversions) divided by the number of ad interactions.
segments_quarter Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, e.g., the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.

Table Name: KeywordStats

Field Name Description
segments_ad_network_type Ad network type.
campaign_id The ID of the campaign.

Google Ads Match Tables are tables that contain only Attribute fields (fields containing settings or other fixed data), and they are defined for users to query account structure information. If you use the refresh window or schedule a backfill, Match Table snapshots are not updated.

Below are 15 Match Tables in Google Ads transfer:

  • Ad
  • AdGroup
  • AgeRange
  • Audience
  • BidGoal
  • Budget
  • Campaign
  • Criteria
  • Customer
  • Gender
  • Keyword
  • LocationBasedCampaignCriterion
  • ParentalStatus
  • Placement
  • Video