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)

IDTypeNameDescriptionReports
absolute_top_impression_percentagePERCENTAbsolute top impression percentageSearch 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
accountTEXTAccountOptional, 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_codeTEXTAccount currency codeThe 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_idTEXTAccount engine idID 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_idTEXTAccount idThe 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_zoneTEXTAccount time zoneThe 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_typeTEXTAccount typeEngine 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
TEXTAdThe 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_description1TEXTAd description1The first line of the ad's description.ad_group_ad
ad_description2TEXTAd description2The second line of the ad's description.ad_group_ad
ad_display_urlTEXTAd display urlThe URL that appears in the ad description for some ad formats.ad_group_ad
ad_engine_idTEXTAd engine idID 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_groupTEXTAd groupThe 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_adjustmentNUMERIC(Deprecated) Ad group desktop bid adjustmentThe 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_dateDATEAd group end dateDate 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-14ad_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, visit
ad_group_engine_idTEXTAd group engine idID 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_idTEXTAd group idThe ID of the ad group.ad_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, paid_organic_search_term_view, visit
ad_group_labelsTEXTAd group labelsThe 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_adjustmentNUMERIC(Deprecated) Ad group mobile bid adjustmentThe 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_cpcNUMERICAd 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_dateDATEAd group start dateDate 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-14ad_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, visit
ad_group_statusTEXTAd group statusThe status of the ad group.ad_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, visit
ad_group_tablet_bid_adjustmentNUMERIC(Deprecated) Ad group tablet bid adjustmentThe 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_idTEXTAd group target idThe ID of the criterion.ad_group_criterion, conversion, keyword_view, visit
ad_group_typeTEXTAd group typeThe type of the ad group.ad_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, visit
ad_headlineTEXTAd headlineThe headline of the ad.ad_group_ad
ad_headline2TEXTAd headline2The second headline of the ad.ad_group_ad
ad_headline3TEXTAd headline3The third headline of the ad.ad_group_ad
ad_idTEXTAd idThe ID of the ad.ad_group_ad
ad_keyword_ad_group_criterionTEXTKeyword ad group criterion (segment)The AdGroupCriterion resource name.ad_group, ad_group_ad, bidding_strategy, campaign, conversion, customer, keyword_view, visit
ad_keyword_idTEXTKeyword 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_typeTEXTKeyword match type (segment)The match type of the keyword.ad_group, ad_group_ad, bidding_strategy, campaign, conversion, customer, keyword_view, visit
ad_keyword_textTEXTKeyword 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_labelsTEXTAd labelsThe resource names of labels attached to this ad group ad.ad_group_ad
ad_landing_pageTEXTAd landing pageThe list of possible final URLs after all cross-domain redirects for the ad.ad_group_ad
ad_path_field1TEXTAd path field1Text appended to the auto-generated visible URL with a delimiter.ad_group_ad
ad_path_field2TEXTAd path field2Text appended to path1 with a delimiter.ad_group_ad
ad_responsive_search_ad_descriptions_combined_textTEXTAd responsive search ad description texts combinedThe responsive search ad descriptions, joined into a single string separated by ' | '.ad_group_ad
ad_responsive_search_ad_headlines_combined_textTEXTAd responsive search ad headline texts combinedThe responsive search ad headlines, joined into a single string separated by ' | '.ad_group_ad
ad_rotationTEXTAd rotationThe 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)

