ReachReport

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
Country	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
SiteId	Long	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
DbmCost	Double	False
DbmCostUsd	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

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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.