CData ODBC Driver for Google Ads 2019J - Online Help

CampaignPerformance

CData ODBC Driver for Google Ads 2019J - Build 19.0.7354

The Campaigns Performance report includes all statistics aggregated by default at the campaign level, one row per campaign.

テーブル固有の情報

Select

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

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

SELECT CampaignId, CampaignName, Device, Clicks, ConversionRate, Impressions FROM CampaignPerformance

WHERE 句では、フィルタを使用することができます。サポートされている処理は、=、!=、>、>=、<、<=、LIKE、NOT LIKE、IN、およびNOT IN operators です。AdWords API ではOR はサポートされていないため、すべてのフィルタはAND で結合される必要があります。 例えば、次のクエリは、100を超えるインプレッションを有効化された(AdWords コンソールのデフォルト設定です)キャンペーンのみを返します。

SELECT CampaignName, CampaignStatus, Impressions FROM CampaignPerformance WHERE CampaignStatus='ENABLED' AND Impressions > 100

Columns

Name Type Behavior DisplayName Description
AccountCurrencyCode String Attribute Currency Currency for the CampaignPerformance report.
AccountDescriptiveName String Attribute Account Account for the CampaignPerformance report.
AccountTimeZone String Attribute Time Zone Time Zone for the CampaignPerformance report.
AdvertisingChannelSubType String Attribute Advertising Sub Channel Advertising Sub Channel for the CampaignPerformance report.

使用できる値は次のとおりです。UNKNOWN, SEARCH_MOBILE_APP, DISPLAY_MOBILE_APP, SEARCH_EXPRESS, DISPLAY_EXPRESS, UNIVERSAL_APP_CAMPAIGN, DISPLAY_SMART_CAMPAIGN, SHOPPING_GOAL_OPTIMIZED_ADS, DISPLAY_GMAIL_AD

AdvertisingChannelType String Attribute Advertising Channel Advertising Channel for the CampaignPerformance report.

使用できる値は次のとおりです。UNKNOWN, SEARCH, DISPLAY, SHOPPING, VIDEO, MULTI_CHANNEL, EXPRESS

Amount Decimal Attribute Budget Budget for the CampaignPerformance report.
BaseCampaignId Long Attribute Base Campaign ID Base Campaign ID for the CampaignPerformance report.
BiddingStrategyId Long Attribute Bid Strategy ID Bid Strategy ID for the CampaignPerformance report.
BiddingStrategyName String Attribute Bid Strategy Name Bid Strategy Name for the CampaignPerformance report.
BiddingStrategyType String Attribute Bid Strategy Type Bid Strategy Type for the CampaignPerformance 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

BudgetId Long Attribute Budget ID Budget ID for the CampaignPerformance report.
CampaignDesktopBidModifier Double Attribute Desktop Bid Adj Desktop Bid Adj for the CampaignPerformance report.
CampaignGroupId Long Attribute Campaign Group ID Campaign Group ID for the CampaignPerformance report.
CampaignId Long Attribute Campaign ID Campaign ID for the CampaignPerformance report.
CampaignMobileBidModifier Double Attribute Mobile Bid Adj Mobile Bid Adj for the CampaignPerformance report.
CampaignName String Attribute Campaign Campaign for the CampaignPerformance report.
CampaignStatus String Attribute Campaign State Campaign State for the CampaignPerformance report.

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

CampaignTabletBidModifier Double Attribute Tablet Bid Adj Tablet Bid Adj for the CampaignPerformance report.
CampaignTrialType String Attribute Campaign Trial Type Campaign Trial Type for the CampaignPerformance report.

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

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

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

CustomerDescriptiveName String Attribute Client Name Client Name for the CampaignPerformance report.
EndDate Date Attribute End Date End Date for the CampaignPerformance report.
EnhancedCpcEnabled String Attribute Enhanced CPC Enabled Enhanced CPC Enabled for the CampaignPerformance report.

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

ExternalCustomerId Long Attribute Customer ID Customer ID for the CampaignPerformance report.
FinalUrlSuffix String Attribute Final URL Suffix Final URL Suffix for the CampaignPerformance report.
HasRecommendedBudget String Attribute Has Recommended Budget Has Recommended Budget for the CampaignPerformance report.

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

IsBudgetExplicitlyShared String Attribute Budget Explicitly Shared Budget Explicitly Shared for the CampaignPerformance report.

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

LabelIds String Attribute Label IDs Label IDs for the CampaignPerformance report.
Labels String Attribute Labels Labels for the CampaignPerformance report.
MaximizeConversionValueTargetRoas Double Attribute Target ROAS (Maximize Conversion Value) Target ROAS (Maximize Conversion Value) for the CampaignPerformance report.
Period String Attribute Budget Period Budget Period for the CampaignPerformance report.
RecommendedBudgetAmount Decimal Attribute Recommended Budget Amount Recommended Budget Amount for the CampaignPerformance report.
ServingStatus String Attribute Campaign Serving Status Campaign Serving Status for the CampaignPerformance report.

使用できる値は次のとおりです。SERVING, NONE, ENDED, PENDING, SUSPENDED

StartDate Date Attribute Start Date Start Date for the CampaignPerformance report.
TotalAmount Decimal Attribute Total Budget Amount Total Budget Amount for the CampaignPerformance report.
TrackingUrlTemplate String Attribute Tracking Template Tracking Template for the CampaignPerformance report.
UrlCustomParameters String Attribute Custom Parameter Custom Parameter for the CampaignPerformance report.
AdNetworkType1 String Segment Network Network for the CampaignPerformance report.

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

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

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

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

ConversionAttributionEventType String Segment Ad Event Type Ad Event Type for the CampaignPerformance report.

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

ConversionCategoryName String Segment Conversion Category Conversion Category for the CampaignPerformance report.
ConversionLagBucket String Segment Days To Conversion Days To Conversion for the CampaignPerformance 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 CampaignPerformance report.
ConversionTypeName String Segment Conversion Name Conversion Name for the CampaignPerformance report.
Date Date Segment Day Day for the CampaignPerformance report.
DayOfWeek String Segment Day Of Week Day Of Week for the CampaignPerformance report.

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

Device String Segment Device Device for the CampaignPerformance report.

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

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

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

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

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

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

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0