Google Search Ads 360 (SA360)
Google · DisponívelConsultar via API
GET https://askaner.askan.com.br/api/v1/data/google_search_ads?fields=date,account_id&date_preset=last_30d Authorization: Bearer ik_...
Campos (81 métricas, 199 dimensões)
| ID | Tipo | Natureza | Descrição |
|---|---|---|---|
absolute_top_impression_percentage | PERCENT | Métrica | 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 | Dimensão | 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 | Dimensão | 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 | Dimensão | 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 | Dimensão | 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 | Dimensão | 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 | Dimensão | 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 | Dimensão | 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 | Dimensão | The first line of the ad's description.ad_group_ad |
ad_description2 | TEXT | Dimensão | The second line of the ad's description.ad_group_ad |
ad_display_url | TEXT | Dimensão | The URL that appears in the ad description for some ad formats.ad_group_ad |
ad_engine_id | TEXT | Dimensão | 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 | Dimensão | 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 | Métrica | 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 | Dimensão | 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-14ad_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, visit |
ad_group_engine_id | TEXT | Dimensão | 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 | Dimensão | 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 | Dimensão | 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 | Métrica | 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 | Métrica | 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 | Dimensão | 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-14ad_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, visit |
ad_group_status | TEXT | Dimensão | The status of the ad group.ad_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, visit |
ad_group_tablet_bid_adjustment | NUMERIC | Métrica | 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 | Dimensão | The ID of the criterion.ad_group_criterion, conversion, keyword_view, visit |
ad_group_type | TEXT | Dimensão | The type of the ad group.ad_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, visit |
ad_headline | TEXT | Dimensão | The headline of the ad.ad_group_ad |
ad_headline2 | TEXT | Dimensão | The second headline of the ad.ad_group_ad |
ad_headline3 | TEXT | Dimensão | The third headline of the ad.ad_group_ad |
ad_id | TEXT | Dimensão | The ID of the ad.ad_group_ad |
ad_keyword_ad_group_criterion | TEXT | Dimensão | The AdGroupCriterion resource name.ad_group, ad_group_ad, bidding_strategy, campaign, conversion, customer, keyword_view, visit |
ad_keyword_id | TEXT | Dimensão | 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 | Dimensão | The match type of the keyword.ad_group, ad_group_ad, bidding_strategy, campaign, conversion, customer, keyword_view, visit |
ad_keyword_text | TEXT | Dimensão | 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 | Dimensão | The resource names of labels attached to this ad group ad.ad_group_ad |
ad_landing_page | TEXT | Dimensão | The list of possible final URLs after all cross-domain redirects for the ad.ad_group_ad |
ad_path_field1 | TEXT | Dimensão | Text appended to the auto-generated visible URL with a delimiter.ad_group_ad |
ad_path_field2 | TEXT | Dimensão | Text appended to path1 with a delimiter.ad_group_ad |
ad_responsive_search_ad_descriptions_combined_text | TEXT | Dimensão | The responsive search ad descriptions, joined into a single string separated by ' | '.ad_group_ad |
ad_responsive_search_ad_headlines_combined_text | TEXT | Dimensão | The responsive search ad headlines, joined into a single string separated by ' | '.ad_group_ad |
ad_rotation | TEXT | Dimensão | The ad rotation mode of the ad group.ad_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, visit |
ad_type | TEXT | Dimensão | The type of ad.ad_group_ad |
ad_words_bid_strategy | TEXT | Dimensão | 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 | Métrica | 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 | Métrica | 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 | Métrica | 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 | Dimensão | 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 | Dimensão | 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 | Dimensão | 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 | Dimensão | 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 | Dimensão | Type of the age range.ad_group_criterion, conversion, keyword_view, visit |
age_target_bid_modifier | NUMERIC | Métrica | 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 | Dimensão | 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 | Dimensão | 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 | Dimensão | Required. The application store that distributes this specific app.asset |
avg_cpc | NUMERIC | Métrica | 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_clausead_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view |
avg_cpm | NUMERIC | Métrica | 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_clausead_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view |
avg_pos | NUMERIC | Métrica | 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 | Dimensão | 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 | Dimensão | 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 | Dimensão | The ID of the bidding strategy.ad_group, bidding_strategy, campaign, keyword_view |
bid_strategy_max_bid | NUMERIC | Métrica | 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 | Métrica | 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 | Dimensão | 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 | Dimensão | 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#adlanguagead_group, ad_group_ad, ad_group_criterion, conversion, keyword_view, visit |
call_conversion_tracker | TEXT | Dimensão | 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 | Dimensão | 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 | Dimensão | Two-letter country code of the phone number. Examples: 'US', 'us'.asset |
call_is_tracked | BOOLEAN | Dimensão | Whether the call should be enabled on call tracking. Applies to Microsoft Ads.asset |
call_phone_number | TEXT | Dimensão | The advertiser's raw phone number. Examples: '1234567890', '(123)456-7890'asset |
campaign | TEXT | Dimensão | 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 | Métrica | 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 | Dimensão | 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 | Dimensão | 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 | Dimensão | 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 | Dimensão | Names of labels directly assigned to this campaign; inherited labels are not included.campaign |
campaign_mobile_bid_adjustment | NUMERIC | Métrica | 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 | Dimensão | 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 | Dimensão | 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 | Métrica | 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 | Dimensão | The ID of the criterion. This field is ignored during mutate.campaign_criterion |
campaign_type | TEXT | Dimensão | 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 | Dimensão | City targets included in the ad group. Download upload templates and geo/language codes.campaign, ad_group |
clicks | NUMERIC | Métrica | 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 | Dimensão | What the conversion is attributed to: Visit or Keyword+Ad.conversion |
conversion_category | TEXT | Dimensão | 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 | Dimensão | The timestamp of the conversion event.conversion |
conversion_id | TEXT | Dimensão | The ID of the conversionconversion |
conversion_last_modified_timestamp | TIMESTAMP | Dimensão | The timestamp of the last time the conversion was modified.conversion |
conversion_quantity | NUMERIC | Métrica | 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 | Métrica | The adjusted revenue in micros for the conversion event. This will always be in the currency of the serving account.conversion |
conversion_timestamp | TIMESTAMP | Dimensão | The timestamp of the conversion event.conversion |
conversion_visit_external_click_id | TEXT | Dimensão | 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 | Dimensão | The Search Ads 360 visit ID that the conversion is attributed to.conversion |
conversion_visit_timestamp | TIMESTAMP | Dimensão | The timestamp of the visit that the conversion is attributed to.conversion |
conversions_value | NUMERIC | Métrica | 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 | Dimensão | Country targets included in the ad group. Download upload templates and geo/language codes.campaign, ad_group |
cpa_target | NUMERIC | Métrica | 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 | TIMESTAMP | Dimensão | 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 | Métrica | 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 | Métrica | 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 | Métrica | 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 | Métrica | 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_sold | NUMERIC | Métrica | 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_margin | NUMERIC | Métrica | 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_sold | NUMERIC | Métrica | 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_sold | NUMERIC | Métrica | 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 | Métrica | 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 | Métrica | Daily budget of the campaign.campaign |
data_fetched_at | TIMESTAMP | Dimensão | 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 | Dimensão | The name of the Windsor connector returning the row |
date | DATE | Dimensão | 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 | Dimensão | Day of the month |
delivery_method | TEXT | Dimensão | Budget delivery method of the campaign: Standard or Accelerated.campaign |
device_segment | TEXT | Dimensão | 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 | Dimensão | Device targets at the ad group level; a combination of Desktop, Mobile, Tablet, or Other.campaign, ad_group |
dfa_actions | NUMERIC | Métrica | 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 | Métrica | 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 | Dimensão | 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 | Dimensão | 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 | Dimensão | 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 |
dfa_revenue | NUMERIC | Métrica | 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 | Métrica | 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 | Métrica | 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 | Métrica | 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 | Métrica | 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 | Métrica | 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 | Métrica | 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 | Dimensão | 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 | Métrica | 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 | Métrica | The CPC (cost-per-click) bid.ad_group_criterion, conversion, keyword_view, visit |
dynamic_search_ads_target_landing_page_url | TEXT | Dimensão | The dynamic ad target's URL template.ad_group_criterion |
effective_bid_strategy | TEXT | Dimensão | 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 | Dimensão | The ID of the bidding strategy.ad_group, bidding_strategy, campaign, keyword_view |
effective_city_targets | TEXT | Dimensão | 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 | Dimensão | 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 | Dimensão | 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 | Métrica | The effective CPC (cost-per-click) bid.ad_group_criterion, conversion, keyword_view, visit |
effective_metro_targets | TEXT | Dimensão | 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 | Dimensão | 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 | Dimensão | The User List resource name.ad_group_criterion, conversion, keyword_view, visit |
engine_remarketing_list_bid_modifier | NUMERIC | Métrica | 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 | Dimensão | 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 | Dimensão | The Engine Status for an asset.asset |
ers_target | NUMERIC | Métrica | The chosen revenue (based on conversion data) per unit of spend.ad_group, bidding_strategy, campaign, keyword_view |
excluded_city_targets | TEXT | Dimensão | City targets excluded from the campaign. Download upload templates and geo/language codes.campaign |
excluded_country_targets | TEXT | Dimensão | Country targets excluded from the campaign. Download upload templates and geo/language codes.campaign |
excluded_metro_targets | TEXT | Dimensão | Metro targets excluded from the campaign. Download upload templates and geo/language codes.campaign |
excluded_province_targets | TEXT | Dimensão | Province targets excluded from the campaign. Download upload templates and geo/language codes.campaign |
feed_id | TEXT | Dimensão | 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 | Dimensão | The ID of the asset.asset |
feed_type | TEXT | Dimensão | Type of the asset.asset |
floodlight_activity | TEXT | Dimensão | 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 | Dimensão | ID of the Floodlight activity in DoubleClick Campaign Manager (DCM).conversion_action |
floodlight_activity_tag | TEXT | Dimensão | 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 | Dimensão | 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 | Dimensão | 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 | Dimensão | The type of this conversion action.conversion_action |
floodlight_group_tag | TEXT | Dimensão | String used to identify a Floodlight activity group when reporting conversions.conversion_action |
floodlight_optimization_enabled | BOOLEAN | Dimensão | 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 | Dimensão | The Floodlight order ID provided by the advertiser for the conversion.conversion |
floodlight_original_revenue | NUMERIC | Métrica | 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 | Dimensão | 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 | Métrica | 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 | Dimensão | Type of the gender.ad_group_criterion, conversion, keyword_view, visit |
impressions | NUMERIC | Métrica | 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 | Dimensão | 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 | Dimensão | The URL template for constructing a tracking URL.ad_group_criterion, conversion, keyword_view, visit |
keyword_engine_id | TEXT | Dimensão | 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 | Dimensão | Search Ads 360 criterion ID. A value of 0 indicates that the criterion is unattributed.conversion, paid_organic_search_term_view |
keyword_labels | TEXT | Dimensão | Names of labels directly assigned to this keyword; inherited labels are not included.ad_group_criterion |
keyword_landing_page | TEXT | Dimensão | 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 | Dimensão | The match type of the keyword.ad_group_criterion, conversion, keyword_view, paid_organic_search_term_view, visit |
keyword_max_bid | NUMERIC | Métrica | 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 | Métrica | The CPC (cost-per-click) bid.ad_group_criterion, conversion, keyword_view, visit |
keyword_min_bid | NUMERIC | Métrica | 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 | Dimensão | 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 | Dimensão | URL template for appending params to final URL.ad_group_criterion, conversion, keyword_view, visit |
language_targets | TEXT | Dimensão | The language constant resource name.campaign_criterion |
last_modified_timestamp | TIMESTAMP | Dimensão | 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 | Métrica | 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 | Métrica | 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_sold | NUMERIC | Métrica | 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_sold | NUMERIC | Métrica | 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_sold | NUMERIC | Métrica | 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 | Métrica | 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 | Dimensão | The name of the location target.ad_group_criterion, campaing_criterion, campaign_criterion, ad_group_criterion |
metro_targets | TEXT | Dimensão | Metro targets included in the ad group. Download upload templates and geo/language codes.campaign, ad_group |
month | TEXT | Dimensão | Number of the month |
month_start | DATE | Dimensão | 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 | Métrica | Monthly budget of the campaign.campaign |
monthly_spend_target | NUMERIC | Métrica | 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 | Dimensão | The ID of the criterion.ad_group_criterion, conversion, keyword_view, visit |
negative_ad_group_keyword_match_type | TEXT | Dimensão | The match type of the keyword.ad_group_criterion, conversion, keyword_view, visit |
negative_ad_group_keyword_text | TEXT | Dimensão | 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 | Dimensão | The ID of the criterion.ad_group_criterion, conversion, keyword_view, visit |
negative_campaign_keyword_id | TEXT | Dimensão | The ID of the criterion. This field is ignored during mutate.campaign_criterion |
negative_campaign_keyword_match_type | TEXT | Dimensão | The match type of the keyword.campaign_criterion |
negative_campaign_keyword_text | TEXT | Dimensão | The text of the keyword (at most 80 characters and 10 words).campaign_criterion |
negative_campaign_target_id | TEXT | Dimensão | The ID of the criterion. This field is ignored during mutate.campaign_criterion |
network_target | TEXT | Dimensão | 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 |
now | TIMESTAMP | Dimensão | Current timestamp |
organic_clicks | NUMERIC | Métrica | 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 | Métrica | 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 | Métrica | 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 | Métrica | 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 | Métrica | 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 | Dimensão | Brand of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
product_category_level1 | TEXT | Dimensão | Bidding category (level 1) of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
product_category_level2 | TEXT | Dimensão | Bidding category (level 2) of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
product_category_level3 | TEXT | Dimensão | Bidding category (level 3) of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
product_category_level4 | TEXT | Dimensão | Bidding category (level 4) of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
product_category_level5 | TEXT | Dimensão | Bidding category (level 5) of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
product_channel | TEXT | Dimensão | The sales channel of the product that was clicked on: Online or Local.conversion |
product_channel_exclusivity | TEXT | Dimensão | Channel exclusivity of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
product_condition | TEXT | Dimensão | Condition of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
product_country | COUNTRY | Dimensão | The country (ISO-3166 format) registered for the inventory feed that contains the product clicked on.visit |
product_custom_label0 | TEXT | Dimensão | Custom attribute 0 of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
product_custom_label1 | TEXT | Dimensão | Custom attribute 1 of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
product_custom_label2 | TEXT | Dimensão | Custom attribute 2 of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
product_custom_label3 | TEXT | Dimensão | Custom attribute 3 of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
product_custom_label4 | TEXT | Dimensão | Custom attribute 4 of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
product_group_id | TEXT | Dimensão | The ID of the criterion.ad_group_criterion, conversion, keyword_view, visit |
product_id | TEXT | Dimensão | The ID of the product clicked on.visit |
product_language | TEXT | Dimensão | The language (ISO-639-1) that has been set for the Merchant Center feed containing data about the product.visit |
product_store_id | TEXT | Dimensão | 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 | Dimensão | 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 | Dimensão | Title of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
product_type_level1 | TEXT | Dimensão | Type (level 1) of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
product_type_level2 | TEXT | Dimensão | Type (level 2) of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
product_type_level3 | TEXT | Dimensão | Type (level 3) of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
product_type_level4 | TEXT | Dimensão | Type (level 4) of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
product_type_level5 | TEXT | Dimensão | Type (level 5) of the product.ad_group, campaign, cart_data_sales_view, customer, shopping_performance_view |
province_targets | TEXT | Dimensão | Province targets included in the ad group. Download upload templates and geo/language codes.campaign, ad_group |
quality_score_avg | NUMERIC | Métrica | The historical quality score.ad_group, ad_group_criterion, campaign, customer, keyword_view |
quality_score_current | NUMERIC | Métrica | 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 | Dimensão | 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 | Métrica | The chosen revenue (based on conversion data) per unit of spend.ad_group, bidding_strategy, campaign, keyword_view |
search_absolute_top_impression_share | NUMERIC | Métrica | 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 | Métrica | 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 | Métrica | 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 |
search_budget_lost_top_impression_share | NUMERIC | Métrica | 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 | Métrica | 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 | Dimensão | 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 | Métrica | 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 | Métrica | 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 | Métrica | 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 | Métrica | 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 | Dimensão | 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 | Dimensão | URL template for constructing a tracking URL.asset |
sitelink_description1 | TEXT | Dimensão | URL display text for the sitelink. The length of this string should be between 1 and 25, inclusive.asset |
sitelink_description2 | TEXT | Dimensão | 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 | Dimensão | URL display text for the sitelink. The length of this string should be between 1 and 25, inclusive.asset |
sitelink_landing_page_url | TEXT | Dimensão | A list of possible final URLs after all cross domain redirects.asset |
source | TEXT | Dimensão | The name of the Windsor connector returning the row |
spend | NUMERIC | Métrica | 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_clausead_group, ad_group_ad, ad_group_criterion, asset, bidding_strategy, campaign, customer, keyword_view, shopping_performance_view |
status | TEXT | Dimensão | 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 | Dimensão | Today's date |
top_impression_percentage | PERCENT | Métrica | 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 | Métrica | 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 | Dimensão | 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 | Dimensão | A unique string for each visit that is passed to the landing page as the click id URL parameter.visit |
visit_id | TEXT | Dimensão | The ID of the visit.visit |
visit_network_type | TEXT | Dimensão | 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 | TIMESTAMP | Dimensão | 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 | Métrica | 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 | Dimensão | Week (Sun-Sat). |
week_day | TEXT | Dimensão | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. |
week_day_iso | TEXT | Dimensão | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 |
week_iso | TEXT | Dimensão | Week, ISO format (Mon-Sun). |
week_start | DATE | Dimensão | 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 | Dimensão | Geo targets for Yahoo Search Marketing campaigns. See Download upload templates and geo/language codes.campaign |
yahoo_japan_bid_strategy | TEXT | Dimensão | 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 | Dimensão | Year |
year_month | TEXT | Dimensão | Year and month, e.g. 2024|3 |
year_month_name | TEXT | Dimensão | Year and month with the month name written out, e.g. "Jan 2025". |
year_of_week | TEXT | Dimensão | The year that contains first day of the week (Sun-Sat). |
year_of_week_iso | TEXT | Dimensão | The year that contains first day of the ISO week (Mon-Sun). |
year_start | DATE | Dimensão | 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 | Dimensão | Year and week for US weeks (Sun-Sat), e.g. 2024|15 |
year_week_iso | TEXT | Dimensão | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |