Google Display & Video 360 fields

Prev Next

Supermetrics brings all your Google Display & Video 360 data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

265 metrics165 dimensions

ACCOUNT

account_id
account

ACTIVE VIEW

activeViewExpectedViewability
activeViewViewableImpressions
activeViewMeasurableImpressions
activeViewDistributionViewable
activeViewEligibleImpressions
activeViewPCTMeasurableImpressions
activeViewPCTViewableImpressions
activeViewUnviewableImpressions
activeViewUnmeasurableImpressions
activeViewPercCompletedImpressionsVisible
activeViewPercFirstQuartileImpressionsVisible
activeViewPercMidpointImpressionsVisible
activeViewPercThirdQuartileImpressionsVisible
activeViewDistributionUnviewable
activeViewDistributionUnmeasurable
activeViewAverageViewableTime
METRIC_ACTIVE_VIEW_DISTRIBUTION_VIEWABLE

ACTIVITY

activityID
FloodlightActivity

ADDITIONAL FEES

fee2
fee3
fee4
fee5
fee6
fee7
fee8
fee9
fee10
fee11
fee12
fee13
fee14
fee15
fee16
fee17
fee18
fee19
fee20
fee21
fee22

ADDITIONAL FEES (ADVERTISER)

fee2Advertiser
fee3Advertiser
fee4Advertiser
fee5Advertiser
fee6Advertiser
fee7Advertiser
fee8Advertiser
fee9Advertiser
fee10Advertiser
fee11Advertiser
fee12Advertiser
fee13Advertiser
fee14Advertiser
fee15Advertiser
fee16Advertiser
fee17Advertiser
fee18Advertiser
fee19Advertiser
fee20Advertiser
fee21Advertiser
fee22Advertiser

ADDITIONAL FEES (USD)

fee2USD
fee3USD
fee4USD
fee5USD
fee6USD
fee7USD
fee8USD
fee9USD
fee10USD
fee11USD
fee12USD
fee13USD
fee14USD
fee15USD
fee16USD
fee17USD
fee18USD
fee19USD
fee20USD
fee21USD
fee22USD

ADVERTISER

advertiser
advertiserID
advertiserStatus
advertiserTimezone
advertiserCurrency
advertiserIntegrationCode

AUDIO

firstQuartileAudio
midpointAudio
thirdQuartileAudio
pausesAudio
startsAudio
stopsAudio
completeListensAudio

BUDGET

costAmountPlacementId
BudgetSegmentBudget
BudgetSegmentDescription
BudgetSegmentStartDate
BudgetSegmentEndDate
BudgetSegmentPacingPercentage
BudgetSegmentType
revenue
mediaCost
totalMediaCost
billableCost
profit
profitMargin
postClickDFArevenue
postViewDFArevenue
mediaECPA
mediaECPAPC
mediaECPAPV
mediaECPC
mediaECPM

BUDGET (ADVERTISER)

revenueAdvertiser
mediaCostAdvertiser
totalMediaCostAdvertiser
billableCostAdvertiser
profitAdvertiser

BUDGET (USD)

revenueUSD
mediaCostUSD
totalMediaCostUSD
billableCostUSD
profitUSD
mediaECPAUSD
mediaECPAPCUSD
mediaECPAPVUSD
mediaECPCUSD
mediaECPMUSD

CAMPAIGN

campaign
campaignID
CampaignDailyFrequency

CONVERSION PERFORMANCE

revenueECPA
revenueECPAPC
revenueECPAPV
profitECPA
profitECPAPC
profitECPAPV

CONVERSION PERFORMANCE (ADVERTISER)

revenueECPAAdvertiser
revenueECPAPCAdvertiser
revenueECPAPVAdvertiser
mediaCostECPAAdvertiser
mediaCostECPAPCAdvertiser
mediaCostECPCPVAdvertiser
profitECPAAdvertiser
profitECPAPCAdvertiser
profitECPAPVAdvertiser

CONVERSION PERFORMANCE (USD)

revenueECPAUSD
revenueECPAPCUSD
revenueECPAPVUSD
mediaCostECPAUSD
mediaCostECPAPCUSD
mediaCostECPCPVUSD
profitECPAUSD
profitECPAPCUSD
profitECPAPVUSD

CREATIVE

Creative
CreativeID
CreativeIntegrationCode
CreativeType
CreativeStatus
CreativeSize
CreativeHeight
CreativeWidth
CreativeSource

DATASOURCE

dataSourceName
system_metadata.data_source_logins
system_metadata.data_source_login_owners

DEPRECATED

UserListTargeted
Activity
RegularChannelID
VideoCompanionType
BrandsafeChannelID
FloodlightPixelID
ActivityStatus
Age
Gender

DEVICE

DeviceMakeMobile
DeviceModelMobile
DeviceTypeMobile
OS
Browser
Carrier
CarrierName

FEES

dataCost
CPMfee1
CPMfee2
CPMfee3
CPMfee4
CPMfee5
mediaFee1
mediaFee2
mediaFee3
mediaFee4
mediaFee5
platformFee
platformFeeRate

FEES (ADVERTISER)

dataCostAdvertiser
CPMfee1Advertiser
CPMfee2Advertiser
CPMfee3Advertiser
CPMfee4Advertiser
CPMfee5Advertiser
mediaFee1Advertiser
mediaFee2Advertiser
mediaFee3Advertiser
mediaFee4Advertiser
mediaFee5Advertiser
platformFeeAdvertiser
customFee1Advertiser
customFee2Advertiser
customFee3Advertiser
customFee4Advertiser
customFee5Advertiser

FEES (USD)

dataCostUSD
CPMfee1USD
CPMfee2USD
CPMfee3USD
CPMfee4USD
CPMfee5USD
mediaFee1USD
mediaFee2USD
mediaFee3USD
mediaFee4USD
mediaFee5USD
platformFeeUSD

INSERTION

InsertionOrder
InsertionOrderID
insertionOrderIntegrationCode
InsertionOrderStatus

INTERACTIONS

impressions
clicks
totalConversions
lastClicks
lastImpressions
bidRequests
clickToPostClickConversionRate
conversionsPerMile
pixelLoads
impressionsToConversionsRate

INVENTORY

InventorySource
InventorySourceID
InventoryFormat
InventoryRateType
InventoryCommitmentType
InventoryDeliveryMethod
InventorySourceGroup
InventorySourceGroupId
InventorySourceType

LINE ITEM

LineItem
LineItemID
LineItemStatus
LineItemType
LineItemLifetimeFreq
LineItemDailyFreq
LineItemPacingPercentage
LineItemIntegrationCode
adPosition

LOCATION

City
CityID
Region
RegionID
DMA
DMAcode
Country
GeoMobile

OTHER METRICS

UniqueVisitorsCookies
ReachAverageImpressionFrequency
ReachImpressionsReach
UniqueReachAverageImpressionFrequency
UniqueReachTotalReach
UniqueReachImpressionReach

PARTNER

Partner
PartnerID
PartnerStatus
PartnerCurrency

PERFORMANCE

billableImpressions
CTR
revenueECPC
revenueECPM
profitECPC
profitECPM
TotalMediaCostECPM
TotalMediaCostECPC

PERFORMANCE (ADVERTISER)

revenueECPCAdvertiser
revenueECPMAdvertiser
mediaCostECPCAdvertiser
mediaCostECPMAdvertiser
profitECPCAdvertiser
profitECPMAdvertiser
clientCostAdvertiser
mediaECPAAdvertiser
mediaECPAPCAdvertiser
mediaECPAPVAdvertiser

PERFORMANCE (USD)

revenueECPCUSD
revenueECPMUSD
mediaCostECPCUSD
mediaCostECPMUSD
profitECPCUSD
profitECPMUSD

QUERY

system_metadata.query_date_range_start
system_metadata.query_date_range_end
system_metadata.query_timezone
system_metadata.query_filters
system_metadata.query_date_start
system_metadata.query_date_end
system_metadata.query_duration
system_metadata.query_accounts

REGULATORY FEES

fee32Advertiser
fee32Partner
fee32Usd

RICH MEDIA

expansions
averageInteractionTime
totalInteractionTime
interactiveImpressions

SITE

Site
AudienceList
AudienceListType
SiteID
SiteLanguage

TIME

today
Year
month
Yearmonth
yearweek
yearweekiso
yearweekiso_daterange
YearOfISOweek
week
weekiso
dayOfMonth
dayOfWeekWithName
date
hour

TRUEVIEW

AdIdTrueView
AdNameTrueView
AdGroupIdTrueView
AdGroupNameTrueView
AgeTrueView
GenderTrueView
ConversionTypeTrueView
InterestTrueView
ParentalStatusTrueView
RemarketingListTrueView
RemarketingListNameTrueView
URLTrueView
PlacementNameTrueView
PlacementIDTrueView
CategoryTrueView
CustomAffinityTrueView
DetailedDemoNameTrueView
DetailedDemoTrueView
HouseholdIncomeTrueView
KeywordTrueView
AdTypeTrueView
PlacementNameAllYouTubeChannels
PlacementIDAllYouTubeChannels
trueViewEarnedLikes
trueViewEarnedViews
trueViewViewRate
trueViewViewThroughConversion
trueViewViews
TrueViewECPEAdvertiser
TrueViewECPEPartner
TrueViewECPEUSD
TrueViewCostPerConversionAdvertiser
TrueViewCostPerConversionPartner
TrueViewCostPerConversionUSD
trueViewConversionManyPerView
trueViewConversionRateOnePerView
TrueViewECPVAdvertiser
TrueViewECPVPartner
TrueViewECPVUSD
trueViewEarnedPlaylistAdditions
trueViewEarnedShares
TrueViewEarnedSubscribers
TrueViewEngagements
TrueViewEngagementRate
trueViewImpressionShare
trueViewLostIsBudget
trueViewLostIsRank
TrueViewTotalConversionValueAdvertiser
TrueViewTotalConversionValuePartner
TrueViewTotalConversionValueUSD
trueViewUniqueViewers

TRUEVIEW LOCATION

RegionTrueView
DMATrueView
DMANameTrueView
ZipCodeTrueView
CityTrueView
CountryTrueView

UNSORTED DIMENSIONS

PublicInventory
PageLayout
PageCategory
OrderID
Keyword
Exchange
ExchangeID
DFPorderID
DataProvider
DataProviderName
ConversionDelay
ChannelID
AdVideoYoutube
AdVideoIDYoutube
AppURL
MediaType

USER LISTS

UserList
AttributedUserList
UserListFirstParty
UserListFirstPartyName
UserListThirdParty
UserListThirdPartyName

VIDEO

VideoPlayerSize
VideoDuration
VideoCompanionSize
YouTubeVertical
videoCompletions
videoFirstQuartileCompletes
videoFullScreens
videoMidPoints
videoMutes
videoPauses
videoPlays
videoThirdQuartileCompletes
VideoCompletionRate
videoCompanionClicks