CData ODBC Driver for Google Ads 2019J - Online Help

AdPerformance

CData ODBC Driver for Google Ads 2019J - Build 19.0.7354

The Ad Performance report includes all statistics aggregated at the ad level, one row per ad.

テーブル固有の情報

Select

Google AdWords は、一つのクエリですべてのカラムをSelect することを許容しません。これは、データによっては同時にSelect された場合に対立するからです。これにより、すべてのカラムをSelect するクエリを発行する場合には、デフォルトのメトリック、セグメント、およびアトリビュートのみが返されます。一般的に、これらのデフォルト項目は、AdWords コンソールを通じて表示されているフィールドと同じです。

デフォルト以外のフィールドを使う場合には、クエリ内で明示的にSelect してください。 例えば、次のクエリは、Ad パフォーマンスデータをクエリする際に、デフォルトのDate セグメントではなくClickType を使用します。

SELECT AdType, Headline, CampaignName, ClickType, Clicks, ConversionRate, Impressions FROM AdPerformance

WHERE 句では、フィルタを使用することができます。サポートされている処理は、=、!=、>、>=、<、<=、LIKE、NOT LIKE、IN、およびNOT IN operators です。AdWords API ではOR はサポートされていないため、すべてのフィルタはAND で結合される必要があります。 AdWords API ではOR はサポートされていないため、すべてのフィルタはAND で結合される必要があります。例えば、次のクエリは、コンバージョン率が0 より大きい広告のみを返します。

SELECT AdType, Headline, CampaignName, Device, Clicks, ConversionRate, Impressions FROM AdPerformance WHERE Status='ENABLED' AND ConversionRate > 0

Columns

Name Type Behavior DisplayName Description
AccentColor String Attribute Accent Color (responsive) Accent Color (responsive) for the AdPerformance report.
AccountCurrencyCode String Attribute Currency Currency for the AdPerformance report.
AccountDescriptiveName String Attribute Account Account for the AdPerformance report.
AccountTimeZone String Attribute Time Zone Time Zone for the AdPerformance report.
AdGroupId Long Attribute Ad Group ID Ad Group ID for the AdPerformance report.
AdGroupName String Attribute Ad Group Ad Group for the AdPerformance report.
AdGroupStatus String Attribute Ad Group State Ad Group State for the AdPerformance report.

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

AdStrengthInfo String Attribute Ad Strength Ad Strength for the AdPerformance report.
AdType String Attribute Ad Type Ad Type for the AdPerformance report.

使用できる値は次のとおりです。DEPRECATED_AD, IMAGE_AD, PRODUCT_AD, TEMPLATE_AD, TEXT_AD, THIRD_PARTY_REDIRECT_AD, DYNAMIC_SEARCH_AD, CALL_ONLY_AD, EXPANDED_TEXT_AD, RESPONSIVE_DISPLAY_AD, SHOWCASE_AD, GOAL_OPTIMIZED_SHOPPING_AD, EXPANDED_DYNAMIC_SEARCH_AD, GMAIL_AD, RESPONSIVE_SEARCH_AD, MULTI_ASSET_RESPONSIVE_DISPLAY_AD, UNKNOWN

AllowFlexibleColor String Attribute Allow Flexible Color (responsive) Allow Flexible Color (responsive) for the AdPerformance report.

使用できる値は次のとおりです。TRUE, FALSE

Automated String Attribute Auto-applied Ad Suggestion Auto-applied Ad Suggestion for the AdPerformance report.

使用できる値は次のとおりです。TRUE, FALSE

BaseAdGroupId Long Attribute Base Ad Group ID Base Ad Group ID for the AdPerformance report.
BaseCampaignId Long Attribute Base Campaign ID Base Campaign ID for the AdPerformance report.
BusinessName String Attribute Business Name Business Name for the AdPerformance report.
CallOnlyPhoneNumber String Attribute Call-only Ad Phone Number Call-only Ad Phone Number for the AdPerformance report.
CallToActionText String Attribute Call To Action Text (responsive) Call To Action Text (responsive) for the AdPerformance report.
CampaignId Long Attribute Campaign ID Campaign ID for the AdPerformance report.
CampaignName String Attribute Campaign Campaign for the AdPerformance report.
CampaignStatus String Attribute Campaign State Campaign State for the AdPerformance report.

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

CombinedApprovalStatus String Attribute Approval Status Approval Status for the AdPerformance report.

