CData Python Connector for Yahoo! Ads

Build 24.0.9062

Stats

Get the stats information of each campaign, ad group, ad, image and video.

Table Specific Information

SELECT

The 本製品 will use the Yahoo! Ads API to process WHERE clause conditions built with the following column and operator. AccountId is required to make a request. The rest of the filter is executed client side within the 本製品.

  • AccountId supports the '='.
  • StatsPeriod supports the '='.
  • Type supports the '='.
  • campaignId supports the '=,IN'.
  • adGroupId supports the '=,IN'.
  • adId supports the '=,IN'.
  • mediaId supports the '=,IN'.
  • EndDate supports the '='.
  • StartDate supports the '='.
  • targetType supports the '=,IN'.

For example:

SELECT * FROM Stats WHERE AccountId = '1002504155'

SELECT  * FROM Stats WHERE AccountId = '1002504155' AND CampaignId = '1833923'

SELECT  * FROM Stats WHERE AccountId = '1002504155' AND Type = 'CAMPAIGN'

SELECT  * FROM Stats WHERE AccountId = '1002504155' AND AdGroupId = '303133212'

SELECT  * FROM Stats WHERE AccountId = '1002504155' AND StatsPeriod = 'REALTIME_MONTH'

SELECT  * FROM Stats WHERE AccountId = '1002504155' AND StartDate = '20210703'

SELECT  * FROM Stats WHERE AccountId = '1002504155' AND EndDate = '20210703'

Columns

Name Type References Description
AccountId [KEY] Int64

DisplayAdsAccounts.AccountId

