location_view

A location view summarizes the performance of campaigns by a Location criterion. If no Location criterion is set, no results are returned; instead, use geographic_view or user_location_view for visitor location data.

Attributed resources
campaign
campaign_criterion
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 location_view. However, when you specify location_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 location_view is specified in the FROM clause.

Is location_view specified in the FROM clause of your query?

location_view.resource_name

Field description

Output only. The resource name of the location view. Location view resource names have the form: customers/{customer_id}/locationViews/{campaign_id}~{criterion_id}

CategoryATTRIBUTE
Data TypeRESOURCE_NAME
Type URLN/A
FilterableTrue
SelectableTrue
SortableFalse
RepeatedFalse

segments.conversion_action

Field description

Resource name of the conversion action.

CategorySEGMENT
Data TypeRESOURCE_NAME
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

segments.conversion_action_category

Field description

Conversion action category.

CategorySEGMENT
Data Type
Type URLgoogle.ads.googleads.v24.enums.ConversionActionCategoryEnum.ConversionActionCategory
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

segments.conversion_action_name

Field description

Conversion action name.

CategorySEGMENT
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

segments.date

Field description

Date to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17.

CategorySEGMENT
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

segments.external_conversion_source

Field description

External conversion source.

CategorySEGMENT
Data Type
Type URLgoogle.ads.googleads.v24.enums.ExternalConversionSourceEnum.ExternalConversionSource
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

segments.month

Field description

Month 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
Selectable with

segments.month_of_year

Field description

Month of the year, for example, January.

CategorySEGMENT
Data Type
Type URLgoogle.ads.googleads.v24.enums.MonthOfYearEnum.MonthOfYear
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

segments.new_versus_returning_customers

Field description

This is for segmenting conversions by whether the user is a new customer or a returning customer. This segmentation is typically used to measure the impact of customer acquisition goal.

CategorySEGMENT
Data Type
Type URLgoogle.ads.googleads.v24.enums.ConvertingUserPriorEngagementTypeAndLtvBucketEnum.ConvertingUserPriorEngagementTypeAndLtvBucket
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

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.

CategorySEGMENT
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

segments.week

Field description

Week 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
Selectable with

segments.year

Field description

Year, formatted as yyyy.

CategorySEGMENT
Data TypeINT32
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.all_conversions

Field description

The 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
Selectable with

metrics.all_conversions_from_interactions_rate

Field description

All 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
Selectable with

metrics.all_conversions_value

Field description

The value of all conversions.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.average_cost

Field description

The average amount you pay per interaction. This amount is the total cost of your ads divided by the total number of interactions.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.average_cpc

Field description

The total cost of all clicks divided by the total number of clicks received.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.average_cpe

Field description

The average amount that you've been charged for an ad engagement. This amount is the total cost of all ad engagements divided by the total number of ad engagements.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.average_cpm

Field description

Average cost-per-thousand impressions (CPM).

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.clicks

Field description

The number of clicks.

CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.conversions

Field description

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
Selectable with

metrics.conversions_from_interactions_rate

Field description

Conversions 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
Selectable with

metrics.conversions_value

Field description

The 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
Selectable with

metrics.cost_micros

Field description

The 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
Selectable with

metrics.cost_per_all_conversions

Field description

The cost of ad interactions divided by all conversions.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.cost_per_conversion

Field description

The 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
Selectable with

metrics.cross_device_conversions

Field description

Conversions 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
Selectable with

metrics.ctr

Field description

The 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
Selectable with

metrics.engagement_rate

Field description

How often people engage with your ad after it's shown to them. This is the number of ad expansions divided by the number of times your ad is shown.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.engagements

Field description

The number of engagements. An engagement occurs when a viewer expands your Lightbox ad. Also, in the future, other ad types may support engagement metrics.

CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.impressions

Field description

Count 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
Selectable with

metrics.interaction_event_types

Field description

The types of payable and free interactions.

CategoryMETRIC
Data TypeENUM
Type URLgoogle.ads.googleads.v24.enums.InteractionEventTypeEnum.InteractionEventType
FilterableTrue
SelectableTrue
SortableFalse
RepeatedTrue
Selectable with

metrics.interaction_rate

Field description

How often people interact with your ad after it is shown to them. This is the number of interactions divided by the number of times your ad is shown.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.interactions

Field description

The number of interactions. An interaction is the main user action associated with an ad format-clicks for text and shopping ads, views for video ads, and so on.

CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.trueview_average_cpv

Field description

The average amount you pay each time someone views your ad. The average CPV is defined by the total cost of all ad views divided by the number of TrueView views.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.value_per_all_conversions

Field description

The value of all conversions divided by the number of all conversions.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.value_per_conversion

Field description

The 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
Selectable with

metrics.video_trueview_view_rate

Field description

The number of TrueView views your video ad receives divided by its number of impressions, including thumbnail impressions for TrueView in-display ads.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.video_trueview_views

Field description

The number of TrueView views your video ads received.

CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.view_through_conversions

Field description

The 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
Selectable with