使用できる値は次のとおりです。UNKNOWN, APPROVED, APPROVED_LIMITED, ELIGIBLE, UNDER_REVIEW, DISAPPROVED, SITE_SUSPENDED

ConversionAdjustment String Attribute Conversion Adjustment Conversion Adjustment for the AdPerformance report.

使用できる値は次のとおりです。TRUE, FALSE

CreativeDestinationUrl String Attribute Destination URL Destination URL for the AdPerformance report.
CreativeFinalAppUrls String Attribute App Final URL App Final URL for the AdPerformance report.
CreativeFinalMobileUrls String Attribute Mobile Final URL Mobile Final URL for the AdPerformance report.
CreativeFinalUrls String Attribute Final URL Final URL for the AdPerformance report.
CreativeFinalUrlSuffix String Attribute Final URL Suffix Final URL Suffix for the AdPerformance report.
CreativeTrackingUrlTemplate String Attribute Tracking Template Tracking Template for the AdPerformance report.
CreativeUrlCustomParameters String Attribute Custom Parameter Custom Parameter for the AdPerformance report.
CriterionType String Attribute Criteria Type Criteria Type for the AdPerformance report.

使用できる値は次のとおりです。UNKNOWN, AD_SCHEDULE, AGE_RANGE, APP_PAYMENT_MODEL, CARRIER, CONTENT_LABEL, CUSTOM_AFFINITY, GENDER, LOCATION_GROUPS, IP_BLOCK, KEYWORD, LANGUAGE, LOCATION, MOBILE_APPLICATION, MOBILE_APP_CATEGORY, MOBILE_DEVICE, OPERATING_SYSTEM_VERSION, PARENT, PLACEMENT, PLATFORM, PREFERRED_CONTENT, PRODUCT_PARTITION, PRODUCT_SCOPE, PROXIMITY, USER_INTEREST, USER_LIST, VERTICAL, WEBPAGE, YOUTUBE_CHANNEL, YOUTUBE_VIDEO, CUSTOM_IN_MARKET

CustomerDescriptiveName String Attribute Client Name Client Name for the AdPerformance report.
Description String Attribute Description Description for the AdPerformance report.
Description1 String Attribute Description Line 1 Description Line 1 for the AdPerformance report.
Description2 String Attribute Description Line 2 Description Line 2 for the AdPerformance report.
DevicePreference Long Attribute Device Preference Device Preference for the AdPerformance report.
DisplayUrl String Attribute Display URL Display URL for the AdPerformance report.
EnhancedDisplayCreativeLandscapeLogoImageMediaId Long Attribute Landscape Logo ID (responsive) Landscape Logo ID (responsive) for the AdPerformance report.
EnhancedDisplayCreativeLogoImageMediaId Long Attribute Logo ID (responsive) Logo ID (responsive) for the AdPerformance report.
EnhancedDisplayCreativeMarketingImageMediaId Long Attribute Image ID (responsive) Image ID (responsive) for the AdPerformance report.
EnhancedDisplayCreativeMarketingImageSquareMediaId Long Attribute Square Image ID (responsive) Square Image ID (responsive) for the AdPerformance report.
ExpandedDynamicSearchCreativeDescription2 String Attribute Expanded Dynamic Search Ad Description 2 Expanded Dynamic Search Ad Description 2 for the AdPerformance report.
ExpandedTextAdDescription2 String Attribute Expanded Text Ad Description 2 Expanded Text Ad Description 2 for the AdPerformance report.
ExpandedTextAdHeadlinePart3 String Attribute Expanded Text Ad Headline 3 Expanded Text Ad Headline 3 for the AdPerformance report.
ExternalCustomerId Long Attribute Customer ID Customer ID for the AdPerformance report.
FormatSetting String Attribute Ad Format Preference (responsive) Ad Format Preference (responsive) for the AdPerformance report.

使用できる値は次のとおりです。UNKNOWN, ALL_FORMATS, NON_NATIVE, NATIVE