Account ID.
AdGroupStatsValueAdGroupId Int64 Ad group ID.
AdGroupStatsValueAdGroupName String Ad group name.
AdGroupStatsValueCampaignId Int64 Campaign ID.
AdGroupStatsValueCampaignName String Campaign name.
AdGroupStatsValueStatsAllConvRate String Conv. rate (all)
AdGroupStatsValueStatsAllConv Int64 Conversions (all)
AdGroupStatsValueStatsAllConvValue String Conv. value (all)
AdGroupStatsValueStatsAllConvValuePerCost String Conv. value (all)/cost All Conv.
AdGroupStatsValueStatsAllCpa String Cost/conv. (all)
AdGroupStatsValueStatsAvgCpv String Avg. CPV
AdGroupStatsValueStatsAvgDurationVideoViewed String Avg. duration of video viewed
AdGroupStatsValueStatsAvgPercentVideoViewed String Avg. video view rate
AdGroupStatsValueStatsAvgCpc String Avg. CPC
AdGroupStatsValueStatsAvgDeliverRank String Avg. position (the average of eCPM rank on ads delivery)
AdGroupStatsValueStatsImpressionShareBudgetLoss String Impression share lost rate(budget)
AdGroupStatsValueStatsClicks Int64 Number of clicks
AdGroupStatsValueStatsClickRate String Click through rate
AdGroupStatsValueStatsClickRatePrev String CTR (previous)
AdGroupStatsValueStatsConvRate String Conv. rate
AdGroupStatsValueStatsConversionRateViaAdClick String Conv. rate (via click)
AdGroupStatsValueStatsConversions Int64 Conversions
AdGroupStatsValueStatsConversionsViaAdClick Int64 Conversions (via click)
AdGroupStatsValueStatsConvValue String Conv. value
AdGroupStatsValueStatsConversionValueViaAdClick String Conv. value (via click)
AdGroupStatsValueStatsConvValuePerCost String Conversions value/cost
AdGroupStatsValueStatsConvValueViaAdClickPerCost String Conversions value(via ad clicks)/cost
AdGroupStatsValueStatsCost String Cost
AdGroupStatsValueStatsCpa String Conversion cost per acquisition
AdGroupStatsValueStatsCpaViaAdClick String Cost/conv. (via click)
AdGroupStatsValueStatsCrossDeviceConversions Int64 Cross-device conv.
AdGroupStatsValueStatsImpressionShare String Impression share
AdGroupStatsValueStatsImps Int64 Number of impressions
AdGroupStatsValueStatsImpsPrev String Impressions (previous)
AdGroupStatsValueStatsInViewClickCnt Int64 Viewable clicks (previous)
AdGroupStatsValueStatsInViewClickRate String Viewable CTR (previous)
AdGroupStatsValueStatsInViewRate String Viewable impression rate (previous)
AdGroupStatsValueStatsMeasuredImps String Measured impressions
AdGroupStatsValueStatsMeasuredImpsRate String Measured impression rate
AdGroupStatsValueStatsPaidVideoViewRate String Paid video view rate (CPV)
AdGroupStatsValueStatsPaidVideoViews Int64 Paid video views (CPV)
AdGroupStatsValueStatsImpressionShareRankLoss String Impression share lost rate(rank)
AdGroupStatsValueStatsTotalVimps Int64 Measured impressions (previous)
AdGroupStatsValueStatsValuePerAllConv String Conv. value (all)/conv. (all)
AdGroupStatsValueStatsValuePerConv String Conv. value/conv.
AdGroupStatsValueStatsValuePerConversionsViaAdClick String Conv. value (via click)/conv. (via click)
AdGroupStatsValueStatsVideoViews Int64 Video views
AdGroupStatsValueStatsVideoViewsTo100 Int64 100% video views
AdGroupStatsValueStatsVideoViewsTo10Sec Int64 10 sec video views
AdGroupStatsValueStatsVideoViewsTo25 Int64 25% video views
AdGroupStatsValueStatsVideoViewsTo3Sec Int64 3 sec video views
AdGroupStatsValueStatsVideoViewsTo50 Int64 50% video views
AdGroupStatsValueStatsVideoViewsTo75 Int64 75% video views
AdGroupStatsValueStatsVideoViewsTo95 Int64 95% video views
AdGroupStatsValueStatsVideoViewThroughRate String Video view through rate
AdGroupStatsValueStatsViewableClickRate String Viewable CTR
AdGroupStatsValueStatsViewableClicks String Viewable clicks
AdGroupStatsValueStatsViewableImpsRate String Viewable impression rate
AdGroupStatsValueStatsConvValueViaViewThrough Int64 View through conversions
AdGroupStatsValueStatsViewableImps Int64 Viewable impressions
AdStatsValueAdGroupId Int64 Ad group ID
AdStatsValueAdGroupName String Ad group name
AdStatsValueAdId Int64 Ad ID
AdStatsValueAdName String Ad name
AdStatsValueCampaignId Int64 Campaign ID.
AdStatsValueCampaignName String Campaign name.
AdStatsValueStatsAllConvRate String Conv. rate (all)
AdStatsValueStatsAllConv Int64 Conversions (all)
AdStatsValueStatsAllConvValue String Conv. value (all)
AdStatsValueStatsAllConvValuePerCost String Conv. value (all)/cost All Conv.
AdStatsValueStatsAllCpa String Cost/conv. (all)
AdStatsValueStatsAvgCpv String Avg. CPV
AdStatsValueStatsAvgDurationVideoViewed String Avg. duration of video viewed
AdStatsValueStatsAvgPercentVideoViewed String Avg. video view rate
AdStatsValueStatsAvgCpc String Avg. CPC
AdStatsValueStatsAvgDeliverRank String Avg. position (the average of eCPM rank on ads delivery)
AdStatsValueStatsImpressionShareBudgetLoss String Impression share lost rate(budget)
AdStatsValueStatsClicks Int64 Number of clicks
AdStatsValueStatsClickRate String Click through rate
AdStatsValueStatsClickRatePrev String CTR (previous)
AdStatsValueStatsConvRate String Conv. rate
AdStatsValueStatsConversionRateViaAdClick String Conv. rate (via click)
AdStatsValueStatsConversions Int64 Conversions
AdStatsValueStatsConversionsViaAdClick Int64 Conversions (via click)
AdStatsValueStatsConvValue String Conv. value
AdStatsValueStatsConvValueViaAdClick String Conv. value (via click)
AdStatsValueStatsConvValuePerCost String Conversions value/cost
AdStatsValueStatsConvValueViaAdClickPerCost String Conversions value(via ad clicks)/cost
AdStatsValueStatsCost String Cost
AdStatsValueStatsCpa String Conversion cost per acquisition
AdStatsValueStatsCpaViaAdClick String Cost/conv. (via click)
AdStatsValueStatsCrossDeviceConversions Int64 Cross-device conv.
AdStatsValueStatsImpressionShare String Impression share
AdStatsValueStatsImps Int64 Number of impressions
AdStatsValueStatsImpsPrev String Impressions (previous)
AdStatsValueStatsInViewClickCnt Int64 Viewable clicks (previous)
AdStatsValueStatsInViewClickRate String Viewable CTR (previous)
AdStatsValueStatsInViewRate String Viewable impression rate (previous)
AdStatsValueStatsMeasuredImps String Measured impressions
AdStatsValueStatsMeasuredImpsRate String Measured impression rate
AdStatsValueStatsPaidVideoViewRate String Paid video view rate (CPV)
AdStatsValueStatsPaidVideoViews Int64 Paid video views (CPV)
AdStatsValueStatsImpressionShareRankLoss String Impression share lost rate(rank)
AdStatsValueStatsTotalVimps Int64 Measured impressions (previous)
AdStatsValueStatsValuePerAllConv String Conv. value (all)/conv. (all)
AdStatsValueStatsValuePerConv String Conv. value/conv.
AdStatsValueStatsValuePerConvViaAdClick String Conv. value (via click)/conv. (via click)
AdStatsValueStatsVideoViews Int64 Video views
AdStatsValueStatsVideoViewsTo100 Int64 100% video views
AdStatsValueStatsVideoViewsTo10Sec Int64 10 sec video views
AdStatsValueStatsVideoViewsTo25 Int64 25% video views
AdStatsValueStatsVideoViewsTo3Sec Int64 3 sec video views
AdStatsValueStatsVideoViewsTo50 Int64 50% video views
AdStatsValueStatsVideoViewsTo75 Int64 75% video views
AdStatsValueStatsVideoViewsTo95 Int64 95% video views
AdStatsValueStatsVideoViewThroughRate String Video view through rate
AdStatsValueStatsViewableClickRate String Viewable CTR
AdStatsValueStatsViewableClicks String Viewable clicks
AdStatsValueStatsViewableImpsRate String Viewable impression rate
AdStatsValueStatsConvValueViaViewThrough Int64 View through conversions
AdStatsValueStatsViewableImps Int64 Viewable impressions
CampaignStatsValueCampaignId Int64 Campaign ID.
CampaignStatsValueCampaignName String Campaign name.
CampaignStatsValueStatsAllConvRate String Conv. rate (all)
CampaignStatsValueStatsAllConv Int64 Conversions (all)
CampaignStatsValueStatsAllConvValue String Conv. value (all)
CampaignStatsValueStatsAllConvValuePerCost String Conv. value (all)/cost All Conv.
CampaignStatsValueStatsAllCpa String Cost/conv. (all)
CampaignStatsValueStatsAvgCpv String Avg. CPV
CampaignStatsValueStatsAvgDurationVideoViewed String Avg. duration of video viewed
CampaignStatsValueStatsAvgPercentVideoViewed String Avg. video view rate
CampaignStatsValueStatsAvgCpc String Avg. CPC
CampaignStatsValueStatsAvgDeliverRank String Avg. position (the average of eCPM rank on ads delivery)
CampaignStatsValueStatsImpressionShareBudgetLoss String Impression share lost rate(budget)
CampaignStatsValueStatsClicks Int64 Number of clicks
CampaignStatsValueStatsClickRate String Click through rate
CampaignStatsValueStatsClickRatePrev String CTR (previous)
CampaignStatsValueStatsConvRate String Conv. rate
CampaignStatsValueStatsConversionRateViaAdClick String Conv. rate (via click)
CampaignStatsValueStatsConversions Int64 Conversions
CampaignStatsValueStatsConversionsViaAdClick Int64 Conversions (via click)
CampaignStatsValueStatsConvValue String Conv. value
CampaignStatsValueStatsConvValueViaAdClick String Conv. value (via click)
CampaignStatsValueStatsConvValuePerCost String Conversions value/cost
CampaignStatsValueStatsConvValueViaAdClickPerCost String Conversions value(via ad clicks)/cost
CampaignStatsValueStatsCost String Cost
CampaignStatsValueStatsCpa String Conversion cost per acquisition
CampaignStatsValueStatsCpaViaAdClick String Cost/conv. (via click)
CampaignStatsValueStatsCrossDeviceConversions Int64 Cross-device conv.
CampaignStatsValueStatsImpressionShare String Impression share
CampaignStatsValueStatsImps Int64 Number of impressions
CampaignStatsValueStatsImpsPrev String Impressions (previous)
CampaignStatsValueStatsInViewClickCnt Int64 Viewable clicks (previous)
CampaignStatsValueStatsInViewClickRate String Viewable CTR (previous)
CampaignStatsValueStatsInViewRate String Viewable impression rate (previous)
CampaignStatsValueStatsMeasuredImps String Measured impressions
CampaignStatsValueStatsMeasuredImpsRate String Measured impression rate
CampaignStatsValueStatsPaidVideoViewRate String Paid video view rate (CPV)
CampaignStatsValueStatsPaidVideoViews Int64 Paid video views (CPV)
CampaignStatsValueStatsImpressionShareRankLoss String Impression share lost rate(rank)
CampaignStatsValueStatsTotalVimps Int64 Measured impressions (previous)
CampaignStatsValueStatsValuePerAllConv String Conv. value (all)/conv. (all)
CampaignStatsValueStatsValuePerConv String Conv. value/conv.
CampaignStatsValueStatsValuePerConvViaAdClick String Conv. value (via click)/conv. (via click)
CampaignStatsValueStatsVideoViews Int64 Video views
CampaignStatsValueStatsVideoViewsTo100 Int64 100% video views
CampaignStatsValueStatsVideoViewsTo10Sec Int64 10 sec video views
CampaignStatsValueStatsVideoViewsTo25 Int64 25% video views
CampaignStatsValueStatsVideoViewsTo3Sec Int64 3 sec video views
CampaignStatsValueStatsVideoViewsTo50 Int64 50% video views
CampaignStatsValueStatsVideoViewsTo75 Int64 75% video views
CampaignStatsValueStatsVideoViewsTo95 Int64 95% video views
CampaignStatsValueStatsVideoViewThroughRate String Video view through rate
CampaignStatsValueStatsViewableClickRate String Viewable CTR
CampaignStatsValueStatsViewableClicks String Viewable clicks
CampaignStatsValueStatsViewableImpsRate String Viewable impression rate
CampaignStatsValueStatsConvValueViaViewThrough Int64 View through conversions
CampaignStatsValueStatsViewableImps Int64 Viewable impressions
Errors String Error information.
ImageStatsValueMediaId Int64 Media ID
ImageStatsValueMediaName String File name
ImageStatsValueMediaTitle String Media title
ImageStatsValueStatsAllConvRate String Conv. rate (all)
ImageStatsValueStatsAllConv Int64 Conversions (all)
ImageStatsValueStatsAllConvValue String Conv. value (all)
ImageStatsValueStatsAllConvValuePerCost String Conv. value (all)/cost All Conv.
ImageStatsValueStatsAllCpa String Cost/conv. (all)
ImageStatsValueStatsAvgCpv String Avg. CPV
ImageStatsValueStatsAvgDurationVideoViewed String Avg. duration of video viewed
ImageStatsValueStatsAvgPercentVideoViewed String Avg. video view rate
ImageStatsValueStatsAvgCpc String Avg. CPC
ImageStatsValueStatsAvgDeliverRank String Avg. position (the average of eCPM rank on ads delivery)
ImageStatsValueStatsImpressionShareBudgetLoss String Impression share lost rate(budget)
ImageStatsValueStatsClicks Int64 Number of clicks
ImageStatsValueStatsClickRate String Click through rate
ImageStatsValueStatsClickRatePrev String CTR (previous)
ImageStatsValueStatsConvRate String Conv. rate
ImageStatsValueStatsConversionRateViaAdClick String Conv. rate (via click)
ImageStatsValueStatsConversions Int64 Conversions
ImageStatsValueStatsConversionsViaAdClick Int64 Conversions (via click)
ImageStatsValueStatsConvValue String Conv. value
ImageStatsValueStatsConvValueViaAdClick String Conv. value (via click)
ImageStatsValueStatsConvValuePerCost String Conversions value/cost
ImageStatsValueStatsConvValueViaAdClickPerCost String Conversions value(via ad clicks)/cost
ImageStatsValueStatsCost String Cost
ImageStatsValueStatsCpa String Conversion cost per acquisition
ImageStatsValueStatsCpaViaAdClick String Cost/conv. (via click)
ImageStatsValueStatsCrossDeviceConversions Int64 Cross-device conv.
ImageStatsValueStatsImpressionShare String Impression share
ImageStatsValueStatsImps Int64 Number of impressions
ImageStatsValueStatsImpsPrev String Impressions (previous)
ImageStatsValueStatsInViewClickCnt Int64 Viewable clicks (previous)
ImageStatsValueStatsInViewClickRate String Viewable CTR (previous)
ImageStatsValueStatsInViewRate String Viewable impression rate (previous)
ImageStatsValueStatsMeasuredImps String Measured impressions
ImageStatsValueStatsMeasuredImpsRate String Measured impression rate
ImageStatsValueStatsPaidVideoViewRate String Paid video view rate (CPV)
ImageStatsValueStatsPaidVideoViews Int64 Paid video views (CPV)
ImageStatsValueStatsImpressionShareRankLoss String Impression share lost rate(rank)
ImageStatsValueStatsTotalVimps Int64 Measured impressions (previous)
ImageStatsValueStatsValuePerAllConv String Conv. value (all)/conv. (all)
ImageStatsValueStatsValuePerConv String Conv. value/conv.
ImageStatsValueStatsValuePerConvViaAdClick String Conv. value (via click)/conv. (via click)
ImageStatsValueStatsVideoViews Int64 Video views
ImageStatsValueStatsVideoViewsTo100 Int64 100% video views
ImageStatsValueStatsVideoViewsTo10Sec Int64 10 sec video views
ImageStatsValueStatsVideoViewsTo25 Int64 25% video views
ImageStatsValueStatsVideoViewsTo3Sec Int64 3 sec video views
ImageStatsValueStatsVideoViewsTo50 Int64 50% video views
ImageStatsValueStatsVideoViewsTo75 Int64 75% video views
ImageStatsValueStatsVideoViewsTo95 Int64 95% video views
ImageStatsValueStatsVideoViewThroughRate String Video view through rate
ImageStatsValueStatsViewableClickRate String Viewable CTR
ImageStatsValueStatsViewableClicks String Viewable clicks
ImageStatsValueStatsViewableImpsRate String Viewable impression rate
ImageStatsValueStatsConvValueViaViewThrough Int64 View through conversions
ImageStatsValueStatsViewableImps Int64 Viewable impressions
OperationSucceeded Boolean The process results. If true, the process succeeded. If false, the process failed.
PeriodCustomDateEndDate Date Acquisition end date of stats information.
PeriodCustomDateStartDate Date Acquisition start date of stats information.
StatsPeriod String Summarized period of statistics

