CData ODBC Driver for Google Ads 2019J - Online Help

CampaignGroupPerformance

CData ODBC Driver for Google Ads 2019J - Build 19.0.7354

The Campaign Group Performance report includes the overall performance statistics of campaigns that you have included in campaign groups. Statistics are aggregated by default at the campaign group level.

テーブル固有の情報

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
Id Long Attribute Campaign Group ID Campaign Group ID for the CampaignGroupPerformance report.
Name String Attribute Campaign Group Name Campaign Group Name for the CampaignGroupPerformance report.
Status String Attribute Campaign Group Status Campaign Group Status for the CampaignGroupPerformance report.

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

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

ActiveViewCpm Decimal Metric Active View Avg CPM Active View Avg CPM for the CampaignGroupPerformance report.
ActiveViewCtr Double Metric Active View Viewable CTR Active View Viewable CTR for the CampaignGroupPerformance report.
ActiveViewImpressions Long Metric Active View Viewable Impressions Active View Viewable Impressions for the CampaignGroupPerformance report.
ActiveViewMeasurability Double Metric Active View Measurable Impr Per Impr Active View Measurable Impr Per Impr for the CampaignGroupPerformance report.
ActiveViewMeasurableCost Decimal Metric Active View Measurable Cost Active View Measurable Cost for the CampaignGroupPerformance report.
ActiveViewMeasurableImpressions Long Metric Active View Measurable Impr Active View Measurable Impr for the CampaignGroupPerformance report.
ActiveViewViewability Double Metric Active View Viewable Impr Per Measurable Impr Active View Viewable Impr Per Measurable Impr for the CampaignGroupPerformance report.
AllConversionRate Double Metric All Conv Rate All Conv Rate for the CampaignGroupPerformance report.
AllConversions Double Metric All Conv All Conv for the CampaignGroupPerformance report.
AllConversionValue Double Metric All Conv Value All Conv Value for the CampaignGroupPerformance report.
AverageCost Decimal Metric Avg Cost Avg Cost for the CampaignGroupPerformance report.
AverageCpe Double Metric Avg CPE Avg CPE for the CampaignGroupPerformance report.
AverageCpv Double Metric Avg CPV Avg CPV for the CampaignGroupPerformance report.
ConversionRate Double Metric Conv Rate Conv Rate for the CampaignGroupPerformance report.
Conversions Double Metric Conversions Conversions for the CampaignGroupPerformance report.
ConversionValue Double Metric Total Conv Value Total Conv Value for the CampaignGroupPerformance report.
CostPerAllConversion Decimal Metric Cost Per All Conv Cost Per All Conv for the CampaignGroupPerformance report.
CostPerConversion Decimal Metric Cost Per Conv Cost Per Conv for the CampaignGroupPerformance report.
CostPerCurrentModelAttributedConversion Double Metric Cost Per Conv (current Model) Cost Per Conv (current Model) for the CampaignGroupPerformance report.
CrossDeviceConversions Double Metric Cross-device Conv Cross-device Conv for the CampaignGroupPerformance report.
CurrentModelAttributedConversions Double Metric Conversions (current Model) Conversions (current Model) for the CampaignGroupPerformance report.
CurrentModelAttributedConversionValue Double Metric Conv Value (current Model) Conv Value (current Model) for the CampaignGroupPerformance report.
EngagementRate Double Metric Engagement Rate Engagement Rate for the CampaignGroupPerformance report.
Engagements Long Metric Engagements Engagements for the CampaignGroupPerformance report.
InteractionRate Double Metric Interaction Rate Interaction Rate for the CampaignGroupPerformance report.
Interactions Long Metric Interactions Interactions for the CampaignGroupPerformance report.
InteractionTypes String Metric Interaction Types Interaction Types for the CampaignGroupPerformance report.
ValuePerAllConversion Double Metric Value Per All Conv Value Per All Conv for the CampaignGroupPerformance report.
ValuePerCurrentModelAttributedConversion Double Metric Value Per Conv (current Model) Value Per Conv (current Model) for the CampaignGroupPerformance report.
VideoViewRate Double Metric View Rate View Rate for the CampaignGroupPerformance report.
VideoViews Long Metric Views Views for the CampaignGroupPerformance report.
ViewThroughConversions Long Metric View-through Conv View-through Conv for the CampaignGroupPerformance 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