GmailCreativeHeaderImageMediaId Long Attribute Gmail Ad Header Image Media Id Gmail Ad Header Image Media Id for the AdPerformance report.
GmailCreativeLogoImageMediaId Long Attribute Gmail Ad Logo Image Media Id Gmail Ad Logo Image Media Id for the AdPerformance report.
GmailCreativeMarketingImageMediaId Long Attribute Gmail Ad Marketing Image Media Id Gmail Ad Marketing Image Media Id for the AdPerformance report.
GmailTeaserBusinessName String Attribute Gmail Ad Business Name Gmail Ad Business Name for the AdPerformance report.
GmailTeaserDescription String Attribute Gmail Ad Description Gmail Ad Description for the AdPerformance report.
GmailTeaserHeadline String Attribute Gmail Ad Headline Gmail Ad Headline for the AdPerformance report.
Headline String Attribute Ad Ad for the AdPerformance report.
HeadlinePart1 String Attribute Headline 1 Headline 1 for the AdPerformance report.
HeadlinePart2 String Attribute Headline 2 Headline 2 for the AdPerformance report.
Id Long Attribute Ad ID Ad ID for the AdPerformance report.
ImageAdUrl String Attribute Image Ad URL Image Ad URL for the AdPerformance report.
ImageCreativeImageHeight Integer Attribute Image Height Image Height for the AdPerformance report.
ImageCreativeImageWidth Integer Attribute Image Width Image Width for the AdPerformance report.
ImageCreativeMimeType String Attribute Image Mime Type Image Mime Type for the AdPerformance report.
ImageCreativeName String Attribute Image Ad Name Image Ad Name for the AdPerformance report.
IsNegative String Attribute Is Negative Is Negative for the AdPerformance report.

使用できる値は次のとおりです。TRUE, FALSE

LabelIds String Attribute Label IDs Label IDs for the AdPerformance report.
Labels String Attribute Labels Labels for the AdPerformance report.
LongHeadline String Attribute Long Headline Long Headline for the AdPerformance report.
MainColor String Attribute Main Color (responsive) Main Color (responsive) for the AdPerformance report.
MarketingImageCallToActionText String Attribute Gmail Ad Marketing Image Call To Action Text Gmail Ad Marketing Image Call To Action Text for the AdPerformance report.
MarketingImageCallToActionTextColor String Attribute Gmail Ad Marketing Image Call To Action Text Color Gmail Ad Marketing Image Call To Action Text Color for the AdPerformance report.
MarketingImageDescription String Attribute Gmail Ad Marketing Image Description Gmail Ad Marketing Image Description for the AdPerformance report.
MarketingImageHeadline String Attribute Gmail Ad Marketing Image Headline Gmail Ad Marketing Image Headline for the AdPerformance report.
MultiAssetResponsiveDisplayAdAccentColor String Attribute Accent Color (multi Asset Responsive Display) Accent Color (multi Asset Responsive Display) for the AdPerformance report.
MultiAssetResponsiveDisplayAdAllowFlexibleColor String Attribute Allow Flexible Color (multi Asset Responsive Display) Allow Flexible Color (multi Asset Responsive Display) for the AdPerformance report.

使用できる値は次のとおりです。TRUE, FALSE

MultiAssetResponsiveDisplayAdBusinessName String Attribute Business Name (multi Asset Responsive Display) Business Name (multi Asset Responsive Display) for the AdPerformance report.
MultiAssetResponsiveDisplayAdCallToActionText String Attribute Call To Action Text (multi Asset Responsive Display) Call To Action Text (multi Asset Responsive Display) for the AdPerformance report.
MultiAssetResponsiveDisplayAdDescriptions String Attribute Descriptions (multi Asset Responsive Display) Descriptions (multi Asset Responsive Display) for the AdPerformance report.
MultiAssetResponsiveDisplayAdDynamicSettingsPricePrefix String Attribute Price Prefix (multi Asset Responsive Display) Price Prefix (multi Asset Responsive Display) for the AdPerformance report.
MultiAssetResponsiveDisplayAdDynamicSettingsPromoText String Attribute Promotion Text (multi Asset Responsive Display) Promotion Text (multi Asset Responsive Display) for the AdPerformance report.
MultiAssetResponsiveDisplayAdFormatSetting String Attribute Ad Format Preference (multi Asset Responsive Display) Ad Format Preference (multi Asset Responsive Display) for the AdPerformance report.

使用できる値は次のとおりです。UNKNOWN, ALL_FORMATS, NON_NATIVE, NATIVE

