Stats
Get the stats information of each campaign, ad group, ad, image and video.
Table Specific Information
SELECT
The connector 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 connector.
- 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 |