CData ODBC Driver for Google Ads 2019J - Online Help

UserAdDistance

CData ODBC Driver for Google Ads 2019J - Build 19.0.7354

The User Ad Distance Report provides statistics aggregated by the user's distance from your location extensions.

Columns

Name Type Behavior DisplayName Description
AccountCurrencyCode String Attribute Currency Currency for the UserAdDistance report.
AccountDescriptiveName String Attribute Account Account for the UserAdDistance report.
AccountTimeZone String Attribute Time Zone Time Zone for the UserAdDistance report.
CampaignId Long Attribute Campaign ID Campaign ID for the UserAdDistance report.
CampaignName String Attribute Campaign Campaign for the UserAdDistance report.
CampaignStatus String Attribute Campaign State Campaign State for the UserAdDistance report.

使用できる値は次のとおりです。UNKNOWN, ENABLED, PAUSED, REMOVED

CustomerDescriptiveName String Attribute Client Name Client Name for the UserAdDistance report.
DistanceBucket String Attribute Distance From Location Extensions Distance From Location Extensions for the UserAdDistance report.

使用できる値は次のとおりです。DISTANCE_BUCKET_WITHIN_200M, DISTANCE_BUCKET_WITHIN_500M, DISTANCE_BUCKET_WITHIN_700M, DISTANCE_BUCKET_WITHIN_1KM, DISTANCE_BUCKET_WITHIN_5KM, DISTANCE_BUCKET_WITHIN_10KM, DISTANCE_BUCKET_WITHIN_15KM, DISTANCE_BUCKET_WITHIN_20KM, DISTANCE_BUCKET_WITHIN_25KM, DISTANCE_BUCKET_WITHIN_30KM, DISTANCE_BUCKET_WITHIN_35KM, DISTANCE_BUCKET_WITHIN_40KM, DISTANCE_BUCKET_WITHIN_45KM, DISTANCE_BUCKET_WITHIN_50KM, DISTANCE_BUCKET_WITHIN_55KM, DISTANCE_BUCKET_WITHIN_60KM, DISTANCE_BUCKET_WITHIN_65KM, DISTANCE_BUCKET_BEYOND_65KM, DISTANCE_BUCKET_WITHIN_0_2MILES, DISTANCE_BUCKET_WITHIN_0_5MILES, DISTANCE_BUCKET_WITHIN_0_7MILES, DISTANCE_BUCKET_WITHIN_1MILE, DISTANCE_BUCKET_WITHIN_5MILES, DISTANCE_BUCKET_WITHIN_10MILES, DISTANCE_BUCKET_WITHIN_15MILES, DISTANCE_BUCKET_WITHIN_20MILES, DISTANCE_BUCKET_WITHIN_25MILES, DISTANCE_BUCKET_WITHIN_30MILES, DISTANCE_BUCKET_WITHIN_35MILES, DISTANCE_BUCKET_WITHIN_40MILES, DISTANCE_BUCKET_BEYOND_40MILES, UNKNOWN

ExternalCustomerId Long Attribute Customer ID Customer ID for the UserAdDistance report.
AdNetworkType1 String Segment Network Network for the UserAdDistance report.

使用できる値は次のとおりです。UNKNOWN, SEARCH, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED

AdNetworkType2 String Segment Network (with Search Partners) Network (with Search Partners) for the UserAdDistance report.

使用できる値は次のとおりです。UNKNOWN, SEARCH, SEARCH_PARTNERS, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED

ConversionCategoryName String Segment Conversion Category Conversion Category for the UserAdDistance report.
ConversionTrackerId Long Segment Conversion Tracker Id Conversion Tracker Id for the UserAdDistance report.
ConversionTypeName String Segment Conversion Name Conversion Name for the UserAdDistance report.
Date Date Segment Day Day for the UserAdDistance report.
DayOfWeek String Segment Day Of Week Day Of Week for the UserAdDistance report.

使用できる値は次のとおりです。MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY

Device String Segment Device Device for the UserAdDistance report.

使用できる値は次のとおりです。UNKNOWN, DESKTOP, HIGH_END_MOBILE, TABLET

ExternalConversionSource String Segment Conversion Source Conversion Source for the UserAdDistance report.

使用できる値は次のとおりです。UNKNOWN, WEBPAGE, ANALYTICS, UPLOAD, AD_CALL_METRICS, OFFERS, ENGAGEMENT, WEBSITE_CALL_METRICS, STORE_VISITS, ANDROID_IN_APP, ANDROID_DOWNLOAD, IOS_IN_APP, IOS_FIRST_OPEN, APP_UNSPECIFIED, ANDROID_FIRST_OPEN, UPLOAD_CALLS, FIREBASE, CLICK_TO_CALL, SALESFORCE, STORE_SALES_CRM, STORE_SALES_PAYMENT_NETWORK, GOOGLE_PLAY, THIRD_PARTY_APP_ANALYTICS, GOOGLE_ATTRIBUTION, STORE_SALES_DIRECT

Month String Segment Month Month for the UserAdDistance report.
MonthOfYear String Segment Month Of Year Month Of Year for the UserAdDistance report.

使用できる値は次のとおりです。JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER

Quarter String Segment Quarter Quarter for the UserAdDistance report.
Week String Segment Week Week for the UserAdDistance report.
Year Integer Segment Year Year for the UserAdDistance report.
AllConversionRate Double Metric All Conv Rate All Conv Rate for the UserAdDistance report.
AllConversions Double Metric All Conv All Conv for the UserAdDistance report.
AllConversionValue Double Metric All Conv Value All Conv Value for the UserAdDistance report.
AverageCpc Decimal Metric Avg CPC Avg CPC for the UserAdDistance report.
AverageCpm Decimal Metric Avg CPM Avg CPM for the UserAdDistance report.
AveragePosition Double Metric Avg Position Avg Position for the UserAdDistance report.
Clicks Long Metric Clicks Clicks for the UserAdDistance report.
ConversionRate Double Metric Conv Rate Conv Rate for the UserAdDistance report.
Conversions Double Metric Conversions Conversions for the UserAdDistance report.
ConversionValue Double Metric Total Conv Value Total Conv Value for the UserAdDistance report.
Cost Decimal Metric Cost Cost for the UserAdDistance report.
CostPerAllConversion Decimal Metric Cost Per All Conv Cost Per All Conv for the UserAdDistance report.
CostPerConversion Decimal Metric Cost Per Conv Cost Per Conv for the UserAdDistance report.
CrossDeviceConversions Double Metric Cross-device Conv Cross-device Conv for the UserAdDistance report.
Ctr Double Metric CTR CTR for the UserAdDistance report.
Impressions Long Metric Impressions Impressions for the UserAdDistance report.
ValuePerAllConversion Double Metric Value Per All Conv Value Per All Conv for the UserAdDistance report.
ValuePerConversion Double Metric Value Per Conv Value Per Conv for the UserAdDistance report.
ViewThroughConversions Long Metric View-through Conv View-through Conv for the UserAdDistance report.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
StartDate String Start date for fetching AdWords data. Both StartDate and EndDate must be set to specify a custom date range. The default range in the last seven days.
EndDate String End date for fetching AdWords data. Both StartDate and EndDate must be set to specify a custom date range. The default range in the last seven days.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0