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
absolute_top_impression_percentage	NUMERIC	Absolute top impression percentage	Percent of your ad impressions that are shown as the very first ad above the organic search results.
account	TEXT	Account	Engine account name.
account_currency_code	TEXT	Account currency code	Currency code of the engine account in ISO 4217 format.
account_engine_id	TEXT	Account engine id	ID of the account in the external engine account.
account_id	TEXT	Account id	DS engine account ID.
account_time_zone	TEXT	Account time zone	Time zone of the engine account in IANA Time Zone Database format, such as America/New_York.
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	TEXT	Ad attribute name	Ad name.
ad_description1	TEXT	Ad description1	Ad description line 1.
ad_description2	TEXT	Ad description2	Ad description line 2; not available for some engines.
ad_display_url	TEXT	Ad display url	Ad display URL.
ad_engine_id	TEXT	Ad engine id	ID of the ad in the external engine account.
ad_group	TEXT	Ad group	Ad group name.
ad_group_broad_max_cpc	NUMERIC	Ad group broad max cpc	Default bid for broad match search keywords in this ad group (Bing Ads only).
ad_group_content_max_cpc	NUMERIC	Ad group content max cpc	Default bid for content keywords in this ad group.
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_end_date	DATE	Ad group end date	End date of the ad group.
ad_group_engine_id	TEXT	Ad group engine id	ID of the ad group in the external engine account.
ad_group_exact_max_cpc	NUMERIC	Ad group exact max cpc	Default bid for exact match keywords in this ad group (Bing Ads only).
ad_group_id	TEXT	Ad group id	DS ad group ID.
ad_group_labels	TEXT	Ad group labels	Names of labels directly assigned to this ad group; inherited labels are not included.
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_phrase_max_cpc	NUMERIC	Ad group phrase max cpc	Default bid for phrasematch search keywords in this ad group (Bing Ads only).
ad_group_search_max_cpc	NUMERIC	Ad group search max cpc	Default bid for search keywords in this ad group.
ad_group_start_date	DATE	Ad group start date	Start date of the ad group.
ad_group_status	TEXT	Ad group status	The status of the ad group that contains this item.
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_target_id	TEXT	Ad group target id	The ID DS generated for an ad group target.
ad_group_type	TEXT	Ad group type	(Applicable to Google Ads only) Indicates the type of ad group: Standard, Dynamic, or Showcase.
ad_headline	TEXT	Ad headline	Ad headline.
ad_headline2	TEXT	Ad headline2	Ad headline 2; not available for some engines.
ad_headline3	TEXT	Ad headline3	Ad headline 3; not available for some engines.
ad_id	TEXT	Ad id	DS ad ID. A value of 0 indicates that the ad is unattributed.
ad_labels	TEXT	Ad labels	Names of labels directly assigned to this ad; inherited labels are not included.
ad_landing_page	TEXT	Ad landing page	Ad landing page. See Landing page and clickserver URLs.
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_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_promotion_line	TEXT	Ad promotion line	Ad promotion line. A short promotional message for a product ad.
ad_rotation	TEXT	Ad rotation	Ad serving rotation used by the ad group: Optimize or Rotate indefinitely.
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_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.
ad_words_conversion_value	NUMERIC	Ad words conversion value	Aggregate value of Google Ads conversions.
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_words_view_through_conversions	NUMERIC	Ad words view through conversions	The total number of Google Ads view-through conversions.
advertiser	TEXT	Advertiser	Advertiser name.
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.
advertiser_currency_code	TEXT	Advertiser currency code	Currency code of the advertiser in ISO 4217 format.
advertiser_id	TEXT	Advertiser id	DS advertiser ID.
age_target_age_range	TEXT	Age target age range	The age range of age target.
age_target_bid_modifier	NUMERIC	Age target bid modifier	The bid adjustment associated with the age target.
agency	TEXT	Agency	Agency name.
agency_id	TEXT	Agency id	DS agency ID.
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.
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.
avg_cpc	NUMERIC	Avg cpc	Average cost per click.
avg_cpm	NUMERIC	Avg cpm	Average cost per thousand impressions.
avg_pos	NUMERIC	Avg pos	Average position.
bid_strategy	TEXT	Bid strategy	The bid strategy name.
bid_strategy_goal	TEXT	Bid strategy goal	The goal of the bid strategy: Position, Conversions, Revenue, Clicks, or Advanced targeting.
bid_strategy_id	TEXT	Bid strategy id	DS bid strategy ID.
bid_strategy_inherited	BOOLEAN	Bid strategy inherited	Indicates whether this entity's bid strategy is inherited.
bid_strategy_max_bid	NUMERIC	Bid strategy max bid	The highest possible bid for keywords in this bid strategy.
bid_strategy_min_bid	NUMERIC	Bid strategy min bid	The lowest possible bid for keywords in this bid strategy.
bing_ads_ad_distributions	TEXT	Bing ads ad distributions	Ad distribution channels used by Bing Ads ad groups; a combination of Search and Content.
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.
bing_ads_language	TEXT	Bing ads language	The language of the ads and keywords in a Bing Ads ad group.
bing_keyword_param2	TEXT	Bing keyword param2	Param2 of a Bing Ads keyword.
bing_keyword_param3	TEXT	Bing keyword param3	Param3 of a Bing Ads keyword.
call_call_only	BOOLEAN	Call call only	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 only shows a phone number, or false if the extension shows both a phone number and a link.
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.
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.
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.
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.
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	TEXT	Campaign	Campaign name.
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_end_date	DATE	Campaign end date	End date of the campaign.
campaign_engine_id	TEXT	Campaign engine id	ID of the campaign in the external engine account.
campaign_id	TEXT	Campaign id	DS campaign ID.
campaign_labels	TEXT	Campaign labels	Names of labels directly assigned to this campaign; inherited labels are not included.
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_start_date	DATE	Campaign start date	Start date of the campaign.
campaign_status	TEXT	Campaign status	The status of the campaign that contains this item.
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_target_id	TEXT	Campaign target id	The ID DS generated for a campaign target.
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.
city_targets	TEXT	City targets	City targets included in the ad group. Download upload templates and geo/language codes.
clicks	NUMERIC	Clicks	Aggregate clicks.
clicks_with_feed_item_showing	NUMERIC	Clicks with feed item showing	Clicks on any link in the ad while the feed item was displayed. This column only returns a value in a feed item report or in a report that is segmented by a feed-item column.
conversion_attribution_type	TEXT	Conversion attribution type	What the conversion is attributed to: Visit or Keyword+Ad.
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_id	TEXT	Conversion id	ID that Search Ads 360 generates for each conversion.
conversion_last_modified_timestamp	TIMESTAMP	Conversion last modified timestamp	The UTC timestamp of the conversion's most recent modification.
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_revenue	NUMERIC	Conversion revenue	The total dollar amount from the conversion.
conversion_search_term	TEXT	Conversion search term	The search term that led to the conversion.
conversion_timestamp	TIMESTAMP	Conversion timestamp	The UTC timestamp when the conversion occurred.
conversion_type	TEXT	Conversion type	The type of the conversion: Action or Transaction.
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_visit_id	TEXT	Conversion visit id	The DS visit ID that the conversion is attributed to.
conversion_visit_timestamp	TIMESTAMP	Conversion visit timestamp	The UTC timestamp of the visit that the conversion is attributed to.
cost_with_feed_item_showing	NUMERIC	Cost with feed item showing	Cost of all ads when the feed item was showing. This column only returns a value in a feed item report or in a report that is segmented by a feed-item column.
country_targets	TEXT	Country targets	Country targets included in the ad group. Download upload templates and geo/language codes.
cpa_target	NUMERIC	Cpa target	The target CPA (cost per action) of the bid strategy.
creation_timestamp	TIMESTAMP	Creation timestamp	Timestamp of the account's creation, formatted in ISO 8601.
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
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.
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.
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.
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).
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.)
ctr	PERCENT	Ctr	Average click-through rate.
daily_budget	NUMERIC	Daily budget	Daily budget of the campaign.
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.
delivery_method	TEXT	Delivery method	Budget delivery method of the campaign: Standard or Accelerated.
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.
device_targets	TEXT	Device targets	Device targets at the ad group level; a combination of Desktop, Mobile, Tablet, or Other.
dfa_actions	NUMERIC	Dfa actions	The total number of Campaign manager actions.
dfa_actions_cross_env	NUMERIC	Dfa actions cross env	The total number of cross-environment Campaign manager actions.
dfa_advertiser_id	TEXT	Dfa advertiser id	ID of the Campaign manager advertiser associated with this DS advertiser.
dfa_network_id	TEXT	Dfa network id	ID of the Campaign manager network associated with this DS advertiser.
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.
dfa_revenue	NUMERIC	Dfa revenue	Aggregate revenue generated by Campaign manager transactions.
dfa_revenue_cross_env	NUMERIC	Dfa revenue cross env	Aggregate revenue generated by cross-environment Campaign manager transactions.
dfa_transactions	NUMERIC	Dfa transactions	The total number of Campaign manager transactions.
dfa_transactions_cross_env	NUMERIC	Dfa transactions cross env	The total number of cross-environment Campaign manager transactions.
dfa_weighted_actions	NUMERIC	Dfa weighted actions	Weighted sum of Campaign manager actions.
dfa_weighted_actions_cross_env	NUMERIC	Dfa weighted actions cross env	Weighted sum of cross-environment Campaign manager actions.
display_budget_lost_impression_share	TEXT	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, as a string > 90%.
display_impression_share	TEXT	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, the string < 10%.
display_rank_lost_impression_share	TEXT	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, as a string > 90%.
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.
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.
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.
dynamic_search_ads_target_landing_page_url	TEXT	Dynamic search ads target landing page url	The dynamic ad target's URL template.
effective_bid_strategy	TEXT	Effective bid strategy	The name of the bid strategy assigned to this entity, or inherited by this entity.
effective_bid_strategy_id	TEXT	Effective bid strategy id	DS ID of the bid strategy assigned to this entity, or inherited by this entity.
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.
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.
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.
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.
effective_labels	TEXT	Effective labels	Names of all labels inherited or directly assigned to this ad.
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.
effective_product_target_max_cpc	NUMERIC	Effective product target max cpc	The max CPC (maximum cost-per-click) that is in effect for this product target. This will be either the same value as the ad group's max CPC or, if the product target is overriding the ad group's setting, the product target's own max CPC.
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.
engine_remarketing_list	TEXT	Engine remarketing list	The name of the remarketing list associated with the target.
engine_remarketing_list_bid_modifier	NUMERIC	Engine remarketing list bid modifier	The bid adjustment associated with the target.
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.
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.
ers_target	NUMERIC	Ers target	The target ERS (effective revenue share) ratio of the bid strategy.
excluded_city_targets	TEXT	Excluded city targets	City targets excluded from the campaign. Download upload templates and geo/language codes.
excluded_country_targets	TEXT	Excluded country targets	Country targets excluded from the campaign. Download upload templates and geo/language codes.
excluded_metro_targets	TEXT	Excluded metro targets	Metro targets excluded from the campaign. Download upload templates and geo/language codes.
excluded_province_targets	TEXT	Excluded province targets	Province targets excluded from the campaign. Download upload templates and geo/language codes.
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.
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.
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.
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.
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.
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.
floodlight_activity_target_ids	TEXT	Floodlight activity target ids	Comma-separated list of Floodlight activity IDs that this bid strategy targets.
floodlight_configuration_id	TEXT	Floodlight configuration id	Campaign manager Floodlight configuration ID.
floodlight_event_request_string	TEXT	Floodlight event request string	The Floodlight request string of the conversion.
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.
floodlight_group_conversion_type	TEXT	Floodlight group conversion type	The type of conversions generated by Floodlight activities in this group: Action or Transaction.
floodlight_group_id	TEXT	Floodlight group id	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 DS Floodlight group ID of each row. Note that some metrics do not have Floodlight segmented values, such as clicks and visits.
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.
floodlight_optimization_enabled	BOOLEAN	Floodlight optimization enabled	Whether the bid strategy targets specific Floodlight activities.
floodlight_order_id	TEXT	Floodlight order id	The Floodlight order ID provided by the advertiser for the 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.
floodlight_referrer	TEXT	Floodlight referrer	The Floodlight referrer website of the conversion.
gender_target_bid_modifier	NUMERIC	Gender target bid modifier	The bid adjustment associated with the gender target.
gender_target_gender_type	TEXT	Gender target gender type	The gender type of gender target: Male, Female, Unknown.
google_analytics_time_zone	TEXT	Google analytics time zone	The time zone of the Google Analytics view linked to this DS advertiser. Uses the IANA Time Zone Database format, such as America/New_York.
high_position	NUMERIC	High position	The highest desirable position (numerically smaller) to show ads. For example, in a position range of 2 - 5, 2 is the highPosition.
impressions	NUMERIC	Impressions	The total number of impressions.
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.
is_display_keyword	BOOLEAN	Is display keyword	Indicates whether this is a placeholder keyword that is used for display and placement reporting.
is_unattributed_ad	BOOLEAN	Is unattributed ad	Indicates whether metrics in this row are unattributable to a specific ad. For example, an ad with an unsupported format or an erroneous clickserver URL can prevent DS from attributing metrics to an ad.
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.
keyword_engine_id	TEXT	Keyword engine id	ID of the keyword in the external engine account.
keyword_id	NUMERIC	Keyword id	DS keyword ID. A value of 0 indicates that the keyword is unattributed.
keyword_labels	TEXT	Keyword labels	Names of labels directly assigned to this keyword; inherited labels are not included.
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.
keyword_match_type	TEXT	Keyword match type	Keyword match type: Broad, Exact, Phrase, or Content.
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.
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.
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.
keyword_near_match_enabled	TEXT	Keyword near match enabled	Whether keyword near match is enabled for the campaign: Enabled or Disabled.
keyword_text	TEXT	Keyword text	Keyword text.
keyword_url_params	TEXT	Keyword url params	Extra URL parameters added to the landing page. See Add URL parameters.
language_targets	TEXT	Language targets	Language targets at the campaign level. Download upload templates and geo/language codes.
last_modified_timestamp	TIMESTAMP	Last modified timestamp	Timestamp of the account's most recent modification, formatted in ISO 8601.
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.
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.
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.
lead_gross_profit_margin	NUMERIC	Lead gross profit margin	The gross profit margin for a specific product as a direct result of advertising the product.
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.
lead_units_sold	NUMERIC	Lead units sold	The number of units sold as a result of advertising the product.
location_business_name	TEXT	Location business name	Segments the report by upgraded location extensions linked to a Business Profile account; each row and its aggregate metrics are split into multiple rows, one for each location that has metrics available. This column returns the location's business name for each row.
location_category	TEXT	Location category	Segments the report by upgraded location extensions linked to a Business Profile account; each row and its aggregate metrics are split into multiple rows, one for each location that has metrics available. This column returns the location's category for each row.
location_details	TEXT	Location details	Segments the report by upgraded location extensions linked to a Business Profile account; each row and its aggregate metrics are split into multiple rows, one for each location that has metrics available. This column returns the details about a location for each row.
location_filter	TEXT	Location filter	Segments the report by upgraded location extensions linked to a Business Profile account; each row and its aggregate metrics are split into multiple rows, one for each location that has metrics available. This column returns the location's filter for each row.
location_target_bid_modifier	NUMERIC	Location target bid modifier	The bid adjustment associated with the location target.
location_target_name	TEXT	Location target name	The name of the location target.
low_position	NUMERIC	Low position	The lowest desirable position (numerically bigger) to show ads. For example, in a position range of 2 - 5, 5 is the lowPosition.
metro_targets	TEXT	Metro targets	Metro targets included in the ad group. Download upload templates and geo/language codes.
month_end	DATE	Month end	Segments the report by months; each row and its aggregate metrics are split into multiple rows, one for each month. This column returns the last day of the month of each row.
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.
monthly_budget	NUMERIC	Monthly budget	Monthly budget of the 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.
negative_ad_group_keyword_id	TEXT	Negative ad group keyword id	DS negative ad group keyword ID.
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.
negative_ad_group_keyword_text	TEXT	Negative ad group keyword text	The keyword text.
negative_ad_group_target_id	TEXT	Negative ad group target id	The ID DS generated for a negative ad-group target.
negative_campaign_keyword_id	TEXT	Negative campaign keyword id	DS negative campaign keyword ID.
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.
negative_campaign_keyword_text	TEXT	Negative campaign keyword text	The keyword text.
negative_campaign_target_id	TEXT	Negative campaign target id	The ID DS generated for a negative campaign target.
network_target	TEXT	Network target	The type of network(s) the campaign advertises on.
organic_avg_pos	NUMERIC	Organic avg pos	The average top position of unpaid search results for your site.
organic_clicks	NUMERIC	Organic clicks	The number of clicks on unpaid search results for your site after someone entered the searchQuery.
organic_ctr	NUMERIC	Organic ctr	The rate at which people who see unpaid search results for your site end up clicking an unpaid result and landing on your site.
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_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_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_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_avg_pos	NUMERIC	Paid avg pos	The average position in which the ad appears after someone entered the searchQuery.
paid_clicks	NUMERIC	Paid clicks	The number of times someone clicked an ad after entering the searchQuery.
paid_cost_per_click	NUMERIC	Paid cost per click	The average cost per click for an ad. This is the average amount you pay each time someone clicks your ad.
paid_ctr	NUMERIC	Paid ctr	The click-through rate for an ad, which is how often people who see your ad end up clicking it after entering the searchQuery.
paid_impressions	NUMERIC	Organic Paid impressions	The number of times an ad has appeared on a search results page or on a website in the Google Network after someone entered the searchQuery.
product_age_group	TEXT	Product age group	The age group attribute of a product item.
product_availability	TEXT	Product availability	The availability attribute of a product item.
product_average_unit_price	NUMERIC	Product average unit price	The average price reported for sales of a product (using the price reported on each product).
product_brand	TEXT	Product brand	The brand attribute of a product item.
product_category	TEXT	Product category	The google product category attribute of a product item.
product_category_level1	TEXT	Product category level1	The google product category level 1 attribute of a product item.
product_category_level2	TEXT	Product category level2	The google product category level 2 attribute of a product item.
product_category_level3	TEXT	Product category level3	The google product category level 3 attribute of a product item.
product_category_level4	TEXT	Product category level4	The google product category level 4 attribute of a product item.
product_category_level5	TEXT	Product category level5	The google product category level 5 attribute of a product item.
product_channel	TEXT	Product channel	The sales channel of the product associated with the conversion: Online or Local.
product_channel_exclusivity	TEXT	Product channel exclusivity	The channel exclusivity attribute of a product item.
product_color	TEXT	Product color	The color attribute of a product item.
product_condition	TEXT	Product condition	The condition attribute of a product item.
product_cost_of_goods_sold	NUMERIC	Product cost of goods sold	The total cost of selling a product as specified in the inventory feed.
product_country	TEXT	Product country	The country (ISO 3166 format) registered for the inventory feed that contains the product associated with this conversion.
product_custom_label0	TEXT	Product custom label0	The custom label 0 attribute of a product item.
product_custom_label1	TEXT	Product custom label1	The custom label 1 attribute of a product item.
product_custom_label2	TEXT	Product custom label2	The custom label 2 attribute of a product item.
product_custom_label3	TEXT	Product custom label3	The custom label 3 attribute of a product item.
product_custom_label4	TEXT	Product custom label4	The custom label 4 attribute of a product item.
product_gender	TEXT	Product gender	The gender attribute of a product item.
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.
product_gtin	TEXT	Product gtin	The GTIN attribute (Global Trading Item Number) of a product item.
product_id	TEXT	Product id	The ID of the product associated with this conversion.
product_item_group_id	TEXT	Product item group id	The item group id attribute of a product item.
product_landing_page_url	TEXT	Product landing page url	The landing page attribute of a product item.
product_language	TEXT	Product language	The language (ISO 639-1) of the product associated this conversion.
product_material	TEXT	Product material	The material attribute of a product item.
product_mpn	TEXT	Product mpn	The MPN attribute (Manufacturer Part Number) of a product item.
product_pattern	TEXT	Product pattern	The pattern attribute of a product item.
product_price	NUMERIC	Product price	The price attribute of a product item.
product_revenue_from_units_sold	NUMERIC	Product revenue from units sold	The total revenue generated from a product (using the price reported on each product).
product_sale_price	NUMERIC	Product sale price	The price attribute of a product item.
product_size	TEXT	Product size	The size attribute of a product item.
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.
product_target_clickserver_url	TEXT	Product target clickserver url	The URL that DS uses to track activity. A user who clicks a shopping ad would visit the clickserver URL first, and then be redirected to the final landing page. See Shopping ads landing pages.
product_target_engine_id	TEXT	Product target engine id	ID of the product target in the external engine account.
product_target_filter	TEXT	Product target filter	Filters products in a Google Merchant Center account with this product target. You can specify matching criteria using attributes such as product IDs, brand, etc.
product_target_id	TEXT	Product target id	DS product target ID.
product_target_labels	TEXT	Product target labels	Names of labels directly assigned to this product target; inherited labels are not included.
product_target_landing_page	TEXT	Product target landing page	The value that indicates the final URL a user would visit after clicking on your shopping ad. See Shopping ads landing pages.
product_target_max_bid	NUMERIC	Product target max bid	If this product target is managed by a DS bid strategy, the bid strategy will never raise bids above this limit. See Apply a bid strategy to product targets.
product_target_max_cpc	NUMERIC	Product target max cpc	Overrides the ad group's max CPC and sets a maximum amount you are willing to pay if someone clicks a product ad for this specific product target. If this field is empty, the product target will use the ad group's max CPC.
product_target_min_bid	NUMERIC	Product target min bid	If this product target is managed by a DS bid strategy, the bid strategy will never lower bids below this limit. See Apply a bid strategy to product targets.
product_title	TEXT	Product title	The title attribute of a product item.
product_type_level1	TEXT	Product type level1	The product type leve 1 attribute of a product item.
product_type_level2	TEXT	Product type level2	The product type leve 2 attribute of a product item.
product_type_level3	TEXT	Product type level3	The product type leve 3 attribute of a product item.
product_type_level4	TEXT	Product type level4	The product type leve 4 attribute of a product item.
product_type_level5	TEXT	Product type level5	The product type leve 5 attribute of a product item.
product_units_sold	NUMERIC	Product units sold	The total number of units sold for a particular product.
province_targets	TEXT	Province targets	Province targets included in the ad group. Download upload templates and geo/language codes.
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.
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.
quarter_end	DATE	Quarter end	Segments the report by quarters; each row and its aggregate metrics are split into multiple rows, one for each quarter. This column returns the last day of the quarter of each row.
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.
roas_target	NUMERIC	Roas target	The target ROAS (return on ad spending) ratio of the bid 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.
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.
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, as a string > 90%.
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.
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, the string < 10%.
search_query	TEXT	Search query	The search terms that Google users entered.
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.
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, as a string > 90%.
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.
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.
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).
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.
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.
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.
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.
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.
spend	NUMERIC	Spend	Aggregate cost paid to engine account(s).
status	TEXT	Status	The status of the account: Active, Paused, or Removed.
top_impression_percentage	NUMERIC	Top impression percentage	Percent of your ad impressions that are shown anywhere above the organic search results.
top_of_page_bid_avg	NUMERIC	Top of page bid avg	Google Ads only. Approximates the average CPC bid needed during the report's time range for your ads to appear regularly in the top positions above the search results.
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.
unclassified_target_name	TEXT	Unclassified target name	The name of the unclassified target.
unclassified_target_type	TEXT	Unclassified target type	The type of the unclassified target: Dynamic search.
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_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_id	TEXT	Visit id	DS visit ID.
visit_network_type	TEXT	Visit network type	The ad network that generated this visit: Content, Search, or Other.
visit_referrer	TEXT	Visit referrer	The referrer URL of the visit.
visit_search_query	TEXT	Visit search query	The search query that generated this visit.
visit_timestamp	TIMESTAMP	Visit timestamp	The UTC timestamp when the visit occurred.
visits	NUMERIC	Visits	The total number of DS visits.
week_end	DATE	Week end	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 last day (Saturday) of each row.
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.
yahoo_geo_targets	TEXT	Yahoo geo targets	Geo targets for Yahoo Search Marketing campaigns. See Download upload templates and geo/language codes.
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.
year_end	DATE	Year end	Segments the report by years; each row and its aggregate metrics are split into multiple rows, one for each year. This column returns the last day of the year of each row.
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.