CData ODBC Driver for Google Ads 2019J - Online Help

BudgetPerformance

CData ODBC Driver for Google Ads 2019J - Build 19.0.7354

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

テーブル固有の情報

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
AccountDescriptiveName String Attribute Account Account for the BudgetPerformance report.
Amount Decimal Attribute Budget Budget for the BudgetPerformance report.
BudgetId Long Attribute Budget ID Budget ID for the BudgetPerformance report.
BudgetName String Attribute Budget Name Budget Name for the BudgetPerformance report.
BudgetReferenceCount Integer Attribute # Campaigns # Campaigns for the BudgetPerformance report.
BudgetStatus String Attribute Budget State Budget State for the BudgetPerformance report.

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

DeliveryMethod String Attribute Delivery Method Delivery Method for the BudgetPerformance report.
ExternalCustomerId Long Attribute Customer ID Customer ID for the BudgetPerformance report.
HasRecommendedBudget String Attribute Has Recommended Budget Has Recommended Budget for the BudgetPerformance report.

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

IsBudgetExplicitlyShared String Attribute Explicitly Shared Explicitly Shared for the BudgetPerformance report.

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

Period String Attribute Budget Period Budget Period for the BudgetPerformance report.
RecommendedBudgetAmount Decimal Attribute Recommended Budget Amount Recommended Budget Amount for the BudgetPerformance report.
TotalAmount Decimal Attribute Total Budget Amount Total Budget Amount for the BudgetPerformance report.
AssociatedCampaignId Long Segment Campaign ID Campaign ID for the BudgetPerformance report.
AssociatedCampaignName String Segment Campaign Campaign for the BudgetPerformance report.
AssociatedCampaignStatus String Segment Campaign State Campaign State for the BudgetPerformance report.

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

BudgetCampaignAssociationStatus String Segment Budget Usage Budget Usage for the BudgetPerformance report.

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

ConversionCategoryName String Segment Conversion Category Conversion Category for the BudgetPerformance report.
ConversionTrackerId Long Segment Conversion Tracker Id Conversion Tracker Id for the BudgetPerformance report.
ConversionTypeName String Segment Conversion Name Conversion Name for the BudgetPerformance report.
ExternalConversionSource String Segment Conversion Source Conversion Source for the BudgetPerformance 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

AllConversionRate Double Metric All Conv Rate All Conv Rate for the BudgetPerformance report.
AllConversions Double Metric All Conv All Conv for the BudgetPerformance report.
AllConversionValue Double Metric All Conv Value All Conv Value for the BudgetPerformance report.
AverageCost Decimal Metric Avg Cost Avg Cost for the BudgetPerformance report.
AverageCpc Decimal Metric Avg CPC Avg CPC for the BudgetPerformance report.
AverageCpe Double Metric Avg CPE Avg CPE for the BudgetPerformance report.
AverageCpm Decimal Metric Avg CPM Avg CPM for the BudgetPerformance report.
AverageCpv Double Metric Avg CPV Avg CPV for the BudgetPerformance report.
AveragePosition Double Metric Avg Position Avg Position for the BudgetPerformance report.
Clicks Long Metric Clicks Clicks for the BudgetPerformance report.
ConversionRate Double Metric Conv Rate Conv Rate for the BudgetPerformance report.
Conversions Double Metric Conversions Conversions for the BudgetPerformance report.
ConversionValue Double Metric Total Conv Value Total Conv Value for the BudgetPerformance report.
Cost Decimal Metric Cost Cost for the BudgetPerformance report.
CostPerAllConversion Decimal Metric Cost Per All Conv Cost Per All Conv for the BudgetPerformance report.
CostPerConversion Decimal Metric Cost Per Conv Cost Per Conv for the BudgetPerformance report.
CrossDeviceConversions Double Metric Cross-device Conv Cross-device Conv for the BudgetPerformance report.
Ctr Double Metric CTR CTR for the BudgetPerformance report.
EngagementRate Double Metric Engagement Rate Engagement Rate for the BudgetPerformance report.
Engagements Long Metric Engagements Engagements for the BudgetPerformance report.
Impressions Long Metric Impressions Impressions for the BudgetPerformance report.
InteractionRate Double Metric Interaction Rate Interaction Rate for the BudgetPerformance report.
Interactions Long Metric Interactions Interactions for the BudgetPerformance report.
InteractionTypes String Metric Interaction Types Interaction Types for the BudgetPerformance report.
RecommendedBudgetEstimatedChangeInWeeklyClicks Long Metric Estimated Change In Weekly Clicks At Recommended Budget Estimated Change In Weekly Clicks At Recommended Budget for the BudgetPerformance report.
RecommendedBudgetEstimatedChangeInWeeklyCost Decimal Metric Estimated Change In Weekly Cost At Recommended Budget Estimated Change In Weekly Cost At Recommended Budget for the BudgetPerformance report.
RecommendedBudgetEstimatedChangeInWeeklyInteractions Long Metric Estimated Change In Weekly Interactions At Recommended Budget Estimated Change In Weekly Interactions At Recommended Budget for the BudgetPerformance report.
RecommendedBudgetEstimatedChangeInWeeklyViews Long Metric Estimated Change In Weekly Views At Recommended Budget Estimated Change In Weekly Views At Recommended Budget for the BudgetPerformance report.
ValuePerAllConversion Double Metric Value Per All Conv Value Per All Conv for the BudgetPerformance report.
ValuePerConversion Double Metric Value Per Conv Value Per Conv for the BudgetPerformance report.
VideoViewRate Double Metric View Rate View Rate for the BudgetPerformance report.
VideoViews Long Metric Views Views for the BudgetPerformance report.
ViewThroughConversions Long Metric View-through Conv View-through Conv for the BudgetPerformance 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