IDTypeNameDescriptionReports
ad_typeTEXTAd typeThe type of ad.ad_group_ad
ad_words_bid_strategyTEXTAd words bid strategyThe 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_valueNUMERICAd words conversion valueThe 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_conversionsNUMERICAd words conversionsThe 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_conversionsNUMERICAd words view through conversionsThe 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
advertiserTEXTAdvertiserOptional, 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_idTEXTAdvertiser conversion idFor 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_codeTEXTAdvertiser currency codeThe 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_idTEXTAdvertiser idThe 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_rangeTEXTAge target age rangeType of the age range.ad_group_criterion, conversion, keyword_view, visit
age_target_bid_modifierNUMERICAge target bid modifierThe 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_idTEXTAgency idDS 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_idTEXTApp idRequired. 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_storeTEXTApp storeRequired. The application store that distributes this specific app.asset
avg_cpcNUMERICAvg cpcThe 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_clausead_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view
avg_cpmNUMERICAvg cpmAverage 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_clausead_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view
avg_posNUMERIC(Deprecated) Avg posAverage 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_strategyTEXTBid strategyThe 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_goalTEXT(Deprecated) Bid strategy goalThe 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_idTEXTBid strategy idThe ID of the bidding strategy.ad_group, bidding_strategy, campaign, keyword_view
bid_strategy_max_bidNUMERICBid 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_bidNUMERICBid 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_typeTEXTBing ads budget typeHow 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_languageTEXTBing ads languageThe 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#adlanguagead_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, visit
call_conversion_trackerTEXTCall conversion trackerThe 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_idTEXTCall conversion tracker idThe 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_codeTEXTCall country codeTwo-letter country code of the phone number. Examples: 'US', 'us'.asset
call_is_trackedBOOLEANCall is trackedWhether the call should be enabled on call tracking. Applies to Microsoft Ads.asset
call_phone_numberTEXTCall phone numberThe advertiser's raw phone number. Examples: '1234567890', '(123)456-7890'asset
campaignTEXTCampaignThe 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_adjustmentNUMERICCampaign desktop bid adjustmentThe 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_dateDATECampaign end dateThe 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_idTEXTCampaign engine idID 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_idTEXTCampaign idThe 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_labelsTEXTCampaign labelsNames of labels directly assigned to this campaign; inherited labels are not included.campaign
campaign_mobile_bid_adjustmentNUMERICCampaign mobile bid adjustmentThe 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_dateDATECampaign start dateThe 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_statusTEXTCampaign statusThe 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_adjustmentNUMERICCampaign tablet bid adjustmentThe 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_idTEXTCampaign target idThe 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)

IDTypeNameDescriptionReports
campaign_typeTEXTCampaign typeThe 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_targetsTEXTCity targetsCity targets included in the ad group. Download upload templates and geo/language codes.campaign, ad_group
clicksNUMERICClicksThe number of clicks.ad_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view
conversion_attribution_typeTEXTConversion attribution typeWhat the conversion is attributed to: Visit or Keyword+Ad.conversion
conversion_categoryTEXTConversion categorySegments 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_dateDATEConversion dateThe timestamp of the conversion event.conversion
conversion_idTEXTConversion idThe ID of the conversionconversion
conversion_last_modified_timestampTIMESTAMPConversion last modified timestampThe timestamp of the last time the conversion was modified.conversion
conversion_quantityNUMERICConversion quantityThe 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_revenueNUMERICConversion revenue (micros)The adjusted revenue in micros for the conversion event. This will always be in the currency of the serving account.conversion
conversion_timestampTIMESTAMPConversion timestampThe timestamp of the conversion event.conversion
conversion_visit_external_click_idTEXTConversion visit external click idA 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_idTEXTConversion visit idThe Search Ads 360 visit ID that the conversion is attributed to.conversion
conversion_visit_timestampTIMESTAMPConversion visit timestampThe timestamp of the visit that the conversion is attributed to.conversion
conversions_valueNUMERICConversion valueThe 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_targetsTEXTCountry targetsCountry targets included in the ad group. Download upload templates and geo/language codes.campaign, ad_group
cpa_targetNUMERICCpa 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_timestampTIMESTAMPCreation timestampThe 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_conversionsNUMERICCross device conversionsConversions 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_valueNUMERICCross device conversions valueThe 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_priceNUMERICCross 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_soldNUMERICCross 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_clausead_group, ad_group_ad, ad_group_criterion, campaign, cart_data_sales_view, customer, keyword_view, shopping_performance_view
cross_sell_gross_from_units_soldNUMERICCross 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_clausead_group, ad_group_ad, ad_group_criterion, campaign, cart_data_sales_view, customer, keyword_view, shopping_performance_view
cross_sell_gross_profit_marginNUMERICCross 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_clausead_group, ad_group_ad, ad_group_criterion, campaign, cart_data_sales_view, customer, keyword_view, shopping_performance_view
cross_sell_revenue_from_units_soldNUMERICCross 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_clausead_group, ad_group_ad, ad_group_criterion, campaign, cart_data_sales_view, customer, keyword_view, shopping_performance_view
cross_sell_units_soldNUMERICCross sell units soldCross-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
ctrPERCENTCtrThe 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_budgetNUMERICDaily budgetDaily budget of the campaign.campaign
data_fetched_atTIMESTAMPData fetched atUTC 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.
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateDate 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_monthTEXTDay of monthDay of the month
delivery_methodTEXTDelivery methodBudget delivery method of the campaign: Standard or Accelerated.campaign
device_segmentTEXTDevice segmentDevice 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_targetsTEXTDevice targetsDevice targets at the ad group level; a combination of Desktop, Mobile, Tablet, or Other.campaign, ad_group
dfa_actionsNUMERICCampaign Manager actionsThe 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_envNUMERICCampaign 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_idTEXTCampaign Manager advertiser IDID 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_idTEXTCampaign Manager network IDID 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_zoneTEXTCampaign Manager network time zoneTime 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)

