Google Search Ads 360 (SA360) Connector Reference
81 metrics199 dimensions
The Google Search Ads 360 connector pulls data on campaign, ad group and keyword level.
A sample URL on how to query data:
https://connectors.windsor.ai/google_search_ads?=[API_KEY]&date_preset=last_7d&fields=agency_id,advertiser_id,account_id,dfa_revenue,campaign
The Google Search Ads 360 (SA360) connector exposes 280 fields (81 metrics, 199 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Google Search Ads 360 (SA360) Fields
The Google Search Ads 360 (SA360) connector includes 280 fields.
Google Search Ads 360 (SA360) fields (absolute_top_impression_percentage to ad_rotation)
| ID | Type | Name | Description | Reports |
|---|---|---|---|---|
| absolute_top_impression_percentage | PERCENT | Absolute top impression percentage | Search absolute top impression share is the percentage of your Search ad impressions that are shown in the most prominent Search position. | ad_group, ad_group_ad, ad_group_criterion, asset, campaign, customer, keyword_view |
| account | TEXT | Account | Optional, non-unique descriptive name of the customer. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, campaign_criterion, cart_data_sales_view, conversion, conversion_action, customer, keyword_view, paid_organic_search_term_view, shopping_performance_view, visit |
| account_currency_code | TEXT | Account currency code | The currency in which the account operates. A subset of the currency codes from the ISO 4217 standard is supported. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, campaign_criterion, cart_data_sales_view, conversion, conversion_action, customer, keyword_view, shopping_performance_view, visit |
| account_engine_id | TEXT | Account engine id | ID of the account in the external engine account. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, campaign_criterion, cart_data_sales_view, conversion, conversion_action, customer, keyword_view, paid_organic_search_term_view, shopping_performance_view, visit |
| account_id | TEXT | Account id | The ID of the customer. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, campaign_criterion, cart_data_sales_view, conversion, conversion_action, customer, keyword_view, paid_organic_search_term_view, shopping_performance_view, visit |
| account_time_zone | TEXT | Account time zone | The local timezone ID of the customer. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, campaign_criterion, cart_data_sales_view, conversion, conversion_action, customer, keyword_view, shopping_performance_view, visit |
| account_type | TEXT | Account type | Engine account type, for example, Google Ads, Microsoft Advertising, Yahoo Japan, Baidu, Facebook, Engine Track, etc. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, campaign_criterion, cart_data_sales_view, conversion, conversion_action, customer, keyword_view, paid_organic_search_term_view, shopping_performance_view, visit |
| ad | TEXT | Ad | The name of the ad. This is only used to be able to identify the ad. It does not need to be unique and does not affect the served ad. | ad_group_ad |
| ad_description1 | TEXT | Ad description1 | The first line of the ad's description. | ad_group_ad |
| ad_description2 | TEXT | Ad description2 | The second line of the ad's description. | ad_group_ad |
| ad_display_url | TEXT | Ad display url | The URL that appears in the ad description for some ad formats. | ad_group_ad |
| ad_engine_id | TEXT | Ad engine id | ID of the ad in the external engine account. This field is for Search Ads 360 account only, for example, Yahoo Japan, Microsoft, Baidu etc. For non-Search Ads 360 entity, use "ad_group_ad.ad.id" instead. | ad_group_ad |
| ad_group | TEXT | Ad group | 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, ad_group_ad, ad_group_criterion, conversion, keyword_view, paid_organic_search_term_view, visit |
| ad_group_desktop_bid_adjustment | NUMERIC | (Deprecated) Ad group desktop bid adjustment | The percentage by which bids are adjusted for desktop. For example, 0.2 means 20% increase, so desktop bids are 1.2 times the default bid. The range of valid values differs based on the external engine. | customer, ad_group_ad, ad_group, ad_group_criterion, bidding_strategy, campaign, campaign_criterion, conversion, asset, conversion_action, paid_organic_search_term_view, shopping_performance_view, cart_data_sales_view, visit, keyword_view |
| ad_group_end_date | DATE | Ad group end date | Date when the ad group ends serving ads. By default, the ad group ends on the ad group's end date. If this field is set, then the ad group ends at the end of the specified date in the customer's time zone. This field is only available for Microsoft Advertising and Facebook gateway accounts. Format: YYYY-MM-DD Example: 2019-03-14 | ad_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, visit |
| ad_group_engine_id | TEXT | Ad group engine id | ID of the ad group in the external engine account. This field is for non-Google Ads account only, for example, Yahoo Japan, Microsoft, Baidu etc. For Google Ads entity, use "ad_group.id" instead. | ad_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, visit |
| ad_group_id | TEXT | Ad group id | The ID of the ad group. | ad_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, paid_organic_search_term_view, visit |
| ad_group_labels | TEXT | Ad group labels | The resource names of labels attached to this ad group. | ad_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, visit |
| ad_group_mobile_bid_adjustment | NUMERIC | (Deprecated) Ad group mobile bid adjustment | The percentage by which bids are adjusted for mobile. For example, 0.2 means 20% increase, so mobile bids are 1.2 times the default bid. The range of valid values differs based on the external engine. | customer, ad_group_ad, ad_group, ad_group_criterion, bidding_strategy, campaign, campaign_criterion, conversion, asset, conversion_action, paid_organic_search_term_view, shopping_performance_view, cart_data_sales_view, visit, keyword_view |
| ad_group_search_max_cpc | NUMERIC | Ad group search max cpc (micros) | The maximum CPC (cost-per-click) bid. This field is used when the ad group's effective bidding strategy is Manual CPC. This field is not applicable and will be ignored if the ad group's campaign is using a portfolio bidding strategy. | ad_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, visit |
| ad_group_start_date | DATE | Ad group start date | Date when this ad group starts serving ads. By default, the ad group starts now or the ad group's start date, whichever is later. If this field is set, then the ad group starts at the beginning of the specified date in the customer's time zone. This field is only available for Microsoft Advertising and Facebook gateway accounts. Format: YYYY-MM-DD Example: 2019-03-14 | ad_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, visit |
| ad_group_status | TEXT | Ad group status | The status of the ad group. | ad_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, visit |
| ad_group_tablet_bid_adjustment | NUMERIC | (Deprecated) Ad group tablet bid adjustment | The percentage by which bids are adjusted for tablet. For example, 0.2 means 20% increase, so tablet bids are 1.2 times the default bid. The range of valid values differs based on the external engine. | customer, ad_group_ad, ad_group, ad_group_criterion, bidding_strategy, campaign, campaign_criterion, conversion, asset, conversion_action, paid_organic_search_term_view, shopping_performance_view, cart_data_sales_view, visit, keyword_view |
| ad_group_target_id | TEXT | Ad group target id | The ID of the criterion. | ad_group_criterion, conversion, keyword_view, visit |
| ad_group_type | TEXT | Ad group type | The type of the ad group. | ad_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, visit |
| ad_headline | TEXT | Ad headline | The headline of the ad. | ad_group_ad |
| ad_headline2 | TEXT | Ad headline2 | The second headline of the ad. | ad_group_ad |
| ad_headline3 | TEXT | Ad headline3 | The third headline of the ad. | ad_group_ad |
| ad_id | TEXT | Ad id | The ID of the ad. | ad_group_ad |
| ad_keyword_ad_group_criterion | TEXT | Keyword ad group criterion (segment) | The AdGroupCriterion resource name. | ad_group, ad_group_ad, bidding_strategy, campaign, conversion, customer, keyword_view, visit |
| ad_keyword_id | TEXT | Keyword criterion id (segment) | Keyword criterion id, extracted from AdGroupCriterion resource name. | ad_group, ad_group_ad, bidding_strategy, campaign, conversion, customer, keyword_view, visit |
| ad_keyword_match_type | TEXT | Keyword match type (segment) | The match type of the keyword. | ad_group, ad_group_ad, bidding_strategy, campaign, conversion, customer, keyword_view, visit |
| ad_keyword_text | TEXT | Keyword text (segment) | The text of the keyword (at most 80 characters and 10 words). | ad_group, ad_group_ad, bidding_strategy, campaign, conversion, customer, keyword_view, visit |
| ad_labels | TEXT | Ad labels | The resource names of labels attached to this ad group ad. | ad_group_ad |
| ad_landing_page | TEXT | Ad landing page | The list of possible final URLs after all cross-domain redirects for the ad. | ad_group_ad |
| ad_path_field1 | TEXT | Ad path field1 | Text appended to the auto-generated visible URL with a delimiter. | ad_group_ad |
| ad_path_field2 | TEXT | Ad path field2 | Text appended to path1 with a delimiter. | ad_group_ad |
| ad_responsive_search_ad_descriptions_combined_text | TEXT | Ad responsive search ad description texts combined | The responsive search ad descriptions, joined into a single string separated by ' | '. | ad_group_ad |
| ad_responsive_search_ad_headlines_combined_text | TEXT | Ad responsive search ad headline texts combined | The responsive search ad headlines, joined into a single string separated by ' | '. | ad_group_ad |
| ad_rotation | TEXT | Ad rotation | The ad rotation mode of the ad group. | ad_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, visit |
Google Search Ads 360 (SA360) fields (ad_type to campaign_target_id)
| ID | Type | Name | Description | Reports |
|---|---|---|---|---|
| ad_type | TEXT | Ad type | The type of ad. | ad_group_ad |
| ad_words_bid_strategy | TEXT | Ad words bid strategy | 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, ad_group_ad, ad_group_criterion, campaign, campaign_criterion, conversion, keyword_view, visit |
| ad_words_conversion_value | NUMERIC | Ad words conversion value | The value of client account conversions. This only includes conversion actions which include_in_client_account_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view |
| ad_words_conversions | NUMERIC | Ad words conversions | The number of client account conversions. This only includes conversion actions which include_in_client_account_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view |
| ad_words_view_through_conversions | NUMERIC | Ad words 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. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, customer, keyword_view |
| advertiser | TEXT | Advertiser | Optional, non-unique descriptive name of the customer. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, campaign_criterion, cart_data_sales_view, conversion, conversion_action, customer, keyword_view, paid_organic_search_term_view, shopping_performance_view, visit |
| advertiser_conversion_id | TEXT | Advertiser conversion id | For offline conversions, this is an ID provided by advertisers. If an advertiser doesn't specify such an ID, Search Ads 360 generates one. For online conversions, this is equal to the id column or the floodlight_order_id column depending on the advertiser's Floodlight instructions. | conversion |
| advertiser_currency_code | TEXT | Advertiser currency code | The currency in which the account operates. A subset of the currency codes from the ISO 4217 standard is supported. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, campaign_criterion, cart_data_sales_view, conversion, conversion_action, customer, keyword_view, shopping_performance_view, visit |
| advertiser_id | TEXT | Advertiser id | The ID of the customer. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, campaign_criterion, cart_data_sales_view, conversion, conversion_action, customer, keyword_view, paid_organic_search_term_view, shopping_performance_view, visit |
| age_target_age_range | TEXT | Age target age range | Type of the age range. | ad_group_criterion, conversion, keyword_view, visit |
| age_target_bid_modifier | NUMERIC | Age target 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, conversion, keyword_view, visit |
| agency_id | TEXT | Agency id | DS agency ID. | customer, campaign, conversion_action, ad_group_criterion, campaign_criterion, ad_group_criterion, campaign_criterion, cart_data_sales_view, ad_group, conversion, ad_group_ad, shopping_performance_view, paid_organic_search_term_view, ad_group_criterion, bidding_strategy, customer, visit, campaing_criterion, campaign_criterion, asset, ad_group_criterion |
| app_id | TEXT | App id | Required. A string that uniquely identifies a mobile application. It should just contain the platform native id, like "com.android.ebay" for Android or "12345689" for iOS. | asset |
| app_store | TEXT | App store | Required. The application store that distributes this specific app. | asset |
| avg_cpc | NUMERIC | Avg cpc | The total cost of all clicks divided by the total number of clicks received. This metric is a monetary value and returned in the customer's currency by default. See the metrics_currency parameter at https://developers.google.com/search-ads/reporting/query/query-structure#parameters_clause | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view |
| avg_cpm | NUMERIC | Avg cpm | Average cost-per-thousand impressions (CPM). This metric is a monetary value and returned in the customer's currency by default. See the metrics_currency parameter at https://developers.google.com/search-ads/reporting/query/query-structure#parameters_clause | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view |
| avg_pos | NUMERIC | (Deprecated) Avg pos | Average position. | customer, ad_group_ad, ad_group, ad_group_criterion, bidding_strategy, campaign, campaign_criterion, conversion, asset, conversion_action, paid_organic_search_term_view, shopping_performance_view, cart_data_sales_view, visit, keyword_view |
| bid_strategy | TEXT | Bid strategy | 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, bidding_strategy, campaign, keyword_view |
| bid_strategy_goal | TEXT | (Deprecated) Bid strategy goal | The goal of the bid strategy: Position, Conversions, Revenue, Clicks, or Advanced targeting. | customer, ad_group_ad, ad_group, ad_group_criterion, bidding_strategy, campaign, campaign_criterion, conversion, asset, conversion_action, paid_organic_search_term_view, shopping_performance_view, cart_data_sales_view, visit, keyword_view |
| bid_strategy_id | TEXT | Bid strategy id | The ID of the bidding strategy. | ad_group, bidding_strategy, campaign, keyword_view |
| bid_strategy_max_bid | NUMERIC | Bid strategy max bid (micros) | Maximum bid limit that can be set by the bid strategy. The limit applies to all keywords managed by the strategy. This should only be set for portfolio bid strategies. | ad_group, bidding_strategy, campaign, keyword_view |
| bid_strategy_min_bid | NUMERIC | Bid strategy min bid (micros) | Minimum bid limit that can be set by the bid strategy. The limit applies to all keywords managed by the strategy. This should only be set for portfolio bid strategies. | ad_group, bidding_strategy, campaign, keyword_view |
| bing_ads_budget_type | TEXT | Bing ads budget type | How budget is controlled for Bing Ads campaigns: Daily budget, Monthly even spend, Monthly accelerated spend, Daily accelerated spend, or Daily even spend. | campaign |
| bing_ads_language | TEXT | Bing ads language | The language of the ads and keywords in an ad group. This field is only available for Microsoft Advertising accounts. More details: https://docs.microsoft.com/en-us/advertising/guides/ad-languages?view=bingads-13#adlanguage | ad_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, visit |
| call_conversion_tracker | TEXT | Call conversion tracker | The conversion action to attribute a call conversion to. If not set, the default conversion action is used. This field only has effect if call_conversion_reporting_state is set to USE_RESOURCE_LEVEL_CALL_CONVERSION_ACTION. | asset |
| call_conversion_tracker_id | TEXT | Call conversion tracker id | The conversion action to attribute a call conversion to. If not set, the default conversion action is used. This field only has effect if call_conversion_reporting_state is set to USE_RESOURCE_LEVEL_CALL_CONVERSION_ACTION. | asset |
| call_country_code | TEXT | Call country code | Two-letter country code of the phone number. Examples: 'US', 'us'. | asset |
| call_is_tracked | BOOLEAN | Call is tracked | Whether the call should be enabled on call tracking. Applies to Microsoft Ads. | asset |
| call_phone_number | TEXT | Call phone number | The advertiser's raw phone number. Examples: '1234567890', '(123)456-7890' | asset |
| campaign | TEXT | Campaign | 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. | ad_group, ad_group_ad, ad_group_criterion, campaign, campaign_criterion, conversion, keyword_view, paid_organic_search_term_view, visit |
| campaign_desktop_bid_adjustment | NUMERIC | Campaign desktop bid adjustment | 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_criterion |
| campaign_end_date | DATE | Campaign end date | The last day of the campaign in serving customer's timezone in YYYY-MM-DD format. On create, defaults to 2037-12-30, which means the campaign will run indefinitely. To set an existing campaign to run indefinitely, set this field to 2037-12-30. | ad_group, ad_group_ad, ad_group_criterion, campaign, campaign_criterion, conversion, keyword_view, visit |
| campaign_engine_id | TEXT | Campaign engine id | ID of the campaign in the external engine account. This field is for non-Google Ads account only, for example, Yahoo Japan, Microsoft, Baidu etc. For Google Ads entity, use "campaign.id" instead. | ad_group, ad_group_ad, ad_group_criterion, campaign, campaign_criterion, conversion, keyword_view, visit |
| campaign_id | TEXT | Campaign id | The ID of the campaign. | ad_group, ad_group_ad, ad_group_criterion, campaign, campaign_criterion, conversion, keyword_view, paid_organic_search_term_view, visit |
| campaign_labels | TEXT | Campaign labels | Names of labels directly assigned to this campaign; inherited labels are not included. | campaign |
| campaign_mobile_bid_adjustment | NUMERIC | Campaign mobile bid adjustment | 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_criterion |
| campaign_start_date | DATE | Campaign start date | The date when campaign started in serving customer's timezone in YYYY-MM-DD format. | ad_group, ad_group_ad, ad_group_criterion, campaign, campaign_criterion, conversion, keyword_view, visit |
| campaign_status | TEXT | Campaign status | The status of the campaign. When a new campaign is added, the status defaults to ENABLED. | ad_group, ad_group_ad, ad_group_criterion, campaign, campaign_criterion, conversion, keyword_view, visit |
| campaign_tablet_bid_adjustment | NUMERIC | Campaign tablet bid adjustment | 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_criterion |
| campaign_target_id | TEXT | Campaign target id | The ID of the criterion. This field is ignored during mutate. | campaign_criterion |
Google Search Ads 360 (SA360) fields (campaign_type to dfa_network_time_zone)
| ID | Type | Name | Description | Reports |
|---|---|---|---|---|
| campaign_type | TEXT | Campaign 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. | ad_group, ad_group_ad, ad_group_criterion, campaign, campaign_criterion, conversion, keyword_view, visit |
| city_targets | TEXT | City targets | City targets included in the ad group. Download upload templates and geo/language codes. | campaign, ad_group |
| clicks | NUMERIC | Clicks | The number of clicks. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view |
| conversion_attribution_type | TEXT | Conversion attribution type | What the conversion is attributed to: Visit or Keyword+Ad. | conversion |
| conversion_category | TEXT | Conversion category | Segments the report by conversion category; each row and its aggregate metrics are split into multiple rows, up to one for each conversion category. This column returns the category of the conversion action of each row (for example PURCHASE, LEAD, PAGE_VIEW or SIGNUP), describing the business goal of the conversion. Distinct from the conversion action type, which describes how the conversion is tracked. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, cart_data_sales_view, conversion, customer, keyword_view, shopping_performance_view |
| conversion_date | DATE | Conversion date | The timestamp of the conversion event. | conversion |
| conversion_id | TEXT | Conversion id | The ID of the conversion | conversion |
| conversion_last_modified_timestamp | Conversion last modified timestamp | The timestamp of the last time the conversion was modified. | conversion | |
| conversion_quantity | NUMERIC | Conversion quantity | The quantity of items recorded by the conversion, as determined by the qty url parameter. The advertiser is responsible for dynamically populating the parameter (such as number of items sold in the conversion), otherwise it defaults to 1. | conversion |
| conversion_revenue | NUMERIC | Conversion revenue (micros) | The adjusted revenue in micros for the conversion event. This will always be in the currency of the serving account. | conversion |
| conversion_timestamp | Conversion timestamp | The timestamp of the conversion event. | conversion | |
| conversion_visit_external_click_id | TEXT | Conversion visit external click id | A unique string, for the visit that the conversion is attributed to, that is passed to the landing page as the click id URL parameter. | conversion |
| conversion_visit_id | TEXT | Conversion visit id | The Search Ads 360 visit ID that the conversion is attributed to. | conversion |
| conversion_visit_timestamp | Conversion visit timestamp | The timestamp of the visit that the conversion is attributed to. | conversion | |
| conversions_value | NUMERIC | Conversion value | The sum of conversion values for the conversions included in the "conversions" field. This metric is useful only if you entered a value for your conversion actions. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view |
| country_targets | TEXT | Country targets | Country targets included in the ad group. Download upload templates and geo/language codes. | campaign, ad_group |
| cpa_target | NUMERIC | Cpa target (micros) | Average CPA target. This target should be greater than or equal to minimum billable unit based on the currency for the account. | ad_group, bidding_strategy, campaign, keyword_view |
| creation_timestamp | Creation timestamp | The timestamp when this customer was created. The timestamp is in the customer's time zone and in "yyyy-MM-dd HH:mm:ss" format. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, campaign_criterion, cart_data_sales_view, conversion, conversion_action, customer, keyword_view, shopping_performance_view, visit | |
| cross_device_conversions | NUMERIC | Cross device conversions | Conversions from when a customer clicks on an ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view |
| cross_device_conversions_value | NUMERIC | Cross device conversions value | The sum of the value of cross-device conversions. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view |
| cross_sell_average_unit_price | NUMERIC | Cross sell average unit price (micros) | Average price reported for sales of a product when it sold as a result of advertising a different product. | ad_group, ad_group_ad, ad_group_criterion, campaign, cart_data_sales_view, customer, keyword_view, shopping_performance_view |
| cross_sell_cost_of_goods_sold | NUMERIC | Cross sell cost of goods sold (micros) | Cross-sell cost of goods sold (COGS) is the total cost of products sold as a result of advertising a different product. How it works: You report conversions with cart data for completed purchases on your website. If the ad that was interacted with before the purchase has an associated product (see Shopping Ads) then this product is considered the advertised product. Any product included in the order the customer places is a sold product. If these products don't match then this is considered cross-sell. Cross-sell cost of goods sold is the total cost of the products sold that weren't advertised. Example: Someone clicked on a Shopping ad for a hat then bought the same hat and a shirt. The hat has a cost of goods sold value of $3, the shirt has a cost of goods sold value of $5. The cross-sell cost of goods sold for this order is $5. This metric is only available if you report conversions with cart data. This metric is a monetary value and returned in the customer's currency by default. See the metrics_currency parameter at https://developers.google.com/search-ads/reporting/query/query-structure#parameters_clause | ad_group, ad_group_ad, ad_group_criterion, campaign, cart_data_sales_view, customer, keyword_view, shopping_performance_view |
| cross_sell_gross_from_units_sold | NUMERIC | Cross sell gross from units sold (micros) | Cross-sell revenue is the total amount you made from products sold as a result of advertising a different product. How it works: You report conversions with cart data for completed purchases on your website. If the ad that was interacted with before the purchase has an associated product (see Shopping Ads) then this product is considered the advertised product. Any product included in the order the customer places is a sold product. If these products don't match then this is considered cross-sell. Cross-sell revenue is the total value you made from cross-sell attributed to your ads. Example: Someone clicked on a Shopping ad for a hat then bought the same hat and a shirt. The hat is priced $10 and the shirt is priced $20. The cross-sell revenue of this order is $20. This metric is only available if you report conversions with cart data. This metric is a monetary value and returned in the customer's currency by default. See the metrics_currency parameter at https://developers.google.com/search-ads/reporting/query/query-structure#parameters_clause | ad_group, ad_group_ad, ad_group_criterion, campaign, cart_data_sales_view, customer, keyword_view, shopping_performance_view |
| cross_sell_gross_profit_margin | NUMERIC | Cross sell gross profit margin (micros) | Cross-sell gross profit is the profit you made from products sold as a result of advertising a different product, minus cost of goods sold (COGS). How it works: You report conversions with cart data for completed purchases on your website. If the ad that was interacted with before the purchase has an associated product (see Shopping Ads) then this product is considered the advertised product. Any product included in the purchase is a sold product. If these products don't match then this is considered cross-sell. Cross-sell gross profit is the revenue you made from cross-sell attributed to your ads minus the cost of the goods sold. Example: Someone clicked on a Shopping ad for a hat then bought the same hat and a shirt. The shirt is priced $20 and has a cost of goods sold value of $5. The cross-sell gross profit of this order is $15 = $20 - $5. This metric is only available if you report conversions with cart data. This metric is a monetary value and returned in the customer's currency by default. See the metrics_currency parameter at https://developers.google.com/search-ads/reporting/query/query-structure#parameters_clause | ad_group, ad_group_ad, ad_group_criterion, campaign, cart_data_sales_view, customer, keyword_view, shopping_performance_view |
| cross_sell_revenue_from_units_sold | NUMERIC | Cross sell revenue from units sold (micros) | Cross-sell revenue is the total amount you made from products sold as a result of advertising a different product. How it works: You report conversions with cart data for completed purchases on your website. If the ad that was interacted with before the purchase has an associated product (see Shopping Ads) then this product is considered the advertised product. Any product included in the order the customer places is a sold product. If these products don't match then this is considered cross-sell. Cross-sell revenue is the total value you made from cross-sell attributed to your ads. Example: Someone clicked on a Shopping ad for a hat then bought the same hat and a shirt. The hat is priced $10 and the shirt is priced $20. The cross-sell revenue of this order is $20. This metric is only available if you report conversions with cart data. This metric is a monetary value and returned in the customer's currency by default. See the metrics_currency parameter at https://developers.google.com/search-ads/reporting/query/query-structure#parameters_clause | ad_group, ad_group_ad, ad_group_criterion, campaign, cart_data_sales_view, customer, keyword_view, shopping_performance_view |
| cross_sell_units_sold | NUMERIC | Cross sell units sold | Cross-sell units sold is the total number of products sold as a result of advertising a different product. How it works: You report conversions with cart data for completed purchases on your website. If the ad that was interacted with before the purchase has an associated product (see Shopping Ads) then this product is considered the advertised product. Any product included in the order the customer places is a sold product. If these products don't match then this is considered cross-sell. Cross-sell units sold is the total number of cross-sold products from all orders attributed to your ads. Example: Someone clicked on a Shopping ad for a hat then bought the same hat, a shirt and a jacket. The cross-sell units sold in this order is 2. This metric is only available if you report conversions with cart data. | ad_group, ad_group_ad, ad_group_criterion, campaign, cart_data_sales_view, customer, keyword_view, shopping_performance_view |
| ctr | PERCENT | Ctr | The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions). | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view |
| daily_budget | NUMERIC | Daily budget | Daily budget of the campaign. | campaign |
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | Date to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, cart_data_sales_view, conversion, conversion_action, customer, keyword_view, paid_organic_search_term_view, shopping_performance_view, visit |
| day_of_month | TEXT | Day of month | Day of the month | |
| delivery_method | TEXT | Delivery method | Budget delivery method of the campaign: Standard or Accelerated. | campaign |
| device_segment | TEXT | Device segment | Device to which metrics apply. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, cart_data_sales_view, conversion, customer, keyword_view, shopping_performance_view, visit |
| device_targets | TEXT | Device targets | Device targets at the ad group level; a combination of Desktop, Mobile, Tablet, or Other. | campaign, ad_group |
| dfa_actions | NUMERIC | Campaign Manager actions | The total number of Campaign manager actions. | ad_group_ad, customer, shopping_performance_view, campaign, bidding_strategy, customer, campaing_criterion, cart_data_sales_view, campaign_criterion, ad_group, asset, keyword_view |
| dfa_actions_cross_env | NUMERIC | Campaign Manager actions (cross-environment) | The total number of conversions. This includes all conversions regardless of the value of include_in_conversions_metric. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, conversion_action, customer, keyword_view, shopping_performance_view |
| dfa_advertiser_id | TEXT | Campaign Manager advertiser ID | ID of the Campaign Manager advertiser associated with this customer. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, campaign_criterion, cart_data_sales_view, conversion, conversion_action, customer, keyword_view, shopping_performance_view, visit |
| dfa_network_id | TEXT | Campaign Manager network ID | ID of the Campaign Manager network associated with this customer. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, campaign_criterion, cart_data_sales_view, conversion, conversion_action, customer, keyword_view, shopping_performance_view, visit |
| dfa_network_time_zone | TEXT | Campaign Manager network time zone | Time zone of the Campaign Manager network associated with this customer in IANA Time Zone Database format, such as America/New_York. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, campaign_criterion, cart_data_sales_view, conversion, conversion_action, customer, keyword_view, shopping_performance_view, visit |
Google Search Ads 360 (SA360) fields (dfa_revenue to floodlight_order_id)
| ID | Type | Name | Description | Reports |
|---|---|---|---|---|
| dfa_revenue | NUMERIC | Campaign Manager revenue | Aggregate revenue generated by Campaign manager transactions. | ad_group_ad, customer, shopping_performance_view, campaign, bidding_strategy, customer, campaing_criterion, cart_data_sales_view, campaign_criterion, ad_group, asset, keyword_view |
| dfa_revenue_cross_env | NUMERIC | Campaign Manager revenue (cross-environment) | The value of all conversions. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, conversion_action, customer, keyword_view, shopping_performance_view |
| dfa_transactions | NUMERIC | Campaign Manager transactions | The total number of Campaign manager transactions. | ad_group_ad, customer, shopping_performance_view, campaign, bidding_strategy, customer, campaing_criterion, cart_data_sales_view, campaign_criterion, ad_group, asset, keyword_view |
| dfa_transactions_cross_env | NUMERIC | Campaign Manager transactions (cross-environment) | The total number of conversions. This includes all conversions regardless of the value of include_in_conversions_metric. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, conversion_action, customer, keyword_view, shopping_performance_view |
| display_budget_lost_impression_share | NUMERIC | Display 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. | ad_group, campaign, customer |
| display_impression_share | NUMERIC | Display 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, campaign, customer |
| display_rank_lost_impression_share | NUMERIC | Display 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. | ad_group, campaign, customer |
| dynamic_search_ads_target_conditions | TEXT | Dynamic search ads target conditions | Conditions, or logical expressions, for webpage targeting. The list of webpage targeting conditions are and-ed together when evaluated for targeting. An empty list of conditions indicates all pages of the campaign's website are targeted. This field is required for CREATE operations and is prohibited on UPDATE operations. | ad_group_criterion, conversion, keyword_view, visit |
| dynamic_search_ads_target_coverage | NUMERIC | Dynamic search ads target coverage | Website criteria coverage percentage. This is the computed percentage of website coverage based on the website target, negative website target and negative keywords in the ad group and campaign. For instance, when coverage returns as 1, it indicates it has 100% coverage. This field is read-only. | ad_group_criterion, conversion, keyword_view, visit |
| dynamic_search_ads_target_cpc_bid | NUMERIC | Dynamic search ads target cpc bid (micros) | The CPC (cost-per-click) bid. | ad_group_criterion, conversion, keyword_view, visit |
| dynamic_search_ads_target_landing_page_url | TEXT | Dynamic search ads target landing page url | The dynamic ad target's URL template. | ad_group_criterion |
| effective_bid_strategy | TEXT | Effective bid strategy | 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, bidding_strategy, campaign, keyword_view |
| effective_bid_strategy_id | TEXT | Effective bid strategy id | The ID of the bidding strategy. | ad_group, bidding_strategy, campaign, keyword_view |
| effective_city_targets | TEXT | Effective city targets | City targets included in the ad group, or inherited from the campaign. Download upload templates and geo/language codes. | campaign, ad_group |
| effective_country_targets | TEXT | Effective country targets | Country targets included in the ad group, or inherited from the campaign. Download upload templates and geo/language codes. | campaign, ad_group |
| effective_device_targets | TEXT | Effective device targets | Device targets at the ad group level, or inherited from the campaign; a combination of Desktop, Mobile, Tablet, or Other. | campaign, ad_group |
| effective_keyword_max_cpc | NUMERIC | Effective keyword max cpc (micros) | The effective CPC (cost-per-click) bid. | ad_group_criterion, conversion, keyword_view, visit |
| effective_metro_targets | TEXT | Effective metro targets | Metro targets included in the ad group, or inherited from the campaign. Download upload templates and geo/language codes. | campaign, ad_group |
| effective_province_targets | TEXT | Effective province targets | Province targets included in the ad group, or inherited from the campaign. Download upload templates and geo/language codes. | campaign, ad_group |
| engine_remarketing_list | TEXT | Engine remarketing list | The User List resource name. | ad_group_criterion, conversion, keyword_view, visit |
| engine_remarketing_list_bid_modifier | NUMERIC | Engine remarketing list 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, conversion, keyword_view, visit |
| engine_remarketing_list_target_all | BOOLEAN | Engine remarketing list target all | The per-targeting-dimension setting to restrict the reach of your campaign or ad group. | ad_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, visit |
| engine_status | TEXT | Engine status | The Engine Status for an asset. | asset |
| ers_target | NUMERIC | Ers target | The chosen revenue (based on conversion data) per unit of spend. | ad_group, bidding_strategy, campaign, keyword_view |
| excluded_city_targets | TEXT | Excluded city targets | City targets excluded from the campaign. Download upload templates and geo/language codes. | campaign |
| excluded_country_targets | TEXT | Excluded country targets | Country targets excluded from the campaign. Download upload templates and geo/language codes. | campaign |
| excluded_metro_targets | TEXT | Excluded metro targets | Metro targets excluded from the campaign. Download upload templates and geo/language codes. | campaign |
| excluded_province_targets | TEXT | Excluded province targets | Province targets excluded from the campaign. Download upload templates and geo/language codes. | campaign |
| feed_id | TEXT | Feed id | Segments the report by feed items; each row and its aggregate metrics are split into multiple rows, one for each feed item. This column returns the DS feed table ID for each row. | campaign, visit, ad_group, conversion, asset |
| feed_item_id | TEXT | Feed item id | The ID of the asset. | asset |
| feed_type | TEXT | Feed type | Type of the asset. | asset |
| floodlight_activity | TEXT | Conversion action name | Conversion action name. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, cart_data_sales_view, conversion, customer, keyword_view, shopping_performance_view |
| floodlight_activity_id | TEXT | Floodlight activity id | ID of the Floodlight activity in DoubleClick Campaign Manager (DCM). | conversion_action |
| floodlight_activity_tag | TEXT | Conversion action (activity tag) | Resource name of the conversion action. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, cart_data_sales_view, conversion, customer, keyword_view, shopping_performance_view |
| floodlight_activity_target_ids | TEXT | Conversion action (target IDs) | Resource name of the conversion action. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, cart_data_sales_view, conversion, customer, keyword_view, shopping_performance_view |
| floodlight_group | TEXT | (Deprecated) Floodlight group | Segments the report by Floodlight groups; each row and its aggregate metrics are split into multiple rows, up to one for each Floodlight group. This column returns the Floodlight group name of each row. Note that some metrics do not have Floodlight segmented values, such as clicks and visits. | customer, ad_group_ad, ad_group, ad_group_criterion, bidding_strategy, campaign, campaign_criterion, conversion, asset, conversion_action, paid_organic_search_term_view, shopping_performance_view, cart_data_sales_view, visit, keyword_view |
| floodlight_group_conversion_type | TEXT | Conversion type | The type of this conversion action. | conversion_action |
| floodlight_group_tag | TEXT | Floodlight group tag | String used to identify a Floodlight activity group when reporting conversions. | conversion_action |
| floodlight_optimization_enabled | BOOLEAN | (Deprecated) Floodlight optimization enabled | Whether the bid strategy targets specific Floodlight activities. | customer, ad_group_ad, ad_group, ad_group_criterion, bidding_strategy, campaign, campaign_criterion, conversion, asset, conversion_action, paid_organic_search_term_view, shopping_performance_view, cart_data_sales_view, visit, keyword_view |
| floodlight_order_id | TEXT | Floodlight order id | The Floodlight order ID provided by the advertiser for the conversion. | conversion |
Google Search Ads 360 (SA360) fields (floodlight_original_revenue to network_target)
| ID | Type | Name | Description | Reports |
|---|---|---|---|---|
| floodlight_original_revenue | NUMERIC | Floodlight original revenue | The original, unchanged revenue associated with the Floodlight event (in the currency of the current report), before Floodlight currency instruction modifications. | conversion |
| floodlight_referrer | TEXT | (Deprecated) Floodlight referrer | The Floodlight referrer website of the conversion. | customer, ad_group_ad, ad_group, ad_group_criterion, bidding_strategy, campaign, campaign_criterion, conversion, asset, conversion_action, paid_organic_search_term_view, shopping_performance_view, cart_data_sales_view, visit, keyword_view |
| gender_target_bid_modifier | NUMERIC | Gender target 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, conversion, keyword_view, visit |
| gender_target_gender_type | TEXT | Gender target gender type | Type of the gender. | ad_group_criterion, conversion, keyword_view, visit |
| impressions | NUMERIC | Impressions | Count of how often your ad has appeared on a search results page or website on the Google Network. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view |
| inventory_account_id | TEXT | Inventory account id | The Search Ads 360 inventory account ID containing the product that was clicked on. Search Ads 360 generates this ID when you link an inventory account in Search Ads 360. | visit |
| keyword_clickserver_url | TEXT | Keyword clickserver url | The URL template for constructing a tracking URL. | ad_group_criterion, conversion, keyword_view, visit |
| keyword_engine_id | TEXT | Keyword engine id | ID of the ad group criterion in the external engine account. This field is for non-Google Ads account only, for example, Yahoo Japan, Microsoft, Baidu etc. For Google Ads entity, use "ad_group_criterion.criterion_id" instead. | ad_group_criterion, conversion, keyword_view, visit |
| keyword_id | TEXT | Keyword id | Search Ads 360 criterion ID. A value of 0 indicates that the criterion is unattributed. | conversion, paid_organic_search_term_view |
| keyword_labels | TEXT | Keyword labels | Names of labels directly assigned to this keyword; inherited labels are not included. | ad_group_criterion |
| keyword_landing_page | TEXT | Keyword landing page | The list of possible final URLs after all cross-domain redirects for the ad. | ad_group_criterion, conversion, keyword_view, visit |
| keyword_match_type | TEXT | Keyword match type | The match type of the keyword. | ad_group_criterion, conversion, keyword_view, paid_organic_search_term_view, visit |
| keyword_max_bid | NUMERIC | Keyword max bid (micros) | Maximum bid limit that can be set by the bid strategy. The limit applies to all keywords managed by the strategy. This should only be set for portfolio bid strategies. | ad_group, bidding_strategy, campaign, keyword_view |
| keyword_max_cpc | NUMERIC | Keyword max cpc (micros) | The CPC (cost-per-click) bid. | ad_group_criterion, conversion, keyword_view, visit |
| keyword_min_bid | NUMERIC | Keyword min bid (micros) | Minimum bid limit that can be set by the bid strategy. The limit applies to all keywords managed by the strategy. This should only be set for portfolio bid strategies. | ad_group, bidding_strategy, campaign, keyword_view |
| keyword_text | TEXT | Keyword text | The text of the keyword (at most 80 characters and 10 words). | ad_group_criterion, conversion, keyword_view, paid_organic_search_term_view, visit |
| keyword_url_params | TEXT | Keyword url params | URL template for appending params to final URL. | ad_group_criterion, conversion, keyword_view, visit |
| language_targets | TEXT | Language targets | The language constant resource name. | campaign_criterion |
| last_modified_timestamp | Last modified timestamp | The datetime when this customer was last modified. The datetime is in the customer's time zone and in "yyyy-MM-dd HH:mm:ss.ssssss" format. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, campaign_criterion, cart_data_sales_view, conversion, conversion_action, customer, keyword_view, shopping_performance_view, visit | |
| lead_average_unit_price | NUMERIC | Lead average unit price (micros) | The average price reported for sales of a product when it sold as a result of advertising the product. | ad_group, ad_group_ad, ad_group_criterion, campaign, cart_data_sales_view, customer, keyword_view, shopping_performance_view |
| lead_cost_of_goods_sold | NUMERIC | Lead cost of goods sold (micros) | Lead cost of goods sold (COGS) is the total cost of products sold as a result of advertising the same product. How it works: You report conversions with cart data for completed purchases on your website. If the ad that was interacted with has an associated product (see Shopping Ads) then this product is considered the advertised product. Any product included in the order the customer places is a sold product. If the advertised and sold products match, then the cost of these goods is counted under lead cost of goods sold. Example: Someone clicked on a Shopping ad for a hat then bought the same hat and a shirt. The hat has a cost of goods sold value of $3, the shirt has a cost of goods sold value of $5. The lead cost of goods sold for this order is $3. This metric is only available if you report conversions with cart data. This metric is a monetary value and returned in the customer's currency by default. See the metrics_currency parameter at https://developers.google.com/search-ads/reporting/query/query-structure#parameters_clause | ad_group, ad_group_ad, ad_group_criterion, campaign, cart_data_sales_view, customer, keyword_view, shopping_performance_view |
| lead_gross_profit_from_units_sold | NUMERIC | Lead gross profit from units sold (micros) | Lead gross profit is the profit you made from products sold as a result of advertising the same product, minus cost of goods sold (COGS). How it works: You report conversions with cart data for completed purchases on your website. If the ad that was interacted with before the purchase has an associated product (see Shopping Ads) then this product is considered the advertised product. Any product included in the order the customer places is a sold product. If the advertised and sold products match, then the revenue you made from these sales minus the cost of goods sold is your lead gross profit. Example: Someone clicked on a Shopping ad for a hat then bought the same hat and a shirt. The hat is priced $10 and has a cost of goods sold value of $3. The lead gross profit of this order is $7 = $10 - $3. This metric is only available if you report conversions with cart data. This metric is a monetary value and returned in the customer's currency by default. See the metrics_currency parameter at https://developers.google.com/search-ads/reporting/query/query-structure#parameters_clause | ad_group, ad_group_ad, ad_group_criterion, campaign, cart_data_sales_view, customer, keyword_view, shopping_performance_view |
| lead_revenue_from_units_sold | NUMERIC | Lead revenue from units sold (micros) | Lead revenue is the total amount you made from products sold as a result of advertising the same product. How it works: You report conversions with cart data for completed purchases on your website. If the ad that was interacted with before the purchase has an associated product (see Shopping Ads) then this product is considered the advertised product. Any product included in the order the customer places is a sold product. If the advertised and sold products match, then the total value you made from the sales of these products is shown under lead revenue. Example: Someone clicked on a Shopping ad for a hat then bought the same hat and a shirt. The hat is priced $10 and the shirt is priced $20. The lead revenue of this order is $10. This metric is only available if you report conversions with cart data. This metric is a monetary value and returned in the customer's currency by default. See the metrics_currency parameter at https://developers.google.com/search-ads/reporting/query/query-structure#parameters_clause | ad_group, ad_group_ad, ad_group_criterion, campaign, cart_data_sales_view, customer, keyword_view, shopping_performance_view |
| lead_units_sold | NUMERIC | Lead units sold | Lead units sold is the total number of products sold as a result of advertising the same product. How it works: You report conversions with cart data for completed purchases on your website. If the ad that was interacted with before the purchase has an associated product (see Shopping Ads) then this product is considered the advertised product. Any product included in the order the customer places is a sold product. If the advertised and sold products match, then the total number of these products sold is shown under lead units sold. Example: Someone clicked on a Shopping ad for a hat then bought the same hat, a shirt and a jacket. The lead units sold in this order is 1. This metric is only available if you report conversions with cart data. | ad_group, ad_group_ad, ad_group_criterion, campaign, cart_data_sales_view, customer, keyword_view, shopping_performance_view |
| location_target_bid_modifier | NUMERIC | Location target 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_criterion |
| location_target_name | TEXT | Location target name | The name of the location target. | ad_group_criterion, campaing_criterion, campaign_criterion, ad_group_criterion |
| metro_targets | TEXT | Metro targets | Metro targets included in the ad group. Download upload templates and geo/language codes. | campaign, ad_group |
| month | TEXT | Month | Number of the month | |
| month_start | DATE | Month start | Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, cart_data_sales_view, conversion, conversion_action, customer, keyword_view, paid_organic_search_term_view, shopping_performance_view, visit |
| monthly_budget | NUMERIC | Monthly budget (micros) | Monthly budget of the campaign. | campaign |
| monthly_spend_target | NUMERIC | Monthly spend target (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. This field is deprecated and should no longer be used. See https://ads-developers.googleblog.com/2020/05/reminder-about-sunset-creation-of.html for details. | ad_group, bidding_strategy, campaign, keyword_view |
| negative_ad_group_keyword_id | TEXT | Negative ad group keyword id | The ID of the criterion. | ad_group_criterion, conversion, keyword_view, visit |
| negative_ad_group_keyword_match_type | TEXT | Negative ad group keyword match type | The match type of the keyword. | ad_group_criterion, conversion, keyword_view, visit |
| negative_ad_group_keyword_text | TEXT | Negative ad group keyword text | The text of the keyword (at most 80 characters and 10 words). | ad_group_criterion, conversion, keyword_view, visit |
| negative_ad_group_target_id | TEXT | Negative ad group target id | The ID of the criterion. | ad_group_criterion, conversion, keyword_view, visit |
| negative_campaign_keyword_id | TEXT | Negative campaign keyword id | The ID of the criterion. This field is ignored during mutate. | campaign_criterion |
| negative_campaign_keyword_match_type | TEXT | Negative campaign keyword match type | The match type of the keyword. | campaign_criterion |
| negative_campaign_keyword_text | TEXT | Negative campaign keyword text | The text of the keyword (at most 80 characters and 10 words). | campaign_criterion |
| negative_campaign_target_id | TEXT | Negative campaign target id | The ID of the criterion. This field is ignored during mutate. | campaign_criterion |
| network_target | TEXT | (Deprecated) Network target | The type of network(s) the campaign advertises on. | customer, ad_group_ad, ad_group, ad_group_criterion, bidding_strategy, campaign, campaign_criterion, conversion, asset, conversion_action, paid_organic_search_term_view, shopping_performance_view, cart_data_sales_view, visit, keyword_view |
Google Search Ads 360 (SA360) fields (now to search_budget_lost_impression_share)
| ID | Type | Name | Description | Reports |
|---|---|---|---|---|
| now | Now | Current timestamp | ||
| organic_clicks | NUMERIC | (Deprecated) Organic clicks | The number of clicks on unpaid search results for your site after someone entered the searchQuery. | customer, ad_group_ad, ad_group, ad_group_criterion, bidding_strategy, campaign, campaign_criterion, conversion, asset, conversion_action, paid_organic_search_term_view, shopping_performance_view, cart_data_sales_view, visit, keyword_view |
| organic_queries | NUMERIC | (Deprecated) Organic queries | The total number of times users have entered the searchQuery and saw at least one organic search result from your site. | customer, ad_group_ad, ad_group, ad_group_criterion, bidding_strategy, campaign, campaign_criterion, conversion, asset, conversion_action, paid_organic_search_term_view, shopping_performance_view, cart_data_sales_view, visit, keyword_view |
| paid_and_organic_clicks | NUMERIC | (Deprecated) Paid and organic clicks | The number of clicks on either one of your ads ad or an unpaid search result for your site after someone entered the searchQuery. | customer, ad_group_ad, ad_group, ad_group_criterion, bidding_strategy, campaign, campaign_criterion, conversion, asset, conversion_action, paid_organic_search_term_view, shopping_performance_view, cart_data_sales_view, visit, keyword_view |
| paid_and_organic_ctr | NUMERIC | Paid and organic ctr | The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions). | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, customer, keyword_view, paid_organic_search_term_view, shopping_performance_view |
| paid_and_organic_queries | NUMERIC | (Deprecated) Paid and organic queries | The total number of times users have entered the searchQuery and saw at least one of your ads or at least one organic search result from your site. | customer, ad_group_ad, ad_group, ad_group_criterion, bidding_strategy, campaign, campaign_criterion, conversion, asset, conversion_action, paid_organic_search_term_view, shopping_performance_view, cart_data_sales_view, visit, keyword_view |
| product_brand | TEXT | Product brand | Brand of the product. | ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
| product_category_level1 | TEXT | Product category level1 | Bidding category (level 1) of the product. | ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
| product_category_level2 | TEXT | Product category level2 | Bidding category (level 2) of the product. | ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
| product_category_level3 | TEXT | Product category level3 | Bidding category (level 3) of the product. | ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
| product_category_level4 | TEXT | Product category level4 | Bidding category (level 4) of the product. | ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
| product_category_level5 | TEXT | Product category level5 | Bidding category (level 5) of the product. | ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
| product_channel | TEXT | Product channel | The sales channel of the product that was clicked on: Online or Local. | conversion |
| product_channel_exclusivity | TEXT | Product channel exclusivity | Channel exclusivity of the product. | ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
| product_condition | TEXT | Product condition | Condition of the product. | ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
| product_country | COUNTRY | Product country | The country (ISO-3166 format) registered for the inventory feed that contains the product clicked on. | visit |
| product_custom_label0 | TEXT | Product custom label0 | Custom attribute 0 of the product. | ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
| product_custom_label1 | TEXT | Product custom label1 | Custom attribute 1 of the product. | ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
| product_custom_label2 | TEXT | Product custom label2 | Custom attribute 2 of the product. | ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
| product_custom_label3 | TEXT | Product custom label3 | Custom attribute 3 of the product. | ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
| product_custom_label4 | TEXT | Product custom label4 | Custom attribute 4 of the product. | ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
| product_group_id | TEXT | Product group id | The ID of the criterion. | ad_group_criterion, conversion, keyword_view, visit |
| product_id | TEXT | Product id | The ID of the product clicked on. | visit |
| product_language | TEXT | Product language | The language (ISO-639-1) that has been set for the Merchant Center feed containing data about the product. | visit |
| product_store_id | TEXT | Product store id | The store in the Local Inventory Ad that was clicked on. This should match the store IDs used in your local products feed. | visit |
| product_target_id | TEXT | (Deprecated) Product target id | DS product target ID. | customer, ad_group_ad, ad_group, ad_group_criterion, bidding_strategy, campaign, campaign_criterion, conversion, asset, conversion_action, paid_organic_search_term_view, shopping_performance_view, cart_data_sales_view, visit, keyword_view |
| product_title | TEXT | Product title | Title of the product. | ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
| product_type_level1 | TEXT | Product type level1 | Type (level 1) of the product. | ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
| product_type_level2 | TEXT | Product type level2 | Type (level 2) of the product. | ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
| product_type_level3 | TEXT | Product type level3 | Type (level 3) of the product. | ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
| product_type_level4 | TEXT | Product type level4 | Type (level 4) of the product. | ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
| product_type_level5 | TEXT | Product type level5 | Type (level 5) of the product. | ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
| province_targets | TEXT | Province targets | Province targets included in the ad group. Download upload templates and geo/language codes. | campaign, ad_group |
| quality_score_avg | NUMERIC | Quality score avg | The historical quality score. | ad_group, ad_group_criterion, campaign, customer, keyword_view |
| quality_score_current | NUMERIC | Quality score current | The quality score. This field may not be populated if Google does not have enough information to determine a value. | ad_group_criterion, conversion, keyword_view, visit |
| quarter_start | DATE | Quarter start | 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. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, cart_data_sales_view, conversion, conversion_action, customer, keyword_view, paid_organic_search_term_view, shopping_performance_view, visit |
| roas_target | NUMERIC | Roas target | The chosen revenue (based on conversion data) per unit of spend. | ad_group, bidding_strategy, campaign, keyword_view |
| search_absolute_top_impression_share | NUMERIC | 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/sa360/answer/9566729 for details. Any value below 0.1 is reported as 0.0999. | ad_group, ad_group_criterion, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view |
| search_budget_lost_absolute_top_impression_share | NUMERIC | Search budget lost absolute top impression share | The number estimating how often your ad wasn't the very first ad among the top ads in the 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. | ad_group, ad_group_criterion, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view |
| search_budget_lost_impression_share | NUMERIC | 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. | ad_group, ad_group_criterion, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view |
Google Search Ads 360 (SA360) fields (search_budget_lost_top_impression_share to year_week_iso)
| ID | Type | Name | Description | Reports |
|---|---|---|---|---|
| search_budget_lost_top_impression_share | NUMERIC | Search budget lost top impression share | The number estimating how often your ad didn't show adjacent to the top 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. | ad_group, ad_group_criterion, bidding_strategy, campaign, customer, keyword_view |
| search_impression_share | NUMERIC | 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. | ad_group, ad_group_criterion, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view |
| search_query | TEXT | (Deprecated) Search query | The search terms that Google users entered. | customer, ad_group_ad, ad_group, ad_group_criterion, bidding_strategy, campaign, campaign_criterion, conversion, asset, conversion_action, paid_organic_search_term_view, shopping_performance_view, cart_data_sales_view, visit, keyword_view |
| search_rank_lost_absolute_top_impression_share | NUMERIC | Search rank lost absolute top impression share | The number estimating how often your ad wasn't the very first ad among the top ads in the 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. | ad_group, ad_group_criterion, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view |
| search_rank_lost_impression_share | NUMERIC | 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. | ad_group, ad_group_criterion, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view |
| search_rank_lost_top_impression_share | NUMERIC | Search rank lost top impression share | The number estimating how often your ad didn't show adjacent to the top 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. | ad_group, ad_group_criterion, bidding_strategy, campaign, customer, keyword_view |
| search_top_impression_share | NUMERIC | Search top impression share | The impressions you've received among the top ads compared to the estimated number of impressions you were eligible to receive among the top ads. 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. Top ads are generally above the top organic results, although they may show below the top organic results on certain queries. | ad_group, ad_group_criterion, bidding_strategy, campaign, customer, keyword_view |
| serp_type | TEXT | (Deprecated) Serp type | The type of search result that Google users clicked.Possible values are:Organic only: Users who entered this query only clicked unpaid search results.Paid only: Users who entered this query only clicked ads.Paid and Organic: Some users who entered this query clicked unpaid search results while others clicked ads (and some may have clicked both). | customer, ad_group_ad, ad_group, ad_group_criterion, bidding_strategy, campaign, campaign_criterion, conversion, asset, conversion_action, paid_organic_search_term_view, shopping_performance_view, cart_data_sales_view, visit, keyword_view |
| sitelink_clickserver_url | TEXT | Sitelink clickserver url | URL template for constructing a tracking URL. | asset |
| sitelink_description1 | TEXT | Sitelink description1 | URL display text for the sitelink. The length of this string should be between 1 and 25, inclusive. | asset |
| sitelink_description2 | TEXT | Sitelink description2 | Second line of the description for the sitelink. If set, the length should be between 1 and 35, inclusive, and description1 must also be set. | asset |
| sitelink_display_text | TEXT | Sitelink display text | URL display text for the sitelink. The length of this string should be between 1 and 25, inclusive. | asset |
| sitelink_landing_page_url | TEXT | Sitelink landing page url | A list of possible final URLs after all cross domain redirects. | asset |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| spend | NUMERIC | Spend | The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period. This metric is a monetary value and returned in the customer's currency by default. See the metrics_currency parameter at https://developers.google.com/search-ads/reporting/query/query-structure#parameters_clause | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view |
| status | TEXT | Status | The status of the customer. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, campaign_criterion, cart_data_sales_view, conversion, conversion_action, customer, keyword_view, shopping_performance_view, visit |
| today | DATE | Today | Today's date | |
| top_impression_percentage | PERCENT | Top impression percentage | The percent of your ad impressions that are shown adjacent to the top organic search results. | ad_group, ad_group_ad, ad_group_criterion, asset, campaign, customer, keyword_view |
| top_of_page_bid_current | NUMERIC | Top of page bid current (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, conversion, keyword_view, visit |
| visit_date | DATE | Visit date | Date to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, cart_data_sales_view, conversion, conversion_action, customer, keyword_view, shopping_performance_view, visit |
| visit_external_click_id | TEXT | Visit external click id | A unique string for each visit that is passed to the landing page as the click id URL parameter. | visit |
| visit_id | TEXT | Visit id | The ID of the visit. | visit |
| visit_network_type | TEXT | Visit network type | Ad network type. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, cart_data_sales_view, conversion, customer, keyword_view, shopping_performance_view, visit |
| visit_timestamp | Visit timestamp | The timestamp of the visit event. The timestamp is in the customer's time zone and in "yyyy-MM-dd HH:mm:ss" format. | visit | |
| visits | NUMERIC | Visits | Clicks that Search Ads 360 has successfully recorded and forwarded to an advertiser's landing page. | ad_group, ad_group_ad, ad_group_criterion, campaign, customer, keyword_view |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| week_start | DATE | Week start | Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, cart_data_sales_view, conversion, conversion_action, customer, keyword_view, paid_organic_search_term_view, shopping_performance_view, visit |
| yahoo_geo_targets | TEXT | Yahoo geo targets | Geo targets for Yahoo Search Marketing campaigns. See Download upload templates and geo/language codes. | campaign |
| yahoo_japan_bid_strategy | TEXT | Yahoo japan bid strategy | 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, bidding_strategy, campaign, keyword_view |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_start | DATE | Year start | Year, formatted as yyyy. | ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, cart_data_sales_view, conversion, conversion_action, customer, keyword_view, paid_organic_search_term_view, shopping_performance_view, visit |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |
