ReachReport
Table for running Reach reports saved in DCM or ad-hoc reports.
Columns
Name | Type | Dimension | Description |
PaidSearchAverageCostPerAction | Double | False | |
PaidSearchAverageCostPerTransaction | Double | False | |
PaidSearchAverageDfaTransactionAmount | Double | False | |
PaidSearchRevenue | Double | False | |
PaidSearchSpendPerTransactionRevenue | Double | False | |
PaidSearchTransactionConversionPercentage | Double | False | |
PaidSearchTransactionRevenuePerSpend | Double | False | |
PaidSearchTransactions | Double | False | |
TotalConversions | Double | False | |
TotalConversionsRevenue | Double | False | |
Advertiser | String | True | |
Ad | String | True | |
AdId | Long | True | |
AdStatus | String | True | |
AdType | String | True | |
AdvertiserGroup | String | True | |
AdvertiserId | Long | True | |
BrowserPlatform | String | True | |
Campaign | String | True | |
CampaignEndDate | String | True | |
CampaignExternalId | String | True | |
CampaignId | Long | True | |
CampaignStartDate | String | True | |
City | String | True | |
ConnectionType | String | True | |
ContentCategory | String | True | |
Date | String | True | |
DmaRegion | String | True | |
FloodlightConfigId | Long | True | |
Hour | String | True | |
MobileCarrier | String | True | |
Month | String | True | |
OperatingSystem | String | True | |
OperatingSystemVersion | String | True | |
PackageRoadblock | String | True | |
PackageRoadblockId | Long | True | |
PackageRoadblockStrategy | String | True | |
PackageRoadblockTotalBookedUnits | String | True | |
PaymentSource | String | True | |
Placement | String | True | |
PlacementCompatibility | String | True | |
PlacementCostStructure | String | True | |
PlacementEndDate | String | True | |
PlacementExternalId | String | True | |
PlacementId | Long | True | |
PlacementRate | String | True | |
PlacementStartDate | String | True | |
PlacementStrategy | String | True | |
PlacementTotalBookedUnits | String | True | |
PlacementTotalPlannedMediaCost | String | True | |
PlatformType | String | True | |
Site | String | True | |
SiteKeyname | String | True | |
Week | String | True | |
ActiveViewAverageViewableTimeSecond | Double | False | |
ActiveViewCustomMetricMeasurableImpressions | Long | False | |
ActiveViewCustomMetricViewableImpressions | Long | False | |
ActiveViewCustomMetricViewableRate | Double | False | |
ActiveViewEligibleImpressions | Long | False | |
ActiveViewGroupmMeasurableImpressions | Long | False | |
ActiveViewGroupmTrvMeasurableImpressions | Long | False | |
ActiveViewGroupmTrvViewableImpressions | Long | False | |
ActiveViewGroupmViewableImpressions | Long | False | |
ActiveViewImpressionDistributionNotMeasurable | Double | False | |
ActiveViewImpressionDistributionNotViewable | Double | False | |
ActiveViewImpressionDistributionViewable | Double | False | |
ActiveViewImpressionsAudibleAndVisibleAtCompletion | Long | False | |
ActiveViewImpressionsVisible10Seconds | Long | False | |
ActiveViewMeasurableImpressions | Long | False | |
ActiveViewNotMeasurableImpressions | Long | False | |
ActiveViewNotViewableImpressions | Long | False | |
ActiveViewPercentAudibleAndVisibleAtCompletion | Double | False | |
ActiveViewPercentAudibleAndVisibleAtFirstQuartile | Double | False | |
ActiveViewPercentAudibleAndVisibleAtMidpoint | Double | False | |
ActiveViewPercentAudibleAndVisibleAtStart | Double | False | |
ActiveViewPercentAudibleAndVisibleAtThirdQuartile | Double | False | |
ActiveViewPercentAudibleImpressions | Double | False | |
ActiveViewPercentBackground | Double | False | |
ActiveViewPercentFullscreen | Double | False | |
ActiveViewPercentImpressionsAudibleAndFullyOnscreen | Double | False | |
ActiveViewPercentImpressionsAudibleAndFullyOnscreenForHalfDuration | Double | False | |
ActiveViewPercentImpressionsAudibleAndVisibleAtCompletion | Double | False | |
ActiveViewPercentImpressionsAudibleAndVisibleAtFirstQuartile | Double | False | |
ActiveViewPercentImpressionsAudibleAndVisibleAtMidpoint | Double | False | |
ActiveViewPercentImpressionsAudibleAndVisibleAtThirdQuartile | Double | False | |
ActiveViewPercentImpressionsVisibleAtCompletion | Double | False | |
ActiveViewPercentImpressionsVisibleAtFirstQuartile | Double | False | |
ActiveViewPercentImpressionsVisibleAtMidpoint | Double | False | |
ActiveViewPercentImpressionsVisibleAtThirdQuartile | Double | False | |
ActiveViewPercentPlayTimeAudible | Double | False | |
ActiveViewPercentPlayTimeAudibleAndVisible | Double | False | |
ActiveViewPercentPlayTimeVisible | Double | False | |
ActiveViewPercentVisible10Seconds | Double | False | |
ActiveViewPercentVisibleAtCompletion | Double | False | |
ActiveViewPercentVisibleAtFirstQuartile | Double | False | |
ActiveViewPercentVisibleAtMidpoint | Double | False | |
ActiveViewPercentVisibleAtStart | Double | False | |
ActiveViewPercentVisibleAtThirdQuartile | Double | False | |
ActiveViewPercentageMeasurableImpressions | Double | False | |
ActiveViewPercentageViewableImpressions | Double | False | |
ActiveViewViewableImpressionCookieReach | Long | False | |
ActiveViewViewableImpressions | Long | False | |
ActivityClickThroughConversions | Double | False | |
ActivityClickThroughRevenue | Double | False | |
ActivityDeliveryStatus | Double | False | |
ActivityPerClick | Double | False | |
ActivityPerThousandImpressions | Double | False | |
ActivityViewThroughConversions | Double | False | |
ActivityViewThroughRevenue | Double | False | |
BookedActivities | Double | False | |
BookedClicks | Double | False | |
BookedImpressions | Double | False | |
BookedViewableImpressions | Double | False | |
ClickDeliveryStatus | Double | False | |
ClickRate | Double | False | |
Clicks | Long | False | |
CookieReachAverageImpressionFrequency | Double | False | |
CookieReachClickReach | Long | False | |
CookieReachImpressionReach | Long | False | |
CookieReachIncrementalClickReach | Long | False | |
CookieReachIncrementalImpressionReach | Long | False | |
CookieReachIncrementalTotalReach | Long | False | |
CookieReachTotalReach | Long | False | |
CostPerActivity | Double | False | |
CostPerClick | Double | False | |
CostPerRevenue | Double | False | |
CrossDeviceClickThroughConversionQuantity | Long | False | |
CrossDeviceClickThroughConversionRevenue | Double | False | |
CrossDeviceClickThroughConversions | Long | False | |
CrossDeviceTotalConversionQuantity | Long | False | |
CrossDeviceTotalConversionRevenue | Double | False | |
CrossDeviceTotalConversions | Long | False | |
CrossDeviceViewThroughConversionQuantity | Long | False | |
CrossDeviceViewThroughConversionRevenue | Double | False | |
CrossDeviceViewThroughConversions | Long | False | |
DV360Cost | Double | False | |
DV360CostUsd | Double | False | |
DownloadedImpressions | Long | False | |
EffectiveCpm | Double | False | |
ImpressionDeliveryStatus | Double | False | |
Impressions | Long | False | |
MediaCost | Double | False | |
NaturalSearchActions | Double | False | |
NaturalSearchClicks | Long | False | |
NaturalSearchRevenue | Double | False | |
NaturalSearchTransactions | Double | False | |
PaidSearchActionConversionPercentage | Double | False | |
PaidSearchActions | Double | False | |
PaidSearchAveragePosition | Double | False | |
PaidSearchClickRate | Double | False | |
PaidSearchClicks | Long | False | |
PaidSearchCost | Double | False | |
PaidSearchImpressions | Long | False | |
PaidSearchVisits | Long | False | |
PlannedMediaCost | Double | False | |
RevenuePerClick | Double | False | |
RevenuePerThousandImpressions | Double | False | |
RichMediaAverageDisplayTime | Double | False | |
RichMediaAverageExpansionTime | Double | False | |
RichMediaAverageFullScreenViewTime | Double | False | |
RichMediaAverageInteractionTime | Double | False | |
RichMediaAverageVideoViewTime | Double | False | |
RichMediaBackupImages | Long | False | |
RichMediaClickRate | Double | False | |
RichMediaClicks | Long | False | |
RichMediaCodeServes | Long | False | |
RichMediaCustomAverageTime | Double | False | |
RichMediaCustomCounters | Long | False | |
RichMediaCustomExits | Long | False | |
RichMediaCustomTimers | Long | False | |
RichMediaDisplayTime | Long | False | |
RichMediaEngagements | Long | False | |
RichMediaEventCounters | Long | False | |
RichMediaEventTimers | Double | False | |
RichMediaExpansionTime | Long | False | |
RichMediaExpansions | Long | False | |
RichMediaFullScreenImpressions | Long | False | |
RichMediaFullScreenVideoCompletes | Long | False | |
RichMediaFullScreenVideoPlays | Long | False | |
RichMediaHtml5Impressions | Long | False | |
RichMediaImpressions | Long | False | |
RichMediaInteractionRate | Double | False | |
RichMediaInteractionTime | Long | False | |
RichMediaInteractions | Long | False | |
RichMediaInteractiveImpressions | Long | False | |
RichMediaManualCloses | Long | False | |
RichMediaScrolls | Long | False | |
RichMediaTrueViewViews | Long | False | |
RichMediaVideoCompanionClicks | Long | False | |
RichMediaVideoCompletions | Long | False | |
RichMediaVideoFirstQuartileCompletes | Long | False | |
RichMediaVideoFullScreens | Long | False | |
RichMediaVideoInteractionRate | Double | False | |
RichMediaVideoInteractions | Long | False | |
RichMediaVideoMidpoints | Long | False | |
RichMediaVideoMutes | Long | False | |
RichMediaVideoPauses | Long | False | |
RichMediaVideoPlays | Long | False | |
RichMediaVideoProgressEvents | Long | False | |
RichMediaVideoReplays | Long | False | |
RichMediaVideoSkips | Long | False | |
RichMediaVideoStops | Long | False | |
RichMediaVideoThirdQuartileCompletes | Long | False | |
RichMediaVideoUnmutes | Long | False | |
RichMediaVideoViewRate | Double | False | |
RichMediaVideoViews | Long | False | |
RoadblockImpressions | Long | False | |
SocialEmailShares | Long | False | |
SocialEngagementRate | Double | False | |
SocialFollows | Long | False | |
SocialLeadSubmissions | Long | False | |
SocialLikes | Long | False | |
SocialOfferAccepts | Long | False | |
SocialReplies | Long | False | |
SocialTotalEngagements | Long | False | |
TwitterAppClicks | Long | False | |
TwitterBuyNowCardClicks | Long | False | |
TwitterBuyNowPurchaseSuccessfuls | Long | False | |
TwitterOtherEngagements | Long | False | |
TwitterRetweets | Long | False | |
TwitterUrlClicks | Long | False | |
TwitterVideo50PercentInViewFor2Seconds | Long | False | |
TwitterVideo100PercentInViewFor3Seconds | Long | False | |
UniqueReachAverageImpressionFrequency | Double | False | |
UniqueReachClickReach | Long | False | |
UniqueReachImpressionReach | Long | False | |
UniqueReachTotalReach | Long | False | |
VerificationBlockedImpressions | Long | False | |
VerificationClassifiedImpressions | Long | False | |
VerificationMeasurableImpressionsForAudio | Long | False | |
VerificationMeasurableImpressionsForVideoPlayerLocation | Long | False | |
VerificationMeasurableImpressionsForVideoPlayerSize | Long | False | |
VerificationPercentageMeasurableImpressionsForAudio | Double | False | |
VerificationPercentageMeasurableImpressionsForVideoPlayerLocation | Double | False | |
VerificationPercentageMeasurableImpressionsForVideoPlayerSize | Double | False | |
VerificationPublisherProblems | Long | False | |
VerificationReportingProblems | Long | False | |
VerificationServingProblems | Long | False | |
VerificationVerifiableImpressions | Long | False | |
VerificationVideoMutedAtStart | Long | False | |
VerificationVideoPlayerHdSizeImpressions | Long | False | |
VerificationVideoPlayerLargeSizeImpressions | Long | False | |
VerificationVideoPlayerLocationAvgPixelsFromLeft | Long | False | |
VerificationVideoPlayerLocationAvgPixelsFromTop | Long | False | |
VerificationVideoPlayerSizeAvgHeight | Long | False | |
VerificationVideoPlayerSizeAvgWidth | Long | False | |
VerificationVideoPlayerSmallSizeImpressions | Long | False | |
VerificationVideoProminenceScore | Double | False | |
VerificationWarnings | Long | False | |
VideoCompanionClicks | Long | False | |
VideoCompanionImpressions | Long | False |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
ReportID | String | Optional input to pull a specific report by ID. |
FileID | String | Optional input to pull a specific file by ID. |
dateRange | String | Optional input to pull a specific date range. Defaults to LAST_30_DAYS. If startDate and endDate are specified, this is ignored. |
startDate | String | Optional input to pull report from specific start date. |
endDate | String | Optional input to pull report from specific end date. |