Google Ads report transformation
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 (v14.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 |
NULLNULLNULLNULLNULL
|
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 |
NULLNULLNULLNULLNULL
|
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 | |||
| Assets (available if Pmax data is enabled) | Assets | |||
| AssetGroup (available if Pmax data is enabled) | Asset Groups | |||
| AssetGroupAsset (available if Pmax data is enabled) | Asset Group Assets | |||
| AssetGroupSignal (available if Pmax data is enabled) | Asset Group Signal | |||
| AssetGroupProductGroupStats (available if Pmax data is enabled) | AssetGroupProductGroupStats | |||
| CampaignAssetStats (available if Pmax data is enabled) | CampaignAssetStats |
Column mapping for Google Ads reports
The BigQuery tables created by an Google Ads transfer consist of the following columns (fields):
Google Ads Table Name: AccountBasicStats
Google Ads API Resource: customer
| Google Ads Field Name | Description | Adwords Mapped Field Name |
|---|---|---|
| customer_id | The ID of the customer. | ExternalCustomerId |
| metrics_clicks | The number of clicks. | Clicks |
| metrics_conversions | The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. | Conversions |
| metrics_conversions_value | The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. | ConversionValue |
| metrics_cost_micros | The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period. | Cost |
| metrics_impressions | Count of how often your ad has appeared on a search results page or website on the Google Network. | Impressions |
| metrics_interaction_event_types | The types of payable and free interactions. | InteractionTypes |
| metrics_interactions | The number of interactions. An interaction is the main user action associated with an ad format, such as clicks for text and shopping ads or views for video ads. | 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 (for example, clicking on) another ad. | ViewThroughConversions |
| segments_ad_network_type | Ad network type. | AdNetworkType2 |
| segments_date | Date to which metrics apply. yyyy-MM-dd format. For example, 2018-04-17. | Date |
| segments_device | Device to which metrics apply. | Device |
| segments_slot | Position of the ad. | Slot |
Google Ads Table Name: AccountConversionStats
Google Ads API Resource: customer
| Google Ads Field Name | Description | Adwords Mapped Field Name |
|---|---|---|
| customer_id | The ID of the customer. | ExternalCustomerId |
| metrics_conversions | The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. | Conversions |
| metrics_conversions_value | The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. | ConversionValue |
| 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. | ValuePerConversion |
| segments_ad_network_type | Ad network type. | AdNetworkType2 |
| segments_click_type | Click type. | ClickType |
| segments_conversion_action | Resource name of the conversion action. | ConversionTrackerId |
| segments_conversion_action_category | Conversion action category. | ConversionCategoryName |
| segments_conversion_action_name | Conversion action name. | ConversionTypeName |
| segments_date | Date to which metrics apply. yyyy-MM-dd format. For example, 2018-04-17. | Date |
| segments_day_of_week | Day of the week. For example, MONDAY. | DayOfWeek |
| segments_device | Device to which metrics apply. | Device |
| segments_month | Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd. | Month |
| segments_quarter | Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters. For example, the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd. | Quarter |
| segments_slot | Position of the ad. | Slot |
| segments_week | Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd. | Week |
| segments_year | Year, formatted as yyyy. | Year |
Google Ads Table Name: AccountNonClickStats
Google Ads API Resource: customer
| Google Ads Field Name | Description | Adwords Mapped Field Name |
|---|---|---|
| customer_id | The ID of the customer. | ExternalCustomerId |
| metrics_all_conversions | The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. | AllConversions |
| metrics_all_conversions_from_interactions_rate | All conversions from interactions (as oppose to view through conversions) divided by the number of ad interactions. | AllConversionRate |
| metrics_all_conversions_value | The total value of all conversions. | AllConversionValue |
| 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. | AverageCpe |
| 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. | AverageCpv |
| 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. | ContentBudgetLostImpressionShare |
| 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. | ContentImpressionShare |
| 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. | ContentRankLostImpressionShare |
| metrics_cost_per_all_conversions | The cost of ad interactions divided by all conversions. | CostPerAllConversion |
| 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. | CrossDeviceConversions |
| 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. | EngagementRate |
| 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. | Engagements |
| metrics_invalid_click_rate | The percentage of clicks filtered out of your total number of clicks (filtered + non-filtered clicks) during the reporting period. | InvalidClickRate |
| metrics_invalid_clicks | Number of clicks Google considers illegitimate and doesn't charge you for. | InvalidClicks |
| 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. | SearchBudgetLostImpressionShare |
| 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. | SearchExactMatchImpressionShare |
| 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. | SearchImpressionShare |
| 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. | SearchRankLostImpressionShare |
| metrics_value_per_all_conversions | The value of all conversions divided by the number of all conversions. | ValuePerAllConversion |
| 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. | VideoViewRate |
| metrics_video_views | The number of times your video ads were viewed. | VideoViews |
| segments_ad_network_type | Ad network type. | AdNetworkType2 |
| segments_date | Date to which metrics apply. yyyy-MM-dd format. For example, 2018-04-17. | Date |
| segments_day_of_week | Day of the week. For example, MONDAY. | DayOfWeek |
| segments_month | Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd. | Month |
| segments_quarter | Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters. For example, the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd. | Quarter |
| segments_week | Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd. | Week |
| segments_year | Year, formatted as yyyy. | Year |
Google Ads Table Name: AccountStats
Google Ads API Resource: customer
| Google Ads Field Name | Description | Adwords Mapped Field Name |
|---|---|---|
| customer_id | The ID of the customer. | ExternalCustomerId |
| metrics_active_view_cpm | Average cost of viewable impressions (`active_view_impressions`). | ActiveViewCpm |
| metrics_active_view_ctr | Active view measurable clicks divided by active view viewable impressions. This metric is reported only for display network. | ActiveViewCtr |
| metrics_active_view_impressions | A measurement of how often your ad has become viewable on a Display Network site. | ActiveViewImpressions |
| metrics_active_view_measurability | The ratio of impressions that could be measured by Active View over the number of served impressions. | ActiveViewMeasurability |
| metrics_active_view_measurable_cost_micros | The cost of the impressions you received that were measurable by Active View. | ActiveViewMeasurableCost |
| metrics_active_view_measurable_impressions | The number of times your ads are appearing on placements in positions where they can be seen. | ActiveViewMeasurableImpressions |
| 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). | ActiveViewViewability |
| 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. | AverageCost |
| metrics_average_cpc | The total cost of all clicks divided by the total number of clicks received. | AverageCpc |
| metrics_average_cpm | Average cost-per-thousand impressions (CPM). | AverageCpm |
| metrics_clicks | The number of clicks. | Clicks |
| metrics_conversions | The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. | 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. | ConversionRate |
| metrics_conversions_value | The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. | ConversionValue |
| metrics_cost_micros | The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period. | Cost |
| 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. | CostPerConversion |
| metrics_ctr | The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions). | Ctr |
| metrics_impressions | Count of how often your ad has appeared on a search results page or website on the Google Network. | Impressions |
| metrics_interaction_event_types | The types of payable and free interactions. | InteractionTypes |
| 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. | InteractionRate |
| metrics_interactions | The number of interactions. An interaction is the main user action associated with an ad format, such as clicks for text and shopping ads or views for video ads. | 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. | ValuePerConversion |
| segments_ad_network_type | Ad network type. | AdNetworkType2 |
| segments_click_type | Click type. | ClickType |
| segments_date | Date to which metrics apply. yyyy-MM-dd format. For example, 2018-04-17. | Date |
| segments_day_of_week | Day of the week. For example, MONDAY. | DayOfWeek |
| segments_device | Device to which metrics apply. | Device |
| segments_month | Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd. | Month |
| segments_quarter | Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters. For example, the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd. | Quarter |
| segments_week | Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd. | Week |
| segments_year | Year, formatted as yyyy. | Year |
Google Ads Table Name: Ad
Google Ads API Resource: ad_group_ad
| Google Ads Field Name | Description | Adwords Mapped Field Name |
|---|---|---|
| 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. | Automated |
| ad_group_ad_ad_app_ad_descriptions | List of text assets for descriptions. When the ad serves the descriptions, they are selected from this list. | UniversalAppAdDescriptions |
| ad_group_ad_ad_app_ad_headlines | List of text assets for headlines. When the ad serves the headlines is selected from this list. | UniversalAppAdHeadlines |
| ad_group_ad_ad_app_ad_html5_media_bundles | List of media bundle assets that may be used with the ad. | UniversalAppAdHtml5MediaBundles |
| ad_group_ad_ad_app_ad_images | List of image assets that may be displayed with the ad. | UniversalAppAdImages |
| 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. | UniversalAppAdMandatoryAdText |
| ad_group_ad_ad_app_ad_youtube_videos | List of YouTube video assets that may be displayed with the ad. | UniversalAppAdYouTubeVideos |
| ad_group_ad_ad_call_ad_phone_number | The phone number in the ad. | CallOnlyPhoneNumber |
| 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 is preferred over other ads when being displayed on a mobile device. The ad can still be displayed on other device types. For example, 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_display_url | The URL that appears in the ad description for some ad formats. | DisplayUrl |
| ad_group_ad_ad_expanded_dynamic_search_ad_description | The description of the ad. | |
| ad_group_ad_ad_expanded_dynamic_search_ad_description2 | The second description of the ad. | ExpandedDynamicSearchCreativeDescription2 |
| ad_group_ad_ad_expanded_text_ad_description | The description of the ad. | |
| ad_group_ad_ad_expanded_text_ad_description2 | The second description of the ad. | ExpandedTextAdDescription2 |
| ad_group_ad_ad_expanded_text_ad_headline_part1 | The first part of the ad's headline. | HeadlinePart1 |
| ad_group_ad_ad_expanded_text_ad_headline_part2 | The second part of the ad's headline. | HeadlinePart2 |
| ad_group_ad_ad_expanded_text_ad_headline_part3 | The third part of the ad's headline. | ExpandedTextAdHeadlinePart3 |
| ad_group_ad_ad_expanded_text_ad_path1 | The text that can appear alongside the ad's displayed URL. | Path1 |
| ad_group_ad_ad_expanded_text_ad_path2 | Additional text that can appear alongside the ad's displayed URL. | Path2 |
| ad_group_ad_ad_final_app_urls | A list of final app URLs that are used on mobile if the user has the specific app installed. | CreativeFinalAppUrls |
| ad_group_ad_ad_final_mobile_urls | The list of possible final mobile URLs after all cross-domain redirects for the ad. | CreativeFinalMobileUrls |
| ad_group_ad_ad_final_urls | The list of possible final URLs after all cross-domain redirects for the ad. | CreativeFinalUrls |
| ad_group_ad_ad_group | The ad group to which the ad belongs. | |
| ad_group_ad_ad_id | The ID of the ad. | CreativeId |
| ad_group_ad_ad_image_ad_image_url | URL of the full size image. | ImageAdUrl |
| ad_group_ad_ad_image_ad_mime_type | The mime type of the image. | ImageCreativeMimeType |
| 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. | ImageCreativeName |
| ad_group_ad_ad_image_ad_pixel_height | Height in pixels of the full size image. | ImageCreativeImageHeight |
| ad_group_ad_ad_image_ad_pixel_width | Width in pixels of the full size image. | ImageCreativeImageWidth |
| ad_group_ad_ad_legacy_responsive_display_ad_accent_color | The accent color of the ad in hexadecimal. For example, #ffffff for white. If one of main_color and accent_color is set, the other is required as well. | AccentColor |
| 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 colors if necessary. When false, the ad is 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. | AllowFlexibleColor |
| ad_group_ad_ad_legacy_responsive_display_ad_business_name | The business name in the ad. | BusinessName |
| ad_group_ad_ad_legacy_responsive_display_ad_call_to_action_text | The call-to-action text for the ad. | CallToActionText |
| ad_group_ad_ad_legacy_responsive_display_ad_description | The description of the ad. | Description |
| ad_group_ad_ad_legacy_responsive_display_ad_format_setting | Specifies which format the ad is served in. Default is ALL_FORMATS. | FormatSetting |
| ad_group_ad_ad_legacy_responsive_display_ad_logo_image | The MediaFile resource name of the logo image used in the ad. | EnhancedDisplayCreativeLandscapeLogoImageMediaId |
| ad_group_ad_ad_legacy_responsive_display_ad_long_headline | The long version of the ad's headline. | LongHeadline |
| ad_group_ad_ad_legacy_responsive_display_ad_main_color | The main color of the ad in hexadecimal. For example, #ffffff for white. If one of main_color and accent_color is set, the other is required as well. | MainColor |
| ad_group_ad_ad_legacy_responsive_display_ad_marketing_image | The MediaFile resource name of the marketing image used in the ad. | EnhancedDisplayCreativeMarketingImageMediaId |
| ad_group_ad_ad_legacy_responsive_display_ad_price_prefix | Prefix before price. For example, 'as low as'. | PricePrefix |
| 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'. | PromoText |
| ad_group_ad_ad_legacy_responsive_display_ad_short_headline | The short version of the ad's headline. | ShortHeadline |
| ad_group_ad_ad_legacy_responsive_display_ad_square_logo_image | The MediaFile resource name of the square logo image used in the ad. | EnhancedDisplayCreativeLogoImageMediaId |
| ad_group_ad_ad_legacy_responsive_display_ad_square_marketing_image | The MediaFile resource name of the square marketing image used in the ad. | EnhancedDisplayCreativeMarketingImageSquareMediaId |
| ad_group_ad_ad_responsive_display_ad_accent_color | The accent color of the ad in hexadecimal. For example, #ffffff for white. If one of main_color and accent_color is set, the other is required as well. | MultiAssetResponsiveDisplayAdAccentColor |
| ad_group_ad_ad_responsive_display_ad_business_name | The advertiser or brand name. Maximum display width is 25. | MultiAssetResponsiveDisplayAdBusinessName |
| ad_group_ad_ad_responsive_display_ad_call_to_action_text | The call-to-action text for the ad. Maximum display width is 30. | MultiAssetResponsiveDisplayAdCallToActionText |
| 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. | MultiAssetResponsiveDisplayAdDescriptions |
| ad_group_ad_ad_responsive_display_ad_format_setting | Specifies which format the ad is served in. Default is ALL_FORMATS. | MultiAssetResponsiveDisplayAdFormatSetting |
| 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. | MultiAssetResponsiveDisplayAdHeadlines |
| 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. | MultiAssetResponsiveDisplayAdLandscapeLogoImages |
| ad_group_ad_ad_responsive_display_ad_long_headline | A required long format headline. The maximum length is 90 characters. | MultiAssetResponsiveDisplayAdLongHeadline |
| ad_group_ad_ad_responsive_display_ad_main_color | The main color of the ad in hexadecimal. For example, #ffffff for white. If one of main_color and accent_color is set, the other is required as well. | MultiAssetResponsiveDisplayAdMainColor |
| 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. | MultiAssetResponsiveDisplayAdMarketingImages |
| ad_group_ad_ad_responsive_display_ad_price_prefix | Prefix before price. For example, 'as low as'. | MultiAssetResponsiveDisplayAdDynamicSettingsPricePrefix |
| ad_group_ad_ad_responsive_display_ad_promo_text | Promotion text used for dynamic formats of responsive ads. For example 'Free two-day shipping'. | MultiAssetResponsiveDisplayAdDynamicSettingsPromoText |
| 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. | MultiAssetResponsiveDisplayAdLogoImages |
| 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. | MultiAssetResponsiveDisplayAdSquareMarketingImages |
| ad_group_ad_ad_responsive_display_ad_youtube_videos | Optional YouTube videos for the ad. A maximum of 5 videos can be specified. | MultiAssetResponsiveDisplayAdYouTubeVideos |
| ad_group_ad_ad_responsive_search_ad_descriptions | List of text assets for descriptions. When the ad serves the descriptions, they are selected from this list. | ResponsiveSearchAdDescriptions |
| ad_group_ad_ad_responsive_search_ad_headlines | List of text assets for headlines. When the ad serves the headlines, they are selected from this list. | ResponsiveSearchAdHeadlines |
| ad_group_ad_ad_responsive_search_ad_path1 | First part of text that may appear appended to the url displayed in the ad. | ResponsiveSearchAdPath1 |
| 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. | ResponsiveSearchAdPath2 |
| ad_group_ad_ad_strength | Overall ad strength for this ad group ad. | AdStrengthInfo |
| ad_group_ad_ad_system_managed_resource_source | If this ad is system managed, then this field indicates the source. This field is read-only. | SystemManagedEntitySource |
| ad_group_ad_ad_text_ad_description1 | The first line of the ad's description. | Description1 |
| ad_group_ad_ad_text_ad_description2 | The second line of the ad's description. | Description2 |
| ad_group_ad_ad_text_ad_headline | The headline of the ad. | Headline |
| ad_group_ad_ad_tracking_url_template | The URL template for constructing a tracking URL. | CreativeTrackingUrlTemplate |
| ad_group_ad_ad_type | The type of ad. | AdType |
| 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. | CreativeUrlCustomParameters |
| ad_group_ad_status | The status of the ad. | Status |
| ad_group_id | Output only. The ID of the ad group. | AdGroupId |
| campaign_id | The ID of the campaign. | CampaignId |
| customer_id | The ID of the customer. | ExternalCustomerId |
Google Ads Table Name: AdBasicStats
Google Ads API Resource: ad_group_ad
| Google Ads Field Name | Description | Adwords Mapped Field Name |
|---|---|---|
| ad_group_ad_ad_group | The ad group to which the ad belongs. | |
| ad_group_ad_ad_id | The ID of the ad. | CreativeId |
| 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. | BaseAdGroupId |
| ad_group_id | Output only. The ID of the ad group. | AdGroupId |
| 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. | BaseCampaignId |
| campaign_id | The ID of the campaign. | CampaignId |
| customer_id | The ID of the customer. | ExternalCustomerId |
| metrics_clicks | The number of clicks. | Clicks |
| metrics_conversions | The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. | Conversions |
| metrics_conversions_value | The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. | ConversionValue |
| metrics_cost_micros | The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period. | Cost |
| metrics_impressions | Count of how often your ad has appeared on a search results page or website on the Google Network. | Impressions |
| metrics_interaction_event_types | The types of payable and free interactions. | InteractionTypes |
| metrics_interactions | The number of interactions. An interaction is the main user action associated with an ad format, such as clicks for text and shopping ads or views for video ads. | 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 (for example, clicking on) another ad. | ViewThroughConversions |
| segments_ad_network_type | Ad network type. | AdNetworkType2 |
| segments_date | Date to which metrics apply. yyyy-MM-dd format. For example, 2018-04-17. | Date |
| segments_device | Device to which metrics apply. | Device |
| segments_slot | Position of the ad. | Slot |
Google Ads Table Name: AdConversionStats
Google Ads API Resource: ad_group_ad
| Google Ads Field Name | Description | Adwords Mapped Field Name |
|---|---|---|
| ad_group_ad_ad_group | The ad group to which the ad belongs. | |
| ad_group_ad_ad_id | The ID of the ad. | CreativeId |
| 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 doesn't 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. | BaseAdGroupId |
| ad_group_id | Output only. The ID of the ad group. | AdGroupId |
| 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. | BaseCampaignId |
| campaign_id | The ID of the campaign. | CampaignId |
| customer_id | The ID of the customer. | ExternalCustomerId |
| metrics_conversions | The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. | Conversions |
| metrics_conversions_value | The total value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. | ConversionValue |
| 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. | ValuePerConversion |
| segments_ad_network_type | Ad network type. | AdNetworkType2 |
| segments_click_type | Click type. | ClickType |
| segments_conversion_action | Resource name of the conversion action. | ConversionTrackerId |
| segments_conversion_action_category | Conversion action category. | ConversionCategoryName |
| segments_conversion_action_name | Conversion action name. | ConversionTypeName |
| segments_date | Date to which metrics apply. yyyy-MM-dd format. For example, 2018-04-17. | Date |
| segments_day_of_week | Day of the week. For example, MONDAY. | DayOfWeek |
| segments_device | Device to which metrics apply. | Device |
| segments_month | Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd. | Month |
| segments_quarter | Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters. For example, the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd. | Quarter |
| segments_slot | Position of the ad. | Slot |
| segments_week | Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd. | Week |
| segments_year | Year, formatted as yyyy. | Year |
Google Ads Table Name: AdCrossDeviceConversionStats
Google Ads API Resource: ad_group_ad
| Google Ads Field Name | Description | Adwords Mapped Field Name |
|---|---|---|
| ad_group_ad_ad_group | The ad group to which the ad belongs. | |
| ad_group_ad_ad_id | The ID of the ad. | CreativeId |
| 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. | BaseAdGroupId |
| ad_group_id | Output only. The ID of the ad group. | AdGroupId |
| 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. | BaseCampaignId |
| campaign_id | The ID of the campaign. | CampaignId |
| customer_id | The ID of the customer. | ExternalCustomerId |
| metrics_all_conversions | The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. | AllConversions |
| metrics_all_conversions_value | The total value of all conversions. | AllConversionValue |
| 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. | CrossDeviceConversions |
| metrics_value_per_all_conversions | The value of all conversions divided by the number of all conversions. | ValuePerAllConversion |
| segments_ad_network_type | Ad network type. | AdNetworkType2 |
| segments_conversion_action | Resource name of the conversion action. | ConversionTrackerId |
| segments_conversion_action_category | Conversion action category. | ConversionCategoryName |
| segments_conversion_action_name | Conversion action name. | ConversionTypeName |
| segments_date | Date to which metrics apply. yyyy-MM-dd format. For example, 2018-04-17. | Date |
| segments_day_of_week | Day of the week. For example, MONDAY. | DayOfWeek |
| segments_month | Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd. | Month |
| segments_quarter | Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters. For example, the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd. | Quarter |
| segments_week | Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd. | Week |
| segments_year | Year, formatted as yyyy. | Year |
Google Ads Table Name: AdCrossDeviceStats
Google Ads API Resource: ad_group_ad
| Google Ads Field Name | Description | Adwords Mapped Field Name |
|---|---|---|
| ad_group_ad_ad_group | The ad group to which the ad belongs. | |
| ad_group_ad_ad_id | The ID of the ad. | CreativeId |
| 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. | BaseAdGroupId |
| ad_group_id | Output only. The ID of the ad group. | AdGroupId |
| 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. | BaseCampaignId |
| campaign_id | The ID of the campaign. | CampaignId |
| customer_id | The ID of the customer. | ExternalCustomerId |
| metrics_absolute_top_impression_percentage | The percent of your ad impressions that are shown as the very first ad above the organic search results. | AbsoluteTopImpressionPercentage |
| metrics_all_conversions | The total number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. | AllConversions |
| metrics_all_conversions_from_interactions_rate | All conversions from interactions (as oppose to view through conversions) divided by the number of ad interactions. | AllConversionRate |
| metrics_all_conversions_value | The total value of all conversions. | AllConversionValue |
| 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. | AverageCpe |
| 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. | AverageCpv |
| metrics_average_page_views | Average number of pages viewed per session. | AveragePageviews |
| metrics_average_time_on_site | Total duration of all sessions (in seconds) / number of sessions. Imported from Google Analytics. | AverageTimeOnSite |
| metrics_bounce_rate | Percentage of clicks where the user only visited a single page on your site. Imported from Google Analytics. | BounceRate |
| metrics_cost_per_all_conversions | The cost of ad interactions divided by all conversions. | CostPerAllConversion |
| 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. | CrossDeviceConversions |
| 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. | EngagementRate |
| 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. | Engagements |
| metrics_percent_new_visitors | Percentage of first-time sessions (from people who had never visited your site before). Imported from Google Analytics. | PercentNewVisitors |
| metrics_top_impression_percentage | The percent of your ad impressions that are shown anywhere above the organic search results. | TopImpressionPercentage |
| metrics_value_per_all_conversions | The value of all conversions divided by the number of all conversions. | ValuePerAllConversion |
| metrics_video_quartile_p100_rate | Percentage of impressions where the viewer watched all of your video. | VideoQuartile100Rate |
| metrics_video_quartile_p25_rate | Percentage of impressions where the viewer watched 25% of your video. | VideoQuartile25Rate |
| metrics_video_quartile_p50_rate | Percentage of impressions where the viewer watched 50% of your video. | VideoQuartile50Rate |
| metrics_video_quartile_p75_rate | Percentage of impressions where the viewer watched 75% of your video. | VideoQuartile75Rate |
| 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. | VideoViewRate |
| metrics_video_views | The number of times your video ads were viewed. | VideoViews |
| segments_ad_network_type | Ad network type. | AdNetworkType2 |
| segments_date | Date to which metrics apply. yyyy-MM-dd format. For example, 2018-04-17. | Date |
| segments_day_of_week | Day of the week. For example, MONDAY. | DayOfWeek |
| segments_month | Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd. | Month |
| segments_quarter | Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters. For example, the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd. | Quarter |
| segments_week | Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd. | Week |
| segments_year | Year, formatted as yyyy. | Year |
Google Ads Table Name: AdGroup
Google Ads API Resource: ad_group
| Google Ads Field Name | Description | Adwords Mapped Field Name |
|---|---|---|
| ad_group_ad_rotation_mode | The ad rotation mode of the ad group. | AdRotationMode |
| ad_group_cpc_bid_micros | The maximum CPC (cost-per-click) bid. | CpcBid |
| ad_group_cpm_bid_micros | The maximum CPM (cost-per-thousand viewable impressions) bid. | CpmBidStr |
| ad_group_cpv_bid_micros | The CPV (cost-per-view) bid. | CpvBid |
| 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. | ContentBidCriterionTypeGroup |
| ad_group_effective_target_cpa_micros | The effective target CPA (cost-per-acquisition). This field is read-only. | TargetCpa |
| ad_group_effective_target_cpa_source | Source of the effective target CPA. This field is read-only. | TargetCpaBidSource |
| ad_group_effective_target_roas | The effective target ROAS (return-on-ad-spend). This field is read-only. | EffectiveTargetRoas |
| ad_group_effective_target_roas_source | Source of the effective target ROAS. This field is read-only. | EffectiveTargetRoasSource |
| ad_group_id | The ID of the ad group. | AdGroupId |
| ad_group_name | The name of the ad group. This field is required and shouldn't 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. | AdGroupName |
| ad_group_status | The status of the ad group. | AdGroupStatus |
| ad_group_tracking_url_template | The URL template for constructing a tracking URL. | TrackingUrlTemplate |
| ad_group_type | The type of the ad group. | AdGroupType |
| 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`. | UrlCustomParameters |
| campaign_bidding_strategy | Portfolio bidding strategy used by campaign. | BiddingStrategyId |
| 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. | BiddingStrategyType |
| campaign_id | The ID of the campaign. | CampaignId |
| campaign_manual_cpc_enhanced_cpc_enabled | Whether bids are to be enhanced based on conversion optimizer data. | EnhancedCpcEnabled |
| 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 shouldn't. | |
| customer_id | The ID of the customer. | ExternalCustomerId |
Google Ads Table Name: AdGroupAdLabel
Google Ads API Resource: ad_group_ad_label
| Google Ads Field Name | Description | Adwords Mapped Field Name |
|---|---|---|
| ad_group_ad_label_ad_group_ad | The ad group ad to which the label is attached. | |
| ad_group_ad_label_label | The label assigned to the ad group ad. | |
| 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}` | |
| ad_group_id | The ID of the ad group. | |
| ad_group_name | The name of the ad group. This field is required and shouldn't 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 shouldn't be empty when creating a new label. The length of this string should be between 1 and 80, inclusive. | |
| label_resource_name | Name of the resource. Label resource names have the form: `customers/{customer_id}/labels/{label_id}` |
Google Ads Table Name: AdGroupAudience
Google Ads API Resource: ad_group_audience_view
| Google Ads Field Name | Description | Adwords Mapped Field Name |
|---|---|---|
| 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_campaign | The campaign to which the ad group belongs. | |
| 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_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. | |
| ad_group_criterion_effective_cpc_bid_source | Source of the effective CPC bid. | |
| ad_group_criterion_effective_cpm_bid_micros | The effective CPM (cost-per-thousand viewable impressions) bid. | |
| ad_group_criterion_effective_cpm_bid_source | Source of the effective CPM bid. | |
| ad_group_criterion_final_mobile_urls | The list of possible final mobile URLs after all cross-domain redirects. | |
| ad_group_criterion_final_urls | The list of possible final URLs after all cross-domain redirects for the ad. | |
| ad_group_criterion_keyword_text | The text of the keyword (at most 80 characters and 10 words). | |
| ad_group_criterion_status | The status of the criterion. | |
| 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_tracking_url_template | The URL template for constructing a tracking URL. | |
| ad_gr |