CData ODBC Driver for Google Ads 2019J - Online Help

CriteriaPerformance

CData ODBC Driver for Google Ads 2019J - Build 19.0.7354

The Criteria Performance report includes statistics aggregated at the ad group criteria level, one row per ad group and criteria combination.

テーブル固有の情報

Select

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

デフォルト以外のフィールドを使う場合には、クエリ内で明示的にSelect してください。

WHERE 句では、フィルタを使用することができます。サポートされている処理は、=、!=、>、>=、<、<=、LIKE、NOT LIKE、IN、およびNOT IN operators です。AdWords API ではOR はサポートされていないため、すべてのフィルタはAND で結合される必要があります。

Columns

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

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

ApprovalStatus String Attribute Approval Status Approval Status for the CriteriaPerformance report.

使用できる値は次のとおりです。APPROVED, PENDING_REVIEW, UNDER_REVIEW, DISAPPROVED

BaseAdGroupId Long Attribute Base Ad Group ID Base Ad Group ID for the CriteriaPerformance report.
BaseCampaignId Long Attribute Base Campaign ID Base Campaign ID for the CriteriaPerformance report.
BidModifier Double Attribute Bid Adj Bid Adj for the CriteriaPerformance report.
CampaignId Long Attribute Campaign ID Campaign ID for the CriteriaPerformance report.
CampaignName String Attribute Campaign Campaign for the CriteriaPerformance report.
CampaignStatus String Attribute Campaign State Campaign State for the CriteriaPerformance report.

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

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

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

CpcBid Decimal Attribute Max CPC Max CPC for the CriteriaPerformance report.
CpcBidSource String Attribute Max CPC Source Max CPC Source for the CriteriaPerformance report.

使用できる値は次のとおりです。ADGROUP, CRITERION, ADGROUP_BIDDING_STRATEGY, CAMPAIGN_BIDDING_STRATEGY

CpmBid Decimal Attribute Max CPM Max CPM for the CriteriaPerformance report.
CpvBid Decimal Attribute Max CPV Max CPV for the CriteriaPerformance report.
CpvBidSource String Attribute Max CPV Source Max CPV Source for the CriteriaPerformance report.

使用できる値は次のとおりです。ADGROUP, CRITERION, ADGROUP_BIDDING_STRATEGY, CAMPAIGN_BIDDING_STRATEGY

CreativeQualityScore String Attribute Ad Relevance Ad Relevance for the CriteriaPerformance report.

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

Criteria String Attribute Keyword Per Placement Keyword Per Placement for the CriteriaPerformance report.
CriteriaDestinationUrl String Attribute Keyword Per Placement Destination URL Keyword Per Placement Destination URL for the CriteriaPerformance report.
CriteriaType String Attribute Criteria Type Criteria Type for the CriteriaPerformance report.

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

CustomerDescriptiveName String Attribute Client Name Client Name for the CriteriaPerformance report.
DisplayName String Attribute Criteria Display Name Criteria Display Name for the CriteriaPerformance report.
EnhancedCpcEnabled String Attribute Enhanced CPC Enabled Enhanced CPC Enabled for the CriteriaPerformance report.

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

EstimatedAddClicksAtFirstPositionCpc Long Attribute Est Add Clicks Per wk (first Position Bid) Est Add Clicks Per wk (first Position Bid) for the CriteriaPerformance report.
EstimatedAddCostAtFirstPositionCpc Decimal Attribute Est Add Cost Per wk (first Position Bid) Est Add Cost Per wk (first Position Bid) for the CriteriaPerformance report.
ExternalCustomerId Long Attribute Customer ID Customer ID for the CriteriaPerformance report.
FinalAppUrls String Attribute App Final URL App Final URL for the CriteriaPerformance report.
FinalMobileUrls String Attribute Mobile Final URL Mobile Final URL for the CriteriaPerformance report.
FinalUrls String Attribute Final URL Final URL for the CriteriaPerformance report.
FinalUrlSuffix String Attribute Final URL Suffix Final URL Suffix for the CriteriaPerformance report.
FirstPageCpc String Attribute First Page CPC First Page CPC for the CriteriaPerformance report.
FirstPositionCpc String Attribute First Position CPC First Position CPC for the CriteriaPerformance report.
HasQualityScore String Attribute Has Quality Score Has Quality Score for the CriteriaPerformance report.

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

Id Long Attribute Keyword ID Keyword ID for the CriteriaPerformance report.
IsNegative String Attribute Is Negative Is Negative for the CriteriaPerformance report.

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

LabelIds String Attribute Label IDs Label IDs for the CriteriaPerformance report.
Labels String Attribute Labels Labels for the CriteriaPerformance report.
Parameter String Attribute Dynamic Ad Target Dynamic Ad Target for the CriteriaPerformance report.
PostClickQualityScore String Attribute Landing Page Experience Landing Page Experience for the CriteriaPerformance report.

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

QualityScore Integer Attribute Quality Score Quality Score for the CriteriaPerformance report.
SearchPredictedCtr String Attribute Expected Clickthrough Rate Expected Clickthrough Rate for the CriteriaPerformance report.

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

Status String Attribute Keyword Per Placement State Keyword Per Placement State for the CriteriaPerformance report.

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

SystemServingStatus String Attribute Criterion Serving Status Criterion Serving Status for the CriteriaPerformance report.

使用できる値は次のとおりです。ELIGIBLE, RARELY_SERVED

TopOfPageCpc String Attribute Top Of Page CPC Top Of Page CPC for the CriteriaPerformance report.
TrackingUrlTemplate String Attribute Tracking Template Tracking Template for the CriteriaPerformance report.
UrlCustomParameters String Attribute Custom Parameter Custom Parameter for the CriteriaPerformance report.
VerticalId Long Attribute Vertical ID Vertical ID for the CriteriaPerformance report.
AdNetworkType1 String Segment Network Network for the CriteriaPerformance report.

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

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

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