MultiAssetResponsiveDisplayAdHeadlines String Attribute Headlines (multi Asset Responsive Display) Headlines (multi Asset Responsive Display) for the AdPerformance report.
MultiAssetResponsiveDisplayAdLandscapeLogoImages String Attribute Landscape Logos (multi Asset Responsive Display) Landscape Logos (multi Asset Responsive Display) for the AdPerformance report.
MultiAssetResponsiveDisplayAdLogoImages String Attribute Logos (multi Asset Responsive Display) Logos (multi Asset Responsive Display) for the AdPerformance report.
MultiAssetResponsiveDisplayAdLongHeadline String Attribute Long Headline (multi Asset Responsive Display) Long Headline (multi Asset Responsive Display) for the AdPerformance report.
MultiAssetResponsiveDisplayAdMainColor String Attribute Main Color (multi Asset Responsive Display) Main Color (multi Asset Responsive Display) for the AdPerformance report.
MultiAssetResponsiveDisplayAdMarketingImages String Attribute Images (multi Asset Responsive Display) Images (multi Asset Responsive Display) for the AdPerformance report.
MultiAssetResponsiveDisplayAdSquareMarketingImages String Attribute Square Images (multi Asset Responsive Display) Square Images (multi Asset Responsive Display) for the AdPerformance report.
MultiAssetResponsiveDisplayAdYouTubeVideos String Attribute Youtube Videos (multi Asset Responsive Display) Youtube Videos (multi Asset Responsive Display) for the AdPerformance report.
Path1 String Attribute Path 1 Path 1 for the AdPerformance report.
Path2 String Attribute Path 2 Path 2 for the AdPerformance report.
PolicySummary String Attribute Policy Policy for the AdPerformance report.
PricePrefix String Attribute Price Prefix (responsive) Price Prefix (responsive) for the AdPerformance report.
PromoText String Attribute Promotion Text (responsive) Promotion Text (responsive) for the AdPerformance report.
ResponsiveSearchAdDescriptions String Attribute Responsive Search Ad Descriptions Responsive Search Ad Descriptions for the AdPerformance report.
ResponsiveSearchAdHeadlines String Attribute Responsive Search Ad Headlines Responsive Search Ad Headlines for the AdPerformance report.
ResponsiveSearchAdPath1 String Attribute Responsive Search Ad Path 1 Responsive Search Ad Path 1 for the AdPerformance report.
ResponsiveSearchAdPath2 String Attribute Responsive Search Ad Path 2 Responsive Search Ad Path 2 for the AdPerformance report.
ShortHeadline String Attribute Short Headline Short Headline for the AdPerformance report.
Status String Attribute Ad State Ad State for the AdPerformance report.

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

SystemManagedEntitySource String Attribute System Managed Entity Source System Managed Entity Source for the AdPerformance report.

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

AdNetworkType1 String Segment Network Network for the AdPerformance report.

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

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

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

ClickType String Segment Click Type Click Type for the AdPerformance 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

ConversionAdjustmentLagBucket String Segment Days To Conversion Or Adjustment Days To Conversion Or Adjustment for the AdPerformance report.

使用できる値は次のとおりです。UNKNOWN, CONVERSION_0_TO_1_DAY, CONVERSION_1_TO_2_DAYS, CONVERSION_2_TO_3_DAYS, CONVERSION_3_TO_4_DAYS, CONVERSION_4_TO_5_DAYS, CONVERSION_5_TO_6_DAYS, CONVERSION_6_TO_7_DAYS, CONVERSION_7_TO_8_DAYS, CONVERSION_8_TO_9_DAYS, CONVERSION_9_TO_10_DAYS, CONVERSION_10_TO_11_DAYS, CONVERSION_11_TO_12_DAYS, CONVERSION_12_TO_13_DAYS, CONVERSION_13_TO_14_DAYS, CONVERSION_14_TO_21_DAYS, CONVERSION_21_TO_30_DAYS, CONVERSION_30_TO_45_DAYS, CONVERSION_45_TO_60_DAYS, CONVERSION_60_TO_90_DAYS, ADJUSTMENT_0_TO_1_DAY, ADJUSTMENT_1_TO_2_DAYS, ADJUSTMENT_2_TO_3_DAYS, ADJUSTMENT_3_TO_4_DAYS, ADJUSTMENT_4_TO_5_DAYS, ADJUSTMENT_5_TO_6_DAYS, ADJUSTMENT_6_TO_7_DAYS, ADJUSTMENT_7_TO_8_DAYS, ADJUSTMENT_8_TO_9_DAYS, ADJUSTMENT_9_TO_10_DAYS, ADJUSTMENT_10_TO_11_DAYS, ADJUSTMENT_11_TO_12_DAYS, ADJUSTMENT_12_TO_13_DAYS, ADJUSTMENT_13_TO_14_DAYS, ADJUSTMENT_14_TO_21_DAYS, ADJUSTMENT_21_TO_30_DAYS, ADJUSTMENT_30_TO_45_DAYS, ADJUSTMENT_45_TO_60_DAYS, ADJUSTMENT_60_TO_90_DAYS, ADJUSTMENT_90_TO_145_DAY, CONVERSION_UNKNOWN, ADJUSTMENT_UNKNOWN