使用できる値は次のとおりです。REALTIME_TODAY, DEFINITE_VALUE_YESTERDAY, DEFINITE_VALUE_LASTWEEK, DEFINITE_VALUE_LASTBSDAY, DEFINITE_VALUE_WEEK, DEFINITE_VALUE_TWOWEEK, DEFINITE_VALUE_THIRTYDAY, REALTIME_MONTH, DEFINITE_VALUE_LASTMONTH, REALTIME_LAST25MONTH, REALTIME_LAST37MONTH, CUSTOM_DATE, UNKNOWN

TargetStatsValueAdGroupId Int64 Ad group ID.
TargetStatsValueAdGroupName String Ad group name.
TargetStatsValueCampaignId Int64 Campaign ID.
TargetStatsValueCampaignName String Campaign name.
TargetStatsValueStatsAllConRate String Conv. rate (all)
TargetStatsValueStatsAllConv Int64 Conversions (all)
TargetStatsValueStatsAllConvValue String Conv. value (all)
TargetStatsValueStatsAllConvValuePerCost String Conv. value (all)/cost All Conv.
TargetStatsValueStatsAllCpa String Cost/conv. (all)
TargetStatsValueStatsAvgCpv String Avg. CPV
TargetStatsValueStatsAvgDurationVideoViewed String Avg. duration of video viewed
TargetStatsValueStatsAvgPercentVideoViewed String Avg. video view rate
TargetStatsValueStatsAvgCpc String Avg. CPC
TargetStatsValueStatsAvgDeliverRank String Avg. position (the average of eCPM rank on ads delivery)
TargetStatsValueStatsImpressionShareBudgetLoss String Impression share lost rate(budget)
TargetStatsValueStatsClicks Int64 Number of clicks
TargetStatsValueStatsClickRate String Click through rate
TargetStatsValueStatsClickRatePrev String CTR (previous)
TargetStatsValueStatsConvRate String Conv. rate
TargetStatsValueStatsConversionRateViaAdClick String Conv. rate (via click)
TargetStatsValueStatsConversions Int64 Conversions
TargetStatsValueStatsConversionsViaAdClick Int64 Conversions (via click)
TargetStatsValueStatsConvValue String Conv. value
TargetStatsValueStatsConvValueViaAdClick String Conv. value (via click)
TargetStatsValueStatsConvValuePerCost String Conversions value/cost
TargetStatsValueStatsConvValueViaAdClickPerCost String Conversions value(via ad clicks)/cost
TargetStatsValueStatsCost String Cost
TargetStatsValueStatsCpa String Conversion cost per acquisition
TargetStatsValueStatsCpaViaAdClick String Cost/conv. (via click)
TargetStatsValueStatsCrossDeviceConversions Int64 Cross-device conv.
TargetStatsValueStatsImpressionShare String Impression share
TargetStatsValueStatsImps Int64 Number of impressions
TargetStatsValueStatsImpsPrev String Impressions (previous)
TargetStatsValueStatsInViewClickCnt Int64 Viewable clicks (previous)
TargetStatsValueStatsInViewClickRate String Viewable CTR (previous)
TargetStatsValueStatsInViewRate String Viewable impression rate (previous)
TargetStatsValueStatsMeasuredImps String Measured impressions
TargetStatsValueStatsMeasuredImpsRate String Measured impression rate
TargetStatsValueStatsPaidVideoViewRate String Paid video view rate (CPV)
TargetStatsValueStatsPaidVideoViews Int64 Paid video views (CPV)
TargetStatsValueStatsImpressionShareRankLoss String Impression share lost rate(rank)
TargetStatsValueStatsTotalVimps Int64 Measured impressions (previous)
TargetStatsValueStatsValuePerAllConv String Conv. value (all)/conv. (all)
TargetStatsValueStatsValuePerConv String Conv. value/conv.
TargetStatsValueStatsValuePerConvViaAdClick String Conv. value (via click)/conv. (via click)
TargetStatsValueStatsVideoViews Int64 Video views
TargetStatsValueStatsVideoViewsTo100 Int64 100% video views
TargetStatsValueStatsVideoViewsTo10Sec Int64 10 sec video views
TargetStatsValueStatsVideoViewsTo25 Int64 25% video views
TargetStatsValueStatsVideoViewsTo3Sec Int64 3 sec video views
TargetStatsValueStatsVideoViewsTo50 Int64 50% video views
TargetStatsValueStatsVideoViewsTo75 Int64 75% video views
TargetStatsValueStatsVideoViewsTo95 Int64 95% video views
TargetStatsValueStatsVideoViewThroughRate String Video view through rate
TargetStatsValueStatsViewableClickRate String Viewable CTR
TargetStatsValueStatsViewableClicks String Viewable clicks
TargetStatsValueStatsViewableImpsRate String Viewable impression rate
TargetStatsValueStatsConvValueViaViewThrough Int64 View through conversions
TargetStatsValueStatsViewableImps Int64 Viewable impressions
TargetStatsValueTargetAdScheduleTargetDayOfWeek String Days of the week to deliver.

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

