per_store_view

Help me build a query

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?

No Yes, it is

Resource fields place_id resource_name

Segments ad_network_type day_of_week month month_of_year quarter week year

Metrics all_conversions_from_location_asset_click_to_call all_conversions_from_location_asset_directions all_conversions_from_location_asset_menu all_conversions_from_location_asset_order all_conversions_from_location_asset_other_engagement all_conversions_from_location_asset_store_visits all_conversions_from_location_asset_website eligible_impressions_from_location_asset_store_reach view_through_conversions_from_location_asset_click_to_call view_through_conversions_from_location_asset_directions view_through_conversions_from_location_asset_menu view_through_conversions_from_location_asset_order view_through_conversions_from_location_asset_other_engagement view_through_conversions_from_location_asset_store_visits view_through_conversions_from_location_asset_website

per_store_view.place_id Field description Output only. The place ID of the per store view. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

per_store_view.resource_name Field description Output only. The resource name of the per store view. Per Store view resource names have the form: customers/{customer_id}/perStoreViews/{place_id} Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

segments.ad_network_type Field description Ad network type. Category SEGMENT Data Type ENUM CONTENT GOOGLE_TV MIXED SEARCH SEARCH_PARTNERS UNKNOWN UNSPECIFIED YOUTUBE Type URL google.ads.googleads.v16.enums.AdNetworkTypeEnum.AdNetworkType 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 ENUM FRIDAY MONDAY SATURDAY SUNDAY THURSDAY TUESDAY UNKNOWN UNSPECIFIED WEDNESDAY Type URL google.ads.googleads.v16.enums.DayOfWeekEnum.DayOfWeek 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.month_of_year Field description Month of the year, for example, January. Category SEGMENT Data Type ENUM APRIL AUGUST DECEMBER FEBRUARY JANUARY JULY JUNE MARCH MAY NOVEMBER OCTOBER SEPTEMBER UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v16.enums.MonthOfYearEnum.MonthOfYear 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.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.all_conversions_from_location_asset_click_to_call Field description Number of call button clicks on any location surface after a chargeable ad event (click or impression). This measure is coming from Asset based location. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.all_conversions_from_location_asset_directions Field description Number of driving directions clicks on any location surface after a chargeable ad event (click or impression). This measure is coming from Asset based location. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.all_conversions_from_location_asset_menu Field description Number of menu link clicks on any location surface after a chargeable ad event (click or impression). This measure is coming from Asset based location. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.all_conversions_from_location_asset_order Field description Number of order clicks on any location surface after a chargeable ad event (click or impression). This measure is coming from Asset based location. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.all_conversions_from_location_asset_other_engagement Field description Number 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. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.all_conversions_from_location_asset_store_visits Field description Estimated number of visits to the store after a chargeable ad event (click or impression). This measure is coming from Asset based location. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.all_conversions_from_location_asset_website Field description Number of website URL clicks on any location surface after a chargeable ad event (click or impression). This measure is coming from Asset based location. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.eligible_impressions_from_location_asset_store_reach Field description Number of impressions in which the store location was shown or the location was used for targeting. This measure is coming from Asset based location. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.view_through_conversions_from_location_asset_click_to_call Field description Number of call button clicks on any location surface after an impression. This measure is coming from Asset based location. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.view_through_conversions_from_location_asset_directions Field description Number of driving directions clicks on any location surface after an impression. This measure is coming from Asset based location. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.view_through_conversions_from_location_asset_menu Field description Number of menu link clicks on any location surface after an impression. This measure is coming from Asset based location. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.view_through_conversions_from_location_asset_order Field description Number of order clicks on any location surface after an impression. This measure is coming from Asset based location. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.view_through_conversions_from_location_asset_other_engagement Field description Number of other types of local action clicks on any location surface after an impression. This measure is coming from Asset based location. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.view_through_conversions_from_location_asset_store_visits Field description Estimated number of visits to the store after an impression. This measure is coming from Asset based location. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.view_through_conversions_from_location_asset_website Field description Number of website URL clicks on any location surface after an impression. This measure is coming from Asset based location. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False