ConversionCategoryName String Segment Conversion Category Conversion Category for the AdPerformance report.
ConversionLagBucket String Segment Days To Conversion Days To Conversion for the AdPerformance report.

使用できる値は次のとおりです。UNKNOWN, CONVERSION_0_TO_1_DAY, CONVERSION_1_TO_2_DAYS, CONVERSION_2_TO_3_DAYS, CONVERSION_3_TO_4_DAYS, CONVERSION_4_TO_5_DAYS, CONVERSION_5_TO_6_DAYS, CONVERSION_6_TO_7_DAYS, CONVERSION_7_TO_8_DAYS, CONVERSION_8_TO_9_DAYS, CONVERSION_9_TO_10_DAYS, CONVERSION_10_TO_11_DAYS, CONVERSION_11_TO_12_DAYS, CONVERSION_12_TO_13_DAYS, CONVERSION_13_TO_14_DAYS, CONVERSION_14_TO_21_DAYS, CONVERSION_21_TO_30_DAYS, CONVERSION_30_TO_45_DAYS, CONVERSION_45_TO_60_DAYS, CONVERSION_60_TO_90_DAYS

ConversionTrackerId Long Segment Conversion Tracker Id Conversion Tracker Id for the AdPerformance report.
ConversionTypeName String Segment Conversion Name Conversion Name for the AdPerformance report.
CriterionId Long Segment Keyword ID Keyword ID for the AdPerformance report.
Date Date Segment Day Day for the AdPerformance report.
DayOfWeek String Segment Day Of Week Day Of Week for the AdPerformance report.

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

Device String Segment Device Device for the AdPerformance report.

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

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

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

Quarter String Segment Quarter Quarter for the AdPerformance report.
Slot String Segment Top Vs Other Top Vs Other for the AdPerformance report.

使用できる値は次のとおりです。SEARCHRHS, SEARCHTOP, SEARCHOTHER, CONTENT, AFSTOP, AFSOTHER, MIXED, UNKNOWN

