ADO.NET Provider for Google Ads

Build 26.0.9655

PerStoreView

A per store view.

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.,
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.
AllConversionsFromLocationAssetClickToCall Double METRIC Number of call button clicks on any location surface after a chargeable ad
AllConversionsFromLocationAssetDirections Double METRIC Number of driving directions clicks on any location surface after a
AllConversionsFromLocationAssetMenu Double METRIC Number of menu link clicks on any location surface after a chargeable ad
AllConversionsFromLocationAssetOrder Double METRIC Number of order clicks on any location surface after a chargeable ad event
AllConversionsFromLocationAssetOtherEngagement Double METRIC Number of other types of local action clicks on any location surface after
AllConversionsFromLocationAssetStoreVisits Double METRIC Estimated number of visits to the business after a chargeable
AllConversionsFromLocationAssetWebsite Double METRIC Number of website URL clicks on any location surface after a chargeable ad
EligibleImpressionsFromLocationAssetStoreReach Long METRIC Number of impressions in which the business location was shown or the
ViewThroughConversionsFromLocationAssetClickToCall Double METRIC Number of call button clicks on any location surface after an impression.
ViewThroughConversionsFromLocationAssetDirections Double METRIC Number of driving directions clicks on any location surface after an
ViewThroughConversionsFromLocationAssetMenu Double METRIC Number of menu link clicks on any location surface after an impression.
ViewThroughConversionsFromLocationAssetOrder Double METRIC Number of order clicks on any location surface after an impression. This
ViewThroughConversionsFromLocationAssetOtherEngagement Double METRIC Number of other types of local action clicks on any location surface after
ViewThroughConversionsFromLocationAssetStoreVisits Double METRIC Estimated number of visits to the business after an impression.
ViewThroughConversionsFromLocationAssetWebsite Double METRIC Number of website URL clicks on any location surface after an impression.
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

The allowed values are UNKNOWN, UNSEGMENTED, YOUTUBE_INFEED, YOUTUBE_INSTREAM, YOUTUBE_SHORTS.

Date Date SEGMENT Date to which metrics apply.
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
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.
Week Date SEGMENT Week as defined as Monday through Sunday, and represented by the date of
Year Int SEGMENT Year, formatted as yyyy.

Pseudo-Columns

Pseudo column 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.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655