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
| ID | Type | Name | Description | Reports |
|---|---|---|---|---|
| absolute_top_impression_percentage | PERCENT | Absolute top impression percentage | Percent of your ad impressions that are shown as the very first ad above the organic search results. | customer; campaign; customer; ad_group; |
| account | TEXT | Account | Engine 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_code | TEXT | Account currency code | Currency code of the engine account in ISO 4217 format. | customer; |
| account_engine_id | TEXT | Account engine id | ID 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_id | TEXT | Account id | DS 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_zone | TEXT | Account time zone | Time zone of the engine account in IANA Time Zone Database format, such as America/New_York. | customer; |
| account_type | TEXT | Account type | Engine 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; |
| ad | TEXT | Ad | Ad name. | ad_group_ad; visit; ad_group_criterion; conversion; |
| ad_description1 | TEXT | Ad description1 | Ad description line 1. | ad_group_ad; ad_group_criterion; |
| ad_description2 | TEXT | Ad description2 | Ad description line 2; not available for some engines. | ad_group_ad; ad_group_criterion; |
| ad_display_url | TEXT | Ad display url | Ad display URL. | ad_group_ad; ad_group_criterion; |
| ad_engine_id | TEXT | Ad engine id | ID of the ad in the external engine account. | ad_group_ad; |
| ad_group | TEXT | Ad group | Ad 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_adjustment | NUMERIC | Ad group desktop bid adjustment | The percentage by which bids are adjusted for desktop. For example, 0.2 means 20% increase, so desktop bids are 1.2 times the default bid. The range of valid values differs based on the external engine. | ad_group; |
| ad_group_end_date | DATE | Ad group end date | End date of the ad group. | ad_group; |
| ad_group_engine_id | TEXT | Ad group engine id | ID of the ad group in the external engine account. | ad_group; |
| ad_group_id | TEXT | Ad group id | DS 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_labels | TEXT | Ad group labels | Names of labels directly assigned to this ad group; inherited labels are not included. | ad_group; |
| ad_group_mobile_bid_adjustment | NUMERIC | Ad group mobile bid adjustment | The percentage by which bids are adjusted for mobile. For example, 0.2 means 20% increase, so mobile bids are 1.2 times the default bid. The range of valid values differs based on the external engine. | ad_group; |
| ad_group_search_max_cpc | NUMERIC | Ad group search max cpc | Default bid for search keywords in this ad group. | ad_group; |
| ad_group_start_date | DATE | Ad group start date | Start date of the ad group. | ad_group; |
| ad_group_status | TEXT | Ad group status | The 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_adjustment | NUMERIC | Ad group tablet bid adjustment | The percentage by which bids are adjusted for tablet. For example, 0.2 means 20% increase, so tablet bids are 1.2 times the default bid. The range of valid values differs based on the external engine. | ad_group; |
| ad_group_target_id | TEXT | Ad group target id | The ID DS generated for an ad group target. | ad_group_criterion; |
| ad_group_type | TEXT | Ad group type | (Applicable to Google Ads only) Indicates the type of ad group: Standard, Dynamic, or Showcase. | ad_group; |
| ad_headline | TEXT | Ad headline | Ad headline. | ad_group_ad; ad_group_criterion; |
| ad_headline2 | TEXT | Ad headline2 | Ad headline 2; not available for some engines. | ad_group_ad; ad_group_criterion; |
| ad_headline3 | TEXT | Ad headline3 | Ad headline 3; not available for some engines. | ad_group_ad; ad_group_criterion; |
| ad_id | TEXT | Ad id | DS ad ID. A value of 0 indicates that the ad is unattributed. | ad_group_ad; visit; ad_group_criterion; conversion; |
| ad_labels | TEXT | Ad labels | Names of labels directly assigned to this ad; inherited labels are not included. | ad_group_ad; |
| ad_landing_page | TEXT | Ad landing page | Ad landing page. See Landing page and clickserver URLs. | ad_group_ad; ad_group_criterion; |
| ad_path_field1 | TEXT | Ad path field1 | Ad 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_field2 | TEXT | Ad path field2 | Ad 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_rotation | TEXT | Ad rotation | Ad serving rotation used by the ad group: Optimize or Rotate indefinitely. | ad_group; |
| ad_type | TEXT | Ad type | The 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_strategy | TEXT | Ad words bid strategy | The 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_value | NUMERIC | Ad words conversion value | Aggregate 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_conversions | NUMERIC | Ad words conversions | The 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_conversions | NUMERIC | Ad words view through conversions | The 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; |
| advertiser | TEXT | Advertiser | Advertiser 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_id | TEXT | Advertiser conversion id | For offline conversions, this is an ID provided by advertisers. If an advertiser doesn't specify such an ID, Search Ads 360 generates one. For online conversions, this is equal to the conversionId column or the floodlightOrderId column depending on the advertiser's Floodlight instructions. | conversion; |
| advertiser_currency_code | TEXT | Advertiser currency code | Currency code of the advertiser in ISO 4217 format. | customer; |
| advertiser_id | TEXT | Advertiser id | DS 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_range | TEXT | Age target age range | The age range of age target. | ad_group_criterion; campaign_criterion; ad_group_criterion; |
| age_target_bid_modifier | NUMERIC | Age target bid modifier | The bid adjustment associated with the age target. | ad_group_criterion; |
| agency_id | TEXT | Agency id | DS agency ID. | customer; campaign; conversion_action; ad_group_criterion; campaign_criterion; ad_group_criterion; campaign_criterion; cart_data_sales_view; ad_group; conversion; ad_group_ad; shopping_performance_view; paid_organic_search_term_view; ad_group_criterion; bidding_strategy; customer; visit; campaing_criterion; campaign_criterion; asset; ad_group_criterion; |
| app_id | TEXT | App id | Segments 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_store | TEXT | App store | Segments 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_cpc | NUMERIC | Avg cpc | Average 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_cpm | NUMERIC | Avg cpm | Average 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_pos | NUMERIC | (Deprecated) Avg pos | Average 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_strategy | TEXT | Bid strategy | The bid strategy name. | bidding_strategy; |
| bid_strategy_goal | TEXT | Bid strategy goal | The goal of the bid strategy: Position, Conversions, Revenue, Clicks, or Advanced targeting. | bidding_strategy; |
| bid_strategy_id | TEXT | Bid strategy id | DS bid strategy ID. | bidding_strategy; |
| bid_strategy_max_bid | NUMERIC | Bid strategy max bid | The highest possible bid for keywords in this bid strategy. | bidding_strategy; |
| bid_strategy_min_bid | NUMERIC | Bid strategy min bid | The lowest possible bid for keywords in this bid strategy. | bidding_strategy; |
| bing_ads_budget_type | TEXT | Bing ads budget type | How budget is controlled for Bing Ads campaigns: Daily budget, Monthly even spend, Monthly accelerated spend, Daily accelerated spend, or Daily even spend. | campaign; |
| bing_ads_language | TEXT | Bing ads language | The language of the ads and keywords in a Bing Ads ad group. | ad_group; |
| call_conversion_tracker | TEXT | Call conversion tracker | Segments 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_id | TEXT | Call conversion tracker id | Segments 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_code | TEXT | Call country code | Segments 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_tracked | BOOLEAN | Call is tracked | Segments 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_number | TEXT | Call phone number | Segments 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; |
| campaign | TEXT | Campaign | Campaign 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_adjustment | NUMERIC | Campaign desktop bid adjustment | The percentage by which bids are adjusted for desktop. For example, 0.2 means 20% increase, so desktop bids are 1.2 times the default bid. The range of valid values differs based on the external engine. | campaign; |
| campaign_end_date | DATE | Campaign end date | End date of the campaign. | campaign; |
| campaign_engine_id | TEXT | Campaign engine id | ID of the campaign in the external engine account. | campaign; |
| campaign_id | TEXT | Campaign id | DS 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_labels | TEXT | Campaign labels | Names of labels directly assigned to this campaign; inherited labels are not included. | campaign; |
| campaign_mobile_bid_adjustment | NUMERIC | Campaign mobile bid adjustment | The 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_date | DATE | Campaign start date | Start date of the campaign. | campaign; |
| campaign_status | TEXT | Campaign status | The 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_adjustment | NUMERIC | Campaign tablet bid adjustment | The percentage by which bids are adjusted for tablet. For example, 0.2 means 20% increase, so tablet bids are 1.2 times the default bid. The range of valid values differs based on the external engine. | campaign; |
| campaign_target_id | TEXT | Campaign target id | The ID DS generated for a campaign target. | campaing_criterion; |
| campaign_type | TEXT | Campaign type | Indicates the type of campaign: Manual, Inventory, Inventory - PLA, Shopping, Comparison shopping, Mobile app install, Universal app, or Smart shopping. | campaign; |
| city_targets | TEXT | City targets | City targets included in the ad group. Download upload templates and geo/language codes. | campaign; ad_group; |
| clicks | NUMERIC | Clicks | Aggregate 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_type | TEXT | Conversion attribution type | What the conversion is attributed to: Visit or Keyword+Ad. | conversion; |
| conversion_date | DATE | Conversion date | The 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_id | TEXT | Conversion id | ID that Search Ads 360 generates for each conversion. | conversion; |
| conversion_last_modified_timestamp | TIMESTAMP | Conversion last modified timestamp | The UTC timestamp of the conversion's most recent modification. | conversion; |
| conversion_quantity | NUMERIC | Conversion quantity | The 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_revenue | NUMERIC | Conversion revenue | The total dollar amount from the conversion. | conversion; |
| conversion_timestamp | TIMESTAMP | Conversion timestamp | The UTC timestamp when the conversion occurred. | conversion; |
| conversion_visit_external_click_id | TEXT | Conversion visit external click id | A unique string, for the visit that the conversion is attributed to, that is passed to the landing page as the gclid URL parameter. Only enabled for advertisers with conversion API integration or Google Analytics integration. | conversion; |
| conversion_visit_id | TEXT | Conversion visit id | The DS visit ID that the conversion is attributed to. | conversion; |
| conversion_visit_timestamp | TIMESTAMP | Conversion visit timestamp | The UTC timestamp of the visit that the conversion is attributed to. | conversion; |
| country_targets | TEXT | Country targets | Country targets included in the ad group. Download upload templates and geo/language codes. | campaign; ad_group; |
| cpa_target | NUMERIC | Cpa target | The target CPA (cost per action) of the bid strategy. | bidding_strategy; |
| creation_timestamp | TIMESTAMP | Creation timestamp | Timestamp 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_conversions | NUMERIC | Cross device conversions | Conversions from when a customer clicks on an ad on one device, then converts on a different device or browser. | 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_value | NUMERIC | Cross device conversions value | The 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_price | NUMERIC | Cross sell average unit price | Average price reported for sales of a product when it sold as a result of advertising a different product | cart_data_sales_view; |
| cross_sell_cost_of_goods_sold | NUMERIC | Cross sell cost of goods sold | The 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_sold | NUMERIC | Cross sell gross from units sold | The total revenue generated from sales of a product as a result of advertising a different product. | cart_data_sales_view; |
| cross_sell_gross_profit_margin | NUMERIC | Cross sell gross profit margin | The 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_sold | NUMERIC | Cross sell revenue from units sold | The total revenue generated from cross sales (revenue generated as a result of advertising a different product). | cart_data_sales_view; |
| cross_sell_units_sold | NUMERIC | Cross sell units sold | The 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; |
| ctr | PERCENT | Ctr | Average 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_budget | NUMERIC | Daily budget | Daily budget of the campaign. | campaign; |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | Segments 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_month | TEXT | Day of month | Day of the month | |
| delivery_method | TEXT | Delivery method | Budget delivery method of the campaign: Standard or Accelerated. | campaign; |
| device_segment | TEXT | Device segment | Segments 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_targets | TEXT | Device targets | Device targets at the ad group level; a combination of Desktop, Mobile, Tablet, or Other. | campaign; ad_group; |
| dfa_actions | NUMERIC | Dfa actions | The 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_env | NUMERIC | Dfa actions cross env | The 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_id | TEXT | Dfa advertiser id | ID of the Campaign manager advertiser associated with this DS advertiser. | customer; |
| dfa_network_id | TEXT | Dfa network id | ID of the Campaign manager network associated with this DS advertiser. | customer; |
| dfa_network_time_zone | TEXT | Dfa network time zone | Time zone of the Campaign manager network associated with this DS advertiser in IANA Time Zone Database format, such as America/New_York. | customer; |
| dfa_revenue | NUMERIC | Dfa revenue | Aggregate 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_env | NUMERIC | Dfa revenue cross env | Aggregate 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_transactions | NUMERIC | Dfa transactions | The 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_env | NUMERIC | Dfa transactions cross env | The 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_share | NUMERIC | Display budget lost impression share | Google 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.95 | customer; campaign; customer; |
| display_impression_share | NUMERIC | Display impression share | Google 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.05 | customer; campaign; customer; ad_group; |
| display_rank_lost_impression_share | NUMERIC | Display rank lost impression share | Google 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.95 | customer; campaign; customer; ad_group; |
| dynamic_search_ads_target_conditions | TEXT | Dynamic search ads target conditions | The 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_coverage | NUMERIC | Dynamic search ads target coverage | The percentage of pages on the advertiser's site that the dynamic ad target matches. | ad_group_criterion; |
| dynamic_search_ads_target_cpc_bid | NUMERIC | Dynamic search ads target cpc bid | The dynamic ad target's max CPC (maximum cost per click) setting. | ad_group_criterion; |
| dynamic_search_ads_target_landing_page_url | TEXT | Dynamic search ads target landing page url | The dynamic ad target's URL template. | ad_group_criterion; |
| effective_bid_strategy | TEXT | Effective bid strategy | The name of the bid strategy assigned to this entity, or inherited by this entity. | campaign; ad_group_criterion; ad_group; campaign_criterion; |
| effective_bid_strategy_id | TEXT | Effective bid strategy id | DS ID of the bid strategy assigned to this entity, or inherited by this entity. | campaign; ad_group_criterion; ad_group; campaign_criterion; |
| effective_city_targets | TEXT | Effective city targets | City targets included in the ad group, or inherited from the campaign. Download upload templates and geo/language codes. | campaign; ad_group; |
| effective_country_targets | TEXT | Effective country targets | Country targets included in the ad group, or inherited from the campaign. Download upload templates and geo/language codes. | campaign; ad_group; |
| effective_device_targets | TEXT | Effective device targets | Device targets at the ad group level, or inherited from the campaign; a combination of Desktop, Mobile, Tablet, or Other. | campaign; ad_group; |
| effective_keyword_max_cpc | NUMERIC | Effective keyword max cpc | The 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_targets | TEXT | Effective metro targets | Metro targets included in the ad group, or inherited from the campaign. Download upload templates and geo/language codes. | campaign; ad_group; |
| effective_province_targets | TEXT | Effective province targets | Province targets included in the ad group, or inherited from the campaign. Download upload templates and geo/language codes. | campaign; ad_group; |
| engine_remarketing_list | TEXT | Engine remarketing list | The name of the remarketing list associated with the target. | ad_group_criterion; campaing_criterion; campaign_criterion; ad_group_criterion; |
| engine_remarketing_list_bid_modifier | NUMERIC | Engine remarketing list bid modifier | The bid adjustment associated with the target. | ad_group_criterion; campaing_criterion; |
| engine_remarketing_list_target_all | BOOLEAN | Engine remarketing list target all | Indicates 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_status | TEXT | Engine status | Additional 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_target | NUMERIC | Ers target | The target ERS (effective revenue share) ratio of the bid strategy. | bidding_strategy; |
| excluded_city_targets | TEXT | Excluded city targets | City targets excluded from the campaign. Download upload templates and geo/language codes. | campaign; |
| excluded_country_targets | TEXT | Excluded country targets | Country targets excluded from the campaign. Download upload templates and geo/language codes. | campaign; |
| excluded_metro_targets | TEXT | Excluded metro targets | Metro targets excluded from the campaign. Download upload templates and geo/language codes. | campaign; |
| excluded_province_targets | TEXT | Excluded province targets | Province targets excluded from the campaign. Download upload templates and geo/language codes. | campaign; |
| feed_id | TEXT | Feed id | Segments the report by feed items; each row and its aggregate metrics are split into multiple rows, one for each feed item. This column returns the DS feed table ID for each row. | campaign; visit; ad_group; conversion; asset; |
| feed_item_id | TEXT | Feed item id | 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 item row ID for each row. | campaign; visit; ad_group; conversion; asset; |
| feed_type | TEXT | Feed type | 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 type of feed item for each row. | campaign; visit; ad_group; conversion; |
| floodlight_activity | TEXT | Floodlight activity | Segments 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_id | TEXT | Floodlight activity id | Segments 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_tag | TEXT | Floodlight activity tag | Segments 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_ids | TEXT | Floodlight activity target ids | Comma-separated list of Floodlight activity IDs that this bid strategy targets. | bidding_strategy; |
| floodlight_group | TEXT | Floodlight group | Segments the report by Floodlight groups; each row and its aggregate metrics are split into multiple rows, up to one for each Floodlight group. This column returns the Floodlight group name of each row. Note that some metrics do not have Floodlight segmented values, such as clicks and visits. | 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_type | TEXT | Floodlight group conversion type | The type of conversions generated by Floodlight activities in this group: Action or Transaction. | conversion_action; conversion; |
| floodlight_group_tag | TEXT | Floodlight group tag | 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 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_enabled | BOOLEAN | Floodlight optimization enabled | Whether the bid strategy targets specific Floodlight activities. | bidding_strategy; |
| floodlight_order_id | TEXT | Floodlight order id | The Floodlight order ID provided by the advertiser for the conversion. | conversion; |
| floodlight_original_revenue | NUMERIC | Floodlight original revenue | The original, unchanged revenue associated with the Floodlight event (in the currency of the current report), before Floodlight currency instruction modifications. | conversion; |
| floodlight_referrer | TEXT | Floodlight referrer | The Floodlight referrer website of the conversion. | conversion; |
| gender_target_bid_modifier | NUMERIC | Gender target bid modifier | The bid adjustment associated with the gender target. | ad_group_criterion; |
| gender_target_gender_type | TEXT | Gender target gender type | The gender type of gender target: Male, Female, Unknown. | ad_group_criterion; campaign_criterion; ad_group_criterion; |
| impressions | NUMERIC | Impressions | The 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_id | TEXT | Inventory account id | The 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_url | TEXT | Keyword clickserver url | The 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_id | TEXT | Keyword engine id | ID of the keyword in the external engine account. | ad_group_criterion; |
| keyword_id | TEXT | Keyword id | DS keyword ID. A value of 0 indicates that the keyword is unattributed. | ad_group_criterion; visit; paid_organic_search_term_view; conversion; |
| keyword_labels | TEXT | Keyword labels | Names of labels directly assigned to this keyword; inherited labels are not included. | ad_group_criterion; |
| keyword_landing_page | TEXT | Keyword landing page | The final URL that a user would visit after clicking on your ad. See Landing page and clickserver URLs. | ad_group_criterion; |
| keyword_match_type | TEXT | Keyword match type | Keyword match type: Broad, Exact, Phrase, or Content. | ad_group_criterion; visit; paid_organic_search_term_view; conversion; |
| keyword_max_bid | NUMERIC | Keyword max bid | If 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_cpc | NUMERIC | Keyword max cpc | Overrides 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_bid | NUMERIC | Keyword min bid | If 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_text | TEXT | Keyword text | Keyword text. | ad_group_criterion; visit; paid_organic_search_term_view; conversion; |
| keyword_url_params | TEXT | Keyword url params | Extra URL parameters added to the landing page. See Add URL parameters. | ad_group_criterion; |
| language_targets | TEXT | Language targets | Language targets at the campaign level. Download upload templates and geo/language codes. | campaign; |
| last_modified_timestamp | TIMESTAMP | Last modified timestamp | Timestamp 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_price | NUMERIC | Lead average unit price | The 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_sold | NUMERIC | Lead cost of goods sold | The total cost of selling a product when sold as a result of advertising the product. | cart_data_sales_view; |
| lead_gross_profit_from_units_sold | NUMERIC | Lead gross profit from units sold | The total revenue generated from sales of a product as a result of advertising the product. | cart_data_sales_view; |
| lead_revenue_from_units_sold | NUMERIC | Lead revenue from units sold | The total revenue generated from a product as a result of advertising the product. | cart_data_sales_view; |
| lead_units_sold | NUMERIC | Lead units sold | The number of units sold as a result of advertising the product. | cart_data_sales_view; |
| location_target_bid_modifier | NUMERIC | Location target bid modifier | The bid adjustment associated with the location target. | ad_group_criterion; campaing_criterion; |
| location_target_name | TEXT | Location target name | The name of the location target. | ad_group_criterion; campaing_criterion; campaign_criterion; ad_group_criterion; |
| metro_targets | TEXT | Metro targets | Metro targets included in the ad group. Download upload templates and geo/language codes. | campaign; ad_group; |
| month | TEXT | Month | Number of the month | |
| month_start | DATE | Month start | Segments 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_budget | NUMERIC | Monthly budget | Monthly budget of the campaign. | campaign; |
| monthly_spend_target | NUMERIC | Monthly spend target | The 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_id | TEXT | Negative ad group keyword id | DS negative ad group keyword ID. | ad_group_criterion; |
| negative_ad_group_keyword_match_type | TEXT | Negative ad group keyword match type | Match type of the negative keyword: Broad, Exact, Phrase, or Content. Currently only for Google Ads accounts. | ad_group_criterion; |
| negative_ad_group_keyword_text | TEXT | Negative ad group keyword text | The keyword text. | ad_group_criterion; |
| negative_ad_group_target_id | TEXT | Negative ad group target id | The ID DS generated for a negative ad-group target. | ad_group_criterion; |
| negative_campaign_keyword_id | TEXT | Negative campaign keyword id | DS negative campaign keyword ID. | campaign_criterion; |
| negative_campaign_keyword_match_type | TEXT | Negative campaign keyword match type | Match type of the negative keyword: Broad, Exact, Phrase, or Content. Currently only for Google Ads accounts. | campaign_criterion; |
| negative_campaign_keyword_text | TEXT | Negative campaign keyword text | The keyword text. | campaign_criterion; |
| negative_campaign_target_id | TEXT | Negative campaign target id | The ID DS generated for a negative campaign target. | campaign_criterion; |
| network_target | TEXT | Network target | The type of network(s) the campaign advertises on. | campaign; |
| organic_clicks | NUMERIC | Organic clicks | The number of clicks on unpaid search results for your site after someone entered the searchQuery. | paid_organic_search_term_view; |
| organic_queries | NUMERIC | Organic queries | The 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; |
| paid_and_organic_clicks | NUMERIC | Paid and organic clicks | The number of clicks on either one of your ads ad or an unpaid search result for your site after someone entered the searchQuery. | paid_organic_search_term_view; |
| paid_and_organic_ctr | NUMERIC | Paid and organic ctr | The 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; |
| paid_and_organic_queries | NUMERIC | Paid and organic queries | The total number of times users have entered the searchQuery and saw at least one of your ads or at least one organic search result from your site. | paid_organic_search_term_view; |
| product_brand | TEXT | Product brand | The brand attribute of a product item. | shopping_performance_view; cart_data_sales_view; |
| product_category_level1 | TEXT | Product category level1 | The google product category level 1 attribute of a product item. | shopping_performance_view; cart_data_sales_view; |
| product_category_level2 | TEXT | Product category level2 | The google product category level 2 attribute of a product item. | shopping_performance_view; cart_data_sales_view; |
| product_category_level3 | TEXT | Product category level3 | The google product category level 3 attribute of a product item. | shopping_performance_view; cart_data_sales_view; |
| product_category_level4 | TEXT | Product category level4 | The google product category level 4 attribute of a product item. | shopping_performance_view; cart_data_sales_view; |
| product_category_level5 | TEXT | Product category level5 | The google product category level 5 attribute of a product item. | shopping_performance_view; cart_data_sales_view; |
| product_channel | TEXT | Product channel | The sales channel of the product associated with the conversion: Online or Local. | shopping_performance_view; visit; conversion; cart_data_sales_view; |
| product_channel_exclusivity | TEXT | Product channel exclusivity | The channel exclusivity attribute of a product item. | shopping_performance_view; cart_data_sales_view; |
| product_condition | TEXT | Product condition | The condition attribute of a product item. | shopping_performance_view; cart_data_sales_view; |
| product_country | COUNTRY | Product country | The 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_label0 | TEXT | Product custom label0 | The custom label 0 attribute of a product item. | shopping_performance_view; cart_data_sales_view; |
| product_custom_label1 | TEXT | Product custom label1 | The custom label 1 attribute of a product item. | shopping_performance_view; cart_data_sales_view; |
| product_custom_label2 | TEXT | Product custom label2 | The custom label 2 attribute of a product item. | shopping_performance_view; cart_data_sales_view; |
| product_custom_label3 | TEXT | Product custom label3 | The custom label 3 attribute of a product item. | shopping_performance_view; cart_data_sales_view; |
| product_custom_label4 | TEXT | Product custom label4 | The custom label 4 attribute of a product item. | shopping_performance_view; cart_data_sales_view; |
| product_group_id | TEXT | Product group id | The 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_id | TEXT | Product id | The ID of the product associated with this conversion. | shopping_performance_view; visit; conversion; cart_data_sales_view; |
| product_language | TEXT | Product language | The language (ISO 639-1) of the product associated this conversion. | shopping_performance_view; visit; conversion; cart_data_sales_view; |
| product_store_id | TEXT | Product store id | The 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_id | TEXT | Product target id | DS product target ID. | visit; conversion; campaign_criterion; |
| product_title | TEXT | Product title | The title attribute of a product item. | shopping_performance_view; cart_data_sales_view; |
| product_type_level1 | TEXT | Product type level1 | The product type leve 1 attribute of a product item. | shopping_performance_view; cart_data_sales_view; |
| product_type_level2 | TEXT | Product type level2 | The product type leve 2 attribute of a product item. | shopping_performance_view; cart_data_sales_view; |
| product_type_level3 | TEXT | Product type level3 | The product type leve 3 attribute of a product item. | shopping_performance_view; cart_data_sales_view; |
| product_type_level4 | TEXT | Product type level4 | The product type leve 4 attribute of a product item. | shopping_performance_view; cart_data_sales_view; |
| product_type_level5 | TEXT | Product type level5 | The product type leve 5 attribute of a product item. | shopping_performance_view; cart_data_sales_view; |
| province_targets | TEXT | Province targets | Province targets included in the ad group. Download upload templates and geo/language codes. | campaign; ad_group; |
| quality_score_avg | NUMERIC | Quality score avg | Google 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_current | NUMERIC | Quality score current | Google 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_start | DATE | Quarter start | Segments 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_target | NUMERIC | Roas target | The target ROAS (return on ad spending) ratio of the bid strategy. | bidding_strategy; |
| search_absolute_top_impression_share | NUMERIC | Search absolute top impression share | Impressions 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_share | NUMERIC | Search budget lost absolute top impression share | Estimates 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_share | NUMERIC | Search budget lost impression share | Google 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_share | NUMERIC | Search budget lost top impression share | Helps 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_share | NUMERIC | Search impression share | Google 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_query | TEXT | Search query | The search terms that Google users entered. | paid_organic_search_term_view; |
| search_rank_lost_absolute_top_impression_share | NUMERIC | Search rank lost absolute top impression share | Estimates 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_share | NUMERIC | Search rank lost impression share | Google 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_share | NUMERIC | Search rank lost top impression share | Estimates 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_share | NUMERIC | Search top impression share | Impressions 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_type | TEXT | Serp type | The type of search result that Google users clicked.Possible values are:Organic only: Users who entered this query only clicked unpaid search results.Paid only: Users who entered this query only clicked ads.Paid and Organic: Some users who entered this query clicked unpaid search results while others clicked ads (and some may have clicked both). | paid_organic_search_term_view; |
| sitelink_clickserver_url | TEXT | Sitelink clickserver url | Segments 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; |
| sitelink_description1 | TEXT | Sitelink description1 | Segments 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; |
| sitelink_description2 | TEXT | Sitelink description2 | Segments 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; |
| sitelink_display_text | TEXT | Sitelink display text | Segments 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; |
| sitelink_landing_page_url | TEXT | Sitelink landing page url | Segments 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; |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| spend | NUMERIC | Spend | Aggregate 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; |
| status | TEXT | Status | The 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; |
| today | DATE | Today | Today's date | |
| top_impression_percentage | PERCENT | Top impression percentage | Percent of your ad impressions that are shown anywhere above the organic search results. | customer; campaign; customer; ad_group; |
| top_of_page_bid_current | NUMERIC | Top of page bid current | Google 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_date | DATE | Visit date | The 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_id | TEXT | Visit external click id | A 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_id | TEXT | Visit id | DS visit ID. | visit; |
| visit_network_type | TEXT | Visit network type | The ad network that generated this visit: Content, Search, or Other. | visit; |
| visit_timestamp | TIMESTAMP | Visit timestamp | The UTC timestamp when the visit occurred. | visit; |
| visits | NUMERIC | Visits | The 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; |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| week_start | DATE | Week start | Segments 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_targets | TEXT | Yahoo geo targets | Geo targets for Yahoo Search Marketing campaigns. See Download upload templates and geo/language codes. | campaign; |
| yahoo_japan_bid_strategy | TEXT | Yahoo japan bid strategy | The bid strategy Yahoo! JAPAN uses for this campaign: Manual cpc or Budget optimizer. Campaigns using DS bid strategies are set to Manual cpc. | campaign; |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_start | DATE | Year start | Segments 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_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |