Google Display & Video 360 data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: LINEITEM

account
Display name Account
Field type dimension
Data type string.text.value
account_id
Display name Account ID
Field type dimension
Data type string.text.value
activeViewDistributionViewable
Display name Distribution viewable % (ActiveView)
Field type metric
Data type float.number.percentage
activeViewViewableImpressions
Display name Viewable impressions (ActiveView)
Field type metric
Data type int.number.value
advertiser
Display name Advertiser
Field type dimension
Data type string.text.value
advertiserCurrency
Display name Advertiser currency
Description Advertiser currency. ISO 4217 three-letter currency code is used for filter value, for example, "USD" for US Dollars
Field type dimension
Data type string.currency.code
advertiserID
Display name Advertiser ID
Description Advertiser ID
Field type dimension
Data type string.text.value
advertiserStatus
Display name Advertiser status
Field type dimension
Data type string.text.value
advertiserTimezone
Display name Advertiser timezone
Description Advertiser timezone. A valid filter value is a canonical timezone code, for example, America/Los_Angeles
Field type dimension
Data type string.time.timezone
billableCost
Display name Billable cost
Description The amount of money charged to partners for using Display & Video 360. This is calculated as the sum of media cost and one or more types of partner costs (for example, CPM fee 1, CPM fee 2, Media fee 1, and/or Media fee 2), depending on the partner's configuration
Field type metric
Data type float.currency.value
billableCostAdvertiser
Display name Billable cost (Advertiser)
Description The amount of money charged to partners for using Display & Video 360. This is calculated as the sum of media cost and one or more types of partner costs (for example, CPM fee 1, CPM fee 2, Media fee 1, and/or Media fee 2), depending on the partner's configuration
Field type metric
Data type float.currency.value
billableCostUSD
Display name Billable cost (USD)
Description The amount of money charged to partners for using Display & Video 360. This is calculated as the sum of media cost and one or more types of partner costs (for example, CPM fee 1, CPM fee 2, Media fee 1, and/or Media fee 2), depending on the partner's configuration
Field type metric
Data type float.currency.value
campaign
Display name Campaign
Field type dimension
Data type string.text.value
campaignID
Display name Campaign ID
Description The campaign ID
Field type dimension
Data type string.text.value
clicks
Display name Clicks
Description The number of times a user has clicked on an ad
Field type metric
Data type int.number.value
CPMfee1
Display name CPM fee (1)
Description CPM fee 1
Field type metric
Data type float.currency.value
CPMfee1Advertiser
Display name CPM fee (1) (Advertiser)
Description CPM fee 1
Field type metric
Data type float.currency.value
CPMfee1USD
Display name CPM fee (1) (USD)
Description CPM fee 1
Field type metric
Data type float.currency.value
CPMfee2
Display name CPM fee (2)
Description CPM fee 2
Field type metric
Data type float.currency.value
CPMfee2Advertiser
Display name CPM fee (2) (Advertiser)
Description CPM fee 2
Field type metric
Data type float.currency.value
CPMfee2USD
Display name CPM fee (2) (USD)
Description CPM fee 2
Field type metric
Data type float.currency.value
CPMfee3
Display name CPM fee (3)
Description CPM fee 3
Field type metric
Data type float.currency.value
CPMfee3Advertiser
Display name CPM fee (3) (Advertiser)
Description CPM fee 3
Field type metric
Data type float.currency.value
CPMfee3USD
Display name CPM fee (3) (USD)
Description CPM fee 3
Field type metric
Data type float.currency.value
CPMfee4
Display name CPM fee (4)
Description CPM fee 4
Field type metric
Data type float.currency.value
CPMfee4Advertiser
Display name CPM fee (4) (Advertiser)
Description CPM fee 4
Field type metric
Data type float.currency.value
CPMfee4USD
Display name CPM fee (4) (USD)
Description CPM fee 4
Field type metric
Data type float.currency.value
CPMfee5
Display name CPM fee (5)
Description CPM fee 5
Field type metric
Data type float.currency.value
CPMfee5Advertiser
Display name CPM fee (5) (Advertiser)
Description CPM fee 5
Field type metric
Data type float.currency.value
CPMfee5USD
Display name CPM fee (5) (USD)
Description CPM fee 5
Field type metric
Data type float.currency.value
CreativeID
Display name Creative ID
Description Companion Creative ID
Field type dimension
Data type string.text.value
dataCost
Display name Data fees
Description The costs for using third-party audience segment data, based on the third-party audience lists targeted by your line items
Field type metric
Data type float.currency.value
dataCostAdvertiser
Display name Data fees (Advertiser)
Description The costs for using third-party audience segment data, based on the third-party audience lists targeted by your line items
Field type metric
Data type float.currency.value
dataCostUSD
Display name Data fees (USD)
Description The costs for using third-party audience segment data, based on the third-party audience lists targeted by your line items
Field type metric
Data type float.currency.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
FloodlightActivity
Display name Floodlight Activity
Description Floodlight activity name
Field type dimension
Data type string.text.value
impressions
Display name Impressions
Description The number of impressions served
Field type metric
Data type int.number.value
InsertionOrder
Display name Insertion order
Description Name of the insertion order
Field type dimension
Data type string.text.value
InsertionOrderID
Display name Insertion order ID
Description Numeric ID value of the insertion order
Field type dimension
Data type string.text.value
InsertionOrderStatus
Display name Insertion order status
Field type dimension
Data type string.text.value
lastClicks
Display name Post-Click Conversions
Field type metric
Data type int.number.value
lastImpressions
Display name Post-View Conversions
Field type metric
Data type int.number.value
LineItem
Display name Line item
Field type dimension
Data type string.text.value
LineItemID
Display name Line item ID
Description Line item ID
Field type dimension
Data type string.text.value
LineItemStatus
Display name Line item status
Field type dimension
Data type string.text.value
LineItemType
Display name Line item type
Description Line item type. Valid filter values include "RTB", "RMX_NON_RTB", and "RTB_VIDEO"
Field type dimension
Data type string.text.value
mediaCost
Display name Media cost
Description The raw cost for impressions purchased from an exchange
Field type metric
Data type float.currency.value
mediaCostAdvertiser
Display name Media cost (Advertiser)
Field type metric
Data type float.currency.value
mediaCostUSD
Display name Media cost (USD)
Description The raw cost for impressions purchased from an exchange
Field type metric
Data type float.currency.value
mediaFee1
Display name Media fee (1)
Description Media fee 1
Field type metric
Data type float.currency.value
mediaFee2
Display name Media fee (2)
Description Media fee 2
Field type metric
Data type float.currency.value
mediaFee3
Display name Media fee (3)
Description Media fee 3
Field type metric
Data type float.currency.value
mediaFee4
Display name Media fee (4)
Description Media fee 4
Field type metric
Data type float.currency.value
Partner
Display name Partner
Field type dimension
Data type string.text.value
PartnerCurrency
Display name Partner currency
Description Partner currency. ISO 4217 three-letter currency code is used for filter value for US Dollars
Field type dimension
Data type string.currency.code
PartnerID
Display name Partner ID
Description Partner ID
Field type dimension
Data type string.text.value
PartnerStatus
Display name Partner status
Field type dimension
Data type string.text.value
platformFee
Display name Platform fee
Field type metric
Data type float.currency.value
platformFeeAdvertiser
Display name Platform fee (Advertiser)
Field type metric
Data type float.currency.value
platformFeeUSD
Display name Platform fee (USD)
Field type metric
Data type float.currency.value
postClickDFArevenue
Display name CM post click revenue
Description The cost amount passed by a (CM) Floodlight Sales tag, after a post-click conversion
Field type metric
Data type float.currency.value
postViewDFArevenue
Display name CM post view revenue
Description The cost amount passed by a (CM) Floodlight Sales tag, after a post-view conversion
Field type metric
Data type float.currency.value
profit
Display name Profit
Description The difference between how much you charged and your costs for running a campaign, calculated as the difference of Revenue - Total Media Cost - Agency markup (if applicable, also known as "Profit margin fees"). This is sometimes also called "net income."
Field type metric
Data type float.currency.value
profitAdvertiser
Display name Profit (Advertiser)
Description The difference between how much you charged and your costs for running a campaign, calculated as the difference of Revenue - Total Media Cost - Agency markup (if applicable, also known as "Profit margin fees"). This is sometimes also called "net income."
Field type metric
Data type float.currency.value
profitECPCAdvertiser
Display name Profit eCPC (Advertiser)
Description The average CPC you paid, based on the Profit earned, calculated as the product of Profit / Clicks
Field type metric
Data type float.currency.value
profitUSD
Display name Profit (USD)
Description The difference between how much you charged and your costs for running a campaign, calculated as the difference of Revenue - Total Media Cost - Agency markup (if applicable, also known as "Profit margin fees"). This is sometimes also called "net income."
Field type metric
Data type float.currency.value
revenue
Display name Revenue
Field type metric
Data type float.currency.value
revenueAdvertiser
Display name Revenue (Advertiser)
Description Also known as the "top-line cost", this is the sum of Media Costs plus any additional costs factored into the price of running campaigns (such as partner costs, data costs, and agency markups). Revenue is calculated based on the revenue model set for line items
Field type metric
Data type float.currency.value
revenueECPAPVUSD
Display name Revenue (eCPAPV) (USD)
Description The average CPA you paid for post-click conversions only, based on Revenue, calculated as the product of Revenue / Conversions
Field type metric
Data type float.currency.value
revenueUSD
Display name Revenue (USD)
Description Also known as the "top-line cost", this is the sum of Media Costs plus any additional costs factored into the price of running campaigns (such as partner costs, data costs, and agency markups). Revenue is calculated based on the revenue model set for line items
Field type metric
Data type float.currency.value
totalConversions
Display name Total conversions
Description The sum of all post-view and post-click conversions
Field type metric
Data type int.number.value
totalMediaCost
Display name Total media cost
Description The total media cost is the combined price for buying impressions (media cost) and using any third-party audience segment data (data cost)
Field type metric
Data type float.currency.value
totalMediaCostAdvertiser
Display name Total media cost (Advertiser)
Field type metric
Data type float.currency.value
totalMediaCostUSD
Display name Total media cost (USD)
Description The total media cost is the combined price for buying impressions (media cost) and using any third-party audience segment data (data cost)
Field type metric
Data type float.currency.value

Table: CREATIVE

account
Display name Account
Field type dimension
Data type string.text.value
account_id
Display name Account ID
Field type dimension
Data type string.text.value
advertiser
Display name Advertiser
Field type dimension
Data type string.text.value
advertiserCurrency
Display name Advertiser currency
Description Advertiser currency. ISO 4217 three-letter currency code is used for filter value, for example, "USD" for US Dollars
Field type dimension
Data type string.currency.code
advertiserID
Display name Advertiser ID
Description Advertiser ID
Field type dimension
Data type string.text.value
clicks
Display name Clicks
Description The number of times a user has clicked on an ad
Field type metric
Data type int.number.value
Creative
Display name Creative
Field type dimension
Data type string.text.value
CreativeHeight
Display name Creative height
Description Creative height
Field type dimension
Data type float.number.value
CreativeID
Display name Creative ID
Description Companion Creative ID
Field type dimension
Data type string.text.value
CreativeSource
Display name Creative source
Field type dimension
Data type string.text.value
CreativeStatus
Display name Creative status
Field type dimension
Data type string.text.value
CreativeType
Display name Creative type
Description Creative type. Valid filter values include "IMAGE", "EXPANDABLE", and "VIDEO"
Field type dimension
Data type string.text.value
CreativeWidth
Display name Creative width
Description Creative width
Field type dimension
Data type float.number.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
FloodlightActivity
Display name Floodlight Activity
Description Floodlight activity name
Field type dimension
Data type string.text.value
impressions
Display name Impressions
Description The number of impressions served
Field type metric
Data type int.number.value
InsertionOrder
Display name Insertion order
Description Name of the insertion order
Field type dimension
Data type string.text.value
InsertionOrderID
Display name Insertion order ID
Description Numeric ID value of the insertion order
Field type dimension
Data type string.text.value
LineItem
Display name Line item
Field type dimension
Data type string.text.value
LineItemID
Display name Line item ID
Description Line item ID
Field type dimension
Data type string.text.value
Partner
Display name Partner
Field type dimension
Data type string.text.value
PartnerID
Display name Partner ID
Description Partner ID
Field type dimension
Data type string.text.value
postClickDFArevenue
Display name CM post click revenue
Description The cost amount passed by a (CM) Floodlight Sales tag, after a post-click conversion
Field type metric
Data type float.currency.value
postViewDFArevenue
Display name CM post view revenue
Description The cost amount passed by a (CM) Floodlight Sales tag, after a post-view conversion
Field type metric
Data type float.currency.value
revenue
Display name Revenue
Field type metric
Data type float.currency.value
revenueAdvertiser
Display name Revenue (Advertiser)
Description Also known as the "top-line cost", this is the sum of Media Costs plus any additional costs factored into the price of running campaigns (such as partner costs, data costs, and agency markups). Revenue is calculated based on the revenue model set for line items
Field type metric
Data type float.currency.value
revenueUSD
Display name Revenue (USD)
Description Also known as the "top-line cost", this is the sum of Media Costs plus any additional costs factored into the price of running campaigns (such as partner costs, data costs, and agency markups). Revenue is calculated based on the revenue model set for line items
Field type metric
Data type float.currency.value
Site
Display name Site
Field type dimension
Data type string.text.value
totalConversions
Display name Total conversions
Description The sum of all post-view and post-click conversions
Field type metric
Data type int.number.value
totalMediaCost
Display name Total media cost
Description The total media cost is the combined price for buying impressions (media cost) and using any third-party audience segment data (data cost)
Field type metric
Data type float.currency.value
totalMediaCostAdvertiser
Display name Total media cost (Advertiser)
Field type metric
Data type float.currency.value
totalMediaCostUSD
Display name Total media cost (USD)
Description The total media cost is the combined price for buying impressions (media cost) and using any third-party audience segment data (data cost)
Field type metric
Data type float.currency.value
videoCompletions
Display name Video completions
Description The number of times a video has been played to its end
Field type metric
Data type int.number.value
VideoDuration
Display name Video duration
Description Video duration range in seconds. Valid values include "0-5", "6-10", "11-15", "16-30", "31-60", and "60+"
Field type dimension
Data type string.text.value
videoFirstQuartileCompletes
Display name Video 1st quartile completes
Description The number of times a video has been played to 25% of its entire length
Field type metric
Data type int.number.value
videoFullScreens
Display name Video full screens
Description The number of times a video has been viewed in full screen mode
Field type metric
Data type float.number.value
videoMidPoints
Display name Video mid points
Description The number of times a video has been played to 50% of its entire length
Field type metric
Data type float.number.value
videoMutes
Display name Video mutes
Description The number of times a video has been muted. This is logged once per view, such that if a person mutes and un-mutes a video multiple times, the sesequent mutes aren't counted
Field type metric
Data type int.number.value
videoPauses
Display name Video pauses
Description The number of times a video has been paused. This is logged once per view, such that if a person pauses a video multiple times, the subsequent pauses aren't counted
Field type metric
Data type int.number.value
VideoPlayerSize
Display name Video player size
Description Video player size. Valid filter values include "BANNER", "SMALL", "LARGE", "HD", and "UNKNOWN"
Field type dimension
Data type string.text.value
videoPlays
Display name Video plays
Description The number of times a video has been played. This is logged once per view, such that if a person stops play and then restarts it, the restart isn't counted
Field type metric
Data type int.number.value
videoThirdQuartileCompletes
Display name Video 3rd quartile completes
Description The number of times a video has been played to 75% of its entire length
Field type metric
Data type int.number.value