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. |
| PerStoreViewPlaceId | String | ATTRIBUTE | Output only. The place ID of the per store view. |
| 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 store 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 store 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 store 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.
使用できる値は次のとおりです。CONTENT, GOOGLE_TV, MIXED, SEARCH, SEARCH_PARTNERS, UNKNOWN, UNSPECIFIED, YOUTUBE |
| 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.
使用できる値は次のとおりです。FRIDAY, MONDAY, SATURDAY, SUNDAY, THURSDAY, TUESDAY, UNKNOWN, UNSPECIFIED, 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.
使用できる値は次のとおりです。APRIL, AUGUST, DECEMBER, FEBRUARY, JANUARY, JULY, JUNE, MARCH, MAY, NOVEMBER, OCTOBER, SEPTEMBER, UNKNOWN, UNSPECIFIED |
| Period | String | SEGMENT | Predefined date range.
使用できる値は次のとおりです。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. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |