Power BI Connector for Google Ads

Build 24.0.9060

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.

The allowed values are 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.

The allowed values are 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.

The allowed values are APRIL, AUGUST, DECEMBER, FEBRUARY, JANUARY, JULY, JUNE, MARCH, MAY, NOVEMBER, OCTOBER, SEPTEMBER, UNKNOWN, UNSPECIFIED.

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.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are 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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060