IDTypeNameDescriptionReports
dfa_revenueNUMERICCampaign Manager revenueAggregate 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_envNUMERICCampaign 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_transactionsNUMERICCampaign Manager transactionsThe 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_envNUMERICCampaign 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_shareNUMERICDisplay budget lost impression shareThe 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_shareNUMERICDisplay impression shareThe 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_shareNUMERICDisplay rank lost impression shareThe 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_conditionsTEXTDynamic search ads target conditionsConditions, 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_coverageNUMERICDynamic search ads target coverageWebsite 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_bidNUMERICDynamic 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_urlTEXTDynamic search ads target landing page urlThe dynamic ad target's URL template.ad_group_criterion
effective_bid_strategyTEXTEffective bid strategyThe 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_idTEXTEffective bid strategy idThe ID of the bidding strategy.ad_group, bidding_strategy, campaign, keyword_view
effective_city_targetsTEXTEffective city targetsCity targets included in the ad group, or inherited from the campaign. Download upload templates and geo/language codes.campaign, ad_group
effective_country_targetsTEXTEffective country targetsCountry targets included in the ad group, or inherited from the campaign. Download upload templates and geo/language codes.campaign, ad_group
effective_device_targetsTEXTEffective device targetsDevice 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_cpcNUMERICEffective keyword max cpc (micros)The effective CPC (cost-per-click) bid.ad_group_criterion, conversion, keyword_view, visit
effective_metro_targetsTEXTEffective metro targetsMetro targets included in the ad group, or inherited from the campaign. Download upload templates and geo/language codes.campaign, ad_group
effective_province_targetsTEXTEffective province targetsProvince targets included in the ad group, or inherited from the campaign. Download upload templates and geo/language codes.campaign, ad_group
engine_remarketing_listTEXTEngine remarketing listThe User List resource name.ad_group_criterion, conversion, keyword_view, visit
engine_remarketing_list_bid_modifierNUMERICEngine remarketing list bid modifierThe 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_allBOOLEANEngine remarketing list target allThe 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_statusTEXTEngine statusThe Engine Status for an asset.asset
ers_targetNUMERICErs targetThe chosen revenue (based on conversion data) per unit of spend.ad_group, bidding_strategy, campaign, keyword_view
excluded_city_targetsTEXTExcluded city targetsCity targets excluded from the campaign. Download upload templates and geo/language codes.campaign
excluded_country_targetsTEXTExcluded country targetsCountry targets excluded from the campaign. Download upload templates and geo/language codes.campaign
excluded_metro_targetsTEXTExcluded metro targetsMetro targets excluded from the campaign. Download upload templates and geo/language codes.campaign
excluded_province_targetsTEXTExcluded province targetsProvince targets excluded from the campaign. Download upload templates and geo/language codes.campaign
feed_idTEXTFeed idSegments 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_idTEXTFeed item idThe ID of the asset.asset
feed_typeTEXTFeed typeType of the asset.asset
floodlight_activityTEXTConversion action nameConversion 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_idTEXTFloodlight activity idID of the Floodlight activity in DoubleClick Campaign Manager (DCM).conversion_action
floodlight_activity_tagTEXTConversion 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_idsTEXTConversion 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_groupTEXT(Deprecated) Floodlight groupSegments 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_typeTEXTConversion typeThe type of this conversion action.conversion_action
floodlight_group_tagTEXTFloodlight group tagString used to identify a Floodlight activity group when reporting conversions.conversion_action
floodlight_optimization_enabledBOOLEAN(Deprecated) Floodlight optimization enabledWhether 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_idTEXTFloodlight order idThe Floodlight order ID provided by the advertiser for the conversion.conversion

Google Search Ads 360 (SA360) fields (floodlight_original_revenue to network_target)

