CData ODBC Driver for Google Ads 2019J - Online Help

LandingPage

CData ODBC Driver for Google Ads 2019J - Build 19.0.7354

The Landing Page report includes all statistics aggregated by default by the UnexpandedFinalUrlString, one row per the URL string.

Columns

Name Type Behavior DisplayName Description
AdGroupId Long Attribute Ad Group ID Ad Group ID for the LandingPage report.
AdGroupName String Attribute Ad Group Ad Group for the LandingPage report.
CampaignId Long Attribute Campaign ID Campaign ID for the LandingPage report.
CampaignName String Attribute Campaign Campaign for the LandingPage report.
ExpandedFinalUrlString String Attribute Expanded Landing Page Expanded Landing Page for the LandingPage report.
UnexpandedFinalUrlString String Attribute Landing Page Landing Page for the LandingPage report.
AdNetworkType1 String Segment Network Network for the LandingPage report.

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

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

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

Date Date Segment Day Day for the LandingPage report.
DayOfWeek String Segment Day Of Week Day Of Week for the LandingPage report.

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

Device String Segment Device Device for the LandingPage report.

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

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

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

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

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

Week String Segment Week Week for the LandingPage report.
Year Integer Segment Year Year for the LandingPage report.
ActiveViewCpm Decimal Metric Active View Avg CPM Active View Avg CPM for the LandingPage report.
ActiveViewCtr Double Metric Active View Viewable CTR Active View Viewable CTR for the LandingPage report.
ActiveViewImpressions Long Metric Active View Viewable Impressions Active View Viewable Impressions for the LandingPage report.
ActiveViewMeasurability Double Metric Active View Measurable Impr Per Impr Active View Measurable Impr Per Impr for the LandingPage report.
ActiveViewMeasurableCost Decimal Metric Active View Measurable Cost Active View Measurable Cost for the LandingPage report.
ActiveViewMeasurableImpressions Long Metric Active View Measurable Impr Active View Measurable Impr for the LandingPage report.
ActiveViewViewability Double Metric Active View Viewable Impr Per Measurable Impr Active View Viewable Impr Per Measurable Impr for the LandingPage report.
AverageCost Decimal Metric Avg Cost Avg Cost for the LandingPage report.
AverageCpc Decimal Metric Avg CPC Avg CPC for the LandingPage report.
AverageCpm Decimal Metric Avg CPM Avg CPM for the LandingPage report.
AveragePosition Double Metric Avg Position Avg Position for the LandingPage report.
Clicks Long Metric Clicks Clicks for the LandingPage report.
ConversionRate Double Metric Conv Rate Conv Rate for the LandingPage report.
Conversions Double Metric Conversions Conversions for the LandingPage report.
ConversionValue Double Metric Total Conv Value Total Conv Value for the LandingPage report.
Cost Decimal Metric Cost Cost for the LandingPage report.
CostPerConversion Decimal Metric Cost Per Conv Cost Per Conv for the LandingPage report.
Ctr Double Metric CTR CTR for the LandingPage report.
Impressions Long Metric Impressions Impressions for the LandingPage report.
InteractionRate Double Metric Interaction Rate Interaction Rate for the LandingPage report.
Interactions Long Metric Interactions Interactions for the LandingPage report.
InteractionTypes String Metric Interaction Types Interaction Types for the LandingPage report.
PercentageMobileFriendlyClicks Double Metric Mobile-friendly Click Rate Mobile-friendly Click Rate for the LandingPage report.
PercentageValidAcceleratedMobilePagesClicks Double Metric Valid AMP Click Rate Valid AMP Click Rate for the LandingPage report.
SpeedScore Long Metric Mobile Speed Score Mobile Speed Score for the LandingPage report.
ValuePerConversion Double Metric Value Per Conv Value Per Conv for the LandingPage 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