CData ODBC Driver for Google Ads 2019J - Online Help

FinalUrl

CData ODBC Driver for Google Ads 2019J - Build 19.0.7354

The Final URL report includes all statistics aggregated at the final URL level, one row per final URL. If other segment fields are used, you may get more than one row per final URL.

Columns

Name Type Behavior DisplayName Description
AccountCurrencyCode String Attribute Currency Currency for the FinalUrl report.
AccountDescriptiveName String Attribute Account Account for the FinalUrl report.
AccountTimeZone String Attribute Time Zone Time Zone for the FinalUrl report.
AdGroupId Long Attribute Ad Group ID Ad Group ID for the FinalUrl report.
AdGroupName String Attribute Ad Group Ad Group for the FinalUrl report.
AdGroupStatus String Attribute Ad Group State Ad Group State for the FinalUrl report.

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

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

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

CampaignId Long Attribute Campaign ID Campaign ID for the FinalUrl report.
CampaignName String Attribute Campaign Campaign for the FinalUrl report.
CampaignStatus String Attribute Campaign State Campaign State for the FinalUrl report.

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

CriteriaTypeName String Attribute Match Type Match Type for the FinalUrl report.
CustomerDescriptiveName String Attribute Client Name Client Name for the FinalUrl report.
EffectiveFinalUrl String Attribute Final URL Final URL for the FinalUrl report.
EffectiveTrackingUrlTemplate String Attribute Tracking Template Tracking Template for the FinalUrl report.
ExternalCustomerId Long Attribute Customer ID Customer ID for the FinalUrl report.
AdNetworkType1 String Segment Network Network for the FinalUrl report.

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

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

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

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

ConversionCategoryName String Segment Conversion Category Conversion Category for the FinalUrl report.
ConversionTrackerId Long Segment Conversion Tracker Id Conversion Tracker Id for the FinalUrl report.
ConversionTypeName String Segment Conversion Name Conversion Name for the FinalUrl report.
CriteriaParameters String Segment Keyword Per Placement Keyword Per Placement for the FinalUrl report.
Date Date Segment Day Day for the FinalUrl report.
DayOfWeek String Segment Day Of Week Day Of Week for the FinalUrl report.

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

Device String Segment Device Device for the FinalUrl report.

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

ExternalConversionSource String Segment Conversion Source Conversion Source for the FinalUrl 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

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

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

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

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

Week String Segment Week Week for the FinalUrl report.
Year Integer Segment Year Year for the FinalUrl report.
ActiveViewCpm Decimal Metric Active View Avg CPM Active View Avg CPM for the FinalUrl report.
ActiveViewCtr Double Metric Active View Viewable CTR Active View Viewable CTR for the FinalUrl report.
ActiveViewImpressions Long Metric Active View Viewable Impressions Active View Viewable Impressions for the FinalUrl report.
ActiveViewMeasurability Double Metric Active View Measurable Impr Per Impr Active View Measurable Impr Per Impr for the FinalUrl report.
ActiveViewMeasurableCost Decimal Metric Active View Measurable Cost Active View Measurable Cost for the FinalUrl report.
ActiveViewMeasurableImpressions Long Metric Active View Measurable Impr Active View Measurable Impr for the FinalUrl report.
ActiveViewViewability Double Metric Active View Viewable Impr Per Measurable Impr Active View Viewable Impr Per Measurable Impr for the FinalUrl report.
AllConversionRate Double Metric All Conv Rate All Conv Rate for the FinalUrl report.
AllConversions Double Metric All Conv All Conv for the FinalUrl report.
AllConversionValue Double Metric All Conv Value All Conv Value for the FinalUrl report.
AverageCost Decimal Metric Avg Cost Avg Cost for the FinalUrl report.
AverageCpc Decimal Metric Avg CPC Avg CPC for the FinalUrl report.
AverageCpe Double Metric Avg CPE Avg CPE for the FinalUrl report.
AverageCpm Decimal Metric Avg CPM Avg CPM for the FinalUrl report.
AverageCpv Double Metric Avg CPV Avg CPV for the FinalUrl report.
AveragePosition Double Metric Avg Position Avg Position for the FinalUrl report.
Clicks Long Metric Clicks Clicks for the FinalUrl report.
ConversionRate Double Metric Conv Rate Conv Rate for the FinalUrl report.
Conversions Double Metric Conversions Conversions for the FinalUrl report.
ConversionValue Double Metric Total Conv Value Total Conv Value for the FinalUrl report.
Cost Decimal Metric Cost Cost for the FinalUrl report.
CostPerAllConversion Decimal Metric Cost Per All Conv Cost Per All Conv for the FinalUrl report.
CostPerConversion Decimal Metric Cost Per Conv Cost Per Conv for the FinalUrl report.
CrossDeviceConversions Double Metric Cross-device Conv Cross-device Conv for the FinalUrl report.
Ctr Double Metric CTR CTR for the FinalUrl report.
EngagementRate Double Metric Engagement Rate Engagement Rate for the FinalUrl report.
Engagements Long Metric Engagements Engagements for the FinalUrl report.
Impressions Long Metric Impressions Impressions for the FinalUrl report.
InteractionRate Double Metric Interaction Rate Interaction Rate for the FinalUrl report.
Interactions Long Metric Interactions Interactions for the FinalUrl report.
InteractionTypes String Metric Interaction Types Interaction Types for the FinalUrl report.
ValuePerAllConversion Double Metric Value Per All Conv Value Per All Conv for the FinalUrl report.
ValuePerConversion Double Metric Value Per Conv Value Per Conv for the FinalUrl report.
VideoViewRate Double Metric View Rate View Rate for the FinalUrl report.
VideoViews Long Metric Views Views for the FinalUrl report.
ViewThroughConversions Long Metric View-through Conv View-through Conv for the FinalUrl 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