per_store_view

A per store view. This view provides per store impression reach and local action conversion stats for advertisers.

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 per_store_view. However, when you specify per_store_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 per_store_view is specified in the FROM clause.

Is per_store_view specified in the FROM clause of your query?

per_store_view.address1

Field descriptionOutput only. First line of the store's address.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

per_store_view.address2

Field descriptionOutput only. Second line of the store's address.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

per_store_view.business_name

Field descriptionOutput only. The name of the business.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

per_store_view.city

Field descriptionOutput only. The city where the store is located.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

per_store_view.country_code

Field descriptionOutput only. The two-letter country code for the store's location (e.g., "US").
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

per_store_view.phone_number

Field descriptionOutput only. The phone number of the store.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

per_store_view.place_id

Field descriptionOutput only. The place ID of the per store view.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

per_store_view.postal_code

Field descriptionOutput only. The postal code of the store's address.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

per_store_view.province

Field descriptionOutput only. The province or state of the store's address.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

per_store_view.resource_name

Field descriptionOutput only. The resource name of the per store view. Per Store view resource names have the form: customers/{customer_id}/perStoreViews/{place_id}
CategoryATTRIBUTE
Data TypeRESOURCE_NAME
Type URLN/A
FilterableTrue
SelectableTrue
SortableFalse
RepeatedFalse

segments.ad_network_type

Field descriptionAd network type.
CategorySEGMENT
Data Type
Type URLgoogle.ads.googleads.v23.enums.AdNetworkTypeEnum.AdNetworkType
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

segments.ad_sub_network_type

Field descriptionAd sub network type. Currently only available for ads running as part of DemandGen campaigns on YouTube and has to always be selected together with ad_network_type.
CategorySEGMENT
Data Type
Type URLgoogle.ads.googleads.v23.enums.AdSubNetworkTypeEnum.AdSubNetworkType
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

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

segments.day_of_week

Field descriptionDay of the week, for example, MONDAY.
CategorySEGMENT
Data Type
Type URLgoogle.ads.googleads.v23.enums.DayOfWeekEnum.DayOfWeek
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

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

segments.month_of_year

Field descriptionMonth of the year, for example, January.
CategorySEGMENT
Data Type
Type URLgoogle.ads.googleads.v23.enums.MonthOfYearEnum.MonthOfYear
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

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

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

segments.year

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

metrics.all_conversions_from_location_asset_click_to_call

Field descriptionNumber of call button clicks on any location surface after a chargeable ad event (click or impression). This measure is coming from Asset based location.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.all_conversions_from_location_asset_directions

Field descriptionNumber of driving directions clicks on any location surface after a chargeable ad event (click or impression). This measure is coming from Asset based location.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.all_conversions_from_location_asset_menu

Field descriptionNumber of menu link clicks on any location surface after a chargeable ad event (click or impression). This measure is coming from Asset based location.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.all_conversions_from_location_asset_order

Field descriptionNumber of order clicks on any location surface after a chargeable ad event (click or impression). This measure is coming from Asset based location.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.all_conversions_from_location_asset_other_engagement

Field descriptionNumber of other types of local action clicks on any location surface after a chargeable ad event (click or impression). This measure is coming from Asset based location.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.all_conversions_from_location_asset_store_visits

Field descriptionEstimated number of visits to the business after a chargeable ad event (click or impression). This measure is coming from Asset based location.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.all_conversions_from_location_asset_website

Field descriptionNumber of website URL clicks on any location surface after a chargeable ad event (click or impression). This measure is coming from Asset based location.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.eligible_impressions_from_location_asset_store_reach

Field descriptionNumber of impressions in which the business location was shown or the location was used for targeting. This measure is coming from Asset based location.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.view_through_conversions_from_location_asset_click_to_call

Field descriptionNumber of call button clicks on any location surface after an impression. This measure is coming from Asset based location.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.view_through_conversions_from_location_asset_directions

Field descriptionNumber of driving directions clicks on any location surface after an impression. This measure is coming from Asset based location.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.view_through_conversions_from_location_asset_menu

Field descriptionNumber of menu link clicks on any location surface after an impression. This measure is coming from Asset based location.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.view_through_conversions_from_location_asset_order

Field descriptionNumber of order clicks on any location surface after an impression. This measure is coming from Asset based location.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.view_through_conversions_from_location_asset_other_engagement

Field descriptionNumber of other types of local action clicks on any location surface after an impression. This measure is coming from Asset based location.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.view_through_conversions_from_location_asset_store_visits

Field descriptionEstimated number of visits to the business after an impression. This measure is coming from Asset based location.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.view_through_conversions_from_location_asset_website

Field descriptionNumber of website URL clicks on any location surface after an impression. This measure is coming from Asset based location.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with