CData ODBC Driver for Google Ads 2019J - Online Help

AudiencePerformance

CData ODBC Driver for Google Ads 2019J - Build 19.0.7354

The Audience Performance report includes performance data from interests and remarketing lists for display ads, and remarketing lists for search ads (RLSA), aggregated at the audience level・スone row per audience.

テーブル固有の情報

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 AudiencePerformance report.
AccountDescriptiveName String Attribute Account Account for the AudiencePerformance report.
AccountTimeZone String Attribute Time Zone Time Zone for the AudiencePerformance report.
BaseAdGroupId Long Attribute Base Ad Group ID Base Ad Group ID for the AudiencePerformance report.
BaseCampaignId Long Attribute Base Campaign ID Base Campaign ID for the AudiencePerformance report.
BiddingStrategyId Long Attribute Bid Strategy ID Bid Strategy ID for the AudiencePerformance report.
BiddingStrategyName String Attribute Bid Strategy Name Bid Strategy Name for the AudiencePerformance report.
BiddingStrategyType String Attribute Bid Strategy Type Bid Strategy Type for the AudiencePerformance report.

使用できる値は次のとおりです。MANUAL_CPC, MANUAL_CPV, MANUAL_CPM, PAGE_ONE_PROMOTED, TARGET_SPEND, TARGET_CPA, TARGET_ROAS, MAXIMIZE_CONVERSIONS, MAXIMIZE_CONVERSION_VALUE, TARGET_OUTRANK_SHARE, NONE, UNKNOWN

BidModifier Double Attribute Bid Adj Bid Adj for the AudiencePerformance report.
CampaignId Long Attribute Campaign ID Campaign ID for the AudiencePerformance report.
CampaignName String Attribute Campaign Campaign for the AudiencePerformance report.
CampaignStatus String Attribute Campaign State Campaign State for the AudiencePerformance report.

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

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

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

CpmBid Decimal Attribute Max CPM Max CPM for the AudiencePerformance report.
CpmBidSource String Attribute Max CPM Source Max CPM Source for the AudiencePerformance report.

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

Criteria String Attribute Audience Audience for the AudiencePerformance report.
CriteriaDestinationUrl String Attribute Destination URL Destination URL for the AudiencePerformance report.
CriterionAttachmentLevel String Attribute Level Level for the AudiencePerformance report.

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

CustomerDescriptiveName String Attribute Client Name Client Name for the AudiencePerformance report.
ExternalCustomerId Long Attribute Customer ID Customer ID for the AudiencePerformance report.
FinalAppUrls String Attribute App Final URL App Final URL for the AudiencePerformance report.
FinalMobileUrls String Attribute Mobile Final URL Mobile Final URL for the AudiencePerformance report.
FinalUrls String Attribute Final URL Final URL for the AudiencePerformance report.
Id Long Attribute Criterion ID Criterion ID for the AudiencePerformance report.
IsRestrict String Attribute Is Restricting Is Restricting for the AudiencePerformance report.

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

Status String Attribute Audience State Audience State for the AudiencePerformance report.

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

TrackingUrlTemplate String Attribute Tracking Template Tracking Template for the AudiencePerformance report.
UrlCustomParameters String Attribute Custom Parameter Custom Parameter for the AudiencePerformance report.
UserListName String Attribute User List Name User List Name for the AudiencePerformance report.
AdGroupId Long Segment Ad Group ID Ad Group ID for the AudiencePerformance report.
AdGroupName String Segment Ad Group Ad Group for the AudiencePerformance report.
AdGroupStatus String Segment Ad Group State Ad Group State for the AudiencePerformance report.

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

AdNetworkType1 String Segment Network Network for the AudiencePerformance report.

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

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

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

ClickType String Segment Click Type Click Type for the AudiencePerformance 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 AudiencePerformance report.
ConversionTrackerId Long Segment Conversion Tracker Id Conversion Tracker Id for the AudiencePerformance report.
ConversionTypeName String Segment Conversion Name Conversion Name for the AudiencePerformance report.
Date Date Segment Day Day for the AudiencePerformance report.
DayOfWeek String Segment Day Of Week Day Of Week for the AudiencePerformance report.

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

Device String Segment Device Device for the AudiencePerformance report.

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

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

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

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

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

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