CData ODBC Driver for Google Ads 2019J - Online Help

MarketplacePerformance

CData ODBC Driver for Google Ads 2019J - Build 19.0.7354

The Marketplace Performance report includes all statistics of ads displayed on the Marketplace, aggregated by default at the account level.

Columns

Name Type Behavior DisplayName Description
AdGroupId Long Attribute Ad Group ID Ad Group ID for the MarketplacePerformance report.
CampaignId Long Attribute Campaign ID Campaign ID for the MarketplacePerformance report.
Date Date Segment Day Day for the MarketplacePerformance report.
DayOfWeek String Segment Day Of Week Day Of Week for the MarketplacePerformance report.

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

Month String Segment Month Month for the MarketplacePerformance report.
MonthOfYear String Segment Month Of Year Month Of Year for the MarketplacePerformance report.

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

Quarter String Segment Quarter Quarter for the MarketplacePerformance report.
Week String Segment Week Week for the MarketplacePerformance report.
Year Integer Segment Year Year for the MarketplacePerformance report.
AverageCpc Decimal Metric Avg CPC Avg CPC for the MarketplacePerformance report.
AverageCpm Decimal Metric Avg CPM Avg CPM for the MarketplacePerformance report.
Clicks Long Metric Clicks Clicks for the MarketplacePerformance report.
ConversionRate Double Metric Conv Rate Conv Rate for the MarketplacePerformance report.
Conversions Double Metric Conversions Conversions for the MarketplacePerformance report.
ConversionValue Double Metric Total Conv Value Total Conv Value for the MarketplacePerformance report.
Cost Decimal Metric Cost Cost for the MarketplacePerformance report.
CostPerConversion Decimal Metric Cost Per Conv Cost Per Conv for the MarketplacePerformance report.
Ctr Double Metric CTR CTR for the MarketplacePerformance report.
Impressions Long Metric Impressions Impressions for the MarketplacePerformance report.
ValuePerConversion Double Metric Value Per Conv Value Per Conv for the MarketplacePerformance 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