TargetStatsValueTargetAdScheduleTargetEndHour Int64 End time (hour only)
TargetStatsValueTargetAdScheduleTargetStartHour Int64 Start time (hour only)
TargetStatsValueTargetAgeTargetAge String Format of age classification.

使用できる値は次のとおりです。GT_RANGE13_14, GT_RANGE15_17, GT_RANGE18_19, GT_RANGE20_21, GT_RANGE22_29, GT_RANGE30_39, GT_RANGE40_49, GT_RANGE50_59, GT_RANGE60_69, GT_RANGE70_UL, GT_UNKNOWN, GT_RANGE15_19, GT_RANGE20_24, GT_RANGE25_29, GT_RANGE30_34, GT_RANGE35_39, GT_RANGE40_44, GT_RANGE45_49, GT_RANGE50_54, GT_RANGE55_59, GT_RANGE60_64, GT_RANGE65_69, GT_RANGE70_UL2, GT_UNKNOWN2, UNKNOWN

TargetStatsValueTargetAgeTargetEstimateFlg String delivery settings

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

TargetStatsValueTargetAppTargetDeviceAppType String Type of delivery application.

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

TargetStatsValueTargetAudienceCategoryTargetAudienceCategoryType String Audience category information.
TargetStatsValueTargetAudienceCategoryTargetCategoryNameEn String Category name (English)
TargetStatsValueTargetAudienceCategoryTargetCategoryNameJa String Category name (Japanese)
TargetStatsValueTargetCarrierTargetCarrierType String Stats Service Carrier Type