IDTypeNameDescriptionReports
floodlight_original_revenueNUMERICFloodlight original revenueThe original, unchanged revenue associated with the Floodlight event (in the currency of the current report), before Floodlight currency instruction modifications.conversion
floodlight_referrerTEXT(Deprecated) Floodlight referrerThe 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_modifierNUMERICGender target bid modifierThe 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_typeTEXTGender target gender typeType of the gender.ad_group_criterion, conversion, keyword_view, visit
impressionsNUMERICImpressionsCount 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_idTEXTInventory account idThe 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_urlTEXTKeyword clickserver urlThe URL template for constructing a tracking URL.ad_group_criterion, conversion, keyword_view, visit
keyword_engine_idTEXTKeyword engine idID 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_idTEXTKeyword idSearch Ads 360 criterion ID. A value of 0 indicates that the criterion is unattributed.conversion, paid_organic_search_term_view
keyword_labelsTEXTKeyword labelsNames of labels directly assigned to this keyword; inherited labels are not included.ad_group_criterion
keyword_landing_pageTEXTKeyword landing pageThe list of possible final URLs after all cross-domain redirects for the ad.ad_group_criterion, conversion, keyword_view, visit
keyword_match_typeTEXTKeyword match typeThe match type of the keyword.ad_group_criterion, conversion, keyword_view, paid_organic_search_term_view, visit
keyword_max_bidNUMERICKeyword 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_cpcNUMERICKeyword max cpc (micros)The CPC (cost-per-click) bid.ad_group_criterion, conversion, keyword_view, visit
keyword_min_bidNUMERICKeyword 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_textTEXTKeyword textThe 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_paramsTEXTKeyword url paramsURL template for appending params to final URL.ad_group_criterion, conversion, keyword_view, visit
language_targetsTEXTLanguage targetsThe language constant resource name.campaign_criterion
last_modified_timestampTIMESTAMPLast modified timestampThe 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_priceNUMERICLead 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_soldNUMERICLead 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_clausead_group, ad_group_ad, ad_group_criterion, campaign, cart_data_sales_view, customer, keyword_view, shopping_performance_view
lead_gross_profit_from_units_soldNUMERICLead 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_clausead_group, ad_group_ad, ad_group_criterion, campaign, cart_data_sales_view, customer, keyword_view, shopping_performance_view
lead_revenue_from_units_soldNUMERICLead 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_clausead_group, ad_group_ad, ad_group_criterion, campaign, cart_data_sales_view, customer, keyword_view, shopping_performance_view
lead_units_soldNUMERICLead units soldLead 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_modifierNUMERICLocation target bid modifierThe 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_nameTEXTLocation target nameThe name of the location target.ad_group_criterion, campaing_criterion, campaign_criterion, ad_group_criterion
metro_targetsTEXTMetro targetsMetro targets included in the ad group. Download upload templates and geo/language codes.campaign, ad_group
monthTEXTMonthNumber of the month
month_startDATEMonth startMonth 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_budgetNUMERICMonthly budget (micros)Monthly budget of the campaign.campaign
monthly_spend_targetNUMERICMonthly 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_idTEXTNegative ad group keyword idThe ID of the criterion.ad_group_criterion, conversion, keyword_view, visit
negative_ad_group_keyword_match_typeTEXTNegative ad group keyword match typeThe match type of the keyword.ad_group_criterion, conversion, keyword_view, visit
negative_ad_group_keyword_textTEXTNegative ad group keyword textThe text of the keyword (at most 80 characters and 10 words).ad_group_criterion, conversion, keyword_view, visit
negative_ad_group_target_idTEXTNegative ad group target idThe ID of the criterion.ad_group_criterion, conversion, keyword_view, visit
negative_campaign_keyword_idTEXTNegative campaign keyword idThe ID of the criterion. This field is ignored during mutate.campaign_criterion
negative_campaign_keyword_match_typeTEXTNegative campaign keyword match typeThe match type of the keyword.campaign_criterion
negative_campaign_keyword_textTEXTNegative campaign keyword textThe text of the keyword (at most 80 characters and 10 words).campaign_criterion
negative_campaign_target_idTEXTNegative campaign target idThe ID of the criterion. This field is ignored during mutate.campaign_criterion
network_targetTEXT(Deprecated) Network targetThe 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)

