conversion

A conversion.

Attributed resources
ad_group
ad_group_criterion
campaign
customer

Fields from the above resources may be selected along with this resource in your SELECT and WHERE clauses. These fields will not segment metrics in your SELECT clause.

Fields/Segments/Metrics

This page shows all metrics and segments that can be put in the same SELECT clause as the fields of conversion. However, when you specify conversion in the FROM clause, some metrics and segments cannot be used. Use the following filter to show only the fields that can be used when conversion is specified in the FROM clause.

Is conversion specified in the FROM clause of your query?

No Yes, it is

Resource fields ad_id advertiser_conversion_id asset_field_type asset_id attribution_type click_id conversion_date_time conversion_last_modified_date_time conversion_quantity conversion_revenue_micros conversion_visit_date_time criterion_id floodlight_order_id floodlight_original_revenue id merchant_id product_channel product_country_code product_id product_language_code product_store_id resource_name status visit_id

Segments ad_network_type conversion_action conversion_action_category conversion_action_name date device month quarter week year

conversion.ad_id Field description Ad ID. A value of 0 indicates that the ad is unattributed. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

conversion.advertiser_conversion_id Field description For offline conversions, this is an ID provided by advertisers. If an advertiser doesn't specify such an ID, Search Ads 360 generates one. For online conversions, this is equal to the id column or the floodlight_order_id column depending on the advertiser's Floodlight instructions. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

conversion.asset_field_type Field description Asset field type of the conversion event. Category ATTRIBUTE Data Type ENUM AD_IMAGE BOOK_ON_GOOGLE BUSINESS_LOGO BUSINESS_NAME CALL CALLOUT CALL_TO_ACTION_SELECTION DESCRIPTION DISCOVERY_CAROUSEL_CARD HEADLINE HOTEL_CALLOUT HOTEL_PROPERTY LANDSCAPE_LOGO LEAD_FORM LOGO LONG_HEADLINE MANDATORY_AD_TEXT MARKETING_IMAGE MEDIA_BUNDLE MOBILE_APP PORTRAIT_MARKETING_IMAGE PRICE PROMOTION SITELINK SQUARE_MARKETING_IMAGE STRUCTURED_SNIPPET UNKNOWN UNSPECIFIED VIDEO YOUTUBE_VIDEO Type URL google.ads.searchads360.v0.enums.AssetFieldTypeEnum.AssetFieldType Filterable True Selectable True Sortable True Repeated False

conversion.asset_id Field description ID of the asset which was interacted with during the conversion event. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

conversion.attribution_type Field description What the conversion is attributed to: Visit or Keyword+Ad. Category ATTRIBUTE Data Type ENUM CRITERION_AD UNKNOWN UNSPECIFIED VISIT Type URL google.ads.searchads360.v0.enums.AttributionTypeEnum.AttributionType Filterable True Selectable True Sortable True Repeated False

conversion.click_id Field description A unique string, for the visit that the conversion is attributed to, that is passed to the landing page as the click id URL parameter. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

conversion.conversion_date_time Field description The timestamp of the conversion event. Category ATTRIBUTE Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

conversion.conversion_last_modified_date_time Field description The timestamp of the last time the conversion was modified. Category ATTRIBUTE Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

conversion.conversion_quantity Field description The quantity of items recorded by the conversion, as determined by the qty url parameter. The advertiser is responsible for dynamically populating the parameter (such as number of items sold in the conversion), otherwise it defaults to 1. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

conversion.conversion_revenue_micros Field description The adjusted revenue in micros for the conversion event. This will always be in the currency of the serving account. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

conversion.conversion_visit_date_time Field description The timestamp of the visit that the conversion is attributed to. Category ATTRIBUTE Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

conversion.criterion_id Field description Search Ads 360 criterion ID. A value of 0 indicates that the criterion is unattributed. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

