CData ODBC Driver for Google Ads 2019J - Online Help

VideoPerformance

CData ODBC Driver for Google Ads 2019J - Build 19.0.7354

The Video Performance report includes statistics for your account's upgraded AdWords for Video campaigns.

Columns

Name Type Behavior DisplayName Description
AccountCurrencyCode String Attribute Currency Currency for the VideoPerformance report.
AccountDescriptiveName String Attribute Account Account for the VideoPerformance report.
AccountTimeZone String Attribute Time Zone Time Zone for the VideoPerformance report.
AdGroupId Long Attribute Ad Group ID Ad Group ID for the VideoPerformance report.
AdGroupName String Attribute Ad Group Ad Group for the VideoPerformance report.
AdGroupStatus String Attribute Ad Group State Ad Group State for the VideoPerformance report.

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

CampaignId Long Attribute Campaign ID Campaign ID for the VideoPerformance report.
CampaignName String Attribute Campaign Campaign for the VideoPerformance report.
CampaignStatus String Attribute Campaign State Campaign State for the VideoPerformance report.

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

CreativeId Long Attribute Ad ID Ad ID for the VideoPerformance report.
CreativeStatus String Attribute Ad State Ad State for the VideoPerformance report.

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

CustomerDescriptiveName String Attribute Client Name Client Name for the VideoPerformance report.
ExternalCustomerId Long Attribute Customer ID Customer ID for the VideoPerformance report.
VideoChannelId String Attribute Video Channel Id Video Channel Id for the VideoPerformance report.
VideoDuration Long Attribute Video Duration Video Duration for the VideoPerformance report.
VideoId String Attribute Video Id Video Id for the VideoPerformance report.
VideoTitle String Attribute Video Title Video Title for the VideoPerformance report.
AdNetworkType1 String Segment Network Network for the VideoPerformance report.

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

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

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

ClickType String Segment Click Type Click Type for the VideoPerformance report.

使用できる値は次のとおりです。URL_CLICKS, CALLS, OTHER, PRODUCT_EXTENSION_CLICKS, SITELINKS, PRODUCT_LISTING_AD_CLICKS, GET_DIRECTIONS, OFFER_PRINTS, BREADCRUMBS, CALL_TRACKING, MOBILE_CALL_TRACKING, LOCATION_EXPANSION, STORE_LOCATOR, PRODUCT_LISTING_AD_LOCAL, APP_DEEPLINK, PRODUCT_LISTING_AD_MULTICHANNEL_LOCAL, PRODUCT_LISTING_AD_MULTICHANNEL_ONLINE, PRODUCT_LISTING_ADS_COUPON, PRODUCT_LISTING_AD_TRANSACTABLE, PRODUCT_AD_APP_DEEPLINK, SHOWCASE_AD_CATEGORY_LINK, SHOWCASE_AD_LOCAL_STOREFRONT_LINK, SHOWCASE_AD_ONLINE_PRODUCT_LINK, SHOWCASE_AD_LOCAL_PRODUCT_LINK, PRICE_EXTENSION, VIDEO_WEBSITE_CLICKS, VIDEO_CALL_TO_ACTION_CLICKS, VIDEO_APP_STORE_CLICKS, VIDEO_CARD_ACTION_HEADLINE_CLICKS, VIDEO_END_CAP_CLICKS, CLICK_ON_ENGAGEMENT_AD, LOCATION_FORMAT_MAP, LOCATION_FORMAT_LANDING_PAGE, LOCATION_FORMAT_STORE_INFO, LOCATION_FORMAT_DIRECTIONS, LOCATION_FORMAT_CALL, LOCATION_FORMAT_TEXT, LOCATION_FORMAT_IMAGE, BROADBAND_PLAN, WIRELESS_PLAN, VISUAL_SITELINKS, PROMOTION_EXTENSION, SWIPEABLE_GALLERY_AD_HEADLINE, SWIPEABLE_GALLERY_AD_SWIPES, SWIPEABLE_GALLERY_AD_SEE_MORE, SWIPEABLE_GALLERY_AD_SITELINK_ONE, SWIPEABLE_GALLERY_AD_SITELINK_TWO, SWIPEABLE_GALLERY_AD_SITELINK_THREE, SWIPEABLE_GALLERY_AD_SITELINK_FOUR, SWIPEABLE_GALLERY_AD_SITELINK_FIVE, UNKNOWN

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

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

Device String Segment Device Device for the VideoPerformance report.

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

ExternalConversionSource String Segment Conversion Source Conversion Source for the VideoPerformance 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 VideoPerformance report.
MonthOfYear String Segment Month Of Year Month Of Year for the VideoPerformance report.

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

Quarter String Segment Quarter Quarter for the VideoPerformance report.
Week String Segment Week Week for the VideoPerformance report.
Year Integer Segment Year Year for the VideoPerformance report.
AllConversionRate Double Metric All Conv Rate All Conv Rate for the VideoPerformance report.
AllConversions Double Metric All Conv All Conv for the VideoPerformance report.
AllConversionValue Double Metric All Conv Value All Conv Value for the VideoPerformance report.
AverageCpm Double Metric Avg CPM Avg CPM for the VideoPerformance report.
AverageCpv Double Metric Avg CPV Avg CPV for the VideoPerformance report.
Clicks Long Metric Clicks Clicks for the VideoPerformance report.
ConversionRate Double Metric Conv Rate Conv Rate for the VideoPerformance report.
Conversions Double Metric Conversions Conversions for the VideoPerformance report.
ConversionValue Double Metric Total Conv Value Total Conv Value for the VideoPerformance report.
Cost Decimal Metric Cost Cost for the VideoPerformance report.
CostPerAllConversion Decimal Metric Cost Per All Conv Cost Per All Conv for the VideoPerformance report.
CostPerConversion Decimal Metric Cost Per Conv Cost Per Conv for the VideoPerformance report.
CrossDeviceConversions Double Metric Cross-device Conv Cross-device Conv for the VideoPerformance report.
Ctr Double Metric CTR CTR for the VideoPerformance report.
EngagementRate Double Metric Engagement Rate Engagement Rate for the VideoPerformance report.
Engagements Long Metric Engagements Engagements for the VideoPerformance report.
Impressions Long Metric Impressions Impressions for the VideoPerformance report.
ValuePerAllConversion Double Metric Value Per All Conv Value Per All Conv for the VideoPerformance report.
VideoQuartile100Rate Double Metric Video Played To 100Percent Video Played To 100Percent for the VideoPerformance report.
VideoQuartile25Rate Double Metric Video Played To 25Percent Video Played To 25Percent for the VideoPerformance report.
VideoQuartile50Rate Double Metric Video Played To 50Percent Video Played To 50Percent for the VideoPerformance report.
VideoQuartile75Rate Double Metric Video Played To 75Percent Video Played To 75Percent for the VideoPerformance report.
VideoViewRate Double Metric View Rate View Rate for the VideoPerformance report.
VideoViews Long Metric Views Views for the VideoPerformance report.
ViewThroughConversions Long Metric View-through Conv View-through Conv for the VideoPerformance 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