PerStoreView
A per store view. This view provides per store impression reach and local action conversion stats for advertisers.
Columns
| Name | Type | Behavior | Description |
| CampaignId | Long | SEGMENT | Output only. The ID of the campaign. |
| CustomerId | Long | ATTRIBUTE | Output only. The ID of the customer. |
| PerStoreViewAddress1 | String | ATTRIBUTE | Output only. First line of the store's address. |
| PerStoreViewAddress2 | String | ATTRIBUTE | Output only. Second line of the store's address. |
| PerStoreViewBusinessName | String | ATTRIBUTE | Output only. The name of the business. |
| PerStoreViewCity | String | ATTRIBUTE | Output only. The city where the store is located. |
| PerStoreViewCountryCode | String | ATTRIBUTE | Output only. The two-letter country code for the store's location (e.g., 'US'). |
| PerStoreViewPhoneNumber | String | ATTRIBUTE | Output only. The phone number of the store. |
| PerStoreViewPlaceId | String | ATTRIBUTE | Output only. The place ID of the per store view. |
| PerStoreViewPostalCode | String | ATTRIBUTE | Output only. The postal code of the store's address. |
| PerStoreViewProvince | String | ATTRIBUTE | Output only. The province or state of the store's address. |
| PerStoreViewResourceName | String | ATTRIBUTE | Output only. The resource name of the per store view. Per Store view resource names have the form: customers/{customer_id}/perStoreViews/{place_id} |
| AllConversionsFromLocationAssetClickToCall | Double | METRIC | 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. |
| AllConversionsFromLocationAssetDirections | Double | METRIC | 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. |
| AllConversionsFromLocationAssetMenu | Double | METRIC | 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. |
| AllConversionsFromLocationAssetOrder | Double | METRIC | Number of order clicks on any location surface after a chargeable ad event (click or impression). This measure is coming from Asset based location. |
| AllConversionsFromLocationAssetOtherEngagement | Double | METRIC | 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. |
| AllConversionsFromLocationAssetStoreVisits | Double | METRIC | Estimated number of visits to the business after a chargeable ad event (click or impression). This measure is coming from Asset based location. |
| AllConversionsFromLocationAssetWebsite | Double | METRIC | 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. |
| EligibleImpressionsFromLocationAssetStoreReach | Long | METRIC | Number of impressions in which the business location was shown or the location was used for targeting. This measure is coming from Asset based location. |
| ViewThroughConversionsFromLocationAssetClickToCall | Double | METRIC | Number of call button clicks on any location surface after an impression. This measure is coming from Asset based location. |
| ViewThroughConversionsFromLocationAssetDirections | Double | METRIC | Number of driving directions clicks on any location surface after an impression. This measure is coming from Asset based location. |
| ViewThroughConversionsFromLocationAssetMenu | Double | METRIC | Number of menu link clicks on any location surface after an impression. This measure is coming from Asset based location. |
| ViewThroughConversionsFromLocationAssetOrder | Double | METRIC | Number of order clicks on any location surface after an impression. This measure is coming from Asset based location. |
| ViewThroughConversionsFromLocationAssetOtherEngagement | Double | METRIC | Number of other types of local action clicks on any location surface after an impression. This measure is coming from Asset based location. |
| ViewThroughConversionsFromLocationAssetStoreVisits | Double | METRIC | Estimated number of visits to the business after an impression. This measure is coming from Asset based location. |
| ViewThroughConversionsFromLocationAssetWebsite | Double | METRIC | Number of website URL clicks on any location surface after an impression. This measure is coming from Asset based location. |
| AdNetworkType | String | SEGMENT | Ad network type.
The allowed values are CONTENT, DISCOVER, GMAIL, GOOGLE_OWNED_CHANNELS, GOOGLE_TV, MAPS, MIXED, SEARCH, SEARCH_PARTNERS, UNKNOWN, YOUTUBE. |
| AdSubNetworkType | String | SEGMENT | Ad 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.
The allowed values are UNKNOWN, UNSEGMENTED, YOUTUBE_INFEED, YOUTUBE_INSTREAM, YOUTUBE_SHORTS. |
| Date | Date | SEGMENT | Date to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17. |
| DayOfWeek | String | SEGMENT | Day of the week, for example, MONDAY.
The allowed values are FRIDAY, MONDAY, SATURDAY, SUNDAY, THURSDAY, TUESDAY, UNKNOWN, WEDNESDAY. |
| Month | Date | SEGMENT | Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd. |
| MonthOfYear | String | SEGMENT | Month of the year, for example, January.
The allowed values are APRIL, AUGUST, DECEMBER, FEBRUARY, JANUARY, JULY, JUNE, MARCH, MAY, NOVEMBER, OCTOBER, SEPTEMBER, UNKNOWN. |
| Period | String | SEGMENT | Predefined date range.
The allowed values are TODAY, YESTERDAY, LAST_7_DAYS, LAST_BUSINESS_WEEK, THIS_MONTH, LAST_MONTH, LAST_14_DAYS, LAST_30_DAYS, THIS_WEEK_SUN_TODAY, THIS_WEEK_MON_TODAY, LAST_WEEK_SUN_SAT, LAST_WEEK_MON_SUN. |
| Quarter | Date | SEGMENT | 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. |
| Week | Date | SEGMENT | Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd. |
| Year | Int | SEGMENT | Year, formatted as yyyy. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |