distance_view

A distance view with metrics aggregated by the user's distance from an advertiser's location extensions. Each DistanceBucket includes all impressions that fall within its distance and a single impression will contribute to the metrics for all DistanceBuckets that include the user's distance.

Attributed resources
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.

Segmenting resources
campaign

Fields from the above resources, when selected along with this resource in your SELECT and WHERE clauses, will segment metrics.

Fields/Segments/Metrics

This page shows all metrics and segments that can be put in the same SELECT clause as the fields of distance_view. However, when you specify distance_view 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 distance_view is specified in the FROM clause.

Is distance_view specified in the FROM clause of your query?

  • No
  • Yes, it is

distance_view.distance_bucket

Field descriptionOutput only. Grouping of user distance from location extensions.
CategoryATTRIBUTE
Data Type
BEYOND_40MILES
BEYOND_65KM
UNKNOWN
UNSPECIFIED
WITHIN_0_7MILES
WITHIN_10KM
WITHIN_10MILES
WITHIN_15KM
WITHIN_15MILES
WITHIN_1KM
WITHIN_1MILE
WITHIN_20KM
WITHIN_20MILES
WITHIN_25KM
WITHIN_25MILES
WITHIN_30KM
WITHIN_30MILES
WITHIN_35KM
WITHIN_35MILES
WITHIN_40KM
WITHIN_40MILES
WITHIN_45KM
WITHIN_50KM
WITHIN_55KM
WITHIN_5KM
WITHIN_5MILES
WITHIN_60KM
WITHIN_65KM
WITHIN_700M
Type URLgoogle.ads.googleads.v18.enums.DistanceBucketEnum.DistanceBucket
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

distance_view.metric_system

Field descriptionOutput only. True if the DistanceBucket is using the metric system, false otherwise.
CategoryATTRIBUTE
Data TypeBOOLEAN
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

distance_view.resource_name

Field descriptionOutput only. The resource name of the distance view. Distance view resource names have the form: customers/{customer_id}/distanceViews/1~{distance_bucket}
CategoryATTRIBUTE
Data TypeRESOURCE_NAME
Type URLN/A
FilterableTrue
SelectableTrue
SortableFalse
RepeatedFalse

segments.ad_network_type

Field descriptionAd network type.
CategorySEGMENT
Data Type
CONTENT
GOOGLE_OWNED_CHANNELS
GOOGLE_TV
MIXED
SEARCH
SEARCH_PARTNERS
UNKNOWN
UNSPECIFIED
YOUTUBE
Type URLgoogle.ads.googleads.v18.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
ADD_TO_CART
BEGIN_CHECKOUT
BOOK_APPOINTMENT
CONTACT
CONVERTED_LEAD
DEFAULT
DOWNLOAD
ENGAGEMENT
GET_DIRECTIONS
IMPORTED_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 URLgoogle.ads.googleads.v18.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.day_of_week

Field descriptionDay of the week, for example, MONDAY.
CategorySEGMENT
Data Type
FRIDAY
MONDAY
SATURDAY
SUNDAY
THURSDAY
TUESDAY
UNKNOWN
UNSPECIFIED
WEDNESDAY
Type URLgoogle.ads.googleads.v18.enums.DayOfWeekEnum.DayOfWeek
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.device

Field descriptionDevice to which metrics apply.
CategorySEGMENT
Data Type
CONNECTED_TV
DESKTOP
MOBILE
OTHER
TABLET
UNKNOWN
UNSPECIFIED
Type URLgoogle.ads.googleads.v18.enums.DeviceEnum.Device
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.external_conversion_source

Field descriptionExternal conversion source.
CategorySEGMENT
Data Type
AD_CALL_METRICS
ANALYTICS
ANALYTICS_SEARCH_ADS_360
ANDROID_FIRST_OPEN
ANDROID_IN_APP
APP_UNSPECIFIED
CLICK_TO_CALL
DISPLAY_AND_VIDEO_360_FLOODLIGHT
FIREBASE
FIREBASE_SEARCH_ADS_360
FLOODLIGHT
GOOGLE_ATTRIBUTION
GOOGLE_HOSTED
GOOGLE_PLAY
IOS_FIRST_OPEN
IOS_IN_APP
SALESFORCE
SEARCH_ADS_360
STORE_SALES
STORE_SALES_CRM
STORE_SALES_DIRECT_UPLOAD
STORE_SALES_PAYMENT_NETWORK
STORE_VISITS
THIRD_PARTY_APP_ANALYTICS
UNKNOWN
UNSPECIFIED
UPLOAD
UPLOAD_CALLS
WEBPAGE
WEBSITE_CALL_METRICS
Type URLgoogle.ads.googleads.v18.enums.ExternalConversionSourceEnum.ExternalConversionSource
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.month_of_year

Field descriptionMonth of the year, for example, January.
CategorySEGMENT
Data Type
APRIL
AUGUST
DECEMBER
FEBRUARY
JANUARY
JULY
JUNE
MARCH
MAY
NOVEMBER
OCTOBER
SEPTEMBER
UNKNOWN
UNSPECIFIED
Type URLgoogle.ads.googleads.v18.enums.MonthOfYearEnum.MonthOfYear
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

metrics.all_conversions

Field descriptionThe total number of conversions. This includes all conversions regardless of the value of include_in_conversions_metric.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.all_conversions_from_interactions_rate

Field descriptionAll conversions from interactions (as oppose to view through conversions) divided by the number of ad interactions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.all_conversions_value

Field descriptionThe value of all conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.average_cpc

Field descriptionThe total cost of all clicks divided by the total number of clicks received.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.average_cpm

Field descriptionAverage cost-per-thousand impressions (CPM).
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.clicks

Field descriptionThe number of clicks.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.conversions

Field descriptionThe number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.conversions_from_interactions_rate

Field descriptionConversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.conversions_value

Field descriptionThe value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.cost_micros

Field descriptionThe sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.cost_per_all_conversions

Field descriptionThe cost of ad interactions divided by all conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.cost_per_conversion

Field descriptionThe cost of ad interactions divided by conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.cross_device_conversions

Field descriptionConversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.ctr

Field descriptionThe number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.impressions

Field descriptionCount of how often your ad has appeared on a search results page or website on the Google Network.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.value_per_all_conversions

Field descriptionThe value of all conversions divided by the number of all conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.value_per_conversion

Field descriptionThe value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.view_through_conversions

Field descriptionThe total number of view-through conversions. These happen when a customer sees an image or rich media ad, then later completes a conversion on your site without interacting with (for example, clicking on) another ad.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse