JDBC Driver for Google Campaign Manager

Build 22.0.8462

StandardReport

Table for running Standard reports saved in DCM or ad-hoc reports.

Columns

Name Type Dimension Description
ActiveViewCustomMetricId Long True
ActiveViewCustomMetricName String True
Activity String True
ActivityGroup String True
ActivityGroupId Long True
ActivityId Long True
Ad String True
AdId Long True
AdStatus String True
AdType String True
Advertiser String True
AdvertiserGroup String True
AdvertiserId Long True
App String True
AppId String True
Asset String True
AssetCategory String True
AssetId Long True
AssetOrientation String True
AttributedEventConnectionType String True
AttributedEventEnvironment String True
AudienceTargeted String True
BrowserPlatform String True
Campaign String True
CampaignEndDate String True
CampaignExternalId String True
CampaignId Long True
CampaignStartDate String True
City String True
ClickThroughUrl String True
CompanionCreative String True
CompanionCreativeId Long True
CompanionCreativeSize String True
ConnectionType String True
ContentCategory String True
ContentClassification String True
Country String True
Creative String True
CreativeEndDate String True
CreativeField1 String True
CreativeField2 String True
CreativeField3 String True
CreativeField4 String True
CreativeField5 String True
CreativeField6 String True
CreativeField7 String True
CreativeField8 String True
CreativeField9 String True
CreativeField10 String True
CreativeField11 String True
CreativeField12 String True
CreativeGroup1 String True
CreativeGroup2 String True
CreativeId Long True
CreativeSize String True
CreativeStartDate String True
CreativeType String True
CreativeVersion String True
Date String True
DV360Advertiser String True
DV360AdvertiserId Long True
DV360Creative String True
DV360CreativeId Long True
DV360InsertionOrder String True
DV360InsertionOrderId Long True
DV360LineItem String True
DV360LineItemId Long True
DV360Partner String True
DV360PartnerId Long True
DV360Site String True
DV360SiteId Long True
DigitalContentLabel String True
DmaRegion String True
Domain String True
DynamicElement String True
DynamicElement1Field1Value String True
DynamicElement1Field2Value String True
DynamicElement1Field3Value String True
DynamicElement1Field4Value String True
DynamicElement1Field5Value String True
DynamicElement1Field6Value String True
DynamicElement2Field1Value String True
DynamicElement2Field2Value String True
DynamicElement2Field3Value String True
DynamicElement2Field4Value String True
DynamicElement2Field5Value String True
DynamicElement2Field6Value String True
DynamicElement3Field1Value String True
DynamicElement3Field2Value String True
DynamicElement3Field3Value String True
DynamicElement3Field4Value String True
DynamicElement3Field5Value String True
DynamicElement3Field6Value String True
DynamicElement4Field1Value String True
DynamicElement4Field2Value String True
DynamicElement4Field3Value String True
DynamicElement4Field4Value String True
DynamicElement4Field5Value String True
DynamicElement4Field6Value String True
DynamicElement5Field1Value String True
DynamicElement5Field2Value String True
DynamicElement5Field3Value String True
DynamicElement5Field4Value String True
DynamicElement5Field5Value String True
DynamicElement5Field6Value String True
DynamicElement6Field1Value String True
DynamicElement6Field2Value String True
DynamicElement6Field3Value String True
DynamicElement6Field4Value String True
DynamicElement6Field5Value String True
DynamicElement6Field6Value String True
DynamicElement7Field1Value String True
DynamicElement7Field2Value String True
DynamicElement7Field3Value String True
DynamicElement7Field4Value String True
DynamicElement7Field5Value String True
DynamicElement7Field6Value String True
DynamicElement8Field1Value String True
DynamicElement8Field2Value String True
DynamicElement8Field3Value String True
DynamicElement8Field4Value String True
DynamicElement8Field5Value String True
DynamicElement8Field6Value String True
DynamicElement9Field1Value String True
DynamicElement9Field2Value String True
DynamicElement9Field3Value String True
DynamicElement9Field4Value String True
DynamicElement9Field5Value String True
DynamicElement9Field6Value String True
DynamicElement10Field1Value String True
DynamicElement10Field2Value String True
DynamicElement10Field3Value String True
DynamicElement10Field4Value String True
DynamicElement10Field5Value String True
DynamicElement10Field6Value String True
DynamicElement11Field1Value String True
DynamicElement11Field2Value String True
DynamicElement11Field3Value String True
DynamicElement11Field4Value String True
DynamicElement11Field5Value String True
DynamicElement11Field6Value String True
DynamicElement12Field1Value String True
DynamicElement12Field2Value String True
DynamicElement12Field3Value String True
DynamicElement12Field4Value String True
DynamicElement12Field6Value String True
DynamicElement13Field1Value String True
DynamicElement13Field2Value String True
DynamicElement13Field4Value String True
DynamicElement13Field5Value String True
DynamicElement13Field6Value String True
DynamicElement14Field1Value String True
DynamicElement14Field2Value String True
DynamicElement14Field3Value String True
DynamicElement14Field4Value String True
DynamicElement14Field5Value String True
DynamicElement14Field6Value String True
DynamicElement15Field1Value String True
DynamicElement15Field2Value String True
DynamicElement15Field3Value String True
DynamicElement15Field4Value String True
DynamicElement15Field5Value String True
DynamicElement15Field6Value String True
DynamicElement16Field1Value String True
DynamicElement16Field2Value String True
DynamicElement16Field3Value String True
DynamicElement16Field4Value String True
DynamicElement16Field5Value String True
DynamicElement16Field6Value String True
DynamicElement17Field1Value String True
DynamicElement17Field2Value String True
DynamicElement17Field3Value String True
DynamicElement17Field4Value String True
DynamicElement17Field5Value String True
DynamicElement17Field6Value String True
DynamicElement18Field1Value String True
DynamicElement18Field2Value String True
DynamicElement18Field3Value String True
DynamicElement18Field4Value String True
DynamicElement18Field5Value String True
DynamicElement18Field6Value String True
DynamicElement19Field1Value String True
DynamicElement19Field2Value String True
DynamicElement19Field3Value String True
DynamicElement19Field4Value String True
DynamicElement19Field5Value String True
DynamicElement19Field6Value String True
DynamicElement20Field1Value String True
DynamicElement20Field2Value String True
DynamicElement20Field3Value String True
DynamicElement20Field4Value String True
DynamicElement20Field5Value String True
DynamicElement20Field6Value String True
DynamicElementValue String True
DynamicElementValueId String True
DynamicFieldValue1 String True
DynamicFieldValue2 String True
DynamicFieldValue3 String True
DynamicFieldValue4 String True
DynamicFieldValue5 String True
DynamicFieldValue6 String True
DynamicProfile String True
DynamicProfileId Long True
Environment String True
EventPlatformType String True
ExitUrl String True
Feed1 String True
Feed1ReportingLabel String True
Feed1UniqueId String True
Feed2 String True
Feed2ReportingLabel String True
Feed2UniqueId String True
Feed3 String True
Feed3ReportingLabel String True
Feed3UniqueId String True
Feed4 String True
Feed4ReportingLabel String True
Feed4UniqueId String True
Feed5 String True
Feed5ReportingLabel String True
Feed5UniqueId String True
Feed6 String True
Feed6UniqueId String True
Feed7 String True
Feed7UniqueId String True
Feed8 String True
Feed8UniqueId String True
Feed9 String True
Feed9UniqueId String True
Feed10 String True
Feed10UniqueId String True
Feed11 String True
Feed11UniqueId String True
Feed12 String True
Feed12UniqueId String True
Feed13 String True
Feed13UniqueId String True
Feed14 String True
Feed14UniqueId String True
Feed15 String True
Feed15UniqueId String True
Feed16 String True
Feed16UniqueId String True
Feed17 String True
Feed17UniqueId String True
Feed18 String True
Feed18UniqueId String True
Feed19 String True
Feed19UniqueId String True
Feed20 String True
Feed20UniqueId String True
FlightBookedCost String True
FlightBookedRate String True
FlightBookedUnits String True
FlightEndDate String True
FlightStartDate String True
FloodlightConfigId Long True
Hour String True
Keyword String True
LandingPageUrl String True
MeasurementSource String True
MobileCarrier String True
Month String True
NaturalSearchEngineCountry String True
NaturalSearchEngineProperty String True
NaturalSearchLandingPage String True
NaturalSearchLandingPageQueryString String True
NaturalSearchProcessedLandingPage String True
NaturalSearchProcessedLandingPageQueryString String True
NaturalSearchQuery String True
OperatingSystem String True
OperatingSystemVersion String True
PackageRoadblock String True
PackageRoadblockId Long True
PackageRoadblockStrategy String True
PackageRoadblockTotalBookedUnits String True
PaidSearchAd String True
PaidSearchAdGroup String True
PaidSearchAdGroupId Long True
PaidSearchAdId Long True
PaidSearchAdvertiser String True
PaidSearchAdvertiserId Long True
PaidSearchAgency String True
PaidSearchAgencyId Long True
PaidSearchBidStrategy String True
PaidSearchBidStrategyId Long True
PaidSearchCampaign String True
PaidSearchCampaignId Long True
PaidSearchEngineAccount String True
PaidSearchEngineAccountCategory String True
PaidSearchEngineAccountId Long True
PaidSearchExternalAdGroupId Long True
PaidSearchExternalAdId Long True
PaidSearchExternalCampaignId Long True
PaidSearchExternalKeywordId Long True
PaidSearchKeyword String True
PaidSearchKeywordId Long True
PaidSearchLandingPageUrl String True
PaidSearchLegacyKeywordId Long True
PaidSearchMatchType 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
PlacementSize String True
PlacementStartDate String True
PlacementStrategy String True
PlacementTagType String True
PlacementTotalBookedUnits String True
PlacementTotalPlannedMediaCost String True
PlatformType String True
PlaybackMethod String True
RenderingId Long True
RichMediaCustomVariable String True
RichMediaEvent String True
RichMediaVideo4asaId String True
RichMediaVideoLength String True
ServedPixelDensity String True
Site String True
SiteDirectory String True
SiteDirectoryId Long True
SiteId Long True
SiteKeyname String True
State String True
TwitterCampaignId Long True
TwitterCreativeId Long True
TwitterCreativeMediaId Long True
TwitterCreativeType String True
TwitterImpressionType String True
TwitterLineItemId Long True
TwitterPlacementType String True
UserList String True
UserListCurrentSize String True
UserListDescription String True
UserListId Long True
UserListMembershipLifeSpan String True
VerificationVideoPlayerSize String True
VerificationVideoProminenceScoreDimension String True
Week String True
ZipCode Long 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
ActiveViewViewableImpressions Long False
ActivityClickThroughConversions Double False
ActivityClickThroughRevenue Double False
ActivityDeliveryStatus Double False
ActivityPerClick Double False
ActivityPerThousandImpressions Double False
ActivityViewThroughConversions Double False
ActivityViewThroughRevenue Double False
AudioCompanionClicks Long False
AudioCompanionImpressions Long False
BookedActivities Double False
BookedClicks Double False
BookedImpressions Double False
BookedViewableImpressions Double False
ClickDeliveryStatus Double False
ClickRate Double False
Clicks 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
DynamicElementClickRate Double False
DynamicElementClickThroughConversions Long False
DynamicElementClicks Long False
DynamicElementImpressions Long False
DynamicElementTotalConversions Long False
DynamicElementViewThroughConversions Long False
EffectiveCpm Double False
GeneralInvalidTrafficActiveViewEligibleImpressions Long False
GeneralInvalidTrafficActiveViewMeasurableImpressions Long False
GeneralInvalidTrafficActiveViewViewableImpressions Long False
GeneralInvalidTrafficClicks Long False
GeneralInvalidTrafficImpressions Long False
ImpressionDeliveryStatus Double False
Impressions Long False
InvalidActiveViewEligibleImpressions Long False
InvalidActiveViewMeasurableImpressions Long False
InvalidActiveViewViewableImpressions Long False
InvalidClicks Long False
InvalidImpressions Long False
MediaCost Double False
NaturalSearchActions Double False
NaturalSearchClicks Long False
NaturalSearchRevenue Double False
NaturalSearchTransactions Double False
PaidSearchActionConversionPercentage Double False
PaidSearchActions Double False
PaidSearchAverageCostPerAction Double False
PaidSearchAverageCostPerTransaction Double False
PaidSearchAverageDfaTransactionAmount Double False
PaidSearchAveragePosition Double False
PaidSearchClickRate Double False
PaidSearchClicks Long False
PaidSearchCost Double False
PaidSearchImpressions Long False
PaidSearchRevenue Double False
PaidSearchSpendPerTransactionRevenue Double False
PaidSearchTransactionConversionPercentage Double False
PaidSearchTransactionRevenuePerSpend Double False
PaidSearchTransactions Double False
PaidSearchVisits Long False
PercentInvalidClicks Double False
PercentInvalidImpressions Double False
PlannedMediaCost Double False
RevenuePerClick Double False
RevenuePerThousandImpressions Double False
RichMediaAudioCompletions Long False
RichMediaAudioFirstQuartileCompletes Long False
RichMediaAudioMidpoints Long False
RichMediaAudioMutes Long False
RichMediaAudioPauses Long False
RichMediaAudioPlays Long False
RichMediaAudioReplays Long False
RichMediaAudioThirdQuartileCompletes Long False
RichMediaAudioUnmutes Long 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
RichMediaCustomVariableCount1 Long False
RichMediaCustomVariableCount2 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
TotalConversions Double False
TotalConversionsRevenue Double 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
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.
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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462