CData ODBC Driver for Google Ads 2019J - Online Help

AdgroupPerformance

CData ODBC Driver for Google Ads 2019J - Build 19.0.7354

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

テーブル固有の情報

Select

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

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

SELECT AdGroupId, AdGroupName, CampaignName, Device, Clicks, ConversionRate, Impressions FROM AdGroupPerformance

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

SELECT AdGroupId, AdGroupName, CampaignName, Device, Clicks, ConversionRate, Impressions FROM AdGroupPerformance WHERE CampaignStatus='ENABLED' AND ConversionRate > 0

Columns

Name Type Behavior DisplayName Description
AccountCurrencyCode String Attribute Currency Currency for the AdgroupPerformance report.
AccountDescriptiveName String Attribute Account Account for the AdgroupPerformance report.
AccountTimeZone String Attribute Time Zone Time Zone for the AdgroupPerformance report.
AdGroupDesktopBidModifier Double Attribute Desktop Bid Adj Desktop Bid Adj for the AdgroupPerformance report.
AdGroupId Long Attribute Ad Group ID Ad Group ID for the AdgroupPerformance report.
AdGroupMobileBidModifier Double Attribute Mobile Bid Adj Mobile Bid Adj for the AdgroupPerformance report.
AdGroupName String Attribute Ad Group Ad Group for the AdgroupPerformance report.
AdGroupStatus String Attribute Ad Group State Ad Group State for the AdgroupPerformance report.

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

AdGroupTabletBidModifier Double Attribute Tablet Bid Adj Tablet Bid Adj for the AdgroupPerformance report.
AdGroupType String Attribute Ad Group Type Ad Group Type for the AdgroupPerformance report.

使用できる値は次のとおりです。UNKNOWN, SEARCH_STANDARD, SEARCH_DYNAMIC_ADS, DISPLAY_STANDARD, DISPLAY_ENGAGEMENT, SHOPPING_PRODUCT_ADS, SHOPPING_SHOWCASE_ADS, SHOPPING_GOAL_OPTIMIZED_ADS, VIDEO_TRUE_VIEW_IN_STREAM, VIDEO_TRUE_VIEW_IN_DISPLAY, VIDEO_BUMPER, VIDEO_NON_SKIPPABLE_IN_STREAM, HOTEL_ADS

AdRotationMode String Attribute Ad Rotation Mode Ad Rotation Mode for the AdgroupPerformance report.

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

BaseAdGroupId Long Attribute Base Ad Group ID Base Ad Group ID for the AdgroupPerformance report.
BaseCampaignId Long Attribute Base Campaign ID Base Campaign ID for the AdgroupPerformance report.
BiddingStrategyId Long Attribute Bid Strategy ID Bid Strategy ID for the AdgroupPerformance report.
BiddingStrategyName String Attribute Bid Strategy Name Bid Strategy Name for the AdgroupPerformance report.
BiddingStrategySource String Attribute Bidding Strategy Source Bidding Strategy Source for the AdgroupPerformance report.

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

BiddingStrategyType String Attribute Bid Strategy Type Bid Strategy Type for the AdgroupPerformance 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

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

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

ContentBidCriterionTypeGroup String Attribute Content Network Bid Dimension Content Network Bid Dimension for the AdgroupPerformance report.

使用できる値は次のとおりです。KEYWORD, USER_INTEREST_AND_LIST, VERTICAL, GENDER, AGE_RANGE, PLACEMENT, PARENT, INCOME_RANGE, NONE, UNKNOWN

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

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

CpcBid Decimal Attribute Default Max CPC Default Max CPC for the AdgroupPerformance report.
CpmBid Decimal Attribute Max CPM Max CPM for the AdgroupPerformance report.
CpvBid Decimal Attribute Max CPV Max CPV for the AdgroupPerformance report.
CustomerDescriptiveName String Attribute Client Name Client Name for the AdgroupPerformance report.
EffectiveTargetRoas Double Attribute Target ROAS Target ROAS for the AdgroupPerformance report.
EffectiveTargetRoasSource String Attribute Target ROAS Source Target ROAS Source for the AdgroupPerformance report.

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

EnhancedCpcEnabled String Attribute Enhanced CPC Enabled Enhanced CPC Enabled for the AdgroupPerformance report.

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