使用できる値は次のとおりです。DOCOMO, KDDI, SOFTBANK, YMOBILE, OTHERS, UNKNOWN

TargetStatsValueTargetDeviceTargetDeviceType String Types of target devices.

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

TargetStatsValueTargetGenderTargetEstimateFlg String Extended delivery settings

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

TargetStatsValueTargetGenderTargetGender String Types of gender

使用できる値は次のとおりです。ST_MALE, ST_FEMALE, ST_UNKNOWN, UNKNOWN

TargetStatsValueTargetGeoTargetGeoNameEn String Geo name(English)
TargetStatsValueTargetGeoTargetGeoNameJa String Geo name(Japanese)
TargetStatsValueTargetInterestCategoryTargetCategoryFullNameEn String Interest category name (English)
TargetStatsValueTargetInterestCategoryTargetCategoryFullNameJa String Interest category name (Japanese
TargetStatsValueTargetOsTargetDeviceOsType String OS types of the delivery target device.

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

TargetStatsValueTargetOsVersionTargetOsVersion String OS Version
TargetStatsValueTargetPlacementTargetPlacementUrlListName String Placement Url List Name
TargetStatsValueTargetPlacementTargetPlacementUrlListType String Type of Placement URL list.

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

TargetStatsValueTargetSearchTargetSearchKeywordListName String Search Keyword List name
TargetStatsValueTargetSiteCategoryTargetCategoryFullNameEn String Site category name (English)
TargetStatsValueTargetSiteCategoryTargetCategoryFullNameJa String Site category name (Japanese)
TargetStatsValueTargetAudienceListTargetDeliverType String Type of target list

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

TargetStatsValueTargetAudienceListTargetAudienceListName String Target list name
TargetStatsValueTargetTargetId String Stats Service Target ID
TargetStatsValueTargetTargetSetting String Setting information of target.

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

TargetStatsValueTargetTargetType String Types of target

使用できる値は次のとおりです。AD_SCHEDULE_TARGET, GEO_TARGET, AGE_TARGET, GENDER_TARGET, INTEREST_CATEGORY, SITE_CATEGORY, SITE_RETARGETING, SEARCH_TARGET, PLACEMENT_TARGET, DEVICE_TARGET, CARRIER_TARGET, AUDIENCE_CATEGORY, PLACEMENT_CATEGORY_DETAIL_TARGET, UNKNOWN

Type String Information type

使用できる値は次のとおりです。CAMPAIGN, ADGROUP, AD, IMAGE, VIDEO, TARGET, UNKNOWN

VideoStatsValueMediaId Int64 Media ID
VideoStatsValueStatsAllConvRate String Conv. rate (all)
VideoStatsValueStatsAllConv Int64 Conversions (all)
VideoStatsValueStatsAllConvValue String Conv. value (all)
VideoStatsValueStatsAllConvValuePerCost String Conv. value (all)/cost All Conv.
VideoStatsValueStatsAllCpa String Cost/conv. (all)
VideoStatsValueStatsAvgCpv String Avg. CPV
VideoStatsValueStatsAvgDurationVideoViewed String Avg. duration of video viewed
VideoStatsValueStatsAvgPercentVideoViewed String Avg. video view rate
VideoStatsValueStatsAvgCpc String Avg. CPC
VideoStatsValueStatsAvgDeliverRank String Avg. position (the average of eCPM rank on ads delivery)
VideoStatsValueStatsImpressionShareBudgetLoss String Impression share lost rate(budget)
VideoStatsValueStatsClicks Int64 Number of clicks
VideoStatsValueStatsClickRate String Click through rate
VideoStatsValueStatsClickRatePrev String CTR (previous)
VideoStatsValueStatsConvRate String Conv. rate
VideoStatsValueStatsConversionRateViaAdClick String Conv. rate (via click)
VideoStatsValueStatsConversions Int64 Conversions
VideoStatsValueStatsConversionsViaAdClick Int64 Conversions (via click)
VideoStatsValueStatsConvValue String Conv. value
VideoStatsValueStatsConvValueViaAdClick String Conv. value (via click)
VideoStatsValueStatsConvValuePerCost String Conversions value/cost
VideoStatsValueStatsConvValueViaAdClickPerCost String Conversions value(via ad clicks)/cost
VideoStatsValueStatsCost String Cost
VideoStatsValueStatsCpa String Conversion cost per acquisition
VideoStatsValueStatsCpaViaAdClick String Cost/conv. (via click)
VideoStatsValueStatsCrossDeviceConversions Int64 Cross-device conv.
VideoStatsValueStatsImpressionShare String Impression share
VideoStatsValueStatsImps Int64 Number of impressions
VideoStatsValueStatsImpsPrev String Impressions (previous)
VideoStatsValueStatsInViewClickCnt Int64 Viewable clicks (previous)
VideoStatsValueStatsInViewClickRate String Viewable CTR (previous)
VideoStatsValueStatsInViewRate String Viewable impression rate (previous)
VideoStatsValueStatsMeasuredImps String Measured impressions
VideoStatsValueStatsMeasuredImpsRate String Measured impression rate
VideoStatsValueStatsPaidVideoViewRate String Paid video view rate (CPV)
VideoStatsValueStatsPaidVideoViews Int64 Paid video views (CPV)
VideoStatsValueStatsImpressionShareRankLoss String Impression share lost rate(rank)
VideoStatsValueStatsTotalVimps Int64 Measured impressions (previous)
VideoStatsValueStatsValuePerAllConv String Conv. value (all)/conv. (all)
VideoStatsValueStatsValuePerConv String Conv. value/conv.
VideoStatsValueStatsValuePerConvViaAdClick String Conv. value (via click)/conv. (via click)
VideoStatsValueStatsVideoViews Int64 Video views
VideoStatsValueStatsVideoViewsTo100 Int64 100% video views
VideoStatsValueStatsVideoViewsTo10Sec Int64 10 sec video views
VideoStatsValueStatsVideoViewsTo25 Int64 25% video views
VideoStatsValueStatsVideoViewsTo3Sec Int64 3 sec video views
VideoStatsValueStatsVideoViewsTo50 Int64 50% video views
VideoStatsValueStatsVideoViewsTo75 Int64 75% video views
VideoStatsValueStatsVideoViewsTo95 Int64 95% video views
VideoStatsValueStatsVideoViewThroughRate String Video view through rate
VideoStatsValueStatsViewableClickRate String Viewable CTR
VideoStatsValueVideoTitle String Video title
VideoStatsValueStatsViewableClicks String Viewable clicks
VideoStatsValueStatsViewableImpsRate String Viewable impression rate
VideoStatsValueStatsConvValueViaViewThrough Int64 View through conversions
VideoStatsValueStatsViewableImps Int64 Viewable impressions
VideoStatsValueVideoName String File name

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
CampaignId Int64 Campaign ID.
AdGroupId Int64 Ad group ID.
AdId Int64 Ad ID.
MediaId Int64 Media ID.
EndDate Date Acquisition end date of stats information.
StartDate Date Acquisition start date of stats information.
TargetType String Types of target

使用できる値は次のとおりです。AD_SCHEDULE_TARGET, GEO_TARGET, AGE_TARGET, GENDER_TARGET, INTEREST_CATEGORY, SITE_CATEGORY, SITE_RETARGETING, SEARCH_TARGET, PLACEMENT_TARGET, DEVICE_TARGET, CARRIER_TARGET, AUDIENCE_CATEGORY, PLACEMENT_CATEGORY_DETAIL_TARGET, UNKNOWN

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062