Cmdlets for Google Campaign Manager

Build 21.0.7930

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
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

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.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930