ClickType String Segment Click Type Click Type for the CriteriaPerformance 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 CriteriaPerformance 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 CriteriaPerformance report.
ConversionLagBucket String Segment Days To Conversion Days To Conversion for the CriteriaPerformance 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 CriteriaPerformance report.
ConversionTypeName String Segment Conversion Name Conversion Name for the CriteriaPerformance report.
Date Date Segment Day Day for the CriteriaPerformance report.
DayOfWeek String Segment Day Of Week Day Of Week for the CriteriaPerformance report.

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

Device String Segment Device Device for the CriteriaPerformance report.

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

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

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

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

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

Week String Segment Week Week for the CriteriaPerformance report.
Year Integer Segment Year Year for the CriteriaPerformance 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 CriteriaPerformance report.
ActiveViewCtr Double Metric Active View Viewable CTR Active View Viewable CTR for the CriteriaPerformance report.
ActiveViewImpressions Long Metric Active View Viewable Impressions Active View Viewable Impressions for the CriteriaPerformance report.
ActiveViewMeasurability Double Metric Active View Measurable Impr Per Impr Active View Measurable Impr Per Impr for the CriteriaPerformance report.
ActiveViewMeasurableCost Decimal Metric Active View Measurable Cost Active View Measurable Cost for the CriteriaPerformance report.
ActiveViewMeasurableImpressions Long Metric Active View Measurable Impr Active View Measurable Impr for the CriteriaPerformance report.
ActiveViewViewability Double Metric Active View Viewable Impr Per Measurable Impr Active View Viewable Impr Per Measurable Impr for the CriteriaPerformance report.
AllConversionRate Double Metric All Conv Rate All Conv Rate for the CriteriaPerformance report.
AllConversions Double Metric All Conv All Conv for the CriteriaPerformance report.
AllConversionValue Double Metric All Conv Value All Conv Value for the CriteriaPerformance report.
AverageCost Decimal Metric Avg Cost Avg Cost for the CriteriaPerformance report.
AverageCpc Decimal Metric Avg CPC Avg CPC for the CriteriaPerformance report.
AverageCpe Double Metric Avg CPE Avg CPE for the CriteriaPerformance report.
AverageCpm Decimal Metric Avg CPM Avg CPM for the CriteriaPerformance report.
AverageCpv Double Metric Avg CPV Avg CPV for the CriteriaPerformance report.
AveragePosition Double Metric Avg Position Avg Position for the CriteriaPerformance report.
Clicks Long Metric Clicks Clicks for the CriteriaPerformance report.
ConversionRate Double Metric Conv Rate Conv Rate for the CriteriaPerformance report.
Conversions Double Metric Conversions Conversions for the CriteriaPerformance report.
ConversionValue Double Metric Total Conv Value Total Conv Value for the CriteriaPerformance report.
Cost Decimal Metric Cost Cost for the CriteriaPerformance report.
CostPerAllConversion Decimal Metric Cost Per All Conv Cost Per All Conv for the CriteriaPerformance report.
CostPerConversion Decimal Metric Cost Per Conv Cost Per Conv for the CriteriaPerformance report.
CostPerCurrentModelAttributedConversion Double Metric Cost Per Conv (current Model) Cost Per Conv (current Model) for the CriteriaPerformance report.
CrossDeviceConversions Double Metric Cross-device Conv Cross-device Conv for the CriteriaPerformance report.
Ctr Double Metric CTR CTR for the CriteriaPerformance report.
CurrentModelAttributedConversions Double Metric Conversions (current Model) Conversions (current Model) for the CriteriaPerformance report.
CurrentModelAttributedConversionValue Double Metric Conv Value (current Model) Conv Value (current Model) for the CriteriaPerformance report.
EngagementRate Double Metric Engagement Rate Engagement Rate for the CriteriaPerformance report.
Engagements Long Metric Engagements Engagements for the CriteriaPerformance report.
GmailForwards Long Metric Gmail Forwards Gmail Forwards for the CriteriaPerformance report.
GmailSaves Long Metric Gmail Saves Gmail Saves for the CriteriaPerformance report.
GmailSecondaryClicks Long Metric Gmail Clicks To Website Gmail Clicks To Website for the CriteriaPerformance report.
Impressions Long Metric Impressions Impressions for the CriteriaPerformance report.
InteractionRate Double Metric Interaction Rate Interaction Rate for the CriteriaPerformance report.
Interactions Long Metric Interactions Interactions for the CriteriaPerformance report.
InteractionTypes String Metric Interaction Types Interaction Types for the CriteriaPerformance 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 CriteriaPerformance report.
ValuePerConversion Double Metric Value Per Conv Value Per Conv for the CriteriaPerformance report.
ValuePerCurrentModelAttributedConversion Double Metric Value Per Conv (current Model) Value Per Conv (current Model) for the CriteriaPerformance report.
VideoQuartile100Rate Double Metric Video Played To 100Percent Video Played To 100Percent for the CriteriaPerformance report.
VideoQuartile25Rate Double Metric Video Played To 25Percent Video Played To 25Percent for the CriteriaPerformance report.
VideoQuartile50Rate Double Metric Video Played To 50Percent Video Played To 50Percent for the CriteriaPerformance report.
VideoQuartile75Rate Double Metric Video Played To 75Percent Video Played To 75Percent for the CriteriaPerformance report.
VideoViewRate Double Metric View Rate View Rate for the CriteriaPerformance report.
VideoViews Long Metric Views Views for the CriteriaPerformance report.
ViewThroughConversions Long Metric View-through Conv View-through Conv for the CriteriaPerformance 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