IDTypeNameDescriptionReports
nowTIMESTAMPNowCurrent timestamp
organic_clicksNUMERIC(Deprecated) Organic clicksThe 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_queriesNUMERIC(Deprecated) Organic queriesThe 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
NUMERIC(Deprecated) Paid and organic clicksThe 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
NUMERICPaid and organic ctrThe 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
NUMERIC(Deprecated) Paid and organic queriesThe 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_brandTEXTProduct brandBrand of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view
product_category_level1TEXTProduct category level1Bidding category (level 1) of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view
product_category_level2TEXTProduct category level2Bidding category (level 2) of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view
product_category_level3TEXTProduct category level3Bidding category (level 3) of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view
product_category_level4TEXTProduct category level4Bidding category (level 4) of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view
product_category_level5TEXTProduct category level5Bidding category (level 5) of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view
product_channelTEXTProduct channelThe sales channel of the product that was clicked on: Online or Local.conversion
product_channel_exclusivityTEXTProduct channel exclusivityChannel exclusivity of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view
product_conditionTEXTProduct conditionCondition of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view
product_countryCOUNTRYProduct countryThe country (ISO-3166 format) registered for the inventory feed that contains the product clicked on.visit
product_custom_label0TEXTProduct custom label0Custom attribute 0 of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view
product_custom_label1TEXTProduct custom label1Custom attribute 1 of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view
product_custom_label2TEXTProduct custom label2Custom attribute 2 of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view
product_custom_label3TEXTProduct custom label3Custom attribute 3 of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view
product_custom_label4TEXTProduct custom label4Custom attribute 4 of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view
product_group_idTEXTProduct group idThe ID of the criterion.ad_group_criterion, conversion, keyword_view, visit
product_idTEXTProduct idThe ID of the product clicked on.visit
product_languageTEXTProduct languageThe language (ISO-639-1) that has been set for the Merchant Center feed containing data about the product.visit
product_store_idTEXTProduct store idThe 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_idTEXT(Deprecated) Product target idDS 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_titleTEXTProduct titleTitle of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view
product_type_level1TEXTProduct type level1Type (level 1) of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view
product_type_level2TEXTProduct type level2Type (level 2) of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view
product_type_level3TEXTProduct type level3Type (level 3) of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view
product_type_level4TEXTProduct type level4Type (level 4) of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view
product_type_level5TEXTProduct type level5Type (level 5) of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view
province_targetsTEXTProvince targetsProvince targets included in the ad group. Download upload templates and geo/language codes.campaign, ad_group
quality_score_avgNUMERICQuality score avgThe historical quality score.ad_group, ad_group_criterion, campaign, customer, keyword_view
quality_score_currentNUMERICQuality score currentThe 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_startDATEQuarter startQuarter 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_targetNUMERICRoas targetThe chosen revenue (based on conversion data) per unit of spend.ad_group, bidding_strategy, campaign, keyword_view
search_absolute_top_impression_shareNUMERICSearch absolute top impression shareThe 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_shareNUMERICSearch budget lost absolute top impression shareThe 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_shareNUMERICSearch budget lost impression shareThe 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)

IDTypeNameDescriptionReports
search_budget_lost_top_impression_shareNUMERICSearch budget lost top impression shareThe 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_shareNUMERICSearch impression shareThe 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_queryTEXT(Deprecated) Search queryThe 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_shareNUMERICSearch rank lost absolute top impression shareThe 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_shareNUMERICSearch rank lost impression shareThe 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_shareNUMERICSearch rank lost top impression shareThe 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_shareNUMERICSearch top impression shareThe 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_typeTEXT(Deprecated) Serp typeThe 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
TEXTSitelink clickserver urlURL template for constructing a tracking URL.asset
TEXTSitelink description1URL display text for the sitelink. The length of this string should be between 1 and 25, inclusive.asset
TEXTSitelink description2Second 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
TEXTSitelink display textURL display text for the sitelink. The length of this string should be between 1 and 25, inclusive.asset
TEXTSitelink landing page urlA list of possible final URLs after all cross domain redirects.asset
sourceTEXTSourceThe name of the Windsor connector returning the row
spendNUMERICSpendThe 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_clausead_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view
statusTEXTStatusThe 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
todayDATETodayToday's date
top_impression_percentagePERCENTTop impression percentageThe 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_currentNUMERICTop 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_dateDATEVisit dateDate 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_idTEXTVisit external click idA unique string for each visit that is passed to the landing page as the click id URL parameter.visit
visit_idTEXTVisit idThe ID of the visit.visit
visit_network_typeTEXTVisit network typeAd 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_timestampTIMESTAMPVisit timestampThe timestamp of the visit event. The timestamp is in the customer's time zone and in "yyyy-MM-dd HH:mm:ss" format.visit
visitsNUMERICVisitsClicks 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
weekTEXTWeekWeek (Sun-Sat).
week_dayTEXTDay of week and day numberWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDay of week and day number, ISOWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTWeek ISOWeek, ISO format (Mon-Sun).
week_startDATEWeek startWeek 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_targetsTEXTYahoo geo targetsGeo targets for Yahoo Search Marketing campaigns. See Download upload templates and geo/language codes.campaign
yahoo_japan_bid_strategyTEXTYahoo japan bid strategyThe 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
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_month_nameTEXTYear month nameYear and month with the month name written out, e.g. "Jan 2025".
year_of_weekTEXTYear of weekThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTYear of week, ISOThe year that contains first day of the ISO week (Mon-Sun).
year_startDATEYear startYear, 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_weekTEXTYear weekYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTYear week ISOYear and week for ISO weeks (Mon-Sun), e.g. 2024|20