Page Summary
-
The User Location View provides geographical insights into campaign performance by aggregating metrics at the country level, distinguishing between targeted and non-targeted locations.
-
Marketers can leverage segments like ad network type, conversion details, date ranges, device, and geographical targets (city, metro, region) to analyze user location data.
-
A wide array of metrics, including clicks, conversions, cost, impressions, and interaction rates, can be queried to understand user behavior and campaign effectiveness across different locations.
-
Resources like customer data can be selected for analysis, while ad group and campaign data can be utilized to segment the metrics for deeper insights.
-
The provided table outlines various fields, segments, and metrics available within the
user_location_view, specifying their data types, filterability, selectability, and sortability for customized reporting.
A user location view. User Location View includes all metrics aggregated at the country level, one row per country. It reports metrics at the actual physical location of the user by targeted or not targeted location. If other segment fields are used, you may get more than one row per country.
| 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 |
|---|
| ad_group |
| 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 user_location_view
.
However, when you specify user_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 user_location_view
is specified in the FROM clause.
Is user_location_view
specified in the FROM clause of your query?
| Resource fields |
|---|
| country_criterion_id |
| resource_name |
| targeting_location |
user_location_view.country_criterion_id
Field description
Criterion Id for the country.
Category
ATTRIBUTE
Data Type
INT64
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
user_location_view.resource_name
Field description
The resource name of the user location view. UserLocation view resource names have the form:
customers/{customer_id}/userLocationViews/{country_criterion_id}~{targeting_location}
Category
ATTRIBUTE
Data Type
RESOURCE_NAME
Type URL
N/A
Filterable
True
Selectable
True
Sortable
False
Repeated
False
user_location_view.targeting_location
Field description
Indicates whether location was targeted or not.
Category
ATTRIBUTE
Data Type
BOOLEAN
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
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
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.day_of_week
Field description
Day of the week, for example, MONDAY.
Category
SEGMENT
Data Type
Type URL
google.ads.searchads360.v0.enums.DayOfWeekEnum.DayOfWeek
Filterable
True
Selectable
True
Sortable
True
Repeated
False
segments.device
Field description
Device to which metrics apply.
Category
SEGMENT
Data Type
Type URL
google.ads.searchads360.v0.enums.DeviceEnum.Device
Filterable
True
Selectable
True
Sortable
True
Repeated
False
segments.geo_target_city
Field description
Resource name of the geo target constant that represents a city.
Category
SEGMENT
Data Type
RESOURCE_NAME
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
segments.geo_target_metro
Field description
Resource name of the geo target constant that represents a metro.
Category
SEGMENT
Data Type
RESOURCE_NAME
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
segments.geo_target_postal_code
Field description
Resource name of the geo target constant that represents a postal code.
Category
SEGMENT
Data Type
RESOURCE_NAME
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
segments.geo_target_region
Field description
Resource name of the geo target constant that represents a region.
Category
SEGMENT
Data Type
RESOURCE_NAME
Type URL
N/A
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.vertical_ads_event_participant_display_names
Field description
The display names of participants in an event listing, like performers, speakers, or teams.
Category
SEGMENT
Data Type
STRING
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
segments.vertical_ads_hotel_class
Field description
The class of the hotel. Generally in the range of 1 to 5 stars, but fully customizable in the hotel feed.
Category
SEGMENT
Data Type
INT64
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
segments.vertical_ads_listing
Field description
The listing associated with a listing impression, click or conversion.
Category
SEGMENT
Data Type
STRING
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
segments.vertical_ads_listing_brand
Field description
The brand associated with a specific listing within a Vertical Ads context, for example, the brand of a car rental, a vacation home, or an event.
Category
SEGMENT
Data Type
STRING
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
segments.vertical_ads_listing_city
Field description
The city where the vertical ads listing is located.
Category
SEGMENT
Data Type
RESOURCE_NAME
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
segments.vertical_ads_listing_country
Field description
The country where the vertical ads listing is located.
Category
SEGMENT
Data Type
RESOURCE_NAME
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
segments.vertical_ads_listing_region
Field description
The region where the vertical ads listing is located.
Category
SEGMENT
Data Type
RESOURCE_NAME
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
segments.vertical_ads_partner_account
Field description
A specific partner account within a Partner Center (for example, Hotel Center) that supplies inventory feed data for Vertical Ads.
Category
SEGMENT
Data Type
INT64
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
segments.vertical_ads_vertical
Field description
Type of vertical ad, such as Vacation Rentals, Car Rentals, or Events, used to categorize and segment data in the context of Vertical Ads.
Category
SEGMENT
Data Type
Type URL
google.ads.searchads360.v0.enums.VerticalAdsItemVerticalTypeEnum.VerticalAdsItemVerticalType
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
metrics.absolute_top_impression_percentage
Field description
Search absolute top impression share is the percentage of your Search ad impressions that are shown in the most prominent Search position.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.all_conversions
Field description
The total number of conversions. This includes all conversions regardless of the value of include_in_conversions_metric.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.all_conversions_by_conversion_date
Field description
The total number of conversions. This includes all conversions regardless of the value of include_in_conversions_metric. When this column is selected with date, the values in date column means the conversion date. Details for the by_conversion_date columns are available at https://support.google.com/sa360/answer/9250611
.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
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.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.all_conversions_from_interactions_value_per_interaction
Field description
The value of all conversions from interactions divided by the total number of interactions.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.all_conversions_value
Field description
The value of all conversions.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.all_conversions_value_by_conversion_date
Field description
The value of all conversions. When this column is selected with date, the values in date column means the conversion date. Details for the by_conversion_date columns are available at https://support.google.com/sa360/answer/9250611
.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.all_conversions_value_per_cost
Field description
The value of all conversions divided by the total cost of ad interactions (such as clicks for text ads or views for video ads).
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
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.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.average_cpc
Field description
The total cost of all clicks divided by the total number of clicks received. This metric is a monetary value and returned in the customer's currency by default. See the metrics_currency parameter at https://developers.google.com/search-ads/reporting/query/query-structure#parameters_clause
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.average_cpm
Field description
Average cost-per-thousand impressions (CPM). This metric is a monetary value and returned in the customer's currency by default. See the metrics_currency parameter at https://developers.google.com/search-ads/reporting/query/query-structure#parameters_clause
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.average_impression_frequency_per_user
Field description
The average number of times a unique user saw your ad during the requested time period. This metric cannot be aggregated, and can only be requested for date ranges of 92 days or less. This metric is available for following campaign types - Display, Video, Discovery and App.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.clicks
Field description
The number of clicks.
Category
METRIC
Data Type
INT64
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.client_account_conversions
Field description
The number of client account conversions. This only includes conversion actions which include_in_client_account_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.client_account_conversions_value
Field description
The value of client account conversions. This only includes conversion actions which include_in_client_account_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.client_account_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.
Category
METRIC
Data Type
INT64
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
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.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.conversions_by_conversion_date
Field description
The sum of conversions by conversion date for biddable conversion types. Can be fractional due to attribution modeling. When this column is selected with date, the values in date column means the conversion date.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.conversions_from_interactions_rate
Field description
Average biddable conversions (from interaction) per conversion eligible interaction. Shows how often, on average, an ad interaction leads to a biddable conversion.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.conversions_from_interactions_value_per_interaction
Field description
The value of conversions from interactions divided by the number of ad interactions. 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.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.conversions_value
Field description
The sum of conversion values for the conversions included in the "conversions" field. This metric is useful only if you entered a value for your conversion actions.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.conversions_value_by_conversion_date
Field description
The sum of biddable conversions value by conversion date. When this column is selected with date, the values in date column means the conversion date.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.conversions_value_per_cost
Field description
The value of biddable conversion divided by the total cost of conversion eligible interactions.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.cost_micros
Field description
The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period. This metric is a monetary value and returned in the customer's currency by default. See the metrics_currency parameter at https://developers.google.com/search-ads/reporting/query/query-structure#parameters_clause
Category
METRIC
Data Type
INT64
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.cost_per_all_conversions
Field description
The cost of ad interactions divided by all conversions.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.cost_per_conversion
Field description
Average conversion eligible cost per biddable conversion.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.cross_device_conversions
Field description
Conversions from when a customer clicks on an ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.cross_device_conversions_by_conversion_date
Field description
The number of cross-device conversions by conversion date. Details for the by_conversion_date columns are available at https://support.google.com/sa360/answer/9250611
.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.cross_device_conversions_value
Field description
The sum of the value of cross-device conversions.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.cross_device_conversions_value_by_conversion_date
Field description
The sum of cross-device conversions value by conversion date. Details for the by_conversion_date columns are available at https://support.google.com/sa360/answer/9250611
.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.ctr
Field description
The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.impressions
Field description
Count of how often your ad has appeared on a search results page or website on the Google Network.
Category
METRIC
Data Type
INT64
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.interaction_event_types
Field description
The types of payable and free interactions.
Category
METRIC
Data Type
ENUM
Type URL
google.ads.searchads360.v0.enums.InteractionEventTypeEnum.InteractionEventType
Filterable
True
Selectable
True
Sortable
False
Repeated
True
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.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
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.
Category
METRIC
Data Type
INT64
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.search_absolute_top_impression_share
Field description
The percentage of the customer's Shopping or Search ad impressions that are shown in the most prominent Shopping position. See https://support.google.com/sa360/answer/9566729
for details. Any value below 0.1 is reported as 0.0999.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.search_budget_lost_absolute_top_impression_share
Field description
The number estimating how often your ad wasn't the very first ad among the top ads in the search results due to a low budget. Note: Search budget lost absolute top impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.search_budget_lost_impression_share
Field description
The estimated percent of times that your ad was eligible to show on the Search Network but didn't because your budget was too low. Note: Search budget lost impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.search_budget_lost_top_impression_share
Field description
The number estimating how often your ad didn't show adjacent to the top organic search results due to a low budget. Note: Search budget lost top impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.search_click_share
Field description
The number of clicks you've received on the Search Network divided by the estimated number of clicks you were eligible to receive. Note: Search click share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.search_impression_share
Field description
The impressions you've received on the Search Network divided by the estimated number of impressions you were eligible to receive. Note: Search impression share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.search_rank_lost_absolute_top_impression_share
Field description
The number estimating how often your ad wasn't the very first ad among the top ads in the search results due to poor Ad Rank. Note: Search rank lost absolute top impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.search_rank_lost_impression_share
Field description
The estimated percentage of impressions on the Search Network that your ads didn't receive due to poor Ad Rank. Note: Search rank lost impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.search_rank_lost_top_impression_share
Field description
The number estimating how often your ad didn't show adjacent to the top organic search results due to poor Ad Rank. Note: Search rank lost top impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.search_top_impression_share
Field description
The impressions you've received among the top ads compared to the estimated number of impressions you were eligible to receive among the top ads. Note: Search top impression share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999. Top ads are generally above the top organic results, although they may show below the top organic results on certain queries.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.top_impression_percentage
Field description
The percent of your ad impressions that are shown adjacent to the top organic search results.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.unique_users
Field description
The number of unique users who saw your ad during the requested time period. This metric cannot be aggregated, and can only be requested for date ranges of 92 days or less. This metric is available for following campaign types - Display, Video, Discovery and App.
Category
METRIC
Data Type
INT64
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.value_per_all_conversions
Field description
The value of all conversions divided by the number of all conversions.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.value_per_all_conversions_by_conversion_date
Field description
The value of all conversions divided by the number of all conversions. When this column is selected with date, the values in date column means the conversion date. Details for the by_conversion_date columns are available at https://support.google.com/sa360/answer/9250611
.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.value_per_conversion
Field description
The value of biddable conversion divided by the number of biddable conversions. Shows how much, on average, each of the biddable conversions is worth.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
metrics.value_per_conversions_by_conversion_date
Field description
Biddable conversions value by conversion date divided by biddable conversions by conversion date. Shows how much, on average, each of the biddable conversions is worth (by conversion date). When this column is selected with date, the values in date column means the conversion date.
Category
METRIC
Data Type
DOUBLE
Type URL
N/A
Filterable
True
Selectable
True
Sortable
True
Repeated
False