ExternalCustomerId Long Attribute Customer ID Customer ID for the AdgroupPerformance report.
FinalUrlSuffix String Attribute Final URL Suffix Final URL Suffix for the AdgroupPerformance report.
LabelIds String Attribute Label IDs Label IDs for the AdgroupPerformance report.
Labels String Attribute Labels Labels for the AdgroupPerformance report.
TargetCpa Decimal Attribute Target CPA Target CPA for the AdgroupPerformance report.
TargetCpaBidSource String Attribute Target CPA Source Target CPA Source for the AdgroupPerformance report.

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

TrackingUrlTemplate String Attribute Tracking Template Tracking Template for the AdgroupPerformance report.
UrlCustomParameters String Attribute Custom Parameter Custom Parameter for the AdgroupPerformance report.
AdNetworkType1 String Segment Network Network for the AdgroupPerformance report.

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

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

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

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

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

Device String Segment Device Device for the AdgroupPerformance report.

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

ExternalConversionSource String Segment Conversion Source Conversion Source for the AdgroupPerformance 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

HourOfDay Integer Segment Hour Of Day Hour Of Day for the AdgroupPerformance report.
Month String Segment Month Month for the AdgroupPerformance report.
MonthOfYear String Segment Month Of Year Month Of Year for the AdgroupPerformance report.

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

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

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

