Windsor brings all your Google Search Ads 360 (SA360) data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL

Google Search Ads 360 (SA360) Field Reference

Sample

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


Fields

IDTypeNameDescriptionReports
absolute_top_impression_percentagePERCENTAbsolute top impression percentagePercent of your ad impressions that are shown as the very first ad above the organic search results.customer; campaign; customer; ad_group;
accountTEXTAccountEngine account name.ad_group_ad; campaign; customer; ad_group_criterion; visit; ad_group_criterion; campaign_criterion; campaing_criterion; ad_group_criterion; paid_organic_search_term_view; campaign_criterion; campaign_criterion; ad_group; conversion; asset; ad_group_criterion;
account_currency_codeTEXTAccount currency codeCurrency code of the engine account in ISO 4217 format.customer;
account_engine_idTEXTAccount engine idID of the account in the external engine account.ad_group_ad; campaign; customer; ad_group_criterion; visit; ad_group_criterion; campaign_criterion; campaing_criterion; ad_group_criterion; paid_organic_search_term_view; campaign_criterion; campaign_criterion; ad_group; conversion; asset; ad_group_criterion;
account_idTEXTAccount idDS engine account ID.ad_group_ad; campaign; shopping_performance_view; customer; ad_group_criterion; visit; ad_group_criterion; campaign_criterion; campaing_criterion; ad_group_criterion; paid_organic_search_term_view; cart_data_sales_view; campaign_criterion; campaign_criterion; ad_group; conversion; asset; ad_group_criterion;
account_time_zoneTEXTAccount time zoneTime zone of the engine account in IANA Time Zone Database format, such as America/New_York.customer;
account_typeTEXTAccount typeEngine account type: Google AdWords, Bing Ads, Yahoo Japan Listing Ads, Yahoo Search Marketing, Yahoo Gemini, Baidu, or Comparison Shopping.ad_group_ad; campaign; customer; ad_group_criterion; visit; ad_group_criterion; campaign_criterion; campaing_criterion; ad_group_criterion; paid_organic_search_term_view; campaign_criterion; campaign_criterion; ad_group; conversion; asset; ad_group_criterion;
TEXTAdAd name.ad_group_ad; visit; ad_group_criterion; conversion;
ad_description1TEXTAd description1Ad description line 1.ad_group_ad; ad_group_criterion;
ad_description2TEXTAd description2Ad description line 2; not available for some engines.ad_group_ad; ad_group_criterion;
ad_display_urlTEXTAd display urlAd display URL.ad_group_ad; ad_group_criterion;
ad_engine_idTEXTAd engine idID of the ad in the external engine account.ad_group_ad;
ad_groupTEXTAd groupAd group name.ad_group_ad; ad_group_criterion; visit; ad_group_criterion; paid_organic_search_term_view; ad_group_criterion; campaign_criterion; ad_group; conversion; ad_group_criterion;
ad_group_desktop_bid_adjustmentNUMERICAd 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.ad_group;
ad_group_end_dateDATEAd group end dateEnd date of the ad group.ad_group;
ad_group_engine_idTEXTAd group engine idID of the ad group in the external engine account.ad_group;
ad_group_idTEXTAd group idDS ad group ID.ad_group_ad; shopping_performance_view; ad_group_criterion; visit; paid_organic_search_term_view; ad_group_criterion; ad_group_criterion; cart_data_sales_view; campaign_criterion; ad_group; conversion; ad_group_criterion;
ad_group_labelsTEXTAd group labelsNames of labels directly assigned to this ad group; inherited labels are not included.ad_group;
ad_group_mobile_bid_adjustmentNUMERICAd 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.ad_group;
ad_group_search_max_cpcNUMERICAd group search max cpcDefault bid for search keywords in this ad group.ad_group;
ad_group_start_dateDATEAd group start dateStart date of the ad group.ad_group;
ad_group_statusTEXTAd group statusThe status of the ad group that contains this item.ad_group_ad; ad_group_criterion; visit; ad_group_criterion; campaign_criterion; ad_group_criterion; ad_group; conversion; ad_group_criterion;
ad_group_tablet_bid_adjustmentNUMERICAd 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.ad_group;
ad_group_target_idTEXTAd group target idThe ID DS generated for an ad group target.ad_group_criterion;
ad_group_typeTEXTAd group type(Applicable to Google Ads only) Indicates the type of ad group: Standard, Dynamic, or Showcase.ad_group;
ad_headlineTEXTAd headlineAd headline.ad_group_ad; ad_group_criterion;
ad_headline2TEXTAd headline2Ad headline 2; not available for some engines.ad_group_ad; ad_group_criterion;
ad_headline3TEXTAd headline3Ad headline 3; not available for some engines.ad_group_ad; ad_group_criterion;
ad_idTEXTAd idDS ad ID. A value of 0 indicates that the ad is unattributed.ad_group_ad; visit; ad_group_criterion; conversion;
ad_labelsTEXTAd labelsNames of labels directly assigned to this ad; inherited labels are not included.ad_group_ad;
ad_landing_pageTEXTAd landing pageAd landing page. See Landing page and clickserver URLs.ad_group_ad; ad_group_criterion;
ad_path_field1TEXTAd path field1Ad path field 1. Path fields 1 and 2 are combined with adDisplayUrl to form the URL that is shown on an ad.ad_group_ad;
ad_path_field2TEXTAd path field2Ad path field 2. Path fields 1 and 2 are combined with adDisplayUrl to form the URL that is shown on an ad.ad_group_ad;
ad_rotationTEXTAd rotationAd serving rotation used by the ad group: Optimize or Rotate indefinitely.ad_group;
ad_typeTEXTAd typeThe type of ad: Text, Product, Dynamic search, Mobile app install, Call-Only, Expanded text, or Expanded dynamic search.ad_group_ad; ad_group_criterion;
ad_words_bid_strategyTEXTAd words bid strategyThe bid strategy Google Ads uses for this campaign: Manual cpc, Manual cpm, Percent cpa, Budget optimizer, or Conversion optimizer. Campaigns using DS bid strategies are set to Manual cpc or Manual cpm.campaign;
ad_words_conversion_valueNUMERICAd words conversion valueAggregate value of Google Ads conversions.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; campaing_criterion; campaign_criterion; ad_group; asset; ad_group_criterion;
ad_words_conversionsNUMERICAd words conversionsThe data that the advertiser has set up to be reported in the Google Ads Conversions column. When an Google Ads conversion action is created, the advertiser can choose whether to count those conversions in the Conversions reporting column.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; campaing_criterion; campaign_criterion; ad_group; asset; ad_group_criterion;
ad_words_view_through_conversionsNUMERICAd words view through conversionsThe total number of Google Ads view-through conversions.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; campaing_criterion; campaign_criterion; ad_group; asset; ad_group_criterion;
advertiserTEXTAdvertiserAdvertiser name.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;
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 conversionId column or the floodlightOrderId column depending on the advertiser's Floodlight instructions.conversion;
advertiser_currency_codeTEXTAdvertiser currency codeCurrency code of the advertiser in ISO 4217 format.customer;
advertiser_idTEXTAdvertiser idDS advertiser 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;
age_target_age_rangeTEXTAge target age rangeThe age range of age target.ad_group_criterion; campaign_criterion; ad_group_criterion;
age_target_bid_modifierNUMERICAge target bid modifierThe bid adjustment associated with the age target.ad_group_criterion;
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 idSegments the report by app extension; each row and its aggregate metrics are split into multiple rows, one for each app extension. This column returns the app ID, if any exists.campaign; asset; ad_group;
app_storeTEXTApp storeSegments the report by app extension; each row and its aggregate metrics are split into multiple rows, one for each app extension. This column returns the app store type (Apple App Store, Google Play Store), if any exists.campaign; asset; ad_group;
avg_cpcNUMERICAvg cpcAverage cost per click.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; campaing_criterion; campaign_criterion; ad_group; asset; ad_group_criterion;
avg_cpmNUMERICAvg cpmAverage cost per thousand impressions.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; campaing_criterion; campaign_criterion; ad_group; asset; ad_group_criterion;
avg_posNUMERIC(Deprecated) Avg posAverage position.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; campaing_criterion; campaign_criterion; ad_group; asset; ad_group_criterion;
bid_strategyTEXTBid strategyThe bid strategy name.bidding_strategy;
bid_strategy_goalTEXTBid strategy goalThe goal of the bid strategy: Position, Conversions, Revenue, Clicks, or Advanced targeting.bidding_strategy;
bid_strategy_idTEXTBid strategy idDS bid strategy ID.bidding_strategy;
bid_strategy_max_bidNUMERICBid strategy max bidThe highest possible bid for keywords in this bid strategy.bidding_strategy;
bid_strategy_min_bidNUMERICBid strategy min bidThe lowest possible bid for keywords in this bid strategy.bidding_strategy;
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 a Bing Ads ad group.ad_group;
call_conversion_trackerTEXTCall conversion trackerSegments the report by call extensions; each row and its aggregate metrics are split into multiple rows, one for each call extension. This column returns the name of the conversion tracker associated with the feed item, if any exists.campaign; asset; ad_group;
call_conversion_tracker_idTEXTCall conversion tracker idSegments the report by call extensions; each row and its aggregate metrics are split into multiple rows, one for each call extension. This column returns the ID of the conversion tracker associated with the call extension, if any exists.campaign; asset; ad_group;
call_country_codeTEXTCall country codeSegments the report by call extension; each row and its aggregate metrics are split into multiple rows, one for each call extension. This column returns the call extension's country code of each row.campaign; asset; ad_group;
call_is_trackedBOOLEANCall is trackedSegments the report by call extension; each row and its aggregate metrics are split into multiple rows, one for each call extension. This column returns true if the call extension's calls will be tracked, false otherwise.campaign; asset; ad_group;
call_phone_numberTEXTCall phone numberSegments the report by call extension; each row and its aggregate metrics are split into multiple rows, one for each call extension. This column returns a call extension's phone number.campaign; asset; ad_group;
campaignTEXTCampaignCampaign name.ad_group_ad; campaign; ad_group_criterion; visit; ad_group_criterion; campaign_criterion; campaing_criterion; ad_group_criterion; paid_organic_search_term_view; campaign_criterion; ad_group; conversion; campaign_criterion; ad_group_criterion;
campaign_desktop_bid_adjustmentNUMERICCampaign 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.campaign;
campaign_end_dateDATECampaign end dateEnd date of the campaign.campaign;
campaign_engine_idTEXTCampaign engine idID of the campaign in the external engine account.campaign;
campaign_idTEXTCampaign idDS campaign ID.ad_group_ad; campaign; shopping_performance_view; ad_group_criterion; visit; ad_group_criterion; campaign_criterion; campaing_criterion; ad_group_criterion; paid_organic_search_term_view; cart_data_sales_view; campaign_criterion; ad_group; conversion; campaign_criterion; ad_group_criterion;
campaign_labelsTEXTCampaign labelsNames of labels directly assigned to this campaign; inherited labels are not included.campaign;
campaign_mobile_bid_adjustmentNUMERICCampaign 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.campaign;
campaign_start_dateDATECampaign start dateStart date of the campaign.campaign;
campaign_statusTEXTCampaign statusThe status of the campaign that contains this item.ad_group_ad; campaign; ad_group_criterion; visit; ad_group_criterion; campaign_criterion; campaing_criterion; ad_group_criterion; campaign_criterion; ad_group; conversion; campaign_criterion; ad_group_criterion;
campaign_tablet_bid_adjustmentNUMERICCampaign 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.campaign;
campaign_target_idTEXTCampaign target idThe ID DS generated for a campaign target.campaing_criterion;
campaign_typeTEXTCampaign typeIndicates the type of campaign: Manual, Inventory, Inventory - PLA, Shopping, Comparison shopping, Mobile app install, Universal app, or Smart shopping.campaign;
city_targetsTEXTCity targetsCity targets included in the ad group. Download upload templates and geo/language codes.campaign; ad_group;
clicksNUMERICClicksAggregate clicks.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; campaing_criterion; campaign_criterion; ad_group; asset; ad_group_criterion;
conversion_attribution_typeTEXTConversion attribution typeWhat the conversion is attributed to: Visit or Keyword+Ad.conversion;
conversion_dateDATEConversion dateThe date, in the Campaign manager network time zone, when the conversion occurred. This date is used for conversion metric aggregation. For example, when DS aggregates actions for May 1, it counts all action conversions whose conversionDate is May 1.conversion;
conversion_idTEXTConversion idID that Search Ads 360 generates for each conversion.conversion;
conversion_last_modified_timestampTIMESTAMPConversion last modified timestampThe UTC timestamp of the conversion's most recent modification.conversion;
conversion_quantityNUMERICConversion quantityThe quantity of items recorded by the conversion, as determined by the qty 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 revenueThe total dollar amount from the conversion.conversion;
conversion_timestampTIMESTAMPConversion timestampThe UTC timestamp when the conversion occurred.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 gclid URL parameter. Only enabled for advertisers with conversion API integration or Google Analytics integration.conversion;
conversion_visit_idTEXTConversion visit idThe DS visit ID that the conversion is attributed to.conversion;
conversion_visit_timestampTIMESTAMPConversion visit timestampThe UTC timestamp of the visit that the conversion is attributed to.conversion;
country_targetsTEXTCountry targetsCountry targets included in the ad group. Download upload templates and geo/language codes.campaign; ad_group;
cpa_targetNUMERICCpa targetThe target CPA (cost per action) of the bid strategy.bidding_strategy;
creation_timestampTIMESTAMPCreation timestampTimestamp of the account's creation, formatted in ISO 8601.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; conversion_action; asset; ad_group_criterion; campaign_criterion; campaing_criterion; ad_group_criterion; campaign_criterion; ad_group; campaign_criterion; ad_group_criterion;
cross_device_conversionsNUMERICCross device conversionsConversions from when a customer clicks on an ad on one device, then converts on a different device or browser.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; campaing_criterion; cart_data_sales_view; campaign_criterion; ad_group; asset; ad_group_criterion;
cross_device_conversions_valueNUMERICCross device conversions valueThe sum of the value of cross-device conversions.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; campaing_criterion; cart_data_sales_view; campaign_criterion; ad_group; asset; ad_group_criterion;
cross_sell_average_unit_priceNUMERICCross sell average unit priceAverage price reported for sales of a product when it sold as a result of advertising a different productcart_data_sales_view;
cross_sell_cost_of_goods_soldNUMERICCross sell cost of goods soldThe total cost of selling a product when it sold as a result of advertising a different product.cart_data_sales_view;
cross_sell_gross_from_units_soldNUMERICCross sell gross from units soldThe total revenue generated from sales of a product as a result of advertising a different product.cart_data_sales_view;
cross_sell_gross_profit_marginNUMERICCross sell gross profit marginThe gross profit margin for a specific product when sold as a result of advertising a different product.cart_data_sales_view;
cross_sell_revenue_from_units_soldNUMERICCross sell revenue from units soldThe total revenue generated from cross sales (revenue generated as a result of advertising a different product).cart_data_sales_view;
cross_sell_units_soldNUMERICCross sell units soldThe number of units sold as the result of cross-selling. (The number of units sold as a result of advertising a different product.)cart_data_sales_view;
ctrPERCENTCtrAverage click-through rate.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; campaing_criterion; campaign_criterion; ad_group; asset; ad_group_criterion;
daily_budgetNUMERICDaily budgetDaily budget of the campaign.campaign;
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateSegments the report by days; each row and its aggregate metrics are split into multiple rows, one for each day. This column returns the date of each row.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; paid_organic_search_term_view; campaing_criterion; cart_data_sales_view; campaign_criterion; ad_group; asset; ad_group_criterion;
day_of_monthTEXTDay of monthDay of the month
delivery_methodTEXTDelivery methodBudget delivery method of the campaign: Standard or Accelerated.campaign;
device_segmentTEXTDevice segmentSegments the report by device; each row and its aggregate metrics are split into multiple rows, up to one for each device segment. This column returns the device segment of each row.ad_group_ad; customer; shopping_performance_view; campaign; customer; ad_group_criterion; visit; campaing_criterion; cart_data_sales_view; campaign_criterion; ad_group; conversion; ad_group_criterion;
device_targetsTEXTDevice targetsDevice targets at the ad group level; a combination of Desktop, Mobile, Tablet, or Other.campaign; ad_group;
dfa_actionsNUMERICDfa actionsThe total number of Campaign manager actions.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; campaing_criterion; cart_data_sales_view; campaign_criterion; ad_group; asset; ad_group_criterion;
dfa_actions_cross_envNUMERICDfa actions cross envThe total number of cross-environment Campaign manager actions.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; campaing_criterion; cart_data_sales_view; campaign_criterion; ad_group; asset; ad_group_criterion;
dfa_advertiser_idTEXTDfa advertiser idID of the Campaign manager advertiser associated with this DS advertiser.customer;
dfa_network_idTEXTDfa network idID of the Campaign manager network associated with this DS advertiser.customer;
dfa_network_time_zoneTEXTDfa network time zoneTime zone of the Campaign manager network associated with this DS advertiser in IANA Time Zone Database format, such as America/New_York.customer;
dfa_revenueNUMERICDfa revenueAggregate revenue generated by Campaign manager transactions.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; campaing_criterion; cart_data_sales_view; campaign_criterion; ad_group; asset; ad_group_criterion;
dfa_revenue_cross_envNUMERICDfa revenue cross envAggregate revenue generated by cross-environment Campaign manager transactions.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; campaing_criterion; cart_data_sales_view; campaign_criterion; ad_group; asset; ad_group_criterion;
dfa_transactionsNUMERICDfa transactionsThe total number of Campaign manager transactions.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; campaing_criterion; cart_data_sales_view; campaign_criterion; ad_group; asset; ad_group_criterion;
dfa_transactions_cross_envNUMERICDfa transactions cross envThe total number of cross-environment Campaign manager transactions.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; campaing_criterion; cart_data_sales_view; campaign_criterion; ad_group; asset; ad_group_criterion;
display_budget_lost_impression_shareNUMERICDisplay budget lost impression shareGoogle Ads only. The percentage of time that your ads weren't shown on the Display Network due to insufficient budget. Returned as a number between 0 and 0.9 or, if the share is greater than 0.9, 0.95customer; campaign; customer;
display_impression_shareNUMERICDisplay impression shareGoogle Ads only. The impressions you have received on the Display Network divided by the estimated number of impressions you were eligible to receive. Returned as a number between 0.1 and 1 or, if the share is less than 0.1, 0.05customer; campaign; customer; ad_group;
display_rank_lost_impression_shareNUMERICDisplay rank lost impression shareGoogle Ads only. The percentage of time that your ads weren’t shown on the Display Network due to poor Ad Rank. Returned as a number between 0 and 0.9 or, if the share is greater than 0.9, 0.95customer; campaign; customer; ad_group;
dynamic_search_ads_target_conditionsTEXTDynamic search ads target conditionsThe criteria the dynamic ad target uses to select pages under the site domain.ad_group_criterion; campaign_criterion; ad_group_criterion;
dynamic_search_ads_target_coverageNUMERICDynamic search ads target coverageThe percentage of pages on the advertiser's site that the dynamic ad target matches.ad_group_criterion;
dynamic_search_ads_target_cpc_bidNUMERICDynamic search ads target cpc bidThe dynamic ad target's max CPC (maximum cost per click) setting.ad_group_criterion;
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 bid strategy assigned to this entity, or inherited by this entity.campaign; ad_group_criterion; ad_group; campaign_criterion;
effective_bid_strategy_idTEXTEffective bid strategy idDS ID of the bid strategy assigned to this entity, or inherited by this entity.campaign; ad_group_criterion; ad_group; campaign_criterion;
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 cpcThe max CPC (maximum cost-per-click) that is in effect for this keyword. This will be either the same value as the ad group's max CPC or, if the keyword is overriding the ad group's setting, the keyword's own max CPC.ad_group_criterion;
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 name of the remarketing list associated with the target.ad_group_criterion; campaing_criterion; campaign_criterion; ad_group_criterion;
engine_remarketing_list_bid_modifierNUMERICEngine remarketing list bid modifierThe bid adjustment associated with the target.ad_group_criterion; campaing_criterion;
engine_remarketing_list_target_allBOOLEANEngine remarketing list target allIndicates if the ad group only uses remarketing targets to adjust bids.Possible values:Yes: The ad group uses remarketing targets to adjust bids.No: The ad group displays ads only to members of remarketing targets, and can use the remarketing targets to adjust bids.ad_group;
engine_statusTEXTEngine statusAdditional status of the ad in the external engine account. Possible statuses (depending on the type of external account) include active, eligible, creative deleted, creative approved family safe, etc.ad_group_ad; campaign; asset; ad_group_criterion; campaign_criterion; ad_group; campaign_criterion; ad_group_criterion;
ers_targetNUMERICErs targetThe target ERS (effective revenue share) ratio of the bid strategy.bidding_strategy;
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 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 item row ID for each row.campaign; visit; ad_group; conversion; asset;
feed_typeTEXTFeed typeSegments 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 type of feed item for each row.campaign; visit; ad_group; conversion;
floodlight_activityTEXTFloodlight activitySegments the report by Floodlight activities; each row and its aggregate metrics are split into multiple rows, up to one for each Floodlight activity. This column returns the Floodlight activity name of each row. Note that some metrics do not have Floodlight segmented values, such as clicks and visits.ad_group_ad; customer; shopping_performance_view; campaign; customer; ad_group_criterion; conversion_action; campaing_criterion; cart_data_sales_view; campaign_criterion; ad_group; conversion; asset; ad_group_criterion;
floodlight_activity_idTEXTFloodlight activity idSegments the report by Floodlight activities; each row and its aggregate metrics are split into multiple rows, up to one for each Floodlight activity. This column returns the DS Floodlight activity ID of each row. Note that some metrics do not have Floodlight segmented values, such as clicks and visits.ad_group_ad; customer; shopping_performance_view; campaign; customer; ad_group_criterion; conversion_action; campaing_criterion; cart_data_sales_view; campaign_criterion; ad_group; conversion; asset; ad_group_criterion;
floodlight_activity_tagTEXTFloodlight activity tagSegments the report by Floodlight activities; each row and its aggregate metrics are split into multiple rows, up to one for each Floodlight activity. This column returns the Floodlight activity tag of each row. Note that some metrics do not have Floodlight segmented values, such as clicks and visits.ad_group_ad; customer; shopping_performance_view; campaign; customer; ad_group_criterion; conversion_action; campaing_criterion; cart_data_sales_view; campaign_criterion; ad_group; conversion; asset; ad_group_criterion;
floodlight_activity_target_idsTEXTFloodlight activity target idsComma-separated list of Floodlight activity IDs that this bid strategy targets.bidding_strategy;
floodlight_groupTEXTFloodlight 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.ad_group_ad; customer; shopping_performance_view; campaign; customer; ad_group_criterion; conversion_action; campaing_criterion; cart_data_sales_view; campaign_criterion; ad_group; conversion; asset; ad_group_criterion;
floodlight_group_conversion_typeTEXTFloodlight group conversion typeThe type of conversions generated by Floodlight activities in this group: Action or Transaction.conversion_action; conversion;
floodlight_group_tagTEXTFloodlight group tagSegments 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 tag of each row. Note that some metrics do not have Floodlight segmented values, such as clicks and visits.ad_group_ad; customer; shopping_performance_view; campaign; customer; ad_group_criterion; conversion_action; campaing_criterion; cart_data_sales_view; campaign_criterion; ad_group; conversion; asset; ad_group_criterion;
floodlight_optimization_enabledBOOLEANFloodlight optimization enabledWhether the bid strategy targets specific Floodlight activities.bidding_strategy;
floodlight_order_idTEXTFloodlight order idThe Floodlight order ID provided by the advertiser for the conversion.conversion;
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_referrerTEXTFloodlight referrerThe Floodlight referrer website of the conversion.conversion;
gender_target_bid_modifierNUMERICGender target bid modifierThe bid adjustment associated with the gender target.ad_group_criterion;
gender_target_gender_typeTEXTGender target gender typeThe gender type of gender target: Male, Female, Unknown.ad_group_criterion; campaign_criterion; ad_group_criterion;
impressionsNUMERICImpressionsThe total number of impressions.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; campaing_criterion; campaign_criterion; ad_group; asset; ad_group_criterion;
inventory_account_idTEXTInventory account idThe DS inventory account ID containing the product associated with the conversion. DS generates this ID when you link an inventory account in DS.conversion; visit;
keyword_clickserver_urlTEXTKeyword clickserver urlThe URL that DS uses to track activity. A user who clicks an ad would visit the clickserver URL first, and then be redirected to the final landing page. See Landing page and clickserver URLs.ad_group_criterion;
keyword_engine_idTEXTKeyword engine idID of the keyword in the external engine account.ad_group_criterion;
keyword_idTEXTKeyword idDS keyword ID. A value of 0 indicates that the keyword is unattributed.ad_group_criterion; visit; paid_organic_search_term_view; conversion;
keyword_labelsTEXTKeyword labelsNames of labels directly assigned to this keyword; inherited labels are not included.ad_group_criterion;
keyword_landing_pageTEXTKeyword landing pageThe final URL that a user would visit after clicking on your ad. See Landing page and clickserver URLs.ad_group_criterion;
keyword_match_typeTEXTKeyword match typeKeyword match type: Broad, Exact, Phrase, or Content.ad_group_criterion; visit; paid_organic_search_term_view; conversion;
keyword_max_bidNUMERICKeyword max bidIf this keyword is managed by a DS bid strategy, the bid strategy will never raise bids above this limit. See Apply a bid strategy to keywords.ad_group_criterion;
keyword_max_cpcNUMERICKeyword max cpcOverrides the ad group's max CPC and sets a maximum amount you are willing to pay if someone clicks an ad for this specific keyword. If this field is empty, the keyword will use the ad group's max CPC.ad_group_criterion;
keyword_min_bidNUMERICKeyword min bidIf this keyword is managed by a DS bid strategy, the bid strategy will never lower bids below this limit. See Apply a bid strategy to keywords.ad_group_criterion;
keyword_textTEXTKeyword textKeyword text.ad_group_criterion; visit; paid_organic_search_term_view; conversion;
keyword_url_paramsTEXTKeyword url paramsExtra URL parameters added to the landing page. See Add URL parameters.ad_group_criterion;
language_targetsTEXTLanguage targetsLanguage targets at the campaign level. Download upload templates and geo/language codes.campaign;
last_modified_timestampTIMESTAMPLast modified timestampTimestamp of the account's most recent modification, formatted in ISO 8601.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; conversion_action; asset; ad_group_criterion; campaign_criterion; campaing_criterion; ad_group_criterion; campaign_criterion; ad_group; campaign_criterion; ad_group_criterion;
lead_average_unit_priceNUMERICLead average unit priceThe average price reported for sales of a product when it sold as a result of advertising the product.cart_data_sales_view;
lead_cost_of_goods_soldNUMERICLead cost of goods soldThe total cost of selling a product when sold as a result of advertising the product.cart_data_sales_view;
lead_gross_profit_from_units_soldNUMERICLead gross profit from units soldThe total revenue generated from sales of a product as a result of advertising the product.cart_data_sales_view;
lead_revenue_from_units_soldNUMERICLead revenue from units soldThe total revenue generated from a product as a result of advertising the product.cart_data_sales_view;
lead_units_soldNUMERICLead units soldThe number of units sold as a result of advertising the product.cart_data_sales_view;
location_target_bid_modifierNUMERICLocation target bid modifierThe bid adjustment associated with the location target.ad_group_criterion; campaing_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 startSegments the report by months; each row and its aggregate metrics are split into multiple rows, one for each month. This column returns the first day of the month of each row.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; paid_organic_search_term_view; campaing_criterion; cart_data_sales_view; campaign_criterion; ad_group; asset; ad_group_criterion;
monthly_budgetNUMERICMonthly budgetMonthly budget of the campaign.campaign;
monthly_spend_targetNUMERICMonthly spend targetThe target spend for each month of this bid strategy. If needed, DS will increase bids to ensure this amount is spent.bidding_strategy;
negative_ad_group_keyword_idTEXTNegative ad group keyword idDS negative ad group keyword ID.ad_group_criterion;
negative_ad_group_keyword_match_typeTEXTNegative ad group keyword match typeMatch type of the negative keyword: Broad, Exact, Phrase, or Content. Currently only for Google Ads accounts.ad_group_criterion;
negative_ad_group_keyword_textTEXTNegative ad group keyword textThe keyword text.ad_group_criterion;
negative_ad_group_target_idTEXTNegative ad group target idThe ID DS generated for a negative ad-group target.ad_group_criterion;
negative_campaign_keyword_idTEXTNegative campaign keyword idDS negative campaign keyword ID.campaign_criterion;
negative_campaign_keyword_match_typeTEXTNegative campaign keyword match typeMatch type of the negative keyword: Broad, Exact, Phrase, or Content. Currently only for Google Ads accounts.campaign_criterion;
negative_campaign_keyword_textTEXTNegative campaign keyword textThe keyword text.campaign_criterion;
negative_campaign_target_idTEXTNegative campaign target idThe ID DS generated for a negative campaign target.campaign_criterion;
network_targetTEXTNetwork targetThe type of network(s) the campaign advertises on.campaign;
organic_clicksNUMERICOrganic clicksThe number of clicks on unpaid search results for your site after someone entered the searchQuery.paid_organic_search_term_view;
organic_queriesNUMERICOrganic queriesThe total number of times users have entered the searchQuery and saw at least one organic search result from your site.paid_organic_search_term_view;
NUMERICPaid 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.paid_organic_search_term_view;
NUMERICPaid and organic ctrThe rate at which people who see either one of your ads or an unpaid search result for your site end up clicking on either and landing on your site.paid_organic_search_term_view;
NUMERICPaid 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.paid_organic_search_term_view;
product_brandTEXTProduct brandThe brand attribute of a product item.shopping_performance_view; cart_data_sales_view;
product_category_level1TEXTProduct category level1The google product category level 1 attribute of a product item.shopping_performance_view; cart_data_sales_view;
product_category_level2TEXTProduct category level2The google product category level 2 attribute of a product item.shopping_performance_view; cart_data_sales_view;
product_category_level3TEXTProduct category level3The google product category level 3 attribute of a product item.shopping_performance_view; cart_data_sales_view;
product_category_level4TEXTProduct category level4The google product category level 4 attribute of a product item.shopping_performance_view; cart_data_sales_view;
product_category_level5TEXTProduct category level5The google product category level 5 attribute of a product item.shopping_performance_view; cart_data_sales_view;
product_channelTEXTProduct channelThe sales channel of the product associated with the conversion: Online or Local.shopping_performance_view; visit; conversion; cart_data_sales_view;
product_channel_exclusivityTEXTProduct channel exclusivityThe channel exclusivity attribute of a product item.shopping_performance_view; cart_data_sales_view;
product_conditionTEXTProduct conditionThe condition attribute of a product item.shopping_performance_view; cart_data_sales_view;
product_countryCOUNTRYProduct countryThe country (ISO 3166 format) registered for the inventory feed that contains the product associated with this conversion.shopping_performance_view; visit; conversion; cart_data_sales_view;
product_custom_label0TEXTProduct custom label0The custom label 0 attribute of a product item.shopping_performance_view; cart_data_sales_view;
product_custom_label1TEXTProduct custom label1The custom label 1 attribute of a product item.shopping_performance_view; cart_data_sales_view;
product_custom_label2TEXTProduct custom label2The custom label 2 attribute of a product item.shopping_performance_view; cart_data_sales_view;
product_custom_label3TEXTProduct custom label3The custom label 3 attribute of a product item.shopping_performance_view; cart_data_sales_view;
product_custom_label4TEXTProduct custom label4The custom label 4 attribute of a product item.shopping_performance_view; cart_data_sales_view;
product_group_idTEXTProduct group idThe product group ID associated with this conversion. Only conversions from shopping campaigns have product group IDs. Product group IDs should not be used for joining.conversion; visit;
product_idTEXTProduct idThe ID of the product associated with this conversion.shopping_performance_view; visit; conversion; cart_data_sales_view;
product_languageTEXTProduct languageThe language (ISO 639-1) of the product associated this conversion.shopping_performance_view; visit; conversion; cart_data_sales_view;
product_store_idTEXTProduct store idThe store in the Local Inventory Ad associated with the conversion. This should match the store IDs used in your local products feed.shopping_performance_view; visit; conversion; cart_data_sales_view;
product_target_idTEXTProduct target idDS product target ID.visit; conversion; campaign_criterion;
product_titleTEXTProduct titleThe title attribute of a product item.shopping_performance_view; cart_data_sales_view;
product_type_level1TEXTProduct type level1The product type leve 1 attribute of a product item.shopping_performance_view; cart_data_sales_view;
product_type_level2TEXTProduct type level2The product type leve 2 attribute of a product item.shopping_performance_view; cart_data_sales_view;
product_type_level3TEXTProduct type level3The product type leve 3 attribute of a product item.shopping_performance_view; cart_data_sales_view;
product_type_level4TEXTProduct type level4The product type leve 4 attribute of a product item.shopping_performance_view; cart_data_sales_view;
product_type_level5TEXTProduct type level5The product type leve 5 attribute of a product item.shopping_performance_view; cart_data_sales_view;
province_targetsTEXTProvince targetsProvince targets included in the ad group. Download upload templates and geo/language codes.campaign; ad_group;
quality_score_avgNUMERICQuality score avgGoogle Ads and Bing Ads only. The impression-weighted average of the engine's Quality score (QS) across all days and keywords in the report scope.customer; campaign; customer; ad_group; ad_group_criterion;
quality_score_currentNUMERICQuality score currentGoogle Ads and Bing Ads only. The most recent value of the engine's Quality score (QS) for a keyword. Note that this column always reports the latest QS for a keyword regardless of the report's time range.ad_group_criterion;
quarter_startDATEQuarter startSegments the report by quarters; each row and its aggregate metrics are split into multiple rows, one for each quarter. This column returns the first day of the quarter of each row.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; paid_organic_search_term_view; campaing_criterion; cart_data_sales_view; campaign_criterion; ad_group; asset; ad_group_criterion;
roas_targetNUMERICRoas targetThe target ROAS (return on ad spending) ratio of the bid strategy.bidding_strategy;
search_absolute_top_impression_shareNUMERICSearch absolute top impression shareImpressions you've received in the absolute top location (the very first ad above the organic search results) divided by the estimated number of impressions you were eligible to receive in the top location.customer; campaign; customer; ad_group;
search_budget_lost_absolute_top_impression_shareNUMERICSearch budget lost absolute top impression shareEstimates how often your ad wasn't the very first ad above the organic search results due to a low budget.customer; campaign; customer;
search_budget_lost_impression_shareNUMERICSearch budget lost impression shareGoogle Ads and Bing Ads only. The percentage of time that your ads weren't shown on the Search Network due to insufficient budget. Returned as a number between 0 and 0.9 or, if the share is greater than 0.9, 0.95.customer; campaign; customer;
search_budget_lost_top_impression_shareNUMERICSearch budget lost top impression shareHelps you to understand how often your ad didn't show anywhere above the organic search results due to a low budget.customer; campaign; customer;
search_impression_shareNUMERICSearch impression shareGoogle Ads and Bing Ads only. The impressions you have received on the Search Network divided by the estimated number of impressions you were eligible to receive. Returned as a number between 0.1 and 1 or, if the share is less than 0.1, 0.05.customer; campaign; customer; ad_group;
search_queryTEXTSearch queryThe search terms that Google users entered.paid_organic_search_term_view;
search_rank_lost_absolute_top_impression_shareNUMERICSearch rank lost absolute top impression shareEstimates how often your ad wasn't the very first ad above the organic search results due to poor Ad Rank.customer; campaign; customer; ad_group;
search_rank_lost_impression_shareNUMERICSearch rank lost impression shareGoogle Ads and Bing Ads only. The percentage of time that your ads weren’t shown on the Search Network due to poor Ad Rank. Returned as a number between 0 and 0.9 or, if the share is greater than 0.9, 0.95.customer; campaign; customer; ad_group;
search_rank_lost_top_impression_shareNUMERICSearch rank lost top impression shareEstimates how often your ad didn't show anywhere above the organic search results due to poor Ad Rank.customer; campaign; customer; ad_group;
search_top_impression_shareNUMERICSearch top impression shareImpressions you've received in the top location (anywhere above the organic search results) compared to the estimated number of impressions you were eligible to receive in the top location.customer; campaign; customer; ad_group;
serp_typeTEXTSerp 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).paid_organic_search_term_view;
TEXTSitelink clickserver urlSegments the report by sitelinks; each row and its aggregate metrics are split into multiple rows, one for each sitelink. This column returns the sitelink's clickserver URL of each row.campaign; asset; ad_group;
TEXTSitelink description1Segments the report by sitelinks; each row and its aggregate metrics are split into multiple rows, one for each sitelink. This column returns the sitelink description 1 of each row.campaign; asset; ad_group;
TEXTSitelink description2Segments the report by sitelinks; each row and its aggregate metrics are split into multiple rows, one for each sitelink. This column returns the sitelink description 2 of each row.campaign; asset; ad_group;
TEXTSitelink display textSegments the report by sitelinks; each row and its aggregate metrics are split into multiple rows, one for each sitelink. This column returns the sitelink display text of each row.campaign; asset; ad_group;
TEXTSitelink landing page urlSegments the report by sitelinks; each row and its aggregate metrics are split into multiple rows, one for each sitelink. This column returns the sitelink's landing page URL of each row.campaign; asset; ad_group;
sourceTEXTSourceThe name of the Windsor connector returning the row
spendNUMERICSpendAggregate cost paid to engine account(s).ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; campaing_criterion; campaign_criterion; ad_group; asset; ad_group_criterion;
statusTEXTStatusThe status of the account: Active, Paused, or Removed.customer; campaign; conversion_action; ad_group_criterion; campaign_criterion; ad_group_criterion; campaign_criterion; ad_group; conversion; ad_group_ad; shopping_performance_view; ad_group_criterion; bidding_strategy; customer; visit; campaing_criterion; campaign_criterion; asset; ad_group_criterion;
todayDATETodayToday's date
top_impression_percentagePERCENTTop impression percentagePercent of your ad impressions that are shown anywhere above the organic search results.customer; campaign; customer; ad_group;
top_of_page_bid_currentNUMERICTop of page bid currentGoogle Ads only. Approximates the current CPC bid needed for your ad to appear regularly in the top positions above the search results. Note that this column always reports the CPC currently needed regardless of the report's time range.ad_group_criterion;
visit_dateDATEVisit dateThe date, in the engine account time zone, when the visit occurred. This date is used for visits aggregation. For example, when DS aggregates visits for May 1, it counts all visits whose visitDate is May 1.visit;
visit_external_click_idTEXTVisit external click idA unique string for each visit that is passed to the landing page as the gclid URL parameter. Only enabled for advertisers with conversion API integration or Google Analytics integration.visit;
visit_idTEXTVisit idDS visit ID.visit;
visit_network_typeTEXTVisit network typeThe ad network that generated this visit: Content, Search, or Other.visit;
visit_timestampTIMESTAMPVisit timestampThe UTC timestamp when the visit occurred.visit;
visitsNUMERICVisitsThe total number of DS visits.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; campaing_criterion; campaign_criterion; ad_group; asset; ad_group_criterion;
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 startSegments the report by weeks (Sunday to Saturday); each row and its aggregate metrics are split into multiple rows, one for each week. This column returns the first day (Sunday) of each row.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; paid_organic_search_term_view; campaing_criterion; cart_data_sales_view; campaign_criterion; ad_group; asset; ad_group_criterion;
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 bid strategy Yahoo! JAPAN uses for this campaign: Manual cpc or Budget optimizer. Campaigns using DS bid strategies are set to Manual cpc.campaign;
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
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 startSegments the report by years; each row and its aggregate metrics are split into multiple rows, one for each year. This column returns the first day of the year of each row.ad_group_ad; customer; shopping_performance_view; campaign; bidding_strategy; customer; ad_group_criterion; paid_organic_search_term_view; campaing_criterion; cart_data_sales_view; campaign_criterion; ad_group; asset; ad_group_criterion;
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