conversion.floodlight_order_id Field description The Floodlight order ID provided by the advertiser for the conversion. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

conversion.floodlight_original_revenue Field description The original, unchanged revenue associated with the Floodlight event (in the currency of the current report), before Floodlight currency instruction modifications. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

conversion.id Field description The ID of the conversion Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

conversion.merchant_id Field description The SearchAds360 inventory account ID containing the product that was clicked on. SearchAds360 generates this ID when you link an inventory account in SearchAds360. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

conversion.product_channel Field description The sales channel of the product that was clicked on: Online or Local. Category ATTRIBUTE Data Type ENUM LOCAL ONLINE UNKNOWN UNSPECIFIED Type URL google.ads.searchads360.v0.enums.ProductChannelEnum.ProductChannel Filterable True Selectable True Sortable True Repeated False

conversion.product_country_code Field description The country (ISO-3166-format) registered for the inventory feed that contains the product clicked on. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

conversion.product_id Field description The ID of the product clicked on. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

conversion.product_language_code Field description The language (ISO-639-1) that has been set for the Merchant Center feed containing data about the product. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

conversion.product_store_id Field description The store in the Local Inventory Ad that was clicked on. This should match the store IDs used in your local products feed. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

conversion.resource_name Field description The resource name of the conversion. Conversion resource names have the form: customers/{customer_id}/conversions/{ad_group_id}~{criterion_id}~{ds_conversion_id} Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

conversion.status Field description The status of the conversion, either ENABLED or REMOVED.. Category ATTRIBUTE Data Type ENUM ENABLED REMOVED UNKNOWN UNSPECIFIED Type URL google.ads.searchads360.v0.enums.ConversionStatusEnum.ConversionStatus Filterable True Selectable True Sortable True Repeated False

conversion.visit_id Field description The SearchAds360 visit ID that the conversion is attributed to. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.ad_network_type Field description Ad network type. Category SEGMENT Data Type ENUM CONTENT MIXED SEARCH SEARCH_PARTNERS UNKNOWN UNSPECIFIED YOUTUBE_SEARCH YOUTUBE_WATCH Type URL google.ads.searchads360.v0.enums.AdNetworkTypeEnum.AdNetworkType Filterable True Selectable True Sortable True Repeated False

segments.conversion_action Field description Resource name of the conversion action. Category SEGMENT Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.conversion_action_category Field description Conversion action category. Category SEGMENT Data Type ENUM ADD_TO_CART BEGIN_CHECKOUT BOOK_APPOINTMENT CONTACT CONVERTED_LEAD DEFAULT DOWNLOAD ENGAGEMENT GET_DIRECTIONS IMPORTED_LEAD LEAD OUTBOUND_CLICK PAGE_VIEW PHONE_CALL_LEAD PURCHASE QUALIFIED_LEAD REQUEST_QUOTE SIGNUP STORE_SALE STORE_VISIT SUBMIT_LEAD_FORM SUBSCRIBE_PAID UNKNOWN UNSPECIFIED Type URL google.ads.searchads360.v0.enums.ConversionActionCategoryEnum.ConversionActionCategory Filterable True Selectable True Sortable True Repeated False

segments.conversion_action_name Field description Conversion action name. Category SEGMENT Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.date Field description Date to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17. Category SEGMENT Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.device Field description Device to which metrics apply. Category SEGMENT Data Type ENUM CONNECTED_TV DESKTOP MOBILE OTHER TABLET UNKNOWN UNSPECIFIED Type URL google.ads.searchads360.v0.enums.DeviceEnum.Device Filterable True Selectable True Sortable True Repeated False

segments.month Field description Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd. Category SEGMENT Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.quarter Field description Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, for example, the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd. Category SEGMENT Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.week Field description Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd. Category SEGMENT Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.year Field description Year, formatted as yyyy. Category SEGMENT Data Type INT32 Type URL N/A Filterable True Selectable True Sortable True Repeated False