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 |
|---|---|---|---|
| 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 | Average position | 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 | COUNTRY | 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. |
| today | DATE | Today | Today's date |