Week String Segment Week Week for the AdgroupPerformance report.
Year Integer Segment Year Year for the AdgroupPerformance 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 AdgroupPerformance report.
ActiveViewCtr Double Metric Active View Viewable CTR Active View Viewable CTR for the AdgroupPerformance report.
ActiveViewImpressions Long Metric Active View Viewable Impressions Active View Viewable Impressions for the AdgroupPerformance report.
ActiveViewMeasurability Double Metric Active View Measurable Impr Per Impr Active View Measurable Impr Per Impr for the AdgroupPerformance report.
ActiveViewMeasurableCost Decimal Metric Active View Measurable Cost Active View Measurable Cost for the AdgroupPerformance report.
ActiveViewMeasurableImpressions Long Metric Active View Measurable Impr Active View Measurable Impr for the AdgroupPerformance report.
ActiveViewViewability Double Metric Active View Viewable Impr Per Measurable Impr Active View Viewable Impr Per Measurable Impr for the AdgroupPerformance report.
AllConversionRate Double Metric All Conv Rate All Conv Rate for the AdgroupPerformance report.
AllConversions Double Metric All Conv All Conv for the AdgroupPerformance report.
AllConversionValue Double Metric All Conv Value All Conv Value for the AdgroupPerformance report.
AverageCost Decimal Metric Avg Cost Avg Cost for the AdgroupPerformance report.
AverageCpc Decimal Metric Avg CPC Avg CPC for the AdgroupPerformance report.
AverageCpe Double Metric Avg CPE Avg CPE for the AdgroupPerformance report.
AverageCpm Decimal Metric Avg CPM Avg CPM for the AdgroupPerformance report.
AverageCpv Double Metric Avg CPV Avg CPV for the AdgroupPerformance report.
AveragePageviews Double Metric Pages Per Session Pages Per Session for the AdgroupPerformance report.
AveragePosition Double Metric Avg Position Avg Position for the AdgroupPerformance report.
AverageTimeOnSite Double Metric Avg Session Duration (seconds) Avg Session Duration (seconds) for the AdgroupPerformance report.
BounceRate Double Metric Bounce Rate Bounce Rate for the AdgroupPerformance report.
ClickAssistedConversions Long Metric Click Assisted Conv Click Assisted Conv for the AdgroupPerformance report.
ClickAssistedConversionsOverLastClickConversions Double Metric Click Assisted Conv Per Last Click Conv Click Assisted Conv Per Last Click Conv for the AdgroupPerformance report.
ClickAssistedConversionValue Double Metric Click Assisted Conv Value Click Assisted Conv Value for the AdgroupPerformance report.
Clicks Long Metric Clicks Clicks for the AdgroupPerformance report.
ContentImpressionShare Double Metric Content Impr Share Content Impr Share for the AdgroupPerformance report.
ContentRankLostImpressionShare Double Metric Content Lost IS (rank) Content Lost IS (rank) for the AdgroupPerformance report.
ConversionRate Double Metric Conv Rate Conv Rate for the AdgroupPerformance report.
Conversions Double Metric Conversions Conversions for the AdgroupPerformance report.
ConversionValue Double Metric Total Conv Value Total Conv Value for the AdgroupPerformance report.
Cost Decimal Metric Cost Cost for the AdgroupPerformance report.
CostPerAllConversion Decimal Metric Cost Per All Conv Cost Per All Conv for the AdgroupPerformance report.
CostPerConversion Decimal Metric Cost Per Conv Cost Per Conv for the AdgroupPerformance report.
CostPerCurrentModelAttributedConversion Double Metric Cost Per Conv (current Model) Cost Per Conv (current Model) for the AdgroupPerformance report.
CrossDeviceConversions Double Metric Cross-device Conv Cross-device Conv for the AdgroupPerformance report.
Ctr Double Metric CTR CTR for the AdgroupPerformance report.
CurrentModelAttributedConversions Double Metric Conversions (current Model) Conversions (current Model) for the AdgroupPerformance report.
CurrentModelAttributedConversionValue Double Metric Conv Value (current Model) Conv Value (current Model) for the AdgroupPerformance report.
EngagementRate Double Metric Engagement Rate Engagement Rate for the AdgroupPerformance report.
Engagements Long Metric Engagements Engagements for the AdgroupPerformance report.
GmailForwards Long Metric Gmail Forwards Gmail Forwards for the AdgroupPerformance report.
GmailSaves Long Metric Gmail Saves Gmail Saves for the AdgroupPerformance report.
GmailSecondaryClicks Long Metric Gmail Clicks To Website Gmail Clicks To Website for the AdgroupPerformance report.
ImpressionAssistedConversions Long Metric Impr Assisted Conv Impr Assisted Conv for the AdgroupPerformance report.
ImpressionAssistedConversionsOverLastClickConversions Double Metric Impr Assisted Conv Per Last Click Conv Impr Assisted Conv Per Last Click Conv for the AdgroupPerformance report.
ImpressionAssistedConversionValue Double Metric Impr Assisted Conv Value Impr Assisted Conv Value for the AdgroupPerformance report.
Impressions Long Metric Impressions Impressions for the AdgroupPerformance report.
InteractionRate Double Metric Interaction Rate Interaction Rate for the AdgroupPerformance report.
Interactions Long Metric Interactions Interactions for the AdgroupPerformance report.
InteractionTypes String Metric Interaction Types Interaction Types for the AdgroupPerformance report.
NumOfflineImpressions Long Metric Phone Impressions Phone Impressions for the AdgroupPerformance report.
NumOfflineInteractions Long Metric Phone Calls Phone Calls for the AdgroupPerformance report.
OfflineInteractionRate Double Metric PTR PTR for the AdgroupPerformance report.
PercentNewVisitors Double Metric Percent New Sessions Percent New Sessions for the AdgroupPerformance report.
RelativeCtr Double Metric Relative CTR Relative CTR for the AdgroupPerformance report.
SearchAbsoluteTopImpressionShare Double Metric Search Abs Top IS Search Abs Top IS for the AdgroupPerformance report.
SearchExactMatchImpressionShare Double Metric Search Exact Match IS Search Exact Match IS for the AdgroupPerformance report.
SearchImpressionShare Double Metric Search Impr Share Search Impr Share for the AdgroupPerformance report.
SearchRankLostImpressionShare Double Metric Search Lost IS (rank) Search Lost IS (rank) for the AdgroupPerformance 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 AdgroupPerformance report.
ValuePerConversion Double Metric Value Per Conv Value Per Conv for the AdgroupPerformance report.
ValuePerCurrentModelAttributedConversion Double Metric Value Per Conv (current Model) Value Per Conv (current Model) for the AdgroupPerformance report.
VideoQuartile100Rate Double Metric Video Played To 100Percent Video Played To 100Percent for the AdgroupPerformance report.
VideoQuartile25Rate Double Metric Video Played To 25Percent Video Played To 25Percent for the AdgroupPerformance report.
VideoQuartile50Rate Double Metric Video Played To 50Percent Video Played To 50Percent for the AdgroupPerformance report.
VideoQuartile75Rate Double Metric Video Played To 75Percent Video Played To 75Percent for the AdgroupPerformance report.
VideoViewRate Double Metric View Rate View Rate for the AdgroupPerformance report.
VideoViews Long Metric Views Views for the AdgroupPerformance report.
ViewThroughConversions Long Metric View-through Conv View-through Conv for the AdgroupPerformance 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