Week String Segment Week Week for the AdPerformance report.
Year Integer Segment Year Year for the AdPerformance report.
AbsoluteTopImpressionPercentage Double Metric Impr Abs Top The percent of add impressions shown as the very first ad.
ActiveViewCpm Decimal Metric Active View Avg CPM Active View Avg CPM for the AdPerformance report.
ActiveViewCtr Double Metric Active View Viewable CTR Active View Viewable CTR for the AdPerformance report.
ActiveViewImpressions Long Metric Active View Viewable Impressions Active View Viewable Impressions for the AdPerformance report.
ActiveViewMeasurability Double Metric Active View Measurable Impr Per Impr Active View Measurable Impr Per Impr for the AdPerformance report.
ActiveViewMeasurableCost Decimal Metric Active View Measurable Cost Active View Measurable Cost for the AdPerformance report.
ActiveViewMeasurableImpressions Long Metric Active View Measurable Impr Active View Measurable Impr for the AdPerformance report.
ActiveViewViewability Double Metric Active View Viewable Impr Per Measurable Impr Active View Viewable Impr Per Measurable Impr for the AdPerformance report.
AllConversionRate Double Metric All Conv Rate All Conv Rate for the AdPerformance report.
AllConversions Double Metric All Conv All Conv for the AdPerformance report.
AllConversionValue Double Metric All Conv Value All Conv Value for the AdPerformance report.
AverageCost Decimal Metric Avg Cost Avg Cost for the AdPerformance report.
AverageCpc Decimal Metric Avg CPC Avg CPC for the AdPerformance report.
AverageCpe Double Metric Avg CPE Avg CPE for the AdPerformance report.
AverageCpm Decimal Metric Avg CPM Avg CPM for the AdPerformance report.
AverageCpv Double Metric Avg CPV Avg CPV for the AdPerformance report.
AveragePageviews Double Metric Pages Per Session Pages Per Session for the AdPerformance report.
AveragePosition Double Metric Avg Position Avg Position for the AdPerformance report.
AverageTimeOnSite Double Metric Avg Session Duration (seconds) Avg Session Duration (seconds) for the AdPerformance report.
BounceRate Double Metric Bounce Rate Bounce Rate for the AdPerformance report.
ClickAssistedConversions Long Metric Click Assisted Conv Click Assisted Conv for the AdPerformance report.
ClickAssistedConversionsOverLastClickConversions Double Metric Click Assisted Conv Per Last Click Conv Click Assisted Conv Per Last Click Conv for the AdPerformance report.
ClickAssistedConversionValue Double Metric Click Assisted Conv Value Click Assisted Conv Value for the AdPerformance report.
Clicks Long Metric Clicks Clicks for the AdPerformance report.
ConversionRate Double Metric Conv Rate Conv Rate for the AdPerformance report.
Conversions Double Metric Conversions Conversions for the AdPerformance report.
ConversionValue Double Metric Total Conv Value Total Conv Value for the AdPerformance report.
Cost Decimal Metric Cost Cost for the AdPerformance report.
CostPerAllConversion Decimal Metric Cost Per All Conv Cost Per All Conv for the AdPerformance report.
CostPerConversion Decimal Metric Cost Per Conv Cost Per Conv for the AdPerformance report.
CostPerCurrentModelAttributedConversion Double Metric Cost Per Conv (current Model) Cost Per Conv (current Model) for the AdPerformance report.
CrossDeviceConversions Double Metric Cross-device Conv Cross-device Conv for the AdPerformance report.
Ctr Double Metric CTR CTR for the AdPerformance report.
CurrentModelAttributedConversions Double Metric Conversions (current Model) Conversions (current Model) for the AdPerformance report.
CurrentModelAttributedConversionValue Double Metric Conv Value (current Model) Conv Value (current Model) for the AdPerformance report.
EngagementRate Double Metric Engagement Rate Engagement Rate for the AdPerformance report.
Engagements Long Metric Engagements Engagements for the AdPerformance report.
GmailForwards Long Metric Gmail Forwards Gmail Forwards for the AdPerformance report.
GmailSaves Long Metric Gmail Saves Gmail Saves for the AdPerformance report.
GmailSecondaryClicks Long Metric Gmail Clicks To Website Gmail Clicks To Website for the AdPerformance report.
ImpressionAssistedConversions Long Metric Impr Assisted Conv Impr Assisted Conv for the AdPerformance report.
ImpressionAssistedConversionsOverLastClickConversions Double Metric Impr Assisted Conv Per Last Click Conv Impr Assisted Conv Per Last Click Conv for the AdPerformance report.
ImpressionAssistedConversionValue Double Metric Impr Assisted Conv Value Impr Assisted Conv Value for the AdPerformance report.
Impressions Long Metric Impressions Impressions for the AdPerformance report.
InteractionRate Double Metric Interaction Rate Interaction Rate for the AdPerformance report.
Interactions Long Metric Interactions Interactions for the AdPerformance report.
InteractionTypes String Metric Interaction Types Interaction Types for the AdPerformance report.
PercentNewVisitors Double Metric Percent New Sessions Percent New Sessions for the AdPerformance report.
TopImpressionPercentage Double Metric Impr Top The percent of add impressions that are shown anywhere above the organic search results.
ValuePerAllConversion Double Metric Value Per All Conv Value Per All Conv for the AdPerformance report.
ValuePerConversion Double Metric Value Per Conv Value Per Conv for the AdPerformance report.
ValuePerCurrentModelAttributedConversion Double Metric Value Per Conv (current Model) Value Per Conv (current Model) for the AdPerformance report.
VideoQuartile100Rate Double Metric Video Played To 100Percent Video Played To 100Percent for the AdPerformance report.
VideoQuartile25Rate Double Metric Video Played To 25Percent Video Played To 25Percent for the AdPerformance report.
VideoQuartile50Rate Double Metric Video Played To 50Percent Video Played To 50Percent for the AdPerformance report.
VideoQuartile75Rate Double Metric Video Played To 75Percent Video Played To 75Percent for the AdPerformance report.
VideoViewRate Double Metric View Rate View Rate for the AdPerformance report.
VideoViews Long Metric Views Views for the AdPerformance report.
ViewThroughConversions Long Metric View-through Conv View-through Conv for the AdPerformance 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