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?

 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 descriptionAd ID. A value of 0 indicates that the ad is unattributed.
CategoryATTRIBUTE
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

conversion.advertiser_conversion_id

Field descriptionFor 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.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

conversion.asset_field_type

Field descriptionAsset field type of the conversion event.
CategoryATTRIBUTE
Data Type
Type URLgoogle.ads.searchads360.v0.enums.AssetFieldTypeEnum.AssetFieldType
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

conversion.asset_id

Field descriptionID of the asset which was interacted with during the conversion event.
CategoryATTRIBUTE
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

conversion.attribution_type

Field descriptionWhat the conversion is attributed to: Visit or Keyword+Ad.
CategoryATTRIBUTE
Data Type
Type URLgoogle.ads.searchads360.v0.enums.AttributionTypeEnum.AttributionType
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

conversion.click_id

Field descriptionA unique string, for the visit that the conversion is attributed to, that is passed to the landing page as the click id URL parameter.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

conversion.conversion_date_time

Field descriptionThe timestamp of the conversion event.
CategoryATTRIBUTE
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

conversion.conversion_last_modified_date_time

Field descriptionThe timestamp of the last time the conversion was modified.
CategoryATTRIBUTE
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

conversion.conversion_quantity

Field descriptionThe 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.
CategoryATTRIBUTE
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

conversion.conversion_revenue_micros

Field descriptionThe adjusted revenue in micros for the conversion event. This will always be in the currency of the serving account.
CategoryATTRIBUTE
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

conversion.conversion_visit_date_time

Field descriptionThe timestamp of the visit that the conversion is attributed to.
CategoryATTRIBUTE
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

conversion.criterion_id

Field descriptionSearch Ads 360 criterion ID. A value of 0 indicates that the criterion is unattributed.
CategoryATTRIBUTE
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

conversion.floodlight_order_id

Field descriptionThe Floodlight order ID provided by the advertiser for the conversion.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

conversion.floodlight_original_revenue

Field descriptionThe original, unchanged revenue associated with the Floodlight event (in the currency of the current report), before Floodlight currency instruction modifications.
CategoryATTRIBUTE
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

conversion.id

Field descriptionThe ID of the conversion
CategoryATTRIBUTE
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

conversion.merchant_id

Field descriptionThe Search Ads 360 inventory account ID containing the product that was clicked on. Search Ads 360 generates this ID when you link an inventory account in Search Ads 360.
CategoryATTRIBUTE
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

conversion.product_channel

Field descriptionThe sales channel of the product that was clicked on: Online or Local.
CategoryATTRIBUTE
Data Type
Type URLgoogle.ads.searchads360.v0.enums.ProductChannelEnum.ProductChannel
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

conversion.product_country_code

Field descriptionThe country (ISO-3166-format) registered for the inventory feed that contains the product clicked on.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

conversion.product_id

Field descriptionThe ID of the product clicked on.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

conversion.product_language_code

Field descriptionThe language (ISO-639-1) that has been set for the Merchant Center feed containing data about the product.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

conversion.product_store_id

Field descriptionThe store in the Local Inventory Ad that was clicked on. This should match the store IDs used in your local products feed.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

conversion.resource_name

Field descriptionThe resource name of the conversion. Conversion resource names have the form: customers/{customer_id}/conversions/{ad_group_id}~{criterion_id}~{ds_conversion_id}
CategoryATTRIBUTE
Data TypeRESOURCE_NAME
Type URLN/A
FilterableTrue
SelectableTrue
SortableFalse
RepeatedFalse

conversion.status

Field descriptionThe status of the conversion, either ENABLED or REMOVED..
CategoryATTRIBUTE
Data Type
Type URLgoogle.ads.searchads360.v0.enums.ConversionStatusEnum.ConversionStatus
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

conversion.visit_id

Field descriptionThe Search Ads 360 visit ID that the conversion is attributed to.
CategoryATTRIBUTE
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.ad_network_type

Field descriptionAd network type.
CategorySEGMENT
Data Type
Type URLgoogle.ads.searchads360.v0.enums.AdNetworkTypeEnum.AdNetworkType
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.conversion_action

Field descriptionResource name of the conversion action.
CategorySEGMENT
Data TypeRESOURCE_NAME
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.conversion_action_category

Field descriptionConversion action category.
CategorySEGMENT
Data Type
Type URLgoogle.ads.searchads360.v0.enums.ConversionActionCategoryEnum.ConversionActionCategory
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.conversion_action_name

Field descriptionConversion action name.
CategorySEGMENT
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.date

Field descriptionDate to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17.
CategorySEGMENT
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.device

Field descriptionDevice to which metrics apply.
CategorySEGMENT
Data Type
Type URLgoogle.ads.searchads360.v0.enums.DeviceEnum.Device
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.month

Field descriptionMonth as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
CategorySEGMENT
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.quarter

Field descriptionQuarter 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.
CategorySEGMENT
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.week

Field descriptionWeek as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
CategorySEGMENT
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.year

Field descriptionYear, formatted as yyyy.
CategorySEGMENT
